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 CEN12LA056Accident · No injuriesLimited investigationFinal reportCessna 182K · Branson West, MOThe pilot's failure to ensure that his seat was in a locked position before takeoff, which resulted in the seat sliding rearward and the subsequent loss of directional control.NTSB ANC12FA006Accident · 1 fatalField investigationFinal reportEurocopter AS 350 B2 · Iliamna, AKThe pilot's loss of control due to sudden medical impairment or incapacitation.NTSB ERA12FA052Accident · 2 fatalField investigationFinal reportInterplane S R O Skyboy · Miami, FLThe pilot’s failure to maintain control of the airplane while flying at low speed, which resulted in a subsequent aerodynamic stall, spin, and impact with terrain. Contributing to the outcome of the accident was the pilot’s decision to operate the airplane…NTSB CEN12LA049Accident · Serious injuriesLimited investigationFinal reportBrochetti Louis Pietenpol Aircamper · Vienna, OHThe loss of engine power during climb after takeoff due to carburetor icing.NTSB WPR12LA023Accident · No injuriesLimited investigationFinal reportCessna 185 · Prineville, ORA total loss of engine power due to fuel starvation, which resulted from the pilot inadvertently leaving the fuel selector set to the left tank. Contributing to the accident was the pilot’s deviation from his normal habit pattern and his failure to refer to…NTSB ERA12CA053Accident · Serious injuriesData collectionFinal reportCessna 172F · Smoketown, PAThe pilot did not maintain a proper approach path, which resulted in a collision with a tree.NTSB DCA12WA010Accident · No injuriesForeign investigationBoeing 777 - 200 · Nani, KenyaOn October 28, 2011 about 1544 hours UTC, a Boeing 777-200LR, registration number A7-BBD, operated by Qatar Airways, encountered inflight turbulence, during cruise flight near Nani, Kenya. A cabin crew member received serious injuries. The flight originated…NTSB CEN12WA046Accident · 3 fatalForeign investigationPiper PA-31T · Toulouse, FranceUnder the jurisdiction and control of the French government.NTSB WPR12LA022Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas 500D · Colusa, CAA total loss of engine power while maneuvering at low altitude for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation. Contributing to the accident severity was the…NTSB WPR12FA021Accident · 1 fatalField investigationFinal reportCessna 182R · Lexington, ORThe pilot’s failure to maintain situational awareness and terrain clearance on a dark night during the approach to landing.NTSB ANC12WA007Accident · No injuriesForeign investigationVancouver, CanadaOn October 27, 2011, about 1600 pacific daylight time, a Beechcraft King Air 100, C-GXRX, operated by Northern Thunderbird Air, Inc. as a non-scheduled passenger flight, collided with terrain while attempting to land at the Vancouver International Airport,…NTSB CEN12FA043Accident · Serious injuriesField investigationFinal reportHawker Beechcraft 76 · Fort Worth, TXThe flight instructor's failure to maintain airspeed above the air minimum control airspeed (Vmca), which resulted in a loss of control and impact with terrain. Contributing to the accident was the instructor's failure to follow published procedures to…NTSB WPR12FA020Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · St. Paul, ORThe pilot was unable to see the other aircraft to avoid a collision.NTSB CEN12CA045Accident · No injuriesData collectionFinal reportEngineering & Research 415-C · Lebanon, OHThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA12CA050Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · McAlpin, FLThe pilot's misjudgment of the airplane's distance from known transmission lines.NTSB DCA12WA007Accident · No injuriesForeign investigationBoeing 737 - 800 · Faro, PortugalTheAir AccidentInvestigation Unit (AAIU) ofIrelandhas notified the NTSB of an accidentinvolving a B737-8AS that occurred on October 20, 2011. The NTSBhas appointed a U.S. Accredited Representative to assist the AAIU investigationunder the provisions of ICAO…NTSB CEN12FA037Accident · 1 fatalField investigationFinal reportCirrus Design SR22T · Carrollton, TXThe pilot's failure to adequately preflight the airplane prior to departure, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN12CA042Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · West Fargo, NDThe pilot's excessive use of brakes during the landing roll before the tailwheel had made sustained contact with the runway.NTSB CEN12CA041Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Pueblo, COThe certified flight instructor’s delayed remedial action. Contributing to the accident was the student pilot's failure to maintain control prior to the landing.NTSB ERA12LA048Accident · No injuriesLimited investigationFinal reportBeech C23 · Columbia, MSThe partial loss of engine power for undetermined reasons during takeoff.NTSB ERA12FA021Accident · 1 fatalField investigationFinal reportElkind Bruce Cozy MK IV · Lexington, NCThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA12CA047Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Dyersburg, TNThe pilot's inadvertent excessive braking during the landing roll.NTSB ENG12IA004Incident · No injuriesIncident investigationFinal reportBombardier CL600 2C10 · Atlanta, GAThe Start Operability Bleed Valve (OBV) fuel return adapter-fitting fractured and separated in cyclic fatigue, which allowed fuel to spill onto a hot engine case that ignited the undercowl fire. The OBV fuel adapter-fitting was dropped and the damage reduced…NTSB ENG12IA003Incident · No injuriesIncident investigationFinal reportBoeing 747-451 · Detroit, MIThe penetration of turbine blade fragments through the rear turbine case, which punctured the No. 4 bearing oil pressure supply tube, allowing misted oil to contact the hot engine case and ignite the undercowl fire. Contributing to the incident was the…NTSB CEN12WA040Accident · 2 fatalForeign investigationCessna 210G · Veracruz, MexicoNTSB CEN12CA036Accident · No injuriesData collectionFinal reportCessna 210J · West Chicago, ILThe pilot's failure to extend the landing gear before touchdown due to his failure to use a checklist.NTSB ERA12FA018Accident · 1 fatalField investigationFinal reportBerger Michael A Waiex · Washington, GAThe in-flight failure of the aircraft’s Y-tail attachment structure during maneuvering flight due to overload. Contributing to the accident was, the kit manufacturer’s use of 14 CFR Part 23, Appendix A design guidelines intended for a conventional tail…NTSB ERA12CA019Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Manassas, VAThe pilot did not maintain adequate airspeed while turning to the downwind leg, which resulted in an aerodynamic stall and spin.NTSB ANC12CA005Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Portage, AKThe pilot's selection of unsuitable terrain for landing.NTSB ANC12CA004Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Aniak, AKThe pilot's excessive use of brakes during landing.NTSB WPR12LA015Accident · Minor injuriesLimited investigationFinal reportPiper PA46R · Paso Robles, CAA loss of engine power while maneuvering for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN12CA035Accident · Minor injuriesData collectionFinal reportHouts Avid Mark IV · Hibbing, MNThe improper installation of a hose clamp, which resulted in an oil line rupture and subsequent loss of engine oil pressure.NTSB WPR12WA186Accident · No injuriesForeign investigationPiper PA-34-220T · Karachi, PakistanOn October 20, 2011, at 1138 local time, a Piper PA-34-220T, Pakistan registry AP-BDK, was substantially damaged during a forced landing following a dual engine failure while in cruise flight. The aircraft was operated by M/S Schon Air Limited of Karachi,…NTSB ERA12CA044Accident · Serious injuriesData collectionFinal reportBoeing 767-2B7 · New York, NYThe passenger's lack of compliance with the illuminated seatbelt sign, which resulted in her injury during a turbulence encounter.NTSB CEN12CA044Accident · No injuriesData collectionFinal reportAviat A-1 · Wolverton, MNThe pilot's inadvertent excessive braking during the landing roll due to momentary pain.NTSB WPR12CA016Accident · No injuriesData collectionFinal reportBeech D17S · Phoenix, AZThe pilot's failure to extend the landing gear.NTSB ERA12LA045Accident · No injuriesLimited investigationFinal reportGraff Wilbur C Bearhawk · Woodrow, WVThe pilot’s delayed use of carburetor heat while operating in conditions conducive to carburetor icing.NTSB ERA12CA042Accident · Minor injuriesData collectionFinal reportMoyes Bailey Dragonfly · Massey, MDThe pilot did not maintain airspeed during approach to landing, which resulted in an aerodynamic stall.NTSB CEN12CA028Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Brookings, SDThe pilot's inadequate compensation for gusty wind conditions while landing.NTSB ERA12LA034Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Newnan, GAA total loss of engine power for undetermined reasons.NTSB ERA12LA033Accident · No injuriesLimited investigationFinal reportCessna R172K · Williamsburg, VAA total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA12FA030Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Danbury, CTThe pilot did not maintain clearance from a lighted tower during final approach in night visual conditions.NTSB ERA12CA043Accident · Minor injuriesData collectionFinal reportFehlner-Shelton Aerosport Scamp WTB1 · Grantham, NCThe pilot's inadequate clearance from unmarked power lines while on approach to land at a private airport.NTSB ERA12CA036Accident · Serious injuriesData collectionFinal reportCessna 172F · Atlanta, GAThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA12CA035Accident · Serious injuriesData collectionFinal reportAmerican Champion 7AC · Berkley, MAThe pilot did not maintain clearance from a tree during the final approach in solar glare conditions.NTSB DCA12WA005Accident · Serious injuriesForeign investigationBoeing 777 · Putong, ChinaOn October 17, 2011, a Singapore Airlines B777-300, Singapore registration 9V-SYH, operating as a passenger flight between Shanghai, China and Singapore, encountered turbulence while in cruise flight about 10nm east of waypoint KARAN. One passenger was…NTSB CEN12FA025Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Watertown, WIThe separation of the number 2 connecting rod from the crankshaft for reasons that could not be determined during postaccident metallurgical examination, which ultimately resulted in a total loss of engine power.NTSB CEN12CA030Accident · No injuriesData collectionFinal reportCessna 172N · Covington, LAThe pilot’s failure to maintain adequate airspeed during a banner drop, resulting in an aerodynamic stall.NTSB WPR12FA012Accident · 3 fatalField investigationFinal reportBeech E33 · Daggett, CAA loss of engine power due to the separation of a connecting rod, and the pilot's failure to maintain airplane control during a sudden maneuver to avoid power lines during the descent, which resulted in an unrecoverable aerodynamic stall and subsequent spin.…NTSB WPR12CA014Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Las Vegas, NVThe inadvertent opening of the airplane’s canopy during takeoff, which distracted the pilot and resulted in his failure to maintain control of the airplane. Contributing to the accident was the pilot's failure to comply with the manufacturer's recommended…