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 MKC77FCQ08Accident · 1 fatalClosedBede BD-5G · Newton, KSNov 23, 1976 · N503BD · DestroyedNTSB FTW77FA016Accident · 1 fatalClosedCessna 182A · Boutte, LANov 23, 1976 · N6304B · DestroyedNTSB SEA77FA008Accident · 1 fatalClosedPiper PA-28R · Sandpoint, IDNov 22, 1976 · N15987 · DestroyedNTSB SEA77FA006Accident · 1 fatalClosedBellanca 7GCBC · Geyser, MTNov 21, 1976 · N36177 · DestroyedNTSB FTW77FA015Accident · 2 fatalClosedPiper PA-11 · Comstock, TXNov 21, 1976 · N66A · DestroyedNTSB NYC77FA014Accident · 1 fatalClosedCessna 172M · Conneautville, PANov 20, 1976 · N80778 · DestroyedNTSB MKC77FA005Accident · 2 fatalClosedChampion 7GCBC · Lincoln, KSNov 20, 1976 · N1852G · DestroyedNTSB MKC77FA004Accident · 3 fatalClosedPiper PA-18 · Grand Rapids, MNNov 20, 1976 · N8415P · 2 aircraft · DestroyedNTSB LAX77FA011Accident · 2 fatalClosedCessna 182 · San Marcos, CANov 20, 1976 · N9186M · DestroyedNTSB FTW77FA014Accident · 1 fatalClosedCessna 210B · Waelder, TXNov 19, 1976 · N9705X · DestroyedNTSB FTW77FA013Accident · 1 fatalClosedPiper PA-28 · Rosebud, TXNov 19, 1976 · N9061W · DestroyedNTSB DEN77FA010Accident · 2 fatalClosedBellanca 17-30A · Taos, NMNov 19, 1976 · N4027B · DestroyedNTSB CHI77FA007Accident · 1 fatalClosedMooney M20C · Peoria, ILNov 19, 1976 · N6861U · DestroyedNTSB FTW77DA025Accident · 1 fatalClosedAero Comdr 500-S · Gulf Of Guinea (Atlantic Ocean)Nov 18, 1976 · N57278 · DestroyedNTSB OAK77FA005Accident · 2 fatalClosedCessna 310L · Hawthorne, NVNov 17, 1976 · N2208F · DestroyedNTSB MKC77FA002Accident · 1 fatalClosedAero Comdr 690A · Independence, KSNov 17, 1976 · N57186 · DestroyedNTSB MIA77FA010Accident · 3 fatalClosedPiper PA-31 · Tallahassee, FLNov 17, 1976 · N50BB · DestroyedNTSB OAK77FVG10Accident · 1 fatalClosedCessna T210K · Davis, CANov 16, 1976 · N8289M · DestroyedNTSB MIA76FA008Accident · 1 fatalClosedCessna 150L · Orlando, FLNov 16, 1976 · N7511G · DestroyedNTSB IAD77FA013Accident · 3 fatalClosedCessna 310 · Black Mountain, NCNov 16, 1976 · N3625D · DestroyedNTSB CHI77FEM10Accident · 1 fatalClosedScorpion 2 · Alston, MINov 16, 1976 · N63301 · Substantial damageNTSB MIA77FA009Accident · 3 fatalClosedPiper PA-28 · Beaufort, SCNov 15, 1976 · N7286J · DestroyedNTSB OAK77FA029Accident · 2 fatalClosedCessna 182L · Bell Station, CANov 14, 1976 · N3187R · DestroyedNTSB LAX77FA010Accident · 1 fatalClosedAero Comdr 112A · Trabuco Canyon, CANov 14, 1976 · N1450J · DestroyedNTSB LAX77FA009Accident · 1 fatalClosedBeech 19A · Grand Canyon, AZNov 13, 1976 · N5084T · DestroyedNTSB UNK77X0101Accident · 5 fatalClosedPiper PA-31T · Shannon Arpt, EINov 12, 1976 · HB-LHT · DestroyedNTSB NYC77FA012Accident · 1 fatalClosedPiper PA-22 · Warren Center, PANov 12, 1976 · N973A · DestroyedNTSB IAD77FA012Accident · 4 fatalClosedPiper PA-28 · Wise, NCNov 12, 1976 · N2693T · DestroyedNTSB CHI77FA006Accident · 2 fatalClosedPiper PA-31 · Spring Lake, MINov 11, 1976 · N74941 · DestroyedNTSB CHI77FA005Accident · 1 fatalClosedTaylorcraft DC0-65 · Belleville, ILNov 11, 1976 · N50377 · Substantial damageNTSB SEA77FA005Accident · 2 fatalClosedCessna 172 · Pendleton, ORNov 9, 1976 · N5789A · DestroyedNTSB IAD77DA011Accident · 1 fatalClosedBell 47G-2 · Pigeon Forge, TNNov 6, 1976 · N6755D · DestroyedNTSB FTW77FA011Accident · 1 fatalClosedCessna 150 · Denton, TXNov 6, 1976 · N1336Q · 2 aircraft · DestroyedNTSB DEN77FA008Accident · 2 fatalClosedPiper PA-24 · Grantsville, UTNov 6, 1976 · N6180P · DestroyedNTSB LAX77FA008Accident · 1 fatalClosedBeech D-45 · Avalon, CANov 5, 1976 · N14406 · DestroyedNTSB FTW77FA010Accident · 2 fatalClosedCessna A150M · Cypress, TXNov 5, 1976 · N9871J · DestroyedNTSB LAX77FA007Accident · 2 fatalClosedCessna 172 · Terminal Islnd, CANov 4, 1976 · N20140 · 2 aircraft · DestroyedNTSB NYC77FA008Accident · 1 fatalClosedBeech 35-B33 · Glenville, NYNov 2, 1976 · N8613Q · DestroyedNTSB MIA77FA006Accident · 2 fatalClosedLuscombe 8E · Batesville, MSNov 1, 1976 · N1666K · DestroyedNTSB NYC77FA007Accident · 2 fatalClosedMooney M20C · Andes, NYOct 31, 1976 · N7861V · DestroyedNTSB MIA77FA005Accident · 1 fatalClosedCessna R172E · Jonesboro, GAOct 29, 1976 · N3CD · DestroyedNTSB LAX77FA006Accident · 2 fatalClosedCessna 172 · Flagstaff, AZOct 28, 1976 · N5591R · DestroyedNTSB LAX77FA005Accident · 1 fatalClosedCessna U206 · Joseph City, AZOct 27, 1976 · N3945G · DestroyedNTSB DEN77FA004Accident · 1 fatalClosedPiper PA-32R · Matheson, COOct 27, 1976 · N9705K · DestroyedNTSB OAK77FA004Accident · 2 fatalClosedBellanca 8GCBC · Las Vegas, NVOct 25, 1976 · N86975 · Substantial damageNTSB FTW77FA009Accident · 1 fatalClosedCessna 177B · Oklahoma City, OKOct 25, 1976 · N515BC · DestroyedNTSB SEA77FA004Accident · 1 fatalClosedBeech A36 · Chester, MTOct 24, 1976 · N6803S · DestroyedNTSB MIA77DA004Accident · 1 fatalClosedBeech E-50 · Missing AircraftOct 24, 1976 · N5665D · DestroyedNTSB IAD77FA009Accident · 2 fatalClosedBellanca 17-30A · Nakina, NCOct 24, 1976 · N8799V · DestroyedNTSB OAK77FA003Accident · 1 fatalClosedBeech A36 · Coalinga, CAOct 23, 1976 · N7317R · Destroyed