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 MIA79FA015Accident · 3 fatalClosedCessna 172N · Ormond Beach, FLNov 20, 1978 · N733QV · DestroyedNTSB MIA79FA014Accident · 2 fatalClosedPiper PA-23 · Ormond Beach, FLNov 20, 1978 · N3485P · DestroyedNTSB MIA79DA019Accident · 4 fatalClosedPiper PA-23 · Missing AircraftNov 20, 1978 · N54615 · DestroyedNTSB FTW79FA015Accident · 1 fatalClosedBeech H18 · Brownsville, TXNov 20, 1978 · N204CC · DestroyedNTSB SEA79FA014Accident · 2 fatalClosedBellanca 17-30 · Medford, ORNov 19, 1978 · N7320V · DestroyedNTSB FTW79FA014Accident · 3 fatalClosedPiper PA-24 · Amarilld, TXNov 19, 1978 · N7856P · DestroyedNTSB ANC79DA021Accident · 2 fatalClosedLake LA-4 · Missing AircraftNov 19, 1978 · N2767P · DestroyedNTSB IAD79FA013Accident · 1 fatalClosedCessna 152 · Spencer, WVNov 18, 1978 · N7359B · DestroyedNTSB FTW79FA013Accident · 1 fatalClosedCessna 172H · Kent, TXNov 18, 1978 · N2757L · DestroyedNTSB DEN79FA008Accident · 1 fatalClosedAero Comdr 500S · Gallup, NMNov 17, 1978 · N2973F · DestroyedNTSB MKC79FA004Accident · 2 fatalClosedBeech G18S · Hays, KSNov 16, 1978 · N901PC · DestroyedNTSB IAD79FA011Accident · 4 fatalClosedPiper PA-24 · Bowie, MDNov 16, 1978 · N6147P · DestroyedNTSB FTW79FA012Accident · 2 fatalClosedCessna 310J · Lubbock, TXNov 13, 1978 · N310BJ · DestroyedNTSB MKC79FA003Accident · 1 fatalClosedCessna 310Q · Eden Prairie, MNNov 12, 1978 · N8050Q · DestroyedNTSB MIA79FLD15Accident · 1 fatalClosedHoffman X2 · Tarpon Springs, FLNov 12, 1978 · N1736 · DestroyedNTSB MIA79FA017Accident · 1 fatalClosedPiper PA-28 · Jacksonville, FLNov 12, 1978 · N3409Q · DestroyedNTSB LAX79FA014Accident · 2 fatalClosedGrum Amer AA1-G · Kernville, CANov 12, 1978 · N9584U · DestroyedNTSB LAX79FA013Accident · 1 fatalClosedCessna 172N · Sn Jun Cpstrn, CANov 12, 1978 · N739HG · DestroyedNTSB FTW79FA011Accident · 2 fatalClosedBell 206B · Sabine Pass, TXNov 12, 1978 · N49755 · DestroyedNTSB CHI79FEK01Accident · 1 fatalClosedGrum Amer AA-5 · Reno, OHNov 12, 1978 · N7187L · DestroyedNTSB OAK79FA010Accident · 1 fatalClosedCessna 182A · Reno, NVNov 10, 1978 · N5895B · DestroyedNTSB NYC79FA011Accident · 6 fatalClosedPiper PA-32 · Newry, MENov 10, 1978 · CGPJU · DestroyedNTSB LAX79FUJ13Accident · 1 fatalClosedBell 47G3B · Springerville, AZNov 10, 1978 · N8483E · DestroyedNTSB DEN79FA006Accident · 2 fatalClosedBeech A36 · Silver City, NMNov 10, 1978 · N9016V · Substantial damageNTSB CHI79FA017Accident · 2 fatalClosedGrumman AA-5 · Norway, MINov 10, 1978 · N7170L · DestroyedNTSB SEA79FA012Accident · 1 fatalClosedCessna 177B · Kimberly, ORNov 9, 1978 · N11606 · DestroyedNTSB IAD79FA010Accident · 4 fatalClosedPiper PA-32 · Melfa, VANov 8, 1978 · N1104X · DestroyedNTSB DEN79FA007Accident · 4 fatalClosedGrum-Amer AA-5B · Meeteetse, WYNov 8, 1978 · N28406 · DestroyedNTSB IAD79FA008Accident · 2 fatalClosedCessna 310I · Portland, TNNov 7, 1978 · N8037M · DestroyedNTSB MIA79FA013Accident · 2 fatalClosedCessa 152 · Boca Raton, FLNov 6, 1978 · N48905 · DestroyedNTSB MIA79FA012Accident · 8 fatalClosedBeech 60 · Jackson, MSNov 6, 1978 · N135D · DestroyedNTSB LAX79FA011Accident · 1 fatalClosedCessna T210M · Hermosa Beach, CANov 6, 1978 · N761GP · DestroyedNTSB SEA79FA011Accident · 3 fatalClosedCessna 185 · Joseph, ORNov 5, 1978 · N80169 · DestroyedNTSB NYC79FNC09Accident · 1 fatalClosedDehavilland DH-82A · No.Hampton, NHNov 5, 1978 · N90406 · Substantial damageNTSB NYC79FA008Accident · 1 fatalClosedCessna 152 · West Mifflin, PANov 5, 1978 · N25507 · DestroyedNTSB MKC79FA001Accident · 4 fatalClosedBeech A23-24 · Lyndon, KSNov 5, 1978 · N6135N · DestroyedNTSB CHI79FA014Accident · 4 fatalClosedCessna 210A · Chicago, ILNov 5, 1978 · N695HP · DestroyedNTSB ANC79FA016Accident · 1 fatalClosedPiper PA-18 · Copper Center, AKNov 5, 1978 · N7166B · Substantial damageNTSB CHI79FEV03Accident · 1 fatalClosedStarduster TOO · Nhenderson, ILNov 4, 1978 · N762RD · DestroyedNTSB CHI79FET04Accident · 2 fatalClosedMonocoupe 90A · Mentone, INNov 4, 1978 · N18062 · DestroyedNTSB MIA79FA010Accident · 1 fatalClosedPiper PA-31 · Missing AircraftNov 3, 1978 · N59912 · DestroyedNTSB SEA79FA009Accident · 3 fatalClosedCessna P210 · Toutle, WANov 2, 1978 · N3686P · DestroyedNTSB NYC79FA007Accident · 2 fatalClosedCessna 172 · Marcy, NYNov 2, 1978 · N46037 · Substantial damageNTSB FTW79FA009Accident · 2 fatalClosedAeronca 7EC · Richmond, LANov 2, 1978 · N4378C · DestroyedNTSB OAK79FA009Accident · 3 fatalClosedMooney M20J · Capay, CANov 1, 1978 · N201WQ · DestroyedNTSB OAK79FA008Accident · 1 fatalClosedCessna T-210L · Dayton, NVNov 1, 1978 · N777FT · DestroyedNTSB OAK79FA007Accident · 2 fatalClosedBellanca 7ECA · San Jose, CANov 1, 1978 · N57642 · DestroyedNTSB OAK78FA051Accident · 2 fatalClosedBellanca 8KCAB · Truckee, CANov 1, 1978 · N4180Y · DestroyedNTSB SEA79FA008Accident · 1 fatalClosedCessna 150H · Swan Lake, MTOct 31, 1978 · N7056S · DestroyedNTSB ANC79DA015Accident · 3 fatalClosedGrumman G-44A · Cordova, AKOct 31, 1978 · N444W · Destroyed