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 WPR09CA435Accident · No injuriesData collectionFinal reportPiper PA-20 · Bozeman, MTThe failure of the pilot receiving instruction to maintain directional control during the takeoff roll and the flight instructor's delayed corrective action.NTSB WPR09CA434Accident · No injuriesData collectionFinal reportCessna 195 · Camarillo, CAThe pilot's failure to maintain directional control during the landing roll.NTSB ERA09LA511Accident · Minor injuriesLimited investigationFinal reportAir Creation 582SL · Strafford, NHA loss of engine power for undetermined reasons.NTSB ERA09LA506Accident · No injuriesLimited investigationFinal reportCessna 140 · Louisa, VAThe Cessna pilot's inadequate visual lookout.NTSB ERA09LA502Accident · 2 fatalLimited investigationFinal reportM-Squared Sprint 1000 · Madeira Beach, FLA loss of torque to the gearbox engine-side coupling flange bolts, which resulted in separation of the gearbox and propeller from the engine and the subsequent severing of the airplane's tail structure.NTSB CEN09LA575Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Preston, TXThe loss of engine power for undetermined reasons.NTSB CEN09LA567Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Marshall, MIThe failure of the main landing gear attach point.NTSB CEN09FA562Accident · 5 fatalField investigationFinal reportPiper PA-32R-300 · Tulsa, OKThe non-instrument-rated pilot’s decision to attempt flight in instrument meteorological conditions, which resulted in spatial disorientation and an in-flight collision with a radio tower guy wire.NTSB CEN09CA581Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Spicewood, TXThe pilot's failure to maintain directional control of the airplane during landing.NTSB CEN09CA577Accident · No injuriesData collectionFinal reportKetonen Schreder · Ionia, MIThe pilot failed to maintain control of the glider during the aero-tow launch.NTSB ANC09CA096Accident · No injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot’s decision to land on unsuitable terrain, which resulted in a loss of control and a collision with trees.NTSB WPR09LA431Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Oroville, CAA total loss of engine power for undetermined reasons.NTSB WPR09CA440Accident · No injuriesData collectionFinal reportUniversal Globe GC-1 · Pacoima, CAThe pilot's failure to maintain directional control during the landing roll.NTSB ERA09LA516Accident · Minor injuriesLimited investigationFinal reportSiai-Marchetti F.260 · Atlanta, GAA total loss of engine power due to a fuel system air leak as a result of a deteriorated O-ring seal in the fuel shut-off cock. Contributing to the accident was the exceedance of the suggested overhaul schedule for the fuel shut-off cock.NTSB ERA09CA508Accident · No injuriesData collectionFinal reportMooney 231 · Charlottesville, VAThe pilot’s inadequate preflight planning and lack of familiarity with the airport diagram, which resulted in a runway excursion onto a grassy area.NTSB CEN09LA561Accident · Serious injuriesLimited investigationFinal reportChampion 7KCAB · Stacy, MNA partial loss of engine power during initial climb for undetermined reasons.NTSB CEN09IA578Incident · No injuriesIncident investigationFinal reportCessna 421 · Sugar Land, TXThe improper installation of the pitch trim cable which resulted in it making improper contact with a guard pin that led to the fatigue failure of the cable.NTSB WPR09LA436Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Torrance, CAA main rotor overspeed due to the pilot’s failure to maintain rotor RPM within allowable limits during a practice autorotation.NTSB ENG09IA017Incident · Minor injuriesIncident investigationFinal reportEmbraer ERJ 190-100 IGW · Nassau, Bahamasfailure of the engine high pressure turbine active clearance control valve fuel rod supply tube coupling seal due to a cross-threaded B-nut as installed during original manufacture.NTSB CEN09LA572Accident · Minor injuriesLimited investigationFinal reportWright Bruce M Avid Flyer · Hitchcock, TXA total loss of engine power for undetermined reasons.NTSB ANC09TA092Accident · No injuriesFinal reportAviat A-1B · Gulkana, AKThe pilot's excessive use of brakes during an off-airport landing, resulting in the airplane nosing over.NTSB ANC09CA095Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Talkeetna, AKThe pilot's selection of an unsuitable landing/takeoff area, resulting in a nose over during takeoff.NTSB WPR09CA439Accident · No injuriesData collectionFinal reportBellanca 17-30A · La Grande, ORThe pilot's improper flare, which resulted in a bounced landing.NTSB DCA09WA076Accident · 5 fatalForeign investigationBell 430 · Kurnoon, IndiaOn September 2, 2009, at approximately 0343 UTC, a Government of Andhra Pradesh Gad (Poll "c") Bell 430 helicopter crashed enroute to Chitoor, India from Hyderabad, India. There were 2 crew members and 3 passengers, including the Secretariat of Hyderabad on…NTSB CEN09LA558Accident · No injuriesLimited investigationFinal reportHughes 269C · Arapahoe, NEA sudden vibration for undetermined reasons.NTSB CEN09LA557Accident · No injuriesLimited investigationFinal reportCessna 150F · Rosedale, MIThe pilot's failure to maintain directional control during the takeoff ground run. Contributing to the accident were the pilot's deteriorated physical and mental capabilities.NTSB CEN09CA568Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-1C · Holland, MIThe pilot's failure to maintain control of the airplane during the landing and subsequent go-around.NTSB ANC09CA091Accident · No injuriesData collectionFinal reportHelio H-295 · Koliganek, AKA loss of engine power during cruise flight due to water in the fuel, and the pilot's inadequate preflight inspection.NTSB ERA09LA498Accident · Serious injuriesLimited investigationFinal reportHahn R-W22 Tiger Moth Rep · Symrna, TNA loss of engine power for undetermined reasons.NTSB ERA09LA496Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Mansfield, MAA loss of engine power due to carburetor icing as a result of the pilot's delayed use of carburetor heat.NTSB ERA09FA497Accident · 1 fatalField investigationFinal reportRobinson R44 · Jackson, MSThe pilot's failure to maintain adequate main rotor rpm, for undetermined reasons.NTSB CEN09CA615Accident · No injuriesData collectionFinal reportCessna 175 · Rio Blanco, COThe pilot's failure to maintain directional control during landing and his failure to execute a go-around.NTSB WPR09CA430Accident · No injuriesData collectionFinal reportCessna 152 · Merced, CAThe pilot's improper flare which resulted in a hard landing and subsequent collapse of the nose landing gear strut.NTSB ERA09CA504Accident · No injuriesData collectionFinal reportCessna 152 · Harrisburg, PAThe student pilot’s delayed decision to abort the takeoff, resulting in an overrun.NTSB CEN10WA072Accident · 1 fatalForeign investigationCessna 414 · Simeprodeso, MexicoNTSB CEN09CA556Accident · No injuriesData collectionFinal reportAlon A2 · Richmond Hts., OHThe pilot's failure to maintain control of the airplane during the landing flare.NTSB ANC09TA090Accident · No injuriesFinal reportPiper PA-18-150 · Bethel, AKThe pilot's excessive use of brakes while landing at an off-airport site.NTSB WPR09LA427Accident · Serious injuriesLimited investigationFinal reportStone Kitfox Series 6 · May, IDThe pilot's failure to maintain clearance from obstacles during the takeoff initial climb.NTSB WPR09FA428Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Canyonville, ORThe non-instrument-rated and non-certificated pilot’s decision to continue visual flight into instrument meteorological conditions in mountainous terrain, which resulted in controlled flight into terrain.NTSB WPR09CA429Accident · No injuriesData collectionFinal reportCurtiss Wright Travel AIR · San Diego, CAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.NTSB ERA09LA492Accident · 1 fatalLimited investigationFinal reportBond Neal O S-9 · Saylorsburg, PAThe pilot’s excessive flight control inputs that resulted in an overload failure of the right elevator and horizontal stabilizer.NTSB ERA09LA491Accident · Minor injuriesLimited investigationFinal reportMyers Donald E Kitfox 4 · Flintstone, MDA total loss of engine power due to the lack of sufficient lubrication and the pilot/owner’s failure to adequately service the airplane’s engine.NTSB ERA09CA493Accident · No injuriesData collectionFinal reportBeech B19 · Thomasville, PAA partial loss of engine power due to a partial blockage of the carburetor fuel inlet filter.NTSB CEN09CA553Accident · No injuriesData collectionFinal reportWarner Lewis Steen · Broomfield, COThe pilot's inability to maintain directional control due to an internal mechanical failure of the left wheel that caused the wheel to seize.NTSB WPR09LA426Accident · Minor injuriesLimited investigationFinal reportSix-Chuter American Spirit · Brownsville, ORThe pilot's failure to maintain clearance from power lines.NTSB ERA09LA529Accident · No injuriesLimited investigationFinal reportBombardier DHC-8-202 · Sterling, VAUndetermined.NTSB ERA09CA495Accident · No injuriesData collectionFinal reportUnderland/Grothe/Finstrom Mmii (Must · Lantana, FLThe delay by both pilots to abort the takeoff resulting in a runway overrun. Contributing to the accident was the unintentional forward movement of the pilot's seat resulting in interference with the control stick.NTSB CEN09CA554Accident · No injuriesData collectionFinal reportSocata TBM 700 · Ann Arbor, MIThe pilot's hard landing during gusty wind conditions.NTSB CEN09CA552Accident · No injuriesData collectionFinal reportCessna 150F · Abilene, KSThe pilot's inadequate crosswind landing technique, resulting in an excessive side load on the left landing gear that led to an overload failure of its axle.NTSB WPR09LA423Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Ballard, WAThe pilot's precautionary water landing with partially extended landing gear. Contributing to the accident was the unidentified anomaly with the airplane's electrical system, which rendered the gear position indicator system inoperative.