NTSB investigations, 2015
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1 WHERE year(c.\"eventDate\") = 2015 ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE year(c."eventDate") = 2015 ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ANC15CA058Accident · No injuriesData collectionFinal reportCessna 150G · Mekoryuk, AKThe pilot's improper decision to land on an unsuitable landing surface which resulted in a nose over.NTSB WPR15WA224Accident · 1 fatalForeign investigationGlasair SH-2FT · Wedderburn, AustraliaOn July 19, 2015 about 1700 local time, an amateur built Glasair SH-2FT, Australian registration VH-HRG, collided with terrain near Wedderburn, Victoria, Australia. The airplane sustained substantial damage and the pilot was fatally injured. The investigation…NTSB WPR15LA217Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-181 · Las Vegas, NVThe engine's inability to produce full-rated power due to wear on internal engine components, which resulted in a loss of altitude and subsequent landing on uneven terrain. Contributing to the accident was the airplane owner's failure to maintain the engine…NTSB GAA15CA193Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Oxford, IAThe pilot's selection of unsuitable terrain for takeoff based on the runway and density altitude conditions, which resulted in a runway excursion and impact with terrain.NTSB ERA15WA290Accident · 1 fatalForeign investigationCessna 210D · Rio Verde, BrazilNTSB ERA15WA275Accident · Serious injuriesForeign investigationCessna 206G · Sucua, EcuadorOn July 19, 2015, about 1515 universal coordinated time, a Cessna 206G, HC-CLR, was destroyed by collision with terrain during a forced landing following a loss of engine power during descent to Edmund Carvajal Airport (XMS), Macas, Santiago, Ecuador. The…NTSB ERA15LA276Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA1B · Lititz, PAA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine found no mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA15LA274Accident · No injuriesLimited investigationFinal reportCessna 172S · Linden, NJThe pilot’s delayed decision to reject the takeoff, which resulted in a runway overrun. Contributing to the accident was the pilot’s failure to properly configure the flaps for maximum takeoff performance with the airplane near its maximum gross weight.NTSB ERA15LA273Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Wilmington, NCThe pilot's failure to ensure that the landing gear was in the down and locked position before touchdown, which resulted in a landing with the gear in transit.NTSB CEN15LA351Accident · Minor injuriesLimited investigationFinal reportRoberts Bruce W Vans Aircraft RV 9A · Land O' Lakes, WIThe pilot’s failure to maintain a proper descent rate, which resulted in a hard landing.NTSB CEN15LA332Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Holland, MIA total loss of engine power due to fuel starvation during cruise flight. Contributing to the accident was the pilot’s inadequate preflight fuel planning.NTSB GAA15LA195Accident · Serious injuriesLimited investigationFinal reportKubicek BB100Z · Hidden Valley Lake, CAThe balloon pilot’s deliberate hard landing to avoid power lines and trees, which resulted in serious passenger injuries.NTSB GAA15CA192Accident · No injuriesData collectionFinal reportCessna R172K · Fairfield, NCThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and impact with terrain.NTSB GAA15CA190Accident · No injuriesData collectionFinal reportPiper PA 32-300 · Greensboro, NCThe pilot's decision to continue the approach after realizing the intended parameters were not attainable, resulting in a runway over-shoot, a loss of control on the ground and the consequent collision with trees.NTSB GAA15CA189Accident · No injuriesData collectionFinal reportCessna 182Q · Hanksville, UTThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and a collision with terrain.NTSB ERA15CA272Accident · Minor injuriesData collectionFinal reportSmith Steen Skybolt · Junction City, KYThe pilot's inaccurate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN15WA440Accident · Serious injuriesForeign investigationMaule MX7 · Munster, SwitzerlandOn July 18, 2015 about 0857 UTC, a Maule MX7-235 airplane, Swiss registration HB-KDF, impacted terrain during a go around near the Munster Airport (LSPU), near Munster, Switzerland. The pilot and two passengers sustained minor injuries and one passenger…NTSB CEN15LA346Accident · No injuriesLimited investigationFinal reportErcoupe 415 · Saint Martin Island, MIThe failure of a connecting rod bearing, which resulted in a loss of engine power.NTSB CEN15FA307Accident · 4 fatalField investigationFinal reportCessna T310R · Cody, WYThe pilot's loss of airplane control following the loss of power in the left engine; the reason for the loss of power could not be determined during postaccident engine examination.NTSB GAA15LA191Accident · Minor injuriesLimited investigationFinal reportCelier Xenon RST · Livingston, TXThe pilot’s loss of directional control after aborting the takeoff due to a grinding noise coming from the main rotor area, which resulted in a runway excursion.NTSB GAA15CA143Accident · No injuriesData collectionFinal reportAventura II · Fenton, MIThe failure of the student pilot to ensure that the experimental seaplane was airworthy prior to take off.NTSB CEN15WA338Accident · 1 fatalForeign investigation3xtrim 450 Ultra · Golub-Dobrzyn City, PolandOn July 17, 2015 about 1615 UTC, a 3Xtrim 450 Ultra, light sport airplane, Poland registration SP-SPRL, impacted terrain while on a sightseeing flight near Golub-Dobrzyn, Poland. The pilot was seriously injured and the passenger was killed. The airplane was…NTSB CEN15LA309Accident · No injuriesLimited investigationFinal reportCessna 172RG · Anoka, MNFailure of the left landing gear actuator for reasons that could not be determined because the actuator was not made available for examination.NTSB CEN15CA373Accident · No injuriesData collectionFinal reportErcoupe 415-C · Alexandria, INThe pilot's failure to maintain/attain adequate airspeed and attitude during landing that resulted in a hard landing. Contributing was the pilot's diverted attention to air traffic and the reduction of perceptible audio cues due to noise attenuating headsets.NTSB ANC15FA049Accident · 1 fatalClass 3 · FieldFinal reportCessna 207A · Juneau, AKThe pilot's decision to initiate and continue visual flight into instrument meteorological conditions, which resulted in a loss of situational awareness and controlled flight into terrain. Contributing to the accident were the company's failure to follow its…NTSB GAA15CA232Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Prairie Lea, TXThe pilot's failure to maintain rotor rpm, resulting in an uncontrolled descent and collision with trees.NTSB GAA15CA207Accident · No injuriesData collectionFinal reportCessna 170B · Rosamond, CAThe pilot's failure to maintain directional control during the takeoff roll, resulting in a collision with terrain.NTSB ERA15LA271Accident · No injuriesLimited investigationFinal reportYoung John E Searey · Corbin, KYThe pilot’s improper conduct of a precautionary landing, which resulted in abnormal water contact that damaged the hull.NTSB ERA15LA269Accident · Minor injuriesLimited investigationFinal reportCessna 162 · Dunkirk, NYThe pilot's failure to maintain control of the airplane while attempting to close an open cabin door, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB ENG15WA036Incident · No injuriesForeign investigationBoeing 737 · Quetta, PakistanThe government of Pakistan has notified the NTSB of an accident involving a Boeing 737-400 airplane that occurred on July 16, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under the…NTSB CEN15LA308Accident · Serious injuriesLimited investigationFinal reportDevoe Clip Wing · Melbourne, ARThe loss of engine power for reasons that could not be determined based on the available evidence and the postaccident engine examination, which led to a forced landing on unsuitable terrain due to the pilot’s decision not to deploy the ballistic parachute…NTSB WPR15CA214Accident · Minor injuriesData collectionFinal reportPiper PA-28-151 · Laurier, WAThe pilot's inadequate decision to continue the approach, which resulted in a long landing and insufficient runway remaining to stop the airplane before it departed the end of the runway.NTSB GAA15CA227Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Sandusky, MIThe pilot's failure to monitor the landing environment while operating in a confined off-airport site resulting in a wire strike and substantial damage to the helicopter.NTSB GAA15CA188Accident · No injuriesData collectionFinal reportChampion 7GCAA · Kingsland, TXThe pilot's failure to maintain pitch attitude which resulted in an aerodynamic stall, hard landing and a loss of directional control.NTSB CEN15WA368Accident · Minor injuriesForeign investigationPiper PA-32R-300 · Varberg, SwedenOn July 15, 2015, at 1402 coordinated universal time, a Piper PA-32R-300 airplane, Swedish registration SE-MCB, operated by a private individual, collided with the terrain following a loss of lift on takeoff from the Varberg Airport (ESGV), Varberg, Sweden.…NTSB WPR15LA218Accident · No injuriesLimited investigationFinal reportDafoe Gerald W Tcow Smith CUB · Cascade, IDA gouge in the right brake master cylinder piston O-ring, which resulted in a loss of brake pressure and reduced effectiveness after landing. Contributing to the accident was the pilot’s decision to operate the airplane with an ongoing brake issue.NTSB GAA15CA184Accident · No injuriesData collectionFinal reportPiper PA 12 · Buhl, IDThe student/instructed pilot lost directional control during the landing roll, resulting in a runway excursion, and ground loop.NTSB ENG15WA027Incident · No injuriesForeign investigationAirbus A330 - 323 · Incheon, Republic of Korea, South KoreaOn July 14, 2015 at about 0832 universal coordinated time, an Airbus A330-300, HL8282, operated by Asiana Airlines experienced No. 2 (right) engine fire and oil pressure warnings shortly after takeoff from Incheon International Airport (ICN), Incheon,…NTSB CEN15LA323Accident · No injuriesLimited investigationFinal reportCessna 182B · Fults, ILThe malfunction of the flap assembly, which resulted in a restriction of aileron control. Contributing to the accident was maintenance personnel’s inadequate inspection of a corroded flap control cable.NTSB CEN15LA306Accident · Serious injuriesLimited investigationFinal reportAir Creation Clipper 582 · Clark, SDThe pilot's inability to maintain control of the weight-shift control aircraft during initial climb due to his impairment from ethanol, methamphetamine, cocaine, and marijuana.NTSB CEN15FA305Accident · 2 fatalField investigationFinal reportPiper PA 32-300 · Brazoria, TXThe student pilot's failure to arrest the descent in a timely manner and the flight instructor's failure to safely intervene in the routine training maneuver for reasons that could not be determined based on the information available.NTSB ANC15CA051Accident · No injuriesData collectionFinal reportCessna 140 · Homer, AKThe pilot's decision to fly at a low altitude in mountainous terrain and weather conditions conducive to downdrafts.NTSB GAA15CA181Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Caldwell, IDAbnormal ground contact during a 180 degree autorotation, resulting in a severed tail rotor driveshaft by a main rotor blade. A factor contributing to the accident was the rotor blowback condition due to the aft tilting of the main rotor disk.NTSB ERA15LA266Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 5 · Southbridge, MAThe pilot’s decision to abort the takeoff with insufficient runway remaining, which resulted in a runway excursion.NTSB CEN15LA357Accident · Minor injuriesLimited investigationFinal reportPiper PA 30 · Clifton, TXThe pilot's failure to maintain control during a precautionary landing following a total loss of power to one engine. The reason for the loss of engine power could not be determined based on available information.NTSB GAA15LA131Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Escalante, UTThe pilot’s inadequate preflight planning and his subsequent decision to attempt to climb over rising terrain with the helicopter over maximum gross weight while operating in high-density altitude conditions with a tailwind, which resulted in its inability to…NTSB GAA15CA185Accident · No injuriesData collectionFinal reportBarron Starduster SA 300 · Whiteville, NCThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion and a collision with terrain.NTSB ERA15LA263Accident · Minor injuriesLimited investigationFinal reportCessna 210 5A(205A) · Stafford Twp, NJThe total loss of engine power due to the failure of the crankshaft, which resulted from a mechanic's failure to properly torque the engine cylinder through bolts.NTSB ERA15CA262Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Viola, TNThe pilot's failure to see and avoid a guy wire, which resulted in contact with the wire and subsequent collision with terrain.NTSB DCA15WA159Incident · No injuriesForeign investigationBoeing 767 - 346 · Singapore, SingaporeThe Aircraft Accident Investigative Bureau (AAIB) of Singapore has notified the NTSB of an incident involving a BOEING 767 airplane that occurred on July 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…