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 OAK77FA002Accident · 2 fatalClosedBeech B35 · Lower Lake, CANTSB FTW77FA008Accident · 2 fatalClosedCessna 182L · Shaw, LANTSB CHI77FA004Accident · 2 fatalClosedCessna 150H · Joliet, ILNTSB FTW77FRG05Accident · 1 fatalClosedAir Tractor AT-301 · La Feria, TXNTSB SEA77FA003Accident · 1 fatalClosedBellanca 8KCAB · Billings, MTNTSB LAX77FA004Accident · 2 fatalClosedBeech 35-C33 · Los Angeles, CANTSB IAD77FKM03Accident · 3 fatalClosedBalloon 1 · Charlotte, NCNTSB FTW77FA006Accident · 1 fatalClosedCessna 210B · Granbury, TXNTSB DEN77FA003Accident · 4 fatalClosedCessna 210F · Edgerton, WYNTSB IAD77FA008Accident · 4 fatalClosedPiper PA-31 · Hampton, VANTSB IAD77FA007Accident · 1 fatalClosedCessna 182 · Centreville, VANTSB CHI76FA003Accident · 1 fatalClosedCessna 150M · Amherst, WINTSB DEN77FTM07Accident · 1 fatalClosedCessna P206B · Nephi, UTNTSB DEN77FA002Accident · 2 fatalClosedCessna 150 · Texico, NMNTSB NYC77FA004Accident · 4 fatalClosedPiper PA-28 · Elizabethville, PANTSB FTW77FA005Accident · 1 fatalClosedPiper PA-28R · Elmendorf, TXNTSB NYC77FA005Accident · 1 fatalClosedPiper PA-28 · Frenchville, PANTSB MIA77FL901Accident · 1 fatalClosedBensen B-8M · Laurens, SCNTSB FTW77FA004Accident · 4 fatalClosedPiper PA-23 · College Sta, TXNTSB FTW77FA007Accident · 1 fatalClosedBellanca 17-30 · Seguin, TXNTSB NYC77FA003Accident · 1 fatalClosedAeronca 15AC · Erwinna, PANTSB NYC77FA002Accident · 1 fatalClosedBeech B95A · Frankfort, NYNTSB MIA77FA002Accident · 2 fatalClosedCessna 150J · Kissimee, FLNTSB FTW77DA003Accident · 1 fatalClosedPitts Spcl S-1S · Durant, OKNTSB LAX77FVA07Accident · 1 fatalClosedCessna 150 · Kernville, CANTSB CHI77FEK02Accident · 2 fatalClosedBel-Spezio BEL · Rockbridge, OHNTSB SEA77FA002Accident · 1 fatalClosedGlobe GC-1B · Hood River, ORNTSB LAX77FA002Accident · 2 fatalClosedMooney M20C · Phoenix, AZNTSB IAD77FA005Accident · 4 fatalClosedPiper PA-34 · Busick, NCNTSB SEA77DA001Accident · 1 fatalClosedAeronca 11AC · Medical Lake, WANTSB OAK76FA001Accident · 1 fatalClosedWildmaster 2 · Oroville, CANTSB MIA77FA001Accident · 2 fatalClosedCessna 210L · Villanow, GANTSB IAD77FA002Accident · 4 fatalClosedCessna 177RG · Centerville, TNNTSB LAX77FUJ02Accident · 2 fatalClosedCessna A188A · Buckeye, AZNTSB FTW77FA002Accident · 3 fatalClosedMooney M20C · Houma, LANTSB DEN77FA001Accident · 1 fatalClosedCessna 182A · Buford, WYNTSB OAK77FVM01Accident · 1 fatalClosedVolksplane VP-1 · Gilroy, CANTSB FTW77FQG01Accident · 1 fatalClosedWarren-Fayo · Big Spring, TXNTSB FTW77FA001Accident · 2 fatalClosedCessna 150H · Claude, TXNTSB CHI77FA002Accident · 1 fatalClosedCessna 177B · Manteno, ILNTSB MIA77FKJ01Accident · 1 fatalClosedGrumman G-164 · Pansey, ALNTSB MIA77DKT01Accident · 1 fatalClosedBensen Gyro · Gulfstream, FLNTSB LAX77FA001Accident · 4 fatalClosedBeech 35 · Bagdad, AZNTSB IAD77FA001Accident · 1 fatalClosedCessna 182 · Hudson, KYNTSB CHI77FA001Accident · 1 fatalClosedCessna 172M · Hagerstown, INNTSB NYC77FA001Accident · 2 fatalClosedBeech E55 · Bradford, PANTSB LAX76FNK13Accident · 1 fatalClosedPitts Spcl SIS · Prescott, AZNTSB CHI76AC094Accident · 1 fatalClosedCessna 182 · Perrysville, INNTSB ANC76AA142Accident · 1 fatalClosedPiper PA-28R · Juneau, AKNTSB MIA76AM112Accident · 4 fatalClosedPiper PA-22 · Treasure Is, FL