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 MKC78FA060Accident · 4 fatalClosedAmer Avco AA-5B · North Bend, NEAug 8, 1978 · N81224 · DestroyedNTSB MIA79FA114Accident · 6 fatalClosedAero Comdr 560E · Bimini, Burkina FasoAug 8, 1978 · N6227B · DestroyedNTSB IAD78FA089Accident · 3 fatalClosedMooney M20J · Bakersville, NCAug 8, 1978 · N201FH · DestroyedNTSB CHI78FEV34Accident · 1 fatalClosedVari-Viggen · Urbana, ILAug 8, 1978 · N29HR · DestroyedNTSB MKC78FCQ36Accident · 1 fatalClosedVari-Eze · Liberal, KSAug 7, 1978 · N36EZ · DestroyedNTSB MIA78DA115Accident · 2 fatalClosedAero Comdr 680F · Ngreat Inagua (Atlantic Ocean)Aug 7, 1978 · N669SA · DestroyedNTSB LAX78FA064Accident · 2 fatalClosedHughes 269C · Phoenix, AZAug 7, 1978 · N7477F · DestroyedNTSB CHI78FA053Accident · 2 fatalClosedCessna 177RG · Jefferson, OHAug 6, 1978 · N45369 · DestroyedNTSB CHI78FA052Accident · 2 fatalClosedPiper PA-22 · East Moline, ILAug 6, 1978 · N3217B · 2 aircraft · DestroyedNTSB MIA78FA110Accident · 1 fatalClosedHughes 269C · Opa Locka, FLAug 5, 1978 · N7455F · DestroyedNTSB LAX78FUG46Accident · 1 fatalClosedCessna 150B · Rialto, CAAug 4, 1978 · N1161Y · 2 aircraft · DestroyedNTSB SEA78FA051Accident · 1 fatalClosedCessna 337F · Ocean Shores, WAAug 3, 1978 · N1843M · Substantial damageNTSB FTW78FRJ26Accident · 1 fatalClosedPiper PA-25 · Tallulah, LAAug 3, 1978 · N9853P · DestroyedNTSB MKC78FA058Accident · 1 fatalClosedCessna 120 · Kimball, NEAug 2, 1978 · N16DF · DestroyedNTSB IAD78FA088Accident · 3 fatalClosedPiper PA-34 · Chesterfield, VAAug 2, 1978 · N56122 · DestroyedNTSB FTW78FA064Accident · 1 fatalClosedPiper PA-23 · Leakey, TXAug 2, 1978 · N4195P · DestroyedNTSB CHI78FEI32Accident · 2 fatalClosedLockheed P38L · Whitehouse, OHAug 1, 1978 · N3005 · DestroyedNTSB NYC79FA075Accident · 1 fatalClosedCessna 310P · Sussex, NJJul 31, 1978 · N5808M · DestroyedNTSB LAX78FA063Accident · 1 fatalClosedCessna 172N · Big Bear, CAJul 31, 1978 · N711RH · DestroyedNTSB CHI78FA051Accident · 2 fatalClosedBeech E-33A · Prt Washington, WIJul 31, 1978 · N6275V · DestroyedNTSB SEA78FA050Accident · 1 fatalClosedCessna 150F · Lynden, WAJul 30, 1978 · N6735F · DestroyedNTSB CHI78FEX28Accident · 2 fatalClosedPiper PA-28 · Mitchell, INJul 30, 1978 · N7638W · DestroyedNTSB CHI78FEP52Accident · 2 fatalClosedThorp T-18 · Oshkosh, WIJul 30, 1978 · N18FK · DestroyedNTSB ANC78FA062Accident · 1 fatalClosedCessna U206F · Bettles, AKJul 30, 1978 · N1041V · DestroyedNTSB UNK78X0129Accident · 1 fatalClosedEnstrom 280C · Lester, WAJul 28, 1978 · N530H · DestroyedNTSB MIA78FLD67Accident · 1 fatalClosedCessna 172 · Ocoee, FLJul 28, 1978 · N8838V · DestroyedNTSB LAX78FUJ89Accident · 1 fatalClosedPiper PA-36 · Casa Grande, AZJul 28, 1978 · N57569 · DestroyedNTSB NYC78FA073Accident · 1 fatalClosedCessna 150 · Southbridge, MAJul 27, 1978 · N8196F · Substantial damageNTSB LAX78FUJ87Accident · 1 fatalClosedGrumman G-164A · Buckeye, AZJul 27, 1978 · N7947 · DestroyedNTSB OAK78FA040Accident · 1 fatalClosedScheitzer 2-33A · Boulder City, NVJul 25, 1978 · N65841 · DestroyedNTSB OAK78FA039Accident · 3 fatalClosedPiper PA-28 · Petaluma, CAJul 23, 1978 · N2831M · DestroyedNTSB MIA78FA107Accident · 1 fatalClosedBeech A23 · Inverness, FLJul 23, 1978 · N1428L · DestroyedNTSB IAD78FA084Accident · 1 fatalClosedCessna 172B · Selmer, TNJul 22, 1978 · N7684X · DestroyedNTSB FTW78FA062Accident · 2 fatalClosedBellanca 8KCAB · Lake Dallas, TXJul 22, 1978 · N68513 · DestroyedNTSB LAX78FUJ85Accident · 1 fatalClosedMidget Mustng · Flagstaff, AZJul 21, 1978 · N6KW · DestroyedNTSB OAK78FVD47Accident · 1 fatalClosedGrumman G-164B · Manteca, CAJul 20, 1978 · N9256A · DestroyedNTSB FTW78FA065Accident · 3 fatalClosedCessna 310B · Cameron, LAJul 20, 1978 · N5403A · DestroyedNTSB DEN78FA052Accident · 2 fatalClosedLuscombe 8A · Farmington, NMJul 20, 1978 · N45694 · Substantial damageNTSB MKC78FA056Accident · 2 fatalClosedCessna 150 · Columbus, KSJul 19, 1978 · N18544 · DestroyedNTSB MIA78FA105Accident · 2 fatalClosedTed Smith 600 · Jacksonville, FLJul 19, 1978 · N868Y · DestroyedNTSB FTW78FRJ24Accident · 1 fatalClosedAero-Comdr S-2R · Lake Providenc, LAJul 19, 1978 · N8859Q · DestroyedNTSB FTW78FPG66Accident · 1 fatalClosedCessna 172L · Durham, ARJul 19, 1978 · N7940G · Substantial damageNTSB ANC78FA054Accident · 4 fatalClosedBeech C24R · Kenai, AKJul 19, 1978 · N2230L · DestroyedNTSB MIA78DA119Accident · 2 fatalClosedPiper PA-31 · Missing AircraftJul 18, 1978 · N689WW · DestroyedNTSB ANC78FA055Accident · 2 fatalClosedPiper PA-18 · Petersville, AKJul 18, 1978 · N3976Z · Substantial damageNTSB SEA78FA047Accident · 1 fatalClosedPiper PA-28R · Coeur D'Alene, IDJul 16, 1978 · N5068S · Substantial damageNTSB MIA78FA104Accident · 4 fatalClosedCessna 336 · Lakeland, FLJul 16, 1978 · N1742Z · DestroyedNTSB FTW78FA060Accident · 1 fatalClosedPiper PA-28 · Brownfield, TXJul 16, 1978 · N55469 · DestroyedNTSB CHI78FEK24Accident · 1 fatalClosedCessna 150M · Urbana, OHJul 16, 1978 · N66382 · DestroyedNTSB NYC78FA071Accident · 3 fatalClosedPiper PA-28 · Campbell, NYJul 15, 1978 · N4853F · Destroyed