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 CHI77FEC48Accident · 1 fatalClosedPiper PA-28 · Romeo, MISep 24, 1977 · N5194S · DestroyedNTSB CHI77FA074Accident · 1 fatalClosedBeech C55 · Farmersburg, INSep 24, 1977 · N3754Q · DestroyedNTSB NYC77FHM26Accident · 1 fatalClosedMahler-Wbr PJ-260 · Westhampton, NYSep 23, 1977 · N4030B · DestroyedNTSB DEN77FA058Accident · 6 fatalClosedCessna U206 · Salida, COSep 23, 1977 · N1452M · DestroyedNTSB CHI77FA073Accident · 2 fatalClosedBeech C90 · Pontiac, ILSep 23, 1977 · N23796 · DestroyedNTSB MIA77FKG81Accident · 1 fatalClosedAero Comdr 600S2R · Albany, GASep 22, 1977 · N8493V · DestroyedNTSB LAX77FA064Accident · 1 fatalClosedCessna T210L · Carlsbad, CASep 22, 1977 · N732GL · DestroyedNTSB IAD77FA067Accident · 1 fatalClosedPiper PA-32R · Williamson, WVSep 22, 1977 · N8653C · DestroyedNTSB FTW77FPG91Accident · 1 fatalClosedAeronca 7AC · Slovak, ARSep 22, 1977 · N2358E · DestroyedNTSB SEA77FA054Accident · 1 fatalClosedCessna 180 · Ashland, ORSep 21, 1977 · N9999N · DestroyedNTSB OAK77FA057Accident · 2 fatalClosedCessna 150L · Mariposa, CASep 21, 1977 · N6709G · DestroyedNTSB OAK77FA055Accident · 1 fatalClosedCessna 150L · Concord, CASep 20, 1977 · N7315G · DestroyedNTSB MKC77FA040Accident · 2 fatalClosedAeronca 7AC · Grand Rapids, MNSep 18, 1977 · N3702E · Substantial damageNTSB FTW77FRA34Accident · 1 fatalClosedBoeing A75N1 · Tomball, TXSep 18, 1977 · N52653 · 2 aircraft · Substantial damageNTSB CHI78FET35Accident · 1 fatalClosedPiper PA-18 · Benton Harbor, MISep 18, 1977 · N82328 · Substantial damageNTSB SEA77FA053Accident · 1 fatalClosedCessna 150L · Clarkston, WASep 17, 1977 · N6578G · DestroyedNTSB OAK77FA054Accident · 2 fatalClosedCessna 177 · Soda Springs, CASep 17, 1977 · N30748 · DestroyedNTSB CHI77FA072Accident · 4 fatalClosedCessna 177RG · Missing AircraftSep 17, 1977 · N7531V · DestroyedNTSB SEA77FA052Accident · 3 fatalClosedCessna 172K · Skykomish, WASep 16, 1977 · N78597 · DestroyedNTSB NYC77FA098Accident · 2 fatalClosedPiper PA-28R · Montauk Point, NYSep 16, 1977 · N2375T · DestroyedNTSB MIA77FA088Accident · 4 fatalClosedCessna 172 · Lauderhill, FLSep 16, 1977 · N7645G · DestroyedNTSB MKC77FA039Accident · 2 fatalClosedCessna 177 · Coldwater, KSSep 15, 1977 · N29358 · DestroyedNTSB FTW77FRJ23Accident · 1 fatalClosedCessna 150M · Oil City, LASep 15, 1977 · N6199K · DestroyedNTSB IAD78FA012Accident · 1 fatalClosedPiper PA28 · Ashford, WVSep 14, 1977 · N9483J · DestroyedNTSB MIA77FLA54Accident · 2 fatalClosedCessna 188-B · Nashville, GASep 13, 1977 · N9600G · DestroyedNTSB MIA77FA087Accident · 2 fatalClosedPiper PA-28 · Jackson, MSSep 12, 1977 · N98039 · DestroyedNTSB FTW77FQD28Accident · 1 fatalClosedPiper PA-25 · Coyanosa, TXSep 12, 1977 · N4775Y · DestroyedNTSB FTW77FA074Accident · 3 fatalClosedBeech V35A · Idabel, OKSep 12, 1977 · N800SC · DestroyedNTSB DCA77AA027Accident · 4 fatalClosedDouglas DC-7BF · Yakutat, AKSep 12, 1977 · N6314J · DestroyedNTSB CHI78FA071Accident · 2 fatalClosedCessna 320 · Milwaukee, WISep 11, 1977 · N5719X · DestroyedNTSB CHI77FET34Accident · 1 fatalClosedPiper PA-22 · Fort Wayne, INSep 11, 1977 · N3213B · DestroyedNTSB NYC77FA096Accident · 1 fatalClosedLake LA-4 · Greenville, MESep 10, 1977 · N1095L · DestroyedNTSB SEA77FA051Accident · 2 fatalClosedCessna 182L · Bellevue, WASep 9, 1977 · N3466R · DestroyedNTSB LAX77FA071Accident · 1 fatalClosedPiper PA-22 · Malibu, CASep 9, 1977 · N75FC · DestroyedNTSB IAD77AA065Accident · 5 fatalClosedLearjet 25B · Sanford, NCSep 8, 1977 · N999HG · DestroyedNTSB MIA77FA086Accident · 1 fatalClosedCessna 172N · Bunnell, FLSep 7, 1977 · N75ER · DestroyedNTSB MIA77FA085Accident · 3 fatalClosedPiper PA-28 · Danville, GASep 7, 1977 · N43485 · DestroyedNTSB MIA77FA084Accident · 1 fatalClosedCessna 172 · Key West, FLSep 7, 1977 · N733QS · No damageNTSB LAX77FA072Accident · 2 fatalClosedCessna 182P · San Onofre, CASep 7, 1977 · N52477 · DestroyedNTSB ANC77DAA51Accident · 1 fatalClosedCessna A185F · Bettles, AKSep 7, 1977 · N4974C · Minor damageNTSB MKC77FA038Accident · 1 fatalClosedPiper PA-18 · Jamestown, NDSep 6, 1977 · N1168A · DestroyedNTSB LAX77FA070Accident · 1 fatalClosedPiper PA-23 · Gorman, CASep 6, 1977 · N250CB · DestroyedNTSB DCA77AA026Accident · 13 fatalClosedDehavilland DHC-6 · Iliamna, AKSep 6, 1977 · N563MA · DestroyedNTSB NYC77FA095Accident · 2 fatalClosedTaylorcraft BC1265 · Oval, PASep 5, 1977 · N36128 · Substantial damageNTSB IAD77FA064Accident · 2 fatalClosedPiper PA-28 · Harriman, TNSep 5, 1977 · N32044 · DestroyedNTSB CHI77FEE50Accident · 1 fatalClosedCessna 172 · Rockford, ILSep 5, 1977 · N1975V · DestroyedNTSB SEA77FA050Accident · 1 fatalClosedGrum Amer AA1C · Othello, WASep 4, 1977 · N9558U · DestroyedNTSB MIA77FA083Accident · 2 fatalClosedPiper PA-28 · Lodge, SCSep 4, 1977 · N6334W · DestroyedNTSB CHI77FEX48Accident · 1 fatalClosedBeech C45 · Richmond, INSep 4, 1977 · N4111A · Substantial damageNTSB CHI77FEM39Accident · 1 fatalClosedCessna 182Q · East Tawas, MISep 4, 1977 · N444SP · No damage