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 CHI77FA050Accident · 1 fatalClosedCessna 150H · Benton, ILNTSB ANC77FA052Accident · 4 fatalClosedLake LA-4 · Matanuska Glcr, AKNTSB OAK77FA036Accident · 1 fatalClosedN.American SNJ-5 · Petaluma, CANTSB FTW77FPG59Accident · 1 fatalClosedBensen B8M · Berryville, ARNTSB CHI77FEV27Accident · 1 fatalClosedTolman SA-3AM · Salem, ILNTSB CHI77FA049Accident · 4 fatalClosedPiper PA-24 · Grafton, WINTSB SEA77FYM41Accident · 1 fatalClosedPitts S1 · Forrest Grove, ORNTSB FTW77FPD26Accident · 1 fatalClosedStarduster TOO · Alvord, TXNTSB SEA77FA040Accident · 2 fatalClosedCessna 172 · Azalea, ORNTSB SEA77FA039Accident · 4 fatalClosedPiper PA-28 · Spokane, WANTSB NYC77FA063Accident · 1 fatalClosedBellanca 8KCAB · Haverhill, MANTSB MKC77FA024Accident · 4 fatalClosedCessna 172M · Gordon, NENTSB LAX77FA050Accident · 2 fatalClosedCessna 177RG · Riverside, CANTSB LAX77FA049Accident · 5 fatalClosedAero Comdr 680 · Upland, CANTSB IAD77FA044Accident · 3 fatalClosedBellanca 14-19 · Robinson Creek, KYNTSB FTW77FA059Accident · 2 fatalClosedAmerican AA-1A · Marion, TXNTSB SEA77FA038Accident · 3 fatalClosedPiper PA-28 · Lavina, MTNTSB OAK77FA035Accident · 2 fatalClosedBeech A33 · Coalinga, CANTSB NYC77FHD15Accident · 1 fatalClosedFly-Baby 1A · Oxford, PANTSB MIA77FLA36Accident · 1 fatalClosedBensen B-8-MG · St Augustine, FLNTSB FTW77FPG42Accident · 1 fatalClosedGrumman G-164A · Dumas, ARNTSB CHI77FA048Accident · 1 fatalClosedBeech E18S · Springfield, OHNTSB OAK77FA034Accident · 3 fatalClosedCessna 150L · San Ramon, CANTSB MIA77FA060Accident · 1 fatalClosedGrum Amer AA-1A · Atlanta, GANTSB SEA77FA037Accident · 4 fatalClosedCessna T210G · Elgin, ORNTSB IAD77FA043Accident · 1 fatalClosedCessna 172 · Cavetown, MDNTSB FTW77FA058Accident · 3 fatalClosedCessna 185 · Houma, LANTSB SEA77FA036Accident · 2 fatalClosedPiper PA-22 · Horseshoe Bend, IDNTSB SEA77FA035Accident · 2 fatalClosedTaylorcraft L-2B · Yelm, WANTSB LAX77FA046Accident · 2 fatalClosedPiper PA-28R · Yucca Valley, CANTSB DEN78FA017Accident · 1 fatalClosedHughes 269C · Colorado Sprgs, CONTSB CHI77FEG19Accident · 2 fatalClosedBellanca 7KCAB · Goshen, OHNTSB SEA77DYM33Accident · 1 fatalClosedPiper PA-22S · Madras, ORNTSB MKC77FCA21Accident · 1 fatalClosedPiper PA-25 · Poplar Bluff, MONTSB FTW77FQD19Accident · 1 fatalClosedBellanca 7KCAB · El Paso, TXNTSB FTW77FA057Accident · 2 fatalClosedBeech S35 · Lamar, ARNTSB DEN77FA044Accident · 2 fatalClosedBeech 19A · Wheatland, WYNTSB CHI77FA046Accident · 4 fatalClosedPiper PA-24 · Evansville, WINTSB NYC77FA062Accident · 3 fatalClosedCessna 182F · Oxbow, MENTSB NYC77FA061Accident · 1 fatalClosedPiper PA-16 · Collins, NYNTSB IAD77FA041Accident · 1 fatalClosedPiper PA-34 · Bridgeport, WVNTSB OAKMMFJA12Accident · 1 fatalClosedRockwell 112B · Honolulu, HINTSB FTW77FPM10Accident · 1 fatalClosedPiper J-3 · Jay, OKNTSB UNK77X0105Accident · 1 fatalClosedBellanca 17-30A · Brightwood, ORNTSB LAX77FA047Accident · 2 fatalClosedGrum Amer AA5-B · San Luis Obspo, CANTSB NYC77FA060Accident · 4 fatalClosedPiper PA-28 · Keeseville, NYNTSB NYC77FA059Accident · 1 fatalClosedCessna 172K · Flushing, NYNTSB DEN77FA042Accident · 1 fatalClosedAero Tek IV · Moriarty, NMNTSB CHI77FA044Accident · 1 fatalClosedCessna 172 · East Dundee, ILNTSB LAX77FUJ48Accident · 2 fatalClosedTailwind W-8A · Mayer, AZ