NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 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 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 CEN15WA251Accident · 5 fatalForeign investigationM7 Aerospace SA226 - TC · Queretaro, MexicoOn June 2, 2015, about 1425 central daylight time, an M7 Aerospace LLC SA226-TC airplane, XA-UKP, impacted terrain near Queretaro, Mexico. A postimpact ground fire occurred. The pilot, co-pilot, and three passengers were fatally injured and the airplane was…NTSB CEN15FA249Accident · 2 fatalField investigationFinal reportMonnett John T JR Sonex SA · Oshkosh, WIThe pilot's failure to maintain sufficient airspeed following a loss of engine power during initial takeoff climb, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. The reason for the loss of…NTSB ERA15LA232Accident · No injuriesLimited investigationFinal reportBeech A23 24 · Grove Hill, ALA total loss of engine power for reasons that could not be determined because engine examination and testing did not reveal any anomalies that would have precluded normal operation.NTSB ANC15WA036Accident · 2 fatalForeign investigationCessna 182 · Sikanni Chief, CanadaNTSB ANC15LA034Accident · Minor injuriesLimited investigationFinal reportPiper PA 22 · Skwentna, AKThe pilot's failure to follow the airplane's operating limitations by rapidly opening the throttle, which resulted in a loss of engine power. Contributing to the accident was the pilot's decision to maneuver the airplane at low altitude even though he was not…NTSB ANC15LA033Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe other pilot’s failure to maintain an adequate visual lookout, which resulted in a midair collision. Contributing to the accident was the other pilot’s failure to follow Federal Aviation Administration-recommended traffic pattern procedures.NTSB WPR15LA178Accident · No injuriesLimited investigationFinal reportGarlick Helicopters UH 1H · Cove, ORThe failure of the engine-to-transmission drive shaft coupling assembly due to a fatigue fracture of one of its attachment bolts, which resulted in a loss of power to the main rotor.NTSB WPR15CA173Accident · No injuriesData collectionFinal reportCessna T188C · Ismay, MTThe pilot's incorrect action to continue the takeoff when he failed to maintain directional control during the takeoff roll.NTSB GAA15LA101Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT 502B · Archer City, TXThe pilot’s failure to maintain adequate clearance from power transmission lines during an aerial application flight.NTSB ERA15WA233Accident · 1 fatalForeign investigationVans RV8 · Corropoli, ItalyOn May 31, 2015, about 1430 universal coordinated time, a Vans RV8, I-LOVI, and a Vans RV7, I-AMEL, were destroyed after colliding midair and then subsequently colliding with the Adriatic Sea, near Corropoli, Italy. The Italian certificated pilot of the RV8…NTSB GAA15CA115Accident · Minor injuriesData collectionFinal reportSmiley James E RAG Wing RW-6 · Mocksville, NCThe pilot's loss of directional control during takeoff, which resulted in a runway excursion and impact with a building.NTSB GAA15CA104Accident · No injuriesData collectionFinal reportCessna 150F · Harlingen, TXThe student pilot's failure to maintain directional control while landing with a crosswind.NTSB GAA15CA098Accident · No injuriesData collectionFinal reportSchweizer SGS 1 26B · Mocksville, NCThe glider pilot over-ran the runway and impacted a structure after encountering a strong updraft on short final.NTSB CEN15WA248Accident · No injuriesForeign investigationPiper PA-28RT-201T · Grenchen, SwitzerlandNTSB CEN15FA245Accident · 3 fatalField investigationFinal reportBeech A36 · Plainview, TXThe pilot’s decision to take off ahead of an approaching severe thunderstorm, which resulted in an encounter with hazardous weather conditions that led to a loss of airplane control.NTSB ANC15FA032Accident · 1 fatalField investigationFinal reportCessna 207 · Bethel, AKThe pilot's failure to maintain altitude, which resulted in collision with the terrain. Contributing to the accident was the pilot's impairment from carbon monoxide exposure in flight. The source of the carbon monoxide could not be determined because the…NTSB WPR15LA179Accident · No injuriesLimited investigationFinal reportBurr Express 2000 RG · Glendale, AZA collapse of the left main landing gear for reasons that could not be determined based on the available information.NTSB WPR15LA170Accident · Serious injuriesLimited investigationFinal reportDuenas Pulsar III · Hurricane, UTAn elevated oil temperature and subsequent total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA15CA124Accident · No injuriesData collectionFinal reportBeech D35 · Sunriver, ORThe pilot's failure to extend the landing gear, which resulted in substantial damage to the fuselage during landing. Contributing to the accident was the pilot's distraction from completing his before landing checklist and inability to hear the gear warning…NTSB GAA15CA102Accident · No injuriesData collectionFinal reportBell 206 - B11 · Caledonia, MIA loss of tail rotor effectiveness while maneuvering at low altitude, resulting in a collision with trees.NTSB ERA15LA228Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Churchville, MDThe pilot's improper reduction of the fuel mixture while the airplane was descending on the final leg of the traffic pattern, which resulted in a total loss of engine power and subsequent aerodynamic stall.NTSB CEN15CA246Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Winnsboro, LAThe pilot's improper approach to landing and his failure to perform a go-around, which resulted in a runway overshoot and collision with trees.NTSB WPR15WA172Accident · 1 fatalForeign investigationRobinson R22 - Beta · Mitchell, AustraliaOn May 28, 2015 about 1620 local time, a Robinson R-22 helicopter, Australian registration VH-HRW, collided with terrain near Mitchell, Queensland, Australia. The helicopter sustained substantial damage, and the pilot was fatally injured. The investigation is…NTSB GAA15CA119Accident · No injuriesData collectionFinal reportCessna 172R · Beaver Falls, PAThe student pilot's failure to maintain airplane attitude control during the landing, resulting in a hard landing.NTSB GAA15CA099Accident · No injuriesData collectionFinal reportCessna 172 - R · State College, PAThe student pilot's failure to maintain adequate airspeed during the approach to landing which resulted in an aerodynamic stall and a hard landing.NTSB GAA15CA097Accident · No injuriesData collectionFinal reportBell 47G 3B 1 · Fort Pierre, SDThe pilot's inadequate preflight fuel planning that resulted in a total loss of engine power due to fuel exhaustion, and the pilot's failure to maintain control of the helicopter during the subsequent autorotation landing.NTSB GAA15CA096Accident · No injuriesData collectionFinal reportAero Vodochody L39 · Grand Junction, COThe pilot's inadequate preflight planning and subsequent failure to remain clear of power line wires while maneuvering at low altitude.NTSB CEN15LA247Accident · Serious injuriesClass 3 · LimitedFinal reportRaytheon G36 · Horseshoe Bay, TXThe pilot’s failure to abort the takeoff after the partial loss of engine power before liftoff, and the partial loss of engine power for undetermined reasons.NTSB WPR15LA168Accident · 1 fatalLimited investigationFinal reportHiller UH 12E · Wasco, CAAn in-flight impact with terrain for reasons that could not be determined based on available evidence.NTSB GAA15CA100Accident · No injuriesData collectionFinal reportCessna 305 · Richfield, UTThe pilot's loss of directional control during landing, which resulted in a ground loop.NTSB ERA15LA224Accident · No injuriesLimited investigationFinal reportCessna 337 · Melbourne, FLThe pilot’s failure to maintain directional control while taxiing as a result of his impairment due to alcohol ingestion.NTSB DCA15CA136Accident · Serious injuriesData collectionFinal reportBoeing 777 - 236 · Windsor Locks, CTan inadvertent encounter with convective turbulence resulting in serious injury to a flight attendant.NTSB CEN15LA250Accident · No injuriesLimited investigationFinal reportCessna T188C · Pine Bluffs, WYThe pilot's loss of directional control to the right for reasons that could not be determined during examination of the right main landing gear wheel and brake drum.NTSB CEN15LA243Accident · No injuriesLimited investigationFinal reportCessna TR182 · Tulia, TXThe partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical anomalies that would have precluded normal operation.NTSB CEN15LA242Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Superior, WIA stuck aileron due to a battery that had become jammed in the aileron bell crank.NTSB ANC15CA031Accident · No injuriesData collectionFinal reportAeronca 7EC · Palmer, AKThe instructor's delayed remedial actions, and the student pilot's failure to maintain adequate airspeed, which resulted in a stall just above the ground and the subsequent hard landing.NTSB ANC15CA030Accident · Minor injuriesData collectionFinal reportCessna U206G · Port Alsworth, AKThe pilot's inadequate preflight and mismanagement of the fuel supply, which resulted fuel exhaustion.NTSB GAA15CA089Accident · No injuriesData collectionFinal reportCessna 188 · Polson, MTThe pilot's failure to maintain airplane pitch, power, and turn coordination while maneuvering at low altitude, resulting in an aerodynamic stall and a collision with terrain.NTSB GAA15CA095Accident · No injuriesData collectionFinal reportCessna 182Q · Honesdale, PAThe pilot's failure to land with sufficient runway remaining to safely stop the airplane.NTSB GAA15CA094Accident · No injuriesData collectionFinal reportCessna 182E · Galion, OHThe pilot's failure to maintain adequate airspeed on final approach, which resulted in an in-flight loss of control and hard landing.NTSB GAA15CA090Accident · Minor injuriesData collectionFinal reportPiper PA 25-260 · Casselton, NDThe pilot's failure to monitor the flight environment for adequate terrain/obstacle clearance, which resulted in the inflight collision with power transmission line wires.NTSB ERA15CA222Accident · No injuriesData collectionFinal reportCessna 172P · Mitchellville, MDThe pilot’s improper landing flare, which resulted in a bounced landing and damage to the airplane.NTSB DCA15WA127Incident · No injuriesForeign investigationBoeing 737 - 883 · Oslo, NorwayThe Accident Investigation Board Norway (AIBN) has notified the NTSB of an incident involving a Boeing 737-800, which occurred on May 27, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AIBN investigation under the provisions of…NTSB CEN15LA241Accident · No injuriesLimited investigationFinal reportGarratt Mansfield W IV-P · Hamilton, TXThe pilot’s decision to continue flight into known severe thunderstorm conditions, which resulted in the loss of engine power during the descent due to the engine’s ingestion of water and ice and a subsequent forced landing.NTSB CEN15FA240Accident · 1 fatalField investigationFinal reportYakovlev YAK 52 · Syracuse, KSThe pilot’s failure to maintain airplane control while maneuvering at low altitude, which resulted in the airplane’s wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall .NTSB GAA15LA092Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Fresno, CAThe failure of the nose landing gear (NLG) leg due to fatigue fractures, which resulted in the NLG collapsing during landing.NTSB GAA15CA110Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Wickenburg, AZThe pilot's failure to monitor the airplane's wing clearance during taxi, which resulted in a collision with a parked airplane.NTSB CEN15WA254Accident · 2 fatalForeign investigationCessna T182 - T · Carlow, IrelandNTSB GAA15LA085Accident · Serious injuriesLimited investigationFinal reportDestiny 2000 · Eltopia, WAThe flight instructor’s failure to tell the student pilot to abort the takeoff after the powered parachute experienced wing oscillations, which resulted in the student pilot’s loss of aircraft control during initial climb and subsequent impact with terrain.…NTSB GAA15CA093Accident · No injuriesData collectionFinal reportRogers Homer/Rogers Sheila RV 6A · Lorain/Elyria, OHThe pilot's failure to maintain airplane attitude control during the landing flare, which resulted in an aerodynamic stall, hard landing, and runway excursion.