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 FTW78FA023Accident · 2 fatalClosedPiper PA-28 · Rockwall, TXJan 7, 1978 · N5127L · DestroyedNTSB MIA78FA029Accident · 1 fatalClosedPiper PA-31 · Anniston, ALJan 6, 1978 · TIAFY · DestroyedNTSB IAD78FA030Accident · 1 fatalClosedBeech 55 · Lexington, KYJan 6, 1978 · N25N · DestroyedNTSB FTW78FA022Accident · 2 fatalClosedBeech D55 · El Campo, TXJan 6, 1978 · N7171N · DestroyedNTSB DEN78FA019Accident · 2 fatalClosedPiper PA-24 · Glendevey, COJan 6, 1978 · N8010P · DestroyedNTSB CHI78FA015Accident · 2 fatalClosedCessna 337G · Marion, ILJan 6, 1978 · N71947 · DestroyedNTSB SEA78FA017Accident · 1 fatalClosedAero Comdr 500B · Miles City, MTJan 5, 1978 · N6308U · DestroyedNTSB NYC78FA020Accident · 3 fatalClosedBell 206L · Courtney, PAJan 5, 1978 · N200BA · DestroyedNTSB IAD78DA029Accident · 2 fatalClosedPiper PA-28R · Cape Charles, VAJan 5, 1978 · N1502X · DestroyedNTSB CHI78FA014Accident · 1 fatalClosedBeech BE-35 · Tell City, INJan 5, 1978 · N8872A · DestroyedNTSB LAX78FA019Accident · 3 fatalClosedPiper PA-22 · Devore, CAJan 4, 1978 · N1511P · DestroyedNTSB IAD78FA028Accident · 5 fatalClosedCessna 421B · Knoxville, TNJan 3, 1978 · N41037 · DestroyedNTSB FTW78DA024Accident · 1 fatalClosedCessna 177RG · New Orleans, LAJan 3, 1978 · N7625V · DestroyedNTSB MIA78FA028Accident · 3 fatalClosedPiper PA-28 · Clewiston, FLJan 2, 1978 · N8005N · DestroyedNTSB LAX78FA018Accident · 4 fatalClosedBeech C-23 · Mojave, CAJan 2, 1978 · N9723L · DestroyedNTSB CHI78FA034Accident · 1 fatalClosedPiper PA-28 · Mellen, WIJan 2, 1978 · N8215C · DestroyedNTSB MKC78FA017Accident · 2 fatalClosedCessna 310L · Garden City, KSJan 1, 1978 · N2254F · DestroyedNTSB IAD78FA027Accident · 2 fatalClosedCessna 182K · Pearisburg, VAJan 1, 1978 · N303JR · DestroyedNTSB ANC78FA009Accident · 3 fatalClosedCessna 180 · Galena, AKJan 1, 1978 · N2441C · Substantial damageNTSB OAK78DA012Accident · 2 fatalClosedPiper PA-28R · Ke-Ahole, HIDec 31, 1977 · N56357 · DestroyedNTSB MIA78FA026Accident · 3 fatalClosedCessna 177 · Albany, GADec 31, 1977 · N3296T · DestroyedNTSB LAX78FA017Accident · 2 fatalClosedCessna 152 · Ojai, CADec 31, 1977 · N24945 · Substantial damageNTSB SEA78FA016Accident · 1 fatalClosedPiper PA-34 · Wenatchee, WADec 30, 1977 · N7089C · DestroyedNTSB MKC78FCG12Accident · 1 fatalClosedCessna 177B · Grain Valley, MODec 29, 1977 · N34769 · Substantial damageNTSB FTW78FA021Accident · 2 fatalClosedCessna 152 · Teague, TXDec 29, 1977 · N714ZQ · DestroyedNTSB SEA78FA015Accident · 2 fatalClosedGrum Amer AA-5A · Anaconda, MTDec 28, 1977 · N9968U · DestroyedNTSB NYC78FA018Accident · 3 fatalClosedCessna 180 · Berlin, NHDec 28, 1977 · N456LM · Substantial damageNTSB NYC78FA017Accident · 2 fatalClosedHughes 269B · Quincy, MADec 27, 1977 · N9364F · DestroyedNTSB MIA78FA024Accident · 4 fatalClosedBeech A24 · Alachua, FLDec 27, 1977 · N6962Q · DestroyedNTSB LAX78FA016Accident · 2 fatalClosedCessna 182A · El Cajon, CADec 27, 1977 · N3979D · DestroyedNTSB NYC78FA016Accident · 1 fatalClosedPiper PA-28 · Brooklyn, CTDec 26, 1977 · N713FL · Substantial damageNTSB LAX78FA015Accident · 3 fatalClosedGrum Amer AA-5B · Desert Hot Spg, CADec 25, 1977 · N74787 · DestroyedNTSB MIA78FA022Accident · 2 fatalClosedCessna 172 · Blairsville, GADec 24, 1977 · N4183L · DestroyedNTSB MIA78DA025Accident · 3 fatalClosedPiper PA-28 · Mayaguez (Atlantic Ocean)Dec 24, 1977 · N4901J · DestroyedNTSB IAD78FA025Accident · 2 fatalClosedCessna 206F · Sylva, NCDec 24, 1977 · N8290Q · DestroyedNTSB MKC78FA016Accident · 2 fatalClosedLuscombe 8E · Gordon, NEDec 23, 1977 · N1226K · DestroyedNTSB MIA78FA020Accident · 2 fatalClosedCessna 150 · Plantation, FLDec 23, 1977 · N10608 · DestroyedNTSB FTW78DQD08Accident · 1 fatalClosedCessna 177RG · Coyanosa, TXDec 23, 1977 · CF-BTL · DestroyedNTSB SEA78FA014Accident · 7 fatalClosedAero Cmdr 520 · Cheshire, ORDec 22, 1977 · C-GHUN · DestroyedNTSB NYC78FA019Accident · 1 fatalClosedCessna 404 · Buffalo, NYDec 22, 1977 · N404SA · DestroyedNTSB FTW78FA019Accident · 2 fatalClosedPiper PA-28R · Giddings, TXDec 22, 1977 · N116MM · DestroyedNTSB OAK78FA011Accident · 1 fatalClosedCessna 172M · Orland, CADec 21, 1977 · N12699 · DestroyedNTSB NYC78FA015Accident · 1 fatalClosedBeagle B206 · Greenwich, CTDec 20, 1977 · N1008B · DestroyedNTSB MIA78FA016Accident · 5 fatalClosedBrittnorman BN-2A · Vieques, PRDec 19, 1977 · N862JA · DestroyedNTSB ANC78FA005Accident · 2 fatalClosedHiller Acft FH1100 · Anchor Point, AKDec 19, 1977 · N18845 · DestroyedNTSB OAK78FA010Accident · 1 fatalClosedCessna U206 · Little River, CADec 18, 1977 · N29275 · DestroyedNTSB FTW78FRA11Accident · 1 fatalClosedLuscombe 8A · Pearland, TXDec 18, 1977 · N1285K · 2 aircraft · DestroyedNTSB DCA78AA005Accident · 3 fatalClosedDouglas DC-8F · Kaysville, UTDec 18, 1977 · N8047U · DestroyedNTSB MIA78AF019Accident · 1 fatalClosedCessna 150 · Dauphin Island, ALDec 17, 1977 · N6589T · DestroyedNTSB LAX78FA013Accident · 2 fatalClosedPiper PA-30 · Van Nuys, CADec 17, 1977 · N922JS · Substantial damage