<p><div><div><div><div data-show-faces="false" data-height="21" data-width="100" data-layout="button_count" data-send="true" data-href="https://www.r-bloggers.com/exploring-aviation-accidents-from-1908-through-the-present/"></div></div><div></div></div><div></div></div>
<div>
(This article was first published on <strong><a href="https://nycdatascience.com/blog/student-works/exploring-aviation-accidents-from-1908-through-the-present/"> R – NYC Data Science Academy Blog</a></strong>, and kindly contributed to <a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers)</a> </div>
<p><a rel="nofollow" href="https://i2.wp.com/nycdatascience.com/blog/wp-content/uploads/2018/01/aircrash-1.jpg" target="_blank"><img sizes="(max-width: 1920px) 100vw, 1920px" src="https://i2.wp.com/nycdatascience.com/blog/wp-content/uploads/2018/01/aircrash-1.jpg?w=450" alt="" class="wp-image-27168" data-recalc-dims="1"></a></p>
<p>If you can walk away from a landing, it’s a good landing. If you use the airplane the next day, it’s an outstanding landing.<br>
-Chuck Yeager</p>
<p>As the first airplane invented by Wright brothers in 1903, aviation accident became an inevitable tragedy as well as an attractive topic. In this project, I used the data of full history of airplane crashes throughout the world, from 1908 to present, to analyze time, airplane type, airlines and accident summary of aviation accidents</p>
<p> </p>
<p><strong>Data</strong></p>
<hr>
<p>The original data I used contain over 5,000 rows coming from Open Data by Socrata, each row of the data represent a single accident, and the data consist of following features:<br>
Date: date the accident happened<br>
Time: time the accident happened<br>
Location: where the accident happened<br>
Operator: operator the crashed aircrafts belong to<br>
Type: type of crashed aircrafts<br>
Aborad: # of people aboard the crashed aircrafts<br>
Fatalities: # of people dead (who aboard the aircrafts)<br>
Ground: # of people dead (who did not aboard the aircrafts)<br>
Summary: brief accident description<br>
Notice that I removed all the rows belong to military operator in order to focus on commercial airplane.</p>
<p> </p>
<p><strong>Time</strong></p>
<hr>
<p><a rel="nofollow" href="https://i2.wp.com/nycdatascience.com/blog/wp-content/uploads/2018/01/time-1.png" target="_blank"><img sizes="(max-width: 1840px) 100vw, 1840px" src="https://i2.wp.com/nycdatascience.com/blog/wp-content/uploads/2018/01/time-1.png?w=450" alt="" class="wp-image-27177" data-recalc-dims="1"></a><br>
The first two plot shows air crash count in each year and fatality count and death ratio in each ten years. We can see that after 1970, total amount of accidents and people die from accidents are both decreasing. Due to lack of annually flights count data, we can’t simply say that accident rate is decreasing. However, the death rate went down from over 90% to around 65% throughout history, which means passengers are more likely to survive than before in an air crash.<br>
The third plot shows air crash count and death ratio by time of day. Number of air crash are distinguished by day and night. Again, due to data limitation, we can’t conclude that at what time it has higher accident rate, but death rate during night is higher than during day. (4 of the top 5 highest death rate time periods are within 12am to 5am)</p>
<p> </p>
<p><strong>Aircraft Type</strong></p>
<hr>
<p><a rel="nofollow" href="https://i2.wp.com/nycdatascience.com/blog/wp-content/uploads/2018/01/AIRCRAFT.png" target="_blank"><img sizes="(max-width: 1415px) 100vw, 1415px" src="https://i2.wp.com/nycdatascience.com/blog/wp-content/uploads/2018/01/AIRCRAFT.png?w=450" alt="" class="wp-image-27178" data-recalc-dims="1"></a></p>
<p>Then I analyzed the type of crashed aircraft. Firstly, I want to see if aircraft size affect death rate. As we can see from the first plot, as the aircraft size increasing, the death rate is overall decreasing. We can conclude that passenger in larger aircraft have higher survive rate than in smaller aircraft.<br>
The next two plot shows air crash count for different aircraft model and air craft manufacturer. By selecting whole time range (can drag the bar in shiny app to change the year range), we find that Douglas DC-3 has the most count of air crash, which is far more than the second one DHC-6, but if only consider accidents after 1964, DHC-6 surpass DC-3 become the one has most accidents. After 2000, Cessna 208-B become the lead.<br>
In the second plot, it’s easy to compare the proportion of different manufacturer’s crashed aircraft in different age. And also, we can select different manufacturer to compare in the shiny app. For example, in the subplot, we selected Boeing and Airbus. From the plot, it’s obvious that Boeing experienced more accident than Airbus through the whole history, but it’s too rough to conclude which is safer. We still need more data such as total number of aircraft in service per year, total number of passenger it delivered, etc.</p>
<p> </p>
<p><strong>Airlines</strong></p>
<hr>
<p><a rel="nofollow" href="https://i2.wp.com/nycdatascience.com/blog/wp-content/uploads/2018/01/AIRLINE1.png" target="_blank"><img sizes="(max-width: 1250px) 100vw, 1250px" src="https://i2.wp.com/nycdatascience.com/blog/wp-content/uploads/2018/01/AIRLINE1.png?w=450" alt="" class="wp-image-27183" data-recalc-dims="1"></a></p>
<p> </p>
<p>The plots show air crash count and death rate by different airlines. Throughout whole history, Aeroflot has the most count of air crash (179 accidents in total), which is far more than the second one Air France(67 accidents in total), but by selecting after 1991, private airplane surpass Aeroflot, become the one has most accidents.</p>
<p> </p>
<p><strong>Accident Summary</strong></p>
<hr>
<p><a rel="nofollow" href="https://i1.wp.com/nycdatascience.com/blog/wp-content/uploads/2018/01/Screen-Shot-2018-01-09-at-2.29.52-AM.png" target="_blank"><img sizes="(max-width: 2008px) 100vw, 2008px" src="https://i1.wp.com/nycdatascience.com/blog/wp-content/uploads/2018/01/Screen-Shot-2018-01-09-at-2.29.52-AM.png?w=450" alt="" class="wp-image-27184" data-recalc-dims="1"></a></p>
<p>Lastly, I put all accident summary together and generated a word cloud. Not surprisingly, Crashed is the most frequent word in the summary. We can see that Landing is more frequent than Takeoff, which illustrate that air crash happened more in the phase of landing rather than takeoff. Also, depends on words such as Mountain, Ground, Runway, Engine, Fuel, Fire, etc. we can roughly estimate where the accident happened and what was the cause of the accident.</p>
<p> </p>
<hr>
<p>Thanks for watching, please feel free to browse my Shiny App and Github via following link!</p>
<p><a rel="nofollow" href="https://tianyigu.shinyapps.io/aircrash_/" target="_blank">Link to Shiny App</a></p>
<p><a rel="nofollow" href="https://github.com/tianyigu/Aircrash_Shiny_Project" target="_blank">Link to Githup</a></p>
<p>Email: <a rel="nofollow" href="https://nycdatascience.com/blog/student-works/exploring-aviation-accidents-from-1908-through-the-present/tianyigu@nyu.edu" target="_blank">tianyigu@nyu.edu</a></p>
	<p>
<div>
<div>To <strong>leave a comment</strong> for the author, please follow the link and comment on their blog: <strong><a href="https://nycdatascience.com/blog/student-works/exploring-aviation-accidents-from-1908-through-the-present/"> R – NYC Data Science Academy Blog</a></strong>.</div>
<hr>
<a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers.com</a> offers <strong><a rel="nofollow" href="https://feedburner.google.com/fb/a/mailverify?uri=RBloggers">daily e-mail updates</a></strong> about <a rel="nofollow" href="https://www.r-project.org/" title="The R Project for Statistical Computing">R</a> news and <a rel="nofollow" href="https://www.r-bloggers.com/search/tutorial" title="R tutorials">tutorials</a> on topics such as: <a rel="nofollow" href="https://www.r-bloggers.com/search/data%20science" title="Data science">Data science</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/Big%20Data" title="Big Data">Big Data, <a rel="nofollow" href="https://www.r-users.com/" title="R jobs">R jobs</a>, visualization (<a rel="nofollow" href="https://www.r-bloggers.com/search/ggplot2" title="ggplot and ggplot2 tutorials">ggplot2</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/boxplot" title="Boxplots using lattice and ggplot2 tutorials">Boxplots</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/map" title="Maps and gis">maps</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/animation" title="Animation in R">animation</a>), programming (<a rel="nofollow" href="https://www.r-bloggers.com/search/RStudio" title="RStudio IDE for R">RStudio</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/sweave" title="Sweave and literate programming">Sweave</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/LaTeX" title="LaTeX in R">LaTeX</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/SQL" title="SQL and databases">SQL</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/eclipse" title="Eclipse IDE for R">Eclipse</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/git" title="git and github, Version Control System">git</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/hadoop" title="Large data in R using Hadoop">hadoop</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/Web+Scraping" title="Web Scraping of google, facebook, yahoo, twitter and more using R">Web Scraping</a>) statistics (<a rel="nofollow" href="https://www.r-bloggers.com/search/regression" title="Regressions and ANOVA analysis tutorials">regression</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/PCA" title="principal component analysis tutorial">PCA</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/time+series" title="Time series">time series</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/trading" title="finance trading">trading</a>) and more...
<img width="1" alt="" src="http://feeds.feedburner.com/~r/RBloggers/~4/85lt-XQdsbo" height="1"></a></div>