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 DEN77FA053Accident · 2 fatalClosedMaule M4 · Estes Park, COAug 16, 1977 · N4132C · DestroyedNTSB OAK77DA053Accident · 1 fatalClosedCessna 210 · Missing AircraftAug 15, 1977 · N6542X · DestroyedNTSB NYC77FA081Accident · 1 fatalClosedAeronca 7AC · Ottsville, PAAug 15, 1977 · N46SS · DestroyedNTSB MIA77FKJ69Accident · 1 fatalClosedPiper PA-18 · Vincent, ALAug 15, 1977 · N4731A · DestroyedNTSB FTW77FPG77Accident · 1 fatalClosedWeatherly 201B · Cornerstone, ARAug 15, 1977 · N1259W · 2 aircraft · Substantial damageNTSB MKC77FA033Accident · 3 fatalClosedCessna 172D · St.Louis, MOAug 14, 1977 · N2113Y · DestroyedNTSB NYC77FA079Accident · 1 fatalClosedBellanca 14-19 · Lemoyne, PAAug 13, 1977 · N8504R · Substantial damageNTSB MIA77FA080Accident · 3 fatalClosedBeech 65-80 · Vancleave, MSAug 13, 1977 · N6DG · DestroyedNTSB MIA77FA079Accident · 1 fatalClosedCessna 150 · Ft.Lauderdale, FLAug 13, 1977 · N8791M · DestroyedNTSB IAD77FA060Accident · 1 fatalClosedAero Comdr A-9 · Petersburg, VAAug 13, 1977 · N7739V · DestroyedNTSB CHI77FA065Accident · 3 fatalClosedCessna 402A · Yates City, ILAug 13, 1977 · N4554Q · DestroyedNTSB ANC77FA073Accident · 2 fatalClosedPiper PA-18 · Merrill Pass, AKAug 13, 1977 · N5979D · Substantial damageNTSB SEA77FA047Accident · 1 fatalClosedAerostar 601P · Burns, ORAug 12, 1977 · N9578Q · DestroyedNTSB IAD77FA059Accident · 4 fatalClosedBeech 58 · Parkersburg, WVAug 12, 1977 · N9265Q · DestroyedNTSB NYC77FA078Accident · 2 fatalClosedBeagle B.206S · Westport, CTAug 11, 1977 · N850EX · DestroyedNTSB IAD77FA058Accident · 1 fatalClosedGrum Amer AA1-B · Unity, MDAug 11, 1977 · N9677L · DestroyedNTSB FTW77FA067Accident · 1 fatalClosedCessna 182P · Austin, TXAug 11, 1977 · N52358 · DestroyedNTSB DEN77FA052Accident · 4 fatalClosedCessna U206 · Engle, NMAug 11, 1977 · N8062Z · DestroyedNTSB DEN77FA051Accident · 2 fatalClosedMooney M20E · Albuquerque, NMAug 11, 1977 · N3488X · DestroyedNTSB ANC77FA072Accident · 6 fatalClosedBeech H18 · Wrangell, AKAug 11, 1977 · C-GWUY · DestroyedNTSB MKC77FER75Accident · 1 fatalClosedWendt WH-1 · Lakeville, MNAug 8, 1977 · N3146 · DestroyedNTSB FTW77FRJ16Accident · 1 fatalClosedGrumman G-164A · Waterproof, LAAug 8, 1977 · N5417 · DestroyedNTSB OAK77FA047Accident · 2 fatalClosedCessna 120 · San Ramon, CAAug 7, 1977 · N2346N · DestroyedNTSB MIA77FA076Accident · 2 fatalClosedChampion 7ECA · Greenville, SCAug 7, 1977 · N9103L · DestroyedNTSB LAX77FUJ78Accident · 3 fatalClosedBellanca 14-13 · Mesa, AZAug 7, 1977 · N86769 · DestroyedNTSB LAX77FA063Accident · 2 fatalClosedCessna 172M · Big Bear City, CAAug 7, 1977 · N1204U · DestroyedNTSB CHI77FA064Accident · 4 fatalClosedPiper PA-28R · De Witt, ILAug 6, 1977 · N3009Q · DestroyedNTSB OAK77FA056Accident · 2 fatalClosedCessna 172M · Carmel Valley, CAAug 5, 1977 · N1786V · DestroyedNTSB OAK77FA046Accident · 2 fatalClosedBeech A36 · Crescent City, CAAug 4, 1977 · N1066W · DestroyedNTSB NYC77FHJ33Accident · 1 fatalClosedChampion 7GCAA · Shirley, NYAug 4, 1977 · N6336N · Substantial damageNTSB MIA77FLA44Accident · 1 fatalClosedBellanca 17-30A · Jacksonville, FLAug 4, 1977 · N14761 · DestroyedNTSB FTW77FPA24Accident · 1 fatalClosedGersbach Sdwndr · Hebron, TXAug 4, 1977 · N11KG · Substantial damageNTSB CHI77FA063Accident · 3 fatalClosedAero Comdr 720 · Wausau, WIAug 4, 1977 · N688R · DestroyedNTSB ANC77FA067Accident · 1 fatalClosedDehavilland DHC-3 · Bettles, AKAug 4, 1977 · N48064 · Substantial damageNTSB MIA77FA074Accident · 1 fatalClosedCessna 182D · Cusseta, GAAug 3, 1977 · N9127X · DestroyedNTSB ANC77FA069Accident · 1 fatalClosedPiper PA-12 · Solo Creek, AKAug 3, 1977 · N4444M · DestroyedNTSB NYC77FNC43Accident · 1 fatalClosedBellanca 7GCBC · Ft Fairfield, MEAug 2, 1977 · N57482 · DestroyedNTSB NYC77FA077Accident · 1 fatalClosedPiper PA-23 · No Atlantic Ocean (Atlantic Ocean)Aug 2, 1977 · N14007 · DestroyedNTSB MIA77FA073Accident · 1 fatalClosedBellanca 7GCBC · Leland, MSAug 2, 1977 · N36379 · DestroyedNTSB IAD77FA055Accident · 1 fatalClosedBoeing A75N-1 · Union City, TNAug 2, 1977 · N46998 · DestroyedNTSB FTW77FA065Accident · 1 fatalClosedPiper PA-28 · Wichita Falls, TXAug 2, 1977 · N5912F · DestroyedNTSB LAX77FA060Accident · 2 fatalClosedBell 206B · Encino, CAAug 1, 1977 · N4TV · DestroyedNTSB CHI77FET31Accident · 2 fatalClosedTurner T-40A · Valparaiso, INAug 1, 1977 · N278S · DestroyedNTSB CHI77FA062Accident · 1 fatalClosedBellanca 7ACA · Oshkosh, WIAug 1, 1977 · N12204 · 2 aircraft · DestroyedNTSB OAK77FA045Accident · 1 fatalClosedCessna 182P · Reno, NVJul 31, 1977 · N7008Q · Substantial damageNTSB NYC77FA075Accident · 1 fatalClosedCessna 172 · Mayfield, NYJul 31, 1977 · N5676R · Substantial damageNTSB ANC77FA065Accident · 5 fatalClosedBeech E90 · Sitka, AKJul 31, 1977 · N4207S · DestroyedNTSB NYC77FHA31Accident · 1 fatalClosedBeech 35H · Avoca, PAJul 30, 1977 · N5530D · DestroyedNTSB CHI77FA061Accident · 1 fatalClosedCessna 172F · Grand Rapids, MIJul 30, 1977 · N5606R · DestroyedNTSB CHI77EEP48Accident · 1 fatalClosedBellanca 14-13 · Prairie Du Chn, WIJul 30, 1977 · N86709 · Substantial damage