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 IAD77FA031Accident · 1 fatalClosedPiper PA-28 · Morgantown, WVMar 25, 1977 · N1500J · DestroyedNTSB CHI77FEG13Accident · 1 fatalClosedChampion 7GCAA · Jamestown, OHMar 25, 1977 · N919RN · DestroyedNTSB MIA77FA047Accident · 2 fatalClosedPiper PA-32 · Lilburn, GAMar 24, 1977 · N5256S · DestroyedNTSB LAX77FA032Accident · 1 fatalClosedBeech H35 · Wrightwood, CAMar 24, 1977 · N5508D · DestroyedNTSB FTW77FA046Accident · 2 fatalClosedNa Rockwell 112 · Spring, TXMar 24, 1977 · N1095J · DestroyedNTSB OAK77FA027Accident · 1 fatalClosedPiper PA-28 · Clayton, CAMar 23, 1977 · N7787F · DestroyedNTSB SEA77FYE12Accident · 2 fatalClosedN.American P-51D · Olympia, WAMar 19, 1977 · N6526D · DestroyedNTSB SEA77FA021Accident · 2 fatalClosedGrum Amer AA-5 · Clifton, IDMar 19, 1977 · N7198L · DestroyedNTSB MKC77FA017Accident · 3 fatalClosedCessna T210L · Atkins, IAMar 19, 1977 · N2231S · DestroyedNTSB CHI77FA036Accident · 2 fatalClosedBeech 23 · Morris, ILMar 19, 1977 · N2309Z · DestroyedNTSB FTW77FA045Accident · 1 fatalClosedMitsubishi MU-2B · Austin, TXMar 18, 1977 · N777MA · DestroyedNTSB NYC77FA039Accident · 1 fatalClosedCessna 150 · Rostraver, PAMar 17, 1977 · N19532 · DestroyedNTSB FTW77FA044Accident · 1 fatalClosedBell 206B · Intracoastal C, LAMar 17, 1977 · N90071 · DestroyedNTSB OAK77FJA07Accident · 2 fatalClosedHughes 269C · Honolulu, HIMar 16, 1977 · N9619F · DestroyedNTSB DEN77FA031Accident · 2 fatalClosedCessna 210L · Elk Mountain, WYMar 16, 1977 · N1630X · DestroyedNTSB DEN77DA031Accident · 2 fatalClosedCessna 210L · Missing AircraftMar 16, 1977 · N1630X · DestroyedNTSB MIA77FKJ21Accident · 1 fatalClosedBellanca 8KCAB · Headland, ALMar 15, 1977 · N57479 · DestroyedNTSB MIA77FA046Accident · 1 fatalClosedPiper PA-32 · Charleston, SCMar 15, 1977 · N43216 · DestroyedNTSB LAX77FA029Accident · 3 fatalClosedBeech F-33A · Needles, CAMar 15, 1977 · N7307R · 2 aircraft · DestroyedNTSB FTW77FA043Accident · 3 fatalClosedCessna 150J · Westwego, LAMar 15, 1977 · N50600 · DestroyedNTSB OAK77FA026Accident · 1 fatalClosedPiper PA-28 · Corralitos, CAMar 14, 1977 · N32606 · DestroyedNTSB MIA77FA045Accident · 2 fatalClosedCessna 182A · Ochlocknee, GAMar 14, 1977 · N2150G · DestroyedNTSB FTW77FA042Accident · 2 fatalClosedMooney MK-21 · El Reno, OKMar 14, 1977 · N6440Q · DestroyedNTSB OAK77FVA23Accident · 1 fatalClosedCessna 150M · Hanford, CAMar 13, 1977 · N501CA · DestroyedNTSB NYC77FA037Accident · 2 fatalClosedCessna U206F · Doylestown, PAMar 13, 1977 · N35634 · Substantial damageNTSB MIA77FA043Accident · 1 fatalClosedCessna 150F · Ormond Beach, FLMar 13, 1977 · N8898G · DestroyedNTSB OAK77FA025Accident · 1 fatalClosedPiper PA-31 · Oakland, CAMar 12, 1977 · N6616L · DestroyedNTSB NYC77FA036Accident · 1 fatalClosedCessna 150M · Fitchburg, MAMar 12, 1977 · N8650U · Substantial damageNTSB MIA77FKT28Accident · 1 fatalClosedPitts S2A · Ft.Lauderdale, FLMar 12, 1977 · N23WB · DestroyedNTSB LAX77FUM22Accident · 1 fatalClosedAero Comdr 600S2R · Brawley, CAMar 12, 1977 · N8429V · DestroyedNTSB IAD77FA030Accident · 1 fatalClosedBeech 35 · Boones Mill, VAMar 12, 1977 · N4459V · DestroyedNTSB CHI77FA035Accident · 2 fatalClosedPiper PA-28 · Rochester, INMar 10, 1977 · N44798 · DestroyedNTSB IAD77FA029Accident · 1 fatalClosedCessna A150L · Lovettsvile, VAMar 9, 1977 · N44GV · DestroyedNTSB FTW77FA040Accident · 2 fatalClosedPiper PA-18 · Uvalde, TXMar 9, 1977 · N8973D · DestroyedNTSB MIA77RA041Accident · 2 fatalClosedBeech B95 · Gun Cay, Burkina FasoMar 8, 1977 · N9905R · DestroyedNTSB MIA77FA040Accident · 2 fatalClosedBeech 35-C33 · Fort Myers, FLMar 7, 1977 · N5862S · DestroyedNTSB OAK77FA024Accident · 4 fatalClosedCessna 182P · Gualala, CAMar 6, 1977 · N8710M · DestroyedNTSB MIA77FA038Accident · 6 fatalClosedBeech H35 · Claxton, GAMar 6, 1977 · N626Q · DestroyedNTSB CHI77FA034Accident · 1 fatalClosedPiper PA-28 · Chicago, ILMar 6, 1977 · N40922 · DestroyedNTSB MIA77RA039Accident · 4 fatalClosedCessna 402 · Stirrup, Burkina FasoMar 5, 1977 · N69378 · DestroyedNTSB MIA77FA042Accident · 2 fatalClosedBeech M35 · Fargo, GAMar 5, 1977 · N9746R · DestroyedNTSB IAD77FA027Accident · 1 fatalClosedMooney M20C · Forest, VAMar 5, 1977 · N6755U · DestroyedNTSB DEN77FA030Accident · 1 fatalClosedCessna 172M · Englewood, COMar 5, 1977 · N64522 · DestroyedNTSB OAK77FA022Accident · 2 fatalClosedBeech 35 · Sacramento, CAMar 4, 1977 · N870R · DestroyedNTSB NYC77FA035Accident · 3 fatalClosedBeech V35B · Nashua, NHMar 4, 1977 · N974DP · DestroyedNTSB MIA77RA036Accident · 1 fatalClosedSwearingen SA226T · Nassau, Burkina FasoMar 3, 1977 · N5329M · DestroyedNTSB CHI77FA033Accident · 4 fatalClosedMooney M20E · St Charles, ILMar 3, 1977 · N1947Y · DestroyedNTSB SEA77FA020Accident · 2 fatalClosedPiper PA-24 · Eugene, ORMar 2, 1977 · N8216P · DestroyedNTSB DEN77FA029Accident · 3 fatalClosedCessna 182E · Pecos, NMMar 2, 1977 · N2861Y · DestroyedNTSB DEN77FA028Accident · 1 fatalClosedCessna 414 · Farson, WYMar 2, 1977 · N8066Q · Destroyed