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 WPR09CA425Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Madras, ORThe pilot's inadequate compensation for the gusty crosswind condition and failure to maintain directional control during landing rollout.NTSB WPR09CA424Accident · Minor injuriesData collectionFinal reportSilvaire Luscombe 8A · Sandy, ORThe pilot's decision to continue the landing rather than execute a go-around. Contributing to the accident was the pilot's failure to maintain proper airspeed and altitude during the approach.NTSB WPR09CA421Accident · No injuriesData collectionFinal reportMeyer Robert AIR CAM · Hamilton, MTThe separation of the right main landing gear wheel due to the flight's encounter with soft terrain while landing on an unimproved river sandbar. Contributing to the accident was the pilot's decision to attempt a landing on an unimproved off-airport surface.NTSB CEN09WA607Accident · No injuriesForeign investigationEurocopter AS350 B2 · Némisko, CanadaOn August 28, 2009, at 1200 eastern daylight time, a Eurocopter model AS350 B2 (AStar), s/n 3292, Canadian registration C-FHAP, experienced a loss of engine power during cruise flight near Némisko, Québec, Canada. The helicopter was substantially damaged…NTSB CEN09CA560Accident · No injuriesData collectionFinal reportPiper PA-12 · Gonvick, MNA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.NTSB ANC09CA089Accident · No injuriesData collectionFinal reportAeronca 15AC · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a runway excursion, collision with terrain, and nose over.NTSB WPR09LA422Accident · No injuriesLimited investigationFinal reportCessna 210K · Show Low, AZA total loss of engine power due to the displaced oil filter adapter gasket, which resulted in an oil leak and oil exhaustion. Contributing to the accident was the unsuitable terrain for a forced landing.NTSB WPR09LA420Accident · No injuriesLimited investigationFinal reportAerospatiale AS350 B2 Ecureuil · Grand Canyon, AZThe pilot's failure to maintain clearance from a boulder during a low-altitude takeoff turn.NTSB WPR09LA419Accident · 2 fatalLimited investigationFinal reportJames B. Taplin RV-6 · Orland, CAThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall/spin.NTSB WPR09LA417Accident · No injuriesLimited investigationFinal reportPiper PA28R · Wendover, UTThe failure of the pilot to attain and maintain an airspeed sufficient for normal landing gear retraction during initial climb. Contributing to the accident was the pilot's failure to use the airplane's manual override landing gear system, misidentifying that…NTSB ERA09LA520Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Arcadia, FLThe pilot's bounced takeoff roll, which resulted in a collapsed landing gear. Contributing to the accident was the airplane's overweight condition.NTSB ERA09LA490Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAA total loss of engine power due to the loss of camshaft timing as a result of the displacement of the idler gear assembly.NTSB ERA09LA488Accident · Serious injuriesLimited investigationFinal reportBoeing 717-200 · Inverness, FLThe flight crew's encounter with convective turbulence. Contributing to the accident was the failure of the operator's dispatch department to provide the flightcrew with current adverse weather information along the planned route of flight. Also contributing…NTSB ERA09FA487Accident · 2 fatalField investigationFinal reportSocata TB20 · Pavo, GAThe pilot’s continued visual flight into instrument meteorological conditions, with embedded intense thunderstorms, heavy rain, and severe to extreme turbulence, resulting in an in-flight separation of the left wing due to overstress.NTSB ERA09CA489Accident · No injuriesData collectionFinal reportPiper J5A · Holland, MAA loss of engine power due to fuel exhaustion. A factor in the accident was the pilot's inadequate preflight inspection.NTSB CEN09CA545Accident · Minor injuriesData collectionFinal reportDekkinga Vans RV-7A · Jenison, MIThe pilot's failure to maintain aircraft control during the landing.NTSB ERA09WA486Accident · Minor injuriesForeign investigationCessna 208 · La Tortuga, VenezuelaOn August 26, 2009, about 1152 UTC, a Cessna 208B, Venezuelan registration YV1182, registered to and operated by Linea Turista Aerotuy (LTA), as a scheduled domestic passenger flight, had a total loss of engine power. The airline transport (ATP) rated pilot…NTSB ERA09LA494Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Luray, VAA total loss of engine power during initial climb for undetermined reasons.NTSB ERA09LA483Accident · 2 fatalLimited investigationFinal reportBeech C24R · Sylva, NCThe pilot's failure to maintain an adequate airspeed during an aborted landing, which resulted in an aerodynamic stall.NTSB ERA09CA485Accident · No injuriesData collectionFinal reportBell 206L-3 · White Plains, NYThe pilot's failure to disconnect the ground power unit prior to takeoff.NTSB CEN09LA551Accident · No injuriesLimited investigationFinal reportWeber Pelican · Searcy, ARA total loss of engine power due to fuel starvation as a result of the pilot's incorrect positioning of the fuel selector valve.NTSB CEN09LA549Accident · 1 fatalLimited investigationFinal reportPiper PA-15 · Lakeview, MIThe pilot's failure to maintain control of the airplane.NTSB WPR09LA418Accident · No injuriesLimited investigationFinal reportCessna 177 · Chandler, AZAn on-ground fire in the engine compartment for undetermined reasons.NTSB ERA09LA481Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Rockaway, NJA total loss of engine power due to oil starvation for undetermined reasons.NTSB ERA09CA484Accident · No injuriesData collectionFinal reportPiper PA-34 · Savannah, GAThe student pilot's failure to maintain pitch control during landing and the flight instructor's delayed remedial action, resulting in a hard landing.NTSB CEN09LA555Accident · 1 fatalLimited investigationFinal reportDestiny Powered Parachutes Destiny 2000 · Arcanum, OHThe failure of pilot to maintain an adequate visual lookout in order to avoid the collision with an aircraft on final approach to land.NTSB CEN09LA543Accident · 2 fatalLimited investigationFinal reportSportflight International Astra HKS · Bloomfield, INThe pilot's failure to maintain control of the airplane while maneuvering.NTSB CEN09CA559Accident · No injuriesData collectionFinal reportNavion Navion G · Eau Claire, MIA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management.NTSB ANC09LA088Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot’s decision to make an abrupt and steep low altitude turn just after takeoff, while attempting to return to his departure airport, resulting in an aerodynamic stall and loss of aircraft control. Contributing to the accident was the pilot’s failure to…NTSB ANC09LA086Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Chugiak, AKThe pilot’s delayed use of carburetor heat while operating in conditions conducive to carburetor icing.NTSB WPR09LA413Accident · Serious injuriesLimited investigationFinal reportAntares US MA-34R · San Jose, CAThe pilot's failure to maintain aircraft control during engine startup, which resulted in a collision with parked aircraft. Contributing to the accident was the engine's inadvertent increase to high power for undetermined reasons.NTSB ERA09CA482Accident · No injuriesData collectionFinal reportBell 206 · Gumboro Township, DEThe pilot’s failure to secure the flight controls before exiting the running helicopter. Contributing to the accident was the operator’s practice of exiting the helicopter while it was still running.NTSB CEN09CA547Accident · No injuriesData collectionFinal reportCessna 182P · Sugar Land, TXThe pilot's failure to control the airplane during engine startup, and his failure to maintain clearance from other objects.NTSB WPR09LA412Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Santa Barbara, CAA loss of power during approach due to fuel exhaustion for undetermined reasonsNTSB WPR09FA414Accident · 1 fatalField investigationFinal reportPiper PA-25 · Creswell, ORThe pilot's failure to maintain aircraft control during takeoff for a glider tow operation. Contributing to the accident were the tow pilot's impairment due to marijuana use and the low altitude of the flight that reduced the time available to recover from an…NTSB ERA09LA477Accident · Serious injuriesLimited investigationFinal reportVollenweider R/Hurst R F Vans RV-9A · Marianna, FLFailure of the propeller speed reduction gearbox for undetermined reasons. Contributing to the accident was the pilot’s decision to disregard the manufacturer's mandate to replace the gearbox, the manufacturer's failure to provide owners with technical…NTSB ERA09CA479Accident · No injuriesData collectionFinal reportJonker JS-1B · Tullahoma, TNThe pilot's failure to maintain a proper glidepath while on approach, resulting in landing short of the runway.NTSB ERA09CA475Accident · Serious injuriesData collectionFinal reportPiper PA-22 · Tuskegee, ALThe pilot’s failure to maintain directional control during the aborted landing.NTSB CEN09LA541Accident · Serious injuriesLimited investigationFinal reportCessna CE-560 · Kremmling, COThe lineman’s inadvertent encounter with jet blast.NTSB CEN09LA538Accident · 2 fatalLimited investigationFinal reportBrown Joseph B JR RV-6 · Ama, LAThe pilot’s failure to maintain directional control during takeoff.NTSB CEN09CA537Accident · No injuriesData collectionFinal reportRewey William M CH 801 · Cottage Grove, WIA total loss of engine power during initial climb due to fuel starvation from a blocked fuel screen that resulted from the pilot/owner's inadequate inspection and maintenance of the fuel system.NTSB ANC09CA087Accident · No injuriesData collectionFinal reportPiper PA-12 · Dillingham, AKThe pilot's decision to land on unsuitable soft, wet terrain, which resulted in a nose-over on landing.NTSB ERA09WA478Accident · No injuriesForeign investigationAgusta A109E · Ras Tanajib, Saudi ArabiaOn August 22, 2009, at 0506 universal coordinated time, an Agusta 109E helicopter, N906AH, operated by Saudi Aramco Aviation, sustained substantial damage during landing and a post crash fire at barge Arabyia 4, in the Persian Gulf, near Ras Tanajib, Saudi…NTSB ERA09LA476Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Fairmount, GAA total loss of engine power due to fuel starvation as a result of a contaminated fuel strainer.NTSB ERA09LA474Accident · No injuriesLimited investigationFinal reportCessna T210M · Dalton, GAThe failure of the right main landing gear actuator downlock spring.NTSB CEN10WA486Accident · 2 fatalForeign investigationCessna T206 · Hamburg Harbour, GermanyOn August 22, 2009, at 1252 coordinated universal time, a Cessna T206H, was substantially damaged when it nosed over during a water landing at Hamburg Harbour, Hamburg, Germany. Visual meteorological conditions prevailed at the time of the accident. The pilot…NTSB CEN09LA602Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301A · New Miner, WIA total loss of engine power due to the fatigue failure of the engine torsion shaft. Contributing to the accident was the chrome plating of the shaft by an undetermined maintenance/overhaul facility.NTSB CEN09LA542Accident · No injuriesLimited investigationFinal reportCessna 182 · Weeping Water, NEThe pilots' improper execution of soft/short field take-off procedures.NTSB CEN09LA536Accident · 2 fatalLimited investigationFinal reportBrown Steen Skybolt · Harrison, OHThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.NTSB CEN09CA540Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · East Grand Forks, MNThe pilot's failure to maintain clearance with the crops while maneuvering at low altitude.