Fatal 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 WHERE c.\"highestInjuryLevel\" = 'Fatal' 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 WHERE c."highestInjuryLevel" = 'Fatal' 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 IAD77FA031Accident · 1 fatalClosedPiper PA-28 · Morgantown, WVNTSB CHI77FEG13Accident · 1 fatalClosedChampion 7GCAA · Jamestown, OHNTSB MIA77FA047Accident · 2 fatalClosedPiper PA-32 · Lilburn, GANTSB LAX77FA032Accident · 1 fatalClosedBeech H35 · Wrightwood, CANTSB FTW77FA046Accident · 2 fatalClosedNa Rockwell 112 · Spring, TXNTSB OAK77FA027Accident · 1 fatalClosedPiper PA-28 · Clayton, CANTSB SEA77FYE12Accident · 2 fatalClosedN.American P-51D · Olympia, WANTSB SEA77FA021Accident · 2 fatalClosedGrum Amer AA-5 · Clifton, IDNTSB MKC77FA017Accident · 3 fatalClosedCessna T210L · Atkins, IANTSB CHI77FA036Accident · 2 fatalClosedBeech 23 · Morris, ILNTSB FTW77FA045Accident · 1 fatalClosedMitsubishi MU-2B · Austin, TXNTSB NYC77FA039Accident · 1 fatalClosedCessna 150 · Rostraver, PANTSB FTW77FA044Accident · 1 fatalClosedBell 206B · Intracoastal C, LANTSB OAK77FJA07Accident · 2 fatalClosedHughes 269C · Honolulu, HINTSB DEN77FA031Accident · 2 fatalClosedCessna 210L · Elk Mountain, WYNTSB DEN77DA031Accident · 2 fatalClosedCessna 210L · Missing AircraftNTSB MIA77FKJ21Accident · 1 fatalClosedBellanca 8KCAB · Headland, ALNTSB MIA77FA046Accident · 1 fatalClosedPiper PA-32 · Charleston, SCNTSB LAX77FA029Accident · 3 fatalClosedBeech F-33A · Needles, CANTSB FTW77FA043Accident · 3 fatalClosedCessna 150J · Westwego, LANTSB OAK77FA026Accident · 1 fatalClosedPiper PA-28 · Corralitos, CANTSB MIA77FA045Accident · 2 fatalClosedCessna 182A · Ochlocknee, GANTSB FTW77FA042Accident · 2 fatalClosedMooney MK-21 · El Reno, OKNTSB OAK77FVA23Accident · 1 fatalClosedCessna 150M · Hanford, CANTSB NYC77FA037Accident · 2 fatalClosedCessna U206F · Doylestown, PANTSB MIA77FA043Accident · 1 fatalClosedCessna 150F · Ormond Beach, FLNTSB OAK77FA025Accident · 1 fatalClosedPiper PA-31 · Oakland, CANTSB NYC77FA036Accident · 1 fatalClosedCessna 150M · Fitchburg, MANTSB MIA77FKT28Accident · 1 fatalClosedPitts S2A · Ft.Lauderdale, FLNTSB LAX77FUM22Accident · 1 fatalClosedAero Comdr 600S2R · Brawley, CANTSB IAD77FA030Accident · 1 fatalClosedBeech 35 · Boones Mill, VANTSB CHI77FA035Accident · 2 fatalClosedPiper PA-28 · Rochester, INNTSB IAD77FA029Accident · 1 fatalClosedCessna A150L · Lovettsvile, VANTSB FTW77FA040Accident · 2 fatalClosedPiper PA-18 · Uvalde, TXNTSB MIA77RA041Accident · 2 fatalClosedBeech B95 · Gun Cay, Burkina FasoNTSB MIA77FA040Accident · 2 fatalClosedBeech 35-C33 · Fort Myers, FLNTSB OAK77FA024Accident · 4 fatalClosedCessna 182P · Gualala, CANTSB MIA77FA038Accident · 6 fatalClosedBeech H35 · Claxton, GANTSB CHI77FA034Accident · 1 fatalClosedPiper PA-28 · Chicago, ILNTSB MIA77RA039Accident · 4 fatalClosedCessna 402 · Stirrup, Burkina FasoNTSB MIA77FA042Accident · 2 fatalClosedBeech M35 · Fargo, GANTSB IAD77FA027Accident · 1 fatalClosedMooney M20C · Forest, VANTSB DEN77FA030Accident · 1 fatalClosedCessna 172M · Englewood, CONTSB OAK77FA022Accident · 2 fatalClosedBeech 35 · Sacramento, CANTSB NYC77FA035Accident · 3 fatalClosedBeech V35B · Nashua, NHNTSB MIA77RA036Accident · 1 fatalClosedSwearingen SA226T · Nassau, Burkina FasoNTSB CHI77FA033Accident · 4 fatalClosedMooney M20E · St Charles, ILNTSB SEA77FA020Accident · 2 fatalClosedPiper PA-24 · Eugene, ORNTSB DEN77FA029Accident · 3 fatalClosedCessna 182E · Pecos, NMNTSB DEN77FA028Accident · 1 fatalClosedCessna 414 · Farson, WY