Some questions to prompt you along (not necessarily for answering, but at least for thinking on):
It's often a character flaw that leads to the fall in a tragedy. Does the protagonist fail because of laziness? unrealistic expectations? Is he just naturally inferior and cannot accept reality? Is he deeply jealous? Or does he displays all the qualities of a hero but is beaten down each time? Do you represent his failings as slight, forgivable, understandable? Or is he a lousy person who experiences terrible things?
Is the family sympathetic or villainous? Does his sister push forward with her rise and ignore her brother? Does she give up her own potential to help him? If so, can the hero even see this or does he misunderstand the actions of his family?
There's two major events, the death and the hospitalization. Is it rising or falling action between them? Is the hero clearly failing and becoming increasing agitated by this? Is he slowly improving and then suddenly knocked off his path? Does the player become excited thinking that the hero will succeed, or is it dramatic irony where the fall is already known?
It seems like the story is building to a third major event. Do you know what it is? Does the story end on a high note, a low note or an ambiguous note?
Is the father still around? How does the family react to the brutalization of the hero? Does it break the family apart? Do they support the father? Does the father seek reconciliation? Does he blame himself or the hero?
In what order will you reveal the events? Will you reveal them via an omniscient narrator, or is the recollection tinged by the character, even untrustworthy? How much of the story is focused on the past, the present and the future? Is it active flashbacks or discussions of past events, long exposition on the past or a jumble of clues that slowly form a pattern?
What's the protagonists relationship to magic after the hospitalization? What does magic represent in the story? Is it a dark, forbidden thing? A sexy, power and status thing? Does it make people better, twist them to failure, highlight existing flaws and virtues? Or maybe it's just uncontrollable and unpredictable? Do regular people respect or fear it?
Does the family feel ashamed of the protagonist, since they are a renowned family? Does he actively embarrass them? Do they emote with his failings or can they not understand?
Is there a moment where the tragedy becomes (at least narratively) inevitable: the failed message in Romeo and Juliet, the murder of the king in Macbeth, or does the story suggest the protagonist could fix things up at any moment but just fails to do so, that the harm is all self inflicted? If you do give a sense of inevitability, when did it start? The death of the friend? The fight?
These are some really good questions, thanks for the input. To begin with, the protagonist when first beginning did have the typical qualities of a hero, with no talent whatsoever though, meaning after around a decade of training he could only barely manipulate magic. It was his constant failings that slowly changed him, so that before whilst he did actually try and fail, it became more of an unwillingness to even try due to knowing the outcome. This I believe ties in with his emotional distance and attempts to think from a logical perspective at all times in the present, since the failures drilled him into a mind set of cynicism and logic with no room for his emotions or desires left there anymore. Its less of him not accepting reality, but through continuous failures and having reality smash his goal numerous times that he does accept it unwillingly, which is one of the major reasons he is damaged.
In terms of the family, I have nothing concrete yet but my main idea is for them to be neutral. They have traditional values due to their heritage, ancestry and teachings which does cause them to be somewhat tough. However they are also sympathetic towards him at times which shows they do care, just that they have no idea how to communicate with him or actually help him since his mentality is different to theirs. In terms of the sister, I was going to have her be a naïve embodiment of the hero's goal. This means she is more or less a very powerful combat magic user, however she has a very narrow and somewhat innocent outlook on life. This leaves her very ignorant of the protagonists problems, because all she sees is her big brother she loves very much. She doesn't actually know he has conflicted feelings towards her and because she treats him as an equal she essentially acts as a catalyst for his worsening problems and inferiority complex, which in turn makes it much harder for the protagonist to even see her, let alone talk with her. I do intend to make her find out however, but I also want her to be somewhat portrayed as an unwilling villain in the protagonist's despite her good nature.
The rise and fall both occur after the death, but before the hospitalisation. The death sets him on the goal, where he initially rises up, but falls down much deeper with the hospitalisation being the end result. He does become agitated after each failure and increasingly stressed and such, however it isn't evidently clear until the incident which makes him snap, with only subtle signs before the big tangible change.
My idea is that the big event which occurs is an incident which causes the protagonists death due to him either snapping or being forced into a magic fight (I haven't fully decided which one yet). I intend to build up the character as a very negative one initially, with surrounding people having a negative opinion of him, with all development occurring after his death. This I would do by characters such as the sister and few acquaintances finding items such as audio notes, diaries and such (I also intend to have dialogues between the family reveal things) from his actual original fall back at the family home. This would then show the sister just why he avoided her when he could, and show his acquaintances why he had such a negative outlook, whilst simultaneously showing the player his spiral downwards and that he was once just a normal boy with a dream, humanising what originally appeared to just be a bastard of a character into someone they can empathise with.
The father as the head of the household is still around, however he rarely interacts with the protagonist. The protagonist doesn't feel enmity, as he recognises the whole thing as his fault, but this damages him again as he feels he doesn't think he has the right to bear the name of his family because of the obvious difference between him and the rest. However, the father when with him does clearly feel remorse, both for putting him down but not shopping him from initially failing, and for drastically injuring him. However the father does not apologise to him, which leads to more remorse and such after his death.
The events will be recollected mostly by the protagonists entries and written word, so there will be a evident air of untrustworthiness due to his obvious impending breakdown throughout his entries. However some will also be recollected before and after his death by the family and their friends, such as failings or small signs they should have noticed that hinted what he was going through.
Magic is represented as more of a status thing. In the story I intend to have magic be almost completely gone from the world, with events such as wars causing the loss of knowledge built over centuries and bloodlines thinning out so only prestigious families with the resources to continue using magic actively using it. It is known about by regular civilians, but many have a negative view on it due to the well known fact that high class families are the only ones able to continue using it. This does affect some people's views on the character as well, since he is from a well known family who actively practises magic. The protagonist does have psychological problems using it, as after using it he tends to vividly recall a past failure or other negative event linked to his use of magic, making him reluctant and feeling unworthy to use it.
The family does appear to be ashamed, however they do also privately help him out and somewhat sympathise with his situation.
I intend to give the downfall and breakdown of the protagonist a very inevitable feeling, mainly because it would be in the past, but I would do it by making the death the inevitable point at which he is set on the path. However I also intend to make his death an avoidable choice, meaning that a decision he made could have easily led to other paths than the one which killed him, hinting that he had a good chance at actually fixing himself had he chose differently and attaining some form of happiness.