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.

NTSB NYC78FA090Accident · 2 fatalClosedPiper PA-32 · Honesdale, PASep 10, 1978 · N789CC · DestroyedNTSB MIA78FLD73Accident · 1 fatalClosedGyrocopter 1 · Dunnellon, FLSep 10, 1978 · NONE · DestroyedNTSB IAD78FA108Accident · 1 fatalClosedGrum Amer AA-5 · Jackson, TNSep 10, 1978 · N1375R · DestroyedNTSB FTW78FA080Accident · 1 fatalClosedBeech V35 · Alexandria, LASep 10, 1978 · N5642S · DestroyedNTSB DEN78FA067Accident · 1 fatalClosedAeronca 11AC · Wray, COSep 10, 1978 · N9366E · DestroyedNTSB CHI78FA065Accident · 3 fatalClosedCessna 172K · Mackinaw City, MISep 10, 1978 · N84380 · DestroyedNTSB ANC78DA083Accident · 3 fatalClosedCessna 185 · Missing AircraftSep 10, 1978 · N4871C · DestroyedNTSB NYC78FA089Accident · 2 fatalClosedCessna 150M · Millbury, MASep 9, 1978 · N9470U · DestroyedNTSB MIA78FLA50Accident · 1 fatalClosedBirdman TL1A · Deland, FLSep 9, 1978 · N102BA · DestroyedNTSB CHI78FA064Accident · 6 fatalClosedPiper PA-31 · Savoy, ILSep 9, 1978 · N26AN · DestroyedNTSB ANC79FA076Accident · 3 fatalClosedSoloy 12EJ3 · Wrangell, AKSep 9, 1978 · N5384V · DestroyedNTSB OAK78FA049Accident · 4 fatalClosedBeech C-24R · Big Sur, CASep 8, 1978 · N23994 · DestroyedNTSB OAK78FA048Accident · 1 fatalClosedWeatherly 201B · Greenfield, CASep 8, 1978 · N1265W · 2 aircraft · Substantial damageNTSB MIA78FA122Accident · 2 fatalClosedPiper PA-38 · Florence, SCSep 8, 1978 · N4425E · DestroyedNTSB SEA78FA063Accident · 4 fatalClosedPiper PA-28 · Sisters, ORSep 7, 1978 · N39499 · DestroyedNTSB SEA78FA062Accident · 1 fatalClosedAero Comdr 500B · Great Falls, MTSep 6, 1978 · N6112X · DestroyedNTSB OAK78FA050Accident · 3 fatalClosedPiper PA-24 · Mariposa, CASep 6, 1978 · N6576P · DestroyedNTSB FTW78FA075Accident · 1 fatalClosedDouglas DC-7C · Farmersville, LASep 6, 1978 · N244B · DestroyedNTSB SEA78FA061Accident · 2 fatalClosedPiper J3 · Lynden, WASep 4, 1978 · N6391H · DestroyedNTSB OAK78FA047Accident · 1 fatalClosedPiper PA-28R · Auburn, CASep 4, 1978 · N9530K · DestroyedNTSB OAK78DA046Accident · 1 fatalClosedPiper PA-28 · Fort Ross, CASep 4, 1978 · N55002 · DestroyedNTSB MIA78FKT77Accident · 1 fatalClosedBeech 65-A80 · South Bay, FLSep 4, 1978 · N44SG · DestroyedNTSB MIA78FA121Accident · 2 fatalClosedConvair 240 · Clewiston, FLSep 4, 1978 · N7177B · DestroyedNTSB FTW78FPG85Accident · 1 fatalClosedPiper PA-18A · Lonoke, ARSep 4, 1978 · N2572P · DestroyedNTSB ANC78FA075Accident · 1 fatalClosedCessna 206 · Twin Lakes, AKSep 4, 1978 · N8497Q · Substantial damageNTSB SEA78FA060Accident · 2 fatalClosedPiper J3C · Mccall, IDSep 3, 1978 · N88185 · DestroyedNTSB NYC78FA087Accident · 1 fatalClosedCessna 150 · Dover, NJSep 3, 1978 · N704QG · Substantial damageNTSB LAX78FA074Accident · 1 fatalClosedBell 47G-3B · Pasadena, CASep 3, 1978 · N1135W · DestroyedNTSB ANC78FA074Accident · 2 fatalClosedCessna 152 · Anchorage, AKSep 3, 1978 · N757VU · 2 aircraft · DestroyedNTSB IAD78FA105Accident · 2 fatalClosedCessna 150 · Louisville, KYSep 2, 1978 · N18123 · 2 aircraft · DestroyedNTSB DCA78AA021Accident · 4 fatalClosedGrumman G-21A · St Thomas, VISep 2, 1978 · N7777V · DestroyedNTSB MKC78FA068Accident · 2 fatalClosedLuscombe 8A · Porcupine, SDSep 1, 1978 · N2177B · DestroyedNTSB IAD78FA104Accident · 2 fatalClosedHughes 269C · Robbinsville, NCSep 1, 1978 · N9295F · DestroyedNTSB IAD78FA103Accident · 1 fatalClosedBell 47G3 · Grissettown, NCSep 1, 1978 · N6092 · DestroyedNTSB ANC78FA072Accident · 4 fatalClosedCessna 177RG · Fairbanks, AKSep 1, 1978 · N2168Q · DestroyedNTSB ANC78FA071Accident · 2 fatalClosedPiper PA-18 · Cooper Landing, AKAug 31, 1978 · N8838L · DestroyedNTSB ANC78FA070Accident · 6 fatalClosedBeech A36 · Ketchikan, AKAug 31, 1978 · N17593 · DestroyedNTSB UNK78X0134Accident · 10 fatalClosedPiper PA-31 · Las Vegas, NVAug 30, 1978 · N44LV · DestroyedNTSB SEA78FYM50Accident · 1 fatalClosedMini Coupe Buffum · Independence, ORAug 30, 1978 · N75MB · DestroyedNTSB LAX78FA072Accident · 2 fatalClosedMooney M20 · Los Angeles, CAAug 30, 1978 · N864B · DestroyedNTSB FTW78FA073Accident · 4 fatalClosedBell 206B · Intracstl City, LAAug 30, 1978 · N9908K · DestroyedNTSB CHI78FEP64Accident · 2 fatalClosedGrumman AA-1C · Laona, WIAug 30, 1978 · N9976U · DestroyedNTSB LAX78FA071Accident · 4 fatalClosedPiper PA-32 · Laverne, CAAug 29, 1978 · N3708M · DestroyedNTSB CHI78FEX37Accident · 3 fatalClosedBalloon WKS FF 7 · Fishers, INAug 29, 1978 · N2044H · Substantial damageNTSB ANC78FA069Accident · 2 fatalClosedCessna 182Q · Ketchikan, AKAug 29, 1978 · N735NZ · DestroyedNTSB NYC78FA085Accident · 2 fatalClosedMitsubishi MU-2P · Bedford, NHAug 28, 1978 · N765MA · DestroyedNTSB FTW78FPG83Accident · 1 fatalClosedWeatherly 201C · Elaine, ARAug 28, 1978 · N9002W · DestroyedNTSB UNK78X0133Accident · 4 fatalClosedDouglas DC-6 · Muscat, MauritiusAug 27, 1978 · N122A · DestroyedNTSB MKC78FCJ43Accident · 1 fatalClosedCessna 188 · Grand Island, NEAug 27, 1978 · N53360 · DestroyedNTSB LAX78FA070Accident · 4 fatalClosedBeech 95-B55 · Costa Mesa, CAAug 27, 1978 · N60000 · Destroyed