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 MKC77FCD27Accident · 1 fatalClosedPiper PA-25 · Woodbine, IAJul 6, 1977 · N8800L · DestroyedNTSB LAX77FUA18Accident · 2 fatalClosedBoeing PT-17 · Costa Mesa, CAJul 6, 1977 · N977Y · DestroyedNTSB DCA77AA022Accident · 3 fatalClosedLockheed L-188C · St.Louis, MOJul 6, 1977 · N280F · DestroyedNTSB ANC77FA054Accident · 1 fatalClosedAeronca 7AC · Sterling, AKJul 6, 1977 · N83535 · Substantial damageNTSB SEA77FYA26Accident · 2 fatalClosedPiper PA-18 · Picabo, IDJul 4, 1977 · N1880P · DestroyedNTSB NYC77FA067Accident · 2 fatalClosedPiper PA-24 · Windham, VTJul 4, 1977 · N5039P · DestroyedNTSB LAX77FA055Accident · 1 fatalClosedSchweizer SGS126 · Ocotillo Wells, CAJul 4, 1977 · N2550H · DestroyedNTSB CHI77FER04Accident · 1 fatalClosedPiper PA-24 · Superior, WIJul 4, 1977 · N8898 · Substantial damageNTSB CHI77FA057Accident · 2 fatalClosedCessna 150J · Missing AircraftJul 4, 1977 · N50935 · DestroyedNTSB CHI77FA056Accident · 4 fatalClosedPiper PA-23 · Freesoil, MIJul 4, 1977 · N4338P · DestroyedNTSB IAD77FA050Accident · 1 fatalClosedCessna 182 · Bryson City, NCJul 3, 1977 · N5478B · DestroyedNTSB DEN77FTC18Accident · 1 fatalClosedLuscombe 8A · Walcott, WYJul 3, 1977 · N71257 · DestroyedNTSB SEA77FYM44Accident · 1 fatalClosedBellanca 8KCAB · Ukiah, ORJul 2, 1977 · N78ML · DestroyedNTSB ANC77FA053Accident · 1 fatalClosedCessna 180F · Bethel, AKJul 2, 1977 · N2182Z · Substantial damageNTSB MIA77DA066Accident · 2 fatalClosedDavis D-1-W · Camden, SCJun 29, 1977 · N13576 · DestroyedNTSB MIA77FLD73Accident · 1 fatalClosedBoeing E-75 · Ft.Pierce, FLJun 28, 1977 · N66307 · DestroyedNTSB FTW77FQG36Accident · 1 fatalClosedAero Comdr A9B · Nolan, TXJun 28, 1977 · N7723V · DestroyedNTSB MIA77FA065Accident · 1 fatalClosedPiper PA18 · Foley, ALJun 26, 1977 · N9578D · DestroyedNTSB DEN77FA046Accident · 2 fatalClosedPiper PA-22 · Englewood, COJun 26, 1977 · N3715A · DestroyedNTSB DEN77FA045Accident · 2 fatalClosedCessna 305A · Gunnison, COJun 26, 1977 · N5222G · DestroyedNTSB LAX77FA053Accident · 5 fatalClosedPiper PA-31 · Grand Canyon, AZJun 25, 1977 · N54727 · DestroyedNTSB CHI77FA054Accident · 4 fatalClosedMooney M20F · Port Huron, MIJun 25, 1977 · N9349V · Substantial damageNTSB CHI77FA053Accident · 5 fatalClosedCessna 182C · Grattan, MIJun 25, 1977 · N8723T · DestroyedNTSB IAD77FA048Accident · 3 fatalClosedNa Rockwell 114 · Littleton, NCJun 24, 1977 · N4721W · DestroyedNTSB SEA77FYE25Accident · 1 fatalClosedCessna 310Q · Arlington, WAJun 23, 1977 · N7709Q · DestroyedNTSB MIA77FA064Accident · 1 fatalClosedCessna 210 · Summerland Key, FLJun 23, 1977 · N9536T · DestroyedNTSB CHI77FA052Accident · 1 fatalClosedCessna 320D · Cleveland, OHJun 23, 1977 · N536T · DestroyedNTSB SEA77FA041Accident · 1 fatalClosedPiper PA-18 · Glasgow, MTJun 22, 1977 · N4094Z · DestroyedNTSB MKC77FA029Accident · 4 fatalClosedPiper PA-28 · Walker, MNJun 22, 1977 · N55548 · DestroyedNTSB MKC77FA028Accident · 1 fatalClosedBellanca 8GCBC · Mound City, MOJun 22, 1977 · N88167 · DestroyedNTSB MIA77FA063Accident · 2 fatalClosedCessna 182F · Plymouth, FLJun 22, 1977 · N3628U · DestroyedNTSB NYC77FNE22Accident · 1 fatalClosedPiper PA-25 · Amherst, MAJun 20, 1977 · N6063Z · DestroyedNTSB NYC77FA065Accident · 1 fatalClosedEnstrom F-28A · North Wales, PAJun 20, 1977 · N1903F · DestroyedNTSB LAX77FA052Accident · 1 fatalClosedCessna 340A · Corona, CAJun 20, 1977 · N98621 · DestroyedNTSB CHI77FEG21Accident · 1 fatalClosedPitts S-1C · Minford, OHJun 20, 1977 · N73XL · DestroyedNTSB OAK77DA039Accident · 2 fatalClosedAero Comdr 112 · Missing AircraftJun 19, 1977 · N1168J · DestroyedNTSB LAX96LA321Accident · 2 fatalLimited investigationClosedRockwell 112 · Eureka, CAThe pilot's intentional VFR flight into instrument meteorological conditions.Jun 19, 1977 · N1168J · DestroyedNTSB IAD77FA046Accident · 1 fatalClosedCessna 150E · Raleigh, NCJun 19, 1977 · N629M · DestroyedNTSB FTW77FRA27Accident · 2 fatalClosedPiper J3C-65 · Waller, TXJun 19, 1977 · N38101 · 2 aircraft · DestroyedNTSB MKC77FA027Accident · 2 fatalClosedCessna 172 · Cedar Rapids, IAJun 18, 1977 · N5172F · Substantial damageNTSB IAD77FKW20Accident · 2 fatalClosedCessna 172 · Midtown Commun, TNJun 18, 1977 · N7129A · DestroyedNTSB MKC77FTK27Accident · 1 fatalClosedPiper PA-20 · Onida, SDJun 17, 1977 · N1507A · DestroyedNTSB MKC77FCD23Accident · 1 fatalClosedMorris Cass 111M · Winterset, IAJun 17, 1977 · N90RM · DestroyedNTSB MKC77FCQ42Accident · 1 fatalClosedCessna 188B · Olsburg, KSJun 16, 1977 · N4809Q · DestroyedNTSB MKC77FA026Accident · 2 fatalClosedBeech H35 · Beawfort, MOJun 16, 1977 · N5519D · DestroyedNTSB NYC77FA064Accident · 2 fatalClosedErco 415C · New Bedford, MAJun 15, 1977 · N3762H · DestroyedNTSB OAK77FA037Accident · 1 fatalClosedSikorski S58FT · Golconda, NVJun 14, 1977 · N9497 · DestroyedNTSB NYC77FA066Accident · 2 fatalClosedCessna 172K · Nantucket, MAJun 13, 1977 · N79005 · DestroyedNTSB MIA77FA061Accident · 1 fatalClosedPiper PA-16 · Valdosta, GAJun 13, 1977 · N5827H · DestroyedNTSB LAX77FA051Accident · 3 fatalClosedCessna 172M · Peoria, AZJun 13, 1977 · N1243U · Destroyed