NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 CEN09CA468Accident · No injuriesData collectionFinal reportCorvus Carone MK 1 · Lee's Summit, MOA loss of engine power for undetermined reasons.NTSB CEN09CA465Accident · No injuriesData collectionFinal reportPiper PA32R · Colorado Springs, COThe pilot's low altitude encounter with windshear during takeoff.NTSB ANC09CA073Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Tok, AKThe pilot's failure to maintain clearance from a parked truck during takeoff from a roadway, resulting in a collision with the truck.NTSB WPR09LA372Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Walla Walla, WAA tripped landing gear motor circuit breaker, which prevented the gear from fully locking in the down position, and subsequent collapse during landing. Contributing to the accident was the disabled landing gear warning horn.NTSB WPR09LA362Accident · 1 fatalLimited investigationFinal reportMooney M20C · Elma, WAA total loss of engine power during cruise flight due to the fatigue failure of the number 4 cylinder connecting rod.NTSB ERA09FA414Accident · 1 fatalField investigationFinal reportHughes 369 · Franklin, PAA loss of engine power due to fuel exhaustion as a result of the pilot's fuel mismanagement.NTSB CEN09CA587Accident · No injuriesData collectionFinal reportTolbert Robert R Rans S-6 · Santa Rosa, NMThe pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall during takeoff.NTSB CEN09CA455Accident · No injuriesData collectionFinal reportForster SA-300 · Iowa City, IAthe loss of engine power for undetermined reasons.NTSB ANC09LA072Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 · Iliamna, AKThe pilot's selection of an unsuitable landing/takeoff area with an unfavorable wind.NTSB WPR09TA356Accident · 1 fatalFinal reportBell 212 · Willow Creek, CAThe rappeller's failure to properly latch the rappelling harness to the rappelling assembly before exiting the helicopter.NTSB WPR09LA361Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Redmond, ORAn undetermined hydraulic system malfunction in the engine compartment during descent from cruise flight which resulted in an in-flight fire.NTSB WPR09CA360Accident · Serious injuriesData collectionFinal reportRobinson R22 Beta · Jerome, AZThe pilot’s failure to maintain adequate main rotor rpm's, and the certified flight instructor’s inadequate supervision of the flight.NTSB CEN09CA473Accident · Minor injuriesData collectionFinal reportStinson 108 · Gardner, KSThe pilot's failure to ensure that the fuel selector valve was set properly in its detent prior to takeoff, resulting in fuel starvation.NTSB CEN09CA464Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Fort Collins, COThe pilot's failure to maintain directional control while landing in gusty, crosswind conditions.NTSB CEN09CA452Accident · Minor injuriesData collectionFinal reportWeatherly 620B · New England, NDThe loss of engine power for undetermined reasons while maneuvering at low altitude.NTSB WPR09CA358Accident · Minor injuriesData collectionFinal reportWsk-Pzl Meilec PZL M18B · Rockland, IDThe pilot's failure to maintain clearance from the terrain during an aerial application reversal turn.NTSB DCA09WA066Incident · No injuriesForeign investigationBoeing 767 · Keflavik, IcelandOn July 20, 2009, UAL flight 949, a B767 enroute from London Heathrow to Chicago O'Hare experienced smoke in the cockpit and the crew elected to divert to Keflavik, Iceland. The flight landed without further incident and no injuries among the 11 crew and 178…NTSB ANC09WA079Accident · 2 fatalForeign investigationRobinson R44 · Tajima, JapanOn July 20, 2009, about 0925 Japan standard time, a Robinson R44 helicopter, Japanese registration JA32CT, collided with mountainous terrain about 9 miles southeast of the Tajima Airport, Tajima, Japan. The helicopter sustained substantial damage due to…NTSB ANC09WA071Accident · 2 fatalForeign investigationPiper PA-46-31P · Kamsack, CanadaOn July 19, 2009, about 2100 central standard time, a Piper PA-46-31P airplane, Canadian registration C-GUZZ, crashed on takeoff from Kamsack, Saskatchewan, Canada. Two people aboard received fatal injuries, and the remaining two people aboard received…NTSB WPR09CA359Accident · No injuriesData collectionFinal reportSchweizer SGS-2-33A · Truckee, CAThe student pilot's failure to maintain adequate airspeed to avoid a stall during final approach to land. Contributing to the accident was the pilot’s lack of experience.NTSB ERA11LA028Accident · Minor injuriesLimited investigationFinal reportBrown Thomas E Thorp T-18 · Lake Como, FLThe pilot's delayed decision to execute a go-around while landing with variable wind, which resulted in a runway overrun.NTSB ERA09LA413Accident · 1 fatalLimited investigationFinal reportCessna 152 · Ponce, PRThe airplane’s impact with water for undetermined reasons.NTSB ERA09LA412Accident · 1 fatalLimited investigationFinal reportJames O'Bert Vari-Eze · Columbus, GAThe pilots improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB ERA09LA410Accident · No injuriesLimited investigationFinal reportRobinson R44 · Silver Spring, PAThe student pilot's inability to fully control the helicopter, during cruise and the resultant off-field hard landing.NTSB ERA09LA409Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Mahwah, NJA loss of engine power due to the failure of the No. 1 cylinder thru bolt hold down nuts due to corrosion.NTSB CEN09LA444Accident · 1 fatalLimited investigationFinal reportBeech TC-45J · Verdel, NEThe pilot's improper decision to fly an airplane that was not airworthy and for which he was not properly rated to operate, and his failure to maintain control of the airplane during a forced landing to a field following an engine failure. Contributing to the…NTSB CEN09IA456Incident · No injuriesIncident investigationFinal reportCessna 172R · West Chicago, ILA partial loss of engine power due to the detachment of the throttle control cable from the throttle assembly during a landing approach. Contributing to the accident was the lack of a redundant means to preclude the detachment of the cable from the throttle…NTSB ANC09CA070Accident · No injuriesData collectionFinal reportDressen Donald L Back Count · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, resulting in a ground-loop and substantial damage to the airplane.NTSB WPR09LA357Accident · 2 fatalLimited investigationFinal reportWeiss Lancair · Santa Clarita, CAThe pilot's failure to maintain adequate airspeed and control while maneuvering.NTSB WPR09LA355Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Truckee, CAA loss of engine power during initial climb for undetermined reasons.NTSB WPR09LA354Accident · Serious injuriesLimited investigationFinal reportLeider T-18 · Carson City, NVThe pilot’s failure to maintain directional control during landing.NTSB CEN09WA454Accident · 1 fatalForeign investigationCirrus SR22 · Perrigny, FranceUnder the jurisdiction and control of the French government.NTSB CEN09LA445Accident · Serious injuriesLimited investigationFinal reportMarvin Faulk Tinker Bell · La Porte, TXThe pilot's failure to maintain adequate airspeed during takeoff, which resulted in a collision with terrain.NTSB CEN09CA458Accident · No injuriesData collectionFinal reportCessna 172M · New Braunfels, TXThe pilot's inadequate recovery from a bounced landing.NTSB CEN09CA453Accident · No injuriesData collectionFinal reportPiper PA28 · Malvern, ARThe pilot's failure to maintain adequate airspeed during the approach to landing.NTSB CEN09CA450Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Waring, TXThe pilot's failure to maintain directional control during landing roll-out. Contributing to the accident was the worn left main landing gear brake.NTSB CEN09CA449Accident · No injuriesData collectionFinal reportFoglio Tiger CUB · Toronto, OHThe pilot not turning off the carburetor heat prior to takeoff resulting in the engine's reduced performance, and his failure to remain clear of the tree during takeoff.NTSB ANC09LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Anchorage, AKThe pilot's unfamiliarity with the airport environment, which resulted in his taxiing the airplane onto a no-taxi section of roadway and into a road sign. Contributing to the accident was the pilot's failure to avail himself of additional information that…NTSB WPR09TA353Accident · Minor injuriesFinal reportCroman SH-3H · Willow Creek, CAThe pilot’s failure to maintain adequate power during egress from a heliwell, which resulted in collision with the heliwell and a dynamic rollover.NTSB ERA09FA419Accident · 3 fatalField investigationFinal reportMD Helicopter 530 (369FF) · Camp Butler, IraqThe pilot’s failure to maintain terrain clearance during a low-level course reversal.NTSB ERA09FA411Accident · 1 fatalField investigationFinal reportCessna R182 · Hayesville, NCFlight into terrain for undetermined reasons.NTSB DCA10WA009Incident · Serious injuriesForeign investigationBoeing 737 · Stansted, United KingdomOn July 17, 2009, while boarding the airplane, a child passenger fell off the airstair to a Ryanair Boeing 737, registration EI-DLJ, at London Stansted airport. The passenger was seriously injured. The UK AAIB is investigating.NTSB CEN09CA448Accident · No injuriesData collectionFinal reportCessna C-182 · Fox Lake, ILThe pilot's inadequate flight planning and continued flight into adverse weather resulting in the collision with the pier during landing.NTSB WPR09LA350Accident · Minor injuriesLimited investigationFinal reportBielawa Rotorway E · Sequim, WAThe failure (disbonding) of a composite main rotor blade for undetermined reasons, leading to an immediate loss of control in flight during hover.NTSB WPR09CA348Accident · Serious injuriesData collectionFinal reportCessna 172M · Thermopolis, WYThe instructor pilot's failure to ensure that his dual student maintained clearance from the terrain during a dark night visual flight rules descent.NTSB ERA09LA407Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Morristown, TNThe partial loss of engine power for undetermined reasons.NTSB CEN09LA447Accident · No injuriesLimited investigationFinal reportCessna A188B · Suring, WIA loss of engine power resulting from the fatigue failure of the crankshaft due to the loss of engine case through-bolt torque. Contributing to the engine failure was the operator's failure to overhaul the engine in accordance with the manufacturer's…NTSB ANC09TA068Accident · No injuriesFinal reportCessna 180A · Anchorage, AKThe pilot's failure to maintain directional control while landing in a crosswind, which resulted in a ground-loop.NTSB WPR09FA347Accident · 3 fatalField investigationFinal reportRaytheon G36 · Hawthorne, CAThe pilot’s failure to maintain an adequate airspeed during a go-around, which resulted in a loss of airplane control. Contributing to the accident was the inadvertent activation of the fuel boost pump during the attempted go-around.NTSB WPR09CA351Accident · No injuriesData collectionFinal reportCox John Wiley Kitfox III · Laurel, MTThe pilot's failure to maintain directional control during an attempted go-around from a landing.