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 MKC78FA060Accident · 4 fatalClosedAmer Avco AA-5B · North Bend, NENTSB MIA79FA114Accident · 6 fatalClosedAero Comdr 560E · Bimini, Burkina FasoNTSB IAD78FA089Accident · 3 fatalClosedMooney M20J · Bakersville, NCNTSB CHI78FEV34Accident · 1 fatalClosedVari-Viggen · Urbana, ILNTSB MKC78FCQ36Accident · 1 fatalClosedVari-Eze · Liberal, KSNTSB MIA78DA115Accident · 2 fatalClosedAero Comdr 680F · Ngreat Inagua (Atlantic Ocean)NTSB LAX78FA064Accident · 2 fatalClosedHughes 269C · Phoenix, AZNTSB CHI78FA053Accident · 2 fatalClosedCessna 177RG · Jefferson, OHNTSB CHI78FA052Accident · 2 fatalClosedPiper PA-22 · East Moline, ILNTSB MIA78FA110Accident · 1 fatalClosedHughes 269C · Opa Locka, FLNTSB LAX78FUG46Accident · 1 fatalClosedCessna 150B · Rialto, CANTSB SEA78FA051Accident · 1 fatalClosedCessna 337F · Ocean Shores, WANTSB FTW78FRJ26Accident · 1 fatalClosedPiper PA-25 · Tallulah, LANTSB MKC78FA058Accident · 1 fatalClosedCessna 120 · Kimball, NENTSB IAD78FA088Accident · 3 fatalClosedPiper PA-34 · Chesterfield, VANTSB FTW78FA064Accident · 1 fatalClosedPiper PA-23 · Leakey, TXNTSB CHI78FEI32Accident · 2 fatalClosedLockheed P38L · Whitehouse, OHNTSB NYC79FA075Accident · 1 fatalClosedCessna 310P · Sussex, NJNTSB LAX78FA063Accident · 1 fatalClosedCessna 172N · Big Bear, CANTSB CHI78FA051Accident · 2 fatalClosedBeech E-33A · Prt Washington, WINTSB SEA78FA050Accident · 1 fatalClosedCessna 150F · Lynden, WANTSB CHI78FEX28Accident · 2 fatalClosedPiper PA-28 · Mitchell, INNTSB CHI78FEP52Accident · 2 fatalClosedThorp T-18 · Oshkosh, WINTSB ANC78FA062Accident · 1 fatalClosedCessna U206F · Bettles, AKNTSB UNK78X0129Accident · 1 fatalClosedEnstrom 280C · Lester, WANTSB MIA78FLD67Accident · 1 fatalClosedCessna 172 · Ocoee, FLNTSB LAX78FUJ89Accident · 1 fatalClosedPiper PA-36 · Casa Grande, AZNTSB NYC78FA073Accident · 1 fatalClosedCessna 150 · Southbridge, MANTSB LAX78FUJ87Accident · 1 fatalClosedGrumman G-164A · Buckeye, AZNTSB OAK78FA040Accident · 1 fatalClosedScheitzer 2-33A · Boulder City, NVNTSB OAK78FA039Accident · 3 fatalClosedPiper PA-28 · Petaluma, CANTSB MIA78FA107Accident · 1 fatalClosedBeech A23 · Inverness, FLNTSB IAD78FA084Accident · 1 fatalClosedCessna 172B · Selmer, TNNTSB FTW78FA062Accident · 2 fatalClosedBellanca 8KCAB · Lake Dallas, TXNTSB LAX78FUJ85Accident · 1 fatalClosedMidget Mustng · Flagstaff, AZNTSB OAK78FVD47Accident · 1 fatalClosedGrumman G-164B · Manteca, CANTSB FTW78FA065Accident · 3 fatalClosedCessna 310B · Cameron, LANTSB DEN78FA052Accident · 2 fatalClosedLuscombe 8A · Farmington, NMNTSB MKC78FA056Accident · 2 fatalClosedCessna 150 · Columbus, KSNTSB MIA78FA105Accident · 2 fatalClosedTed Smith 600 · Jacksonville, FLNTSB FTW78FRJ24Accident · 1 fatalClosedAero-Comdr S-2R · Lake Providenc, LANTSB FTW78FPG66Accident · 1 fatalClosedCessna 172L · Durham, ARNTSB ANC78FA054Accident · 4 fatalClosedBeech C24R · Kenai, AKNTSB MIA78DA119Accident · 2 fatalClosedPiper PA-31 · Missing AircraftNTSB ANC78FA055Accident · 2 fatalClosedPiper PA-18 · Petersville, AKNTSB SEA78FA047Accident · 1 fatalClosedPiper PA-28R · Coeur D'Alene, IDNTSB MIA78FA104Accident · 4 fatalClosedCessna 336 · Lakeland, FLNTSB FTW78FA060Accident · 1 fatalClosedPiper PA-28 · Brownfield, TXNTSB CHI78FEK24Accident · 1 fatalClosedCessna 150M · Urbana, OHNTSB NYC78FA071Accident · 3 fatalClosedPiper PA-28 · Campbell, NY