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 ERA11GA207Accident · 1 fatalFinal reportCessna A185F · Ashland, MEAn inadvertent encounter with localized instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB ERA11CA206Accident · Serious injuriesData collectionFinal reportRolladen-Schneider LS-3 · Winchester, TNThe glider pilot's delayed response to changing weather conditions, which resulted in an off-airport landing into trees.NTSB CEN11LA265Accident · No injuriesLimited investigationFinal reportDassault-Breguet Falcon 10 · Sellersburg, INThe pilot's failure to maintain control of the airplane during landing in strong and gusty wind conditions.NTSB CEN11LA252Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · (Gulf of Mexico)The loss of engine power due to an engine compressor stall as a result of ingesting methane gas during takeoff.NTSB CEN11FA244Accident · 2 fatalField investigationFinal reportCessna 182M · Hot Springs, ARA total loss of engine power for undetermined reasons.NTSB OPS11IA401Incident · No injuriesIncident investigationFinal reportArlington, VAThe tower controller's loss of consciousness induced by lack of sleep, fatigue resulting from working successive midnight shifts, and air traffic control scheduling practices.NTSB ERA11CA205Accident · Minor injuriesData collectionFinal reportCessna 172M · Statesville, NCThe certified flight instructor's inadequate remedial action during the go-around, which resulted in a collision with trees.NTSB DCA11FA035Accident · No injuriesField investigationFinal reportAirbus F4-622R · Albuquerque, NMThe captain's failure to control the airplane pitch-up induced by ground spoiler deployment during the go-around.NTSB CEN11LA273Accident · No injuriesLimited investigationFinal reportCessna 414A · Aberdeen, SDThe pilot's inadequate compensation for gusty crosswinds during takeoff, which resulted in a loss of directional control.NTSB CEN11CA268Accident · Minor injuriesData collectionFinal reportCub Crafters CC11-160 · Kiowa, COThe pilot's failure to maintain directional control following a hard landing.NTSB ERA11LA204Accident · No injuriesLimited investigationFinal reportRobinson R22 · Goshen, NYThe pilot’s failure to adhere to published preflight checklist limitations and procedures, resulting in excessive slack and subsequent failure of the power transmission belts and a total loss of rotor system drive.NTSB WPR11LA175Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Spanish Fork, UTThe student pilot's inadequate compensation for the gusting wind, which resulted in a loss of airplane control during landing. Contributing to the accident was the pilot's decision to depart with a high gusting wind.NTSB CEN11CA242Accident · No injuriesData collectionFinal reportDarrow Stephen A Aventura · Ferris, TXThe pilot’s loss of aircraft control during landing.NTSB WPR11FA173Accident · 3 fatalField investigationFinal reportCessna P210 · Daggett, CAThe pilot's decision to conduct the flight into a region of reported moderate to severe turbulence and icing conditions, followed by a loss of airplane control and an aerodynamic spin from which the pilot did not recover.NTSB WPR11CA174Accident · Minor injuriesData collectionFinal reportCessna 182C · Stockton, CAThe pilot's failure to secure the airplane before pulling the propeller to start the engine.NTSB ERA11LA203Accident · No injuriesLimited investigationFinal reportCessna 150H · Maury City, TNThe pilot's failure to attain the proper glidepath during on off-airport landing.NTSB ERA11LA198Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Vineyard Haven, MAThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA11CA201Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Mount Pocono, PAThe flight instructor's selection of an unsuitable landing site to practice autorotations, which resulted in an inadvertent dynamic rollover during touchdown.NTSB CEN11LA239Accident · 1 fatalLimited investigationFinal reportGlasflugel Standard Libelle · Wellington, COThe pilot's loss of glider control due to impairment or incapacitation caused by an episode of ventricular tachycardia.NTSB CEN11FA240Accident · 2 fatalField investigationFinal reportCessna 150D · Baraboo, WIThe student pilot’s inadequate preflight planning and his decision to continue the flight into instrument meteorological conditions, which resulted in a subsequent loss of airplane control.NTSB WPR11LA172Accident · No injuriesLimited investigationFinal reportBeech G35 · Whidbey Island, WAThe pilot's failure to prioritize flying over navigation due to his diverted attention, which allowed the airplane to near a restricted area, which, in turn, led the pilot to enter a rapid avoidance maneuver and subsequently lose airplane control.…NTSB WPR11LA169Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Mesa, AZThe pilot's attempt to correct a landing float by adding power, followed by his premature attempt to climb the airplane out of ground effect during a balked landing, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's failure…NTSB WPR11LA168Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Puyallup, WAThe pilots’ activation of the fuel boost pump while preparing to land, which was contrary to checklist procedures and resulted in a loss of engine power.NTSB WPR11FA170Accident · 1 fatalField investigationFinal reportCessna T310R · Butte, MTThe pilot's loss of airplane control during the missed approach for undetermined reasons. Contributing to the accident was the rapid and unforecast deterioration of the weather conditions to below the landing minimum and the pilot's decision to attempt the…NTSB WPR11CA171Accident · No injuriesData collectionFinal reportRemos GX · Arlington, WAThe LSA pilots' failure to stop and to ensure that the taxiway was clear of conflicting traffic before entering.NTSB ERA11LA208Accident · 1 fatalLimited investigationFinal reportJennings John C Mini Max · Clinton, SCThe pilot's inadequate performance planning, which resulted in a collision with a tree during takeoff.NTSB ERA11LA200Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Hollywood, FLA total loss of engine power for undetermined reasons.NTSB ERA11LA197Accident · No injuriesLimited investigationFinal reportBurr Andrew E Xiv Rotorway Exec 162F · Lincoln, ALA total loss of engine power during cruise flight for undetermined reasons.NTSB ERA11LA196Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ocean Springs, MSThe airplane's overweight condition due to the pilot's improper weight and balance calculation that resulted in the airplane's inability to maintain altitude.NTSB ERA11CA199Accident · No injuriesData collectionFinal reportLuscombe 8E · Taunton, MAThe pilot's inadvertent application of the brakes during recovery from a ground loop which resulted in a nose over.NTSB ERA11CA195Accident · Serious injuriesData collectionFinal reportBrown Narcisse A Christen Eagle II · Gainesville, FLThe pilot's failure to maintain airspeed while turning from base leg to final approach, which resulted in an aerodynamic stall and collision with the ground.NTSB ENG11RA023Accident · No injuriesForeign investigationBell Bell · Alcorsia, Teruel, Spain, SpainOn March 19, 2011, at 12:35 UTC, a Bell 407 helicopter crashed near the town of Villastar, Teruel - Spain. The helicopter crashed while transporting a fire brigade to extinguish a blaze in the eastern part of Spain about 400 kilometers from Madrid. The pilot,…NTSB CEN11CA241Accident · Minor injuriesData collectionFinal reportCessna 150M · Garland, TXThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11CA238Accident · No injuriesData collectionFinal reportCessna 305A · Anoka, MNThe pilot's failure to maintain control of the airplane during the go-around, which resulted in an inadvertent stall.NTSB ANC11CA020Accident · No injuriesData collectionFinal reportPiper PA-18A 150 · Beluga Lake, AKThe pilot's decision to land on unsuitable terrain, resulting in the airplane nosing over.NTSB ANC11CA018Accident · No injuriesData collectionFinal reportCessna A185F · Aniak, AKThe inadvertent contact with a rut in the snow while taxiing, resulting in the collapse of the right main landing gear.NTSB CEN11LA237Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Austin, TXThe loss of engine power due to fuel starvation for undetermined reasons.NTSB CEN11IA234Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145XR · Akron, OHThe uncommanded left deflection of the airplane's nosewheel for reasons that could not be determined because postincident examination of the nosewheel steering system did not reveal any anomalies that would have precluded normal operation.NTSB ERA11CA194Accident · No injuriesData collectionFinal reportRobinson R44 · Petersburg, WVThe pilot's failure to maintain control during the takeoff.NTSB ENG11IA021Incident · No injuriesIncident investigationFinal reportBombardier DHC 8 402 · Pittsburgh, PAthe flight crew's delay in shutting down the left engine following an engine oil pressure master warning, which led to a hard rub inside the engine that served as an ignition point for a titanium fire. Contributing to the event was a PW150 No. 5 seal design…NTSB CEN11CA233Accident · No injuriesData collectionFinal reportMaule M-4-220C · Albuquerque, NMThe pilot's failure to maintain control of the airplane during landing, which resulted in a runway excursion.NTSB CEN11CA232Accident · No injuriesData collectionFinal reportBell 230 · Gulf of Mexico, LAThe pilot's failure to maintain adequate clearance from the safety skirting during the repositioning landing.NTSB CEN11CA231Accident · No injuriesData collectionFinal reportHiller UH-12D · Iowa, LAThe pilot's inadequate compensation for gusty crosswinds during takeoff, which resulted in a loss of directional control.NTSB ANC11CA017Accident · No injuriesData collectionFinal reportChampion 7GCBC · Nenana, AKThe pilot's selection of an unsuitable off-airport landing site, which resulted in a nose over.NTSB WPR11FA166Accident · 5 fatalField investigationFinal reportBeech 200 · Long Beach, CAThe pilot's failure to maintain directional control of the airplane during a momentary interruption of power from the left engine during the initial takeoff climb. Contributing to the accident was the power interruption due to water contamination of the fuel,…NTSB ENG11WA054Incident · No injuriesForeign investigationBell 412 - EP · Zakum Field, United Arab EmiratesOn March 16, 2011, about 0718 coordinated universal time, a Bell 412EP helicopter, United Arab Emirates (UAE) registration A6-FLV, experienced a failure of the landing gear aft cross tube during loading of the helicopter at Zakum Field, UAE. The investigation…NTSB CEN11CA236Accident · No injuriesData collectionFinal reportPiper PA-22-150 · South St. Paul, MNThe pilot's failure to maintain directional control of the airplane during the takeoff roll.NTSB WPR11LA167Accident · No injuriesLimited investigationFinal reportRotorway A600 · Chandler, AZA design modification that changed the fasteners and components used to attach the main rotor drive pulley to the engine, which resulted in fatigue failure of those fasteners and a complete loss of power to the main rotor.NTSB WPR11CA165Accident · No injuriesData collectionFinal reportBellanca 14-13-2 · Mesquite, NVThe malfunction of the brake system which led to the pilot's failure to maintain directional control during the landing roll.NTSB ERA11LA190Accident · No injuriesLimited investigationFinal reportCessna 182P · Alachua, FLA loss of engine power due to the failure of the camshaft gear teeth and crankshaft gear teeth for undetermined reasons.