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 MIA79FLD63Accident · 1 fatalClosedBell 47G · Loghman, FLJul 15, 1978 · N1158W · DestroyedNTSB ANC78FA052Accident · 1 fatalClosedCessna 150M · Cantwell, AKJul 15, 1978 · N66744 · Substantial damageNTSB SEA78FA045Accident · 1 fatalClosedHiller FH1100 · Clearlake, WAJul 14, 1978 · N99024 · DestroyedNTSB NYC78FA070Accident · 1 fatalClosedPiper PA-22 · Huntingdon, PAJul 14, 1978 · N2393P · DestroyedNTSB MKC78FER74Accident · 1 fatalClosedJ Lowers T-WIND · Fergus Falls, MNJul 14, 1978 · N195J · DestroyedNTSB IAD78FA083Accident · 1 fatalClosedLuscombe 8A · Fairfield, NCJul 14, 1978 · N71956 · Substantial damageNTSB CHI78FEC40Accident · 1 fatalClosedRyan ST3KR · Petersburg, MIJul 14, 1978 · N48700 · DestroyedNTSB ANC79FA051Accident · 1 fatalClosedBrantly B2-B · Nome, AKJul 14, 1978 · N2281U · Substantial damageNTSB LAX78FA062Accident · 2 fatalClosedGrum Amer AA1C · Prescott, AZJul 13, 1978 · N39002 · DestroyedNTSB NYC78FNE27Accident · 1 fatalClosedSchempp-Hir Cirrus · Fitchburg, MAJul 12, 1978 · N2RQ · DestroyedNTSB MKC78FA055Accident · 6 fatalClosedBeech 60 · Faribault, MNJul 12, 1978 · N777HH · Substantial damageNTSB CHI78FA049Accident · 1 fatalClosedBellanca 17-30A · Rhinelander, WIJul 12, 1978 · N93627 · DestroyedNTSB SEA78FA044Accident · 1 fatalClosedBeech B24R · Vashon, WAJul 11, 1978 · N6591R · DestroyedNTSB MKC78FCD39Accident · 2 fatalClosedSkylark WC-3 · Eagle Grove, IAJul 10, 1978 · N214JC · DestroyedNTSB MIA78FA103Accident · 3 fatalClosedPiper PA-30 · Albany, GAJul 10, 1978 · N41AC · DestroyedNTSB DEN78FA054Accident · 6 fatalClosedBeech 65-A90 · Aurora, COJul 10, 1978 · N278DU · DestroyedNTSB SEA78DA042Accident · 1 fatalClosedCessna 170A · Billings, MTJul 9, 1978 · N1780D · DestroyedNTSB NYC78FA069Accident · 4 fatalClosedPiper PA-32 · Westerly, RIJul 9, 1978 · N5254S · Substantial damageNTSB MKC78FA054Accident · 1 fatalClosedCessna 175B · Turtle Lake, NDJul 9, 1978 · N8126T · DestroyedNTSB CHI78FEX23Accident · 1 fatalClosedHunter Mong GH-1 · Roll, INJul 9, 1978 · N132H · DestroyedNTSB DEN78FTM28Accident · 1 fatalClosedClark Focke 190A3 · Cedar City, UTJul 8, 1978 · N23FW · DestroyedNTSB ANC78FA045Accident · 1 fatalClosedCessna 180 · Iliamna, AKJul 8, 1978 · N9427C · DestroyedNTSB MIA78FKG60Accident · 1 fatalClosedPiper PA-25 · Cordele, GAJul 7, 1978 · N4417Y · DestroyedNTSB LAX78FA061Accident · 1 fatalClosedSikorsky S-62A · San Pedro, CAJul 7, 1978 · N54516 · Substantial damageNTSB IAD78FA078Accident · 1 fatalClosedPiper PA-32 · Deep Gap, NCJul 6, 1978 · N43087 · DestroyedNTSB FTW78FA058Accident · 1 fatalClosedBell 206B · Cameron, LAJul 6, 1978 · N7979S · DestroyedNTSB CHI78FA046Accident · 1 fatalClosedCessna 170B · Ann Arbor, MIJul 6, 1978 · N2763C · DestroyedNTSB OAK78FA037Accident · 5 fatalClosedPiper PA-34 · Ysmite Nat Pk, CAJul 4, 1978 · N56954 · DestroyedNTSB MIA78FA102Accident · 2 fatalClosedBellanca 17-31A · Lake City, FLJul 4, 1978 · N8805V · DestroyedNTSB LAX78FA060Accident · 2 fatalClosedCessna 195 · Grand Canyon, AZJul 4, 1978 · N9809A · DestroyedNTSB IAD78FA077Accident · 3 fatalClosedPiper PA-24 · Deerfield, VAJul 4, 1978 · N5991P · DestroyedNTSB IAD78FA076Accident · 2 fatalClosedAeronca 7AC · Vanceboro, NCJul 4, 1978 · N81452 · DestroyedNTSB ANC78FA048Accident · 1 fatalClosedCessna A185F · Coronation Is, AKJul 4, 1978 · N774SB · DestroyedNTSB OAK78FVG59Accident · 1 fatalClosedVarieze · Dorris, CAJul 3, 1978 · N942 · DestroyedNTSB FTW78FA056Accident · 3 fatalClosedCessna 182P · Hollis, OKJul 3, 1978 · N10HP · DestroyedNTSB DEN78FA053Accident · 1 fatalClosedCessna TU206 · Canyon, WYJul 3, 1978 · N8478Q · DestroyedNTSB OAK78FAO36Accident · 4 fatalClosedCessna 182A · Red Bluff, CAJul 2, 1978 · N3873D · DestroyedNTSB LAX78FA059Accident · 3 fatalClosedMooney M20E · Ajo, AZJul 2, 1978 · N7129U · DestroyedNTSB FTW78FA055Accident · 2 fatalClosedBellanca 7GCBC · San Jose Isl, TXJul 2, 1978 · N36772 · DestroyedNTSB MKC78FA053Accident · 4 fatalClosedPiper PA-32 · Denison, IAJul 1, 1978 · N5510J · DestroyedNTSB MIA78FA101Accident · 2 fatalClosedPiper PA-28R · Courtland, ALJul 1, 1978 · N47975 · DestroyedNTSB LAX78FUJ74Accident · 1 fatalClosedPitts S-1T · Taylor, AZJul 1, 1978 · N9WT · DestroyedNTSB LAX78FA058Accident · 1 fatalClosedCessna 182 · San Diego, CAJul 1, 1978 · N2341G · 2 aircraft · DestroyedNTSB FTW78FPJ29Accident · 1 fatalClosedBellanca 8GCBC · Hinton, OKJul 1, 1978 · N86899 · DestroyedNTSB SEA78FA041Accident · 2 fatalClosedCessna 210L · Belgrade, MTJun 30, 1978 · N22195 · DestroyedNTSB ANC78FA042Accident · 1 fatalClosedCessna 207 · Omalik, AKJun 30, 1978 · N1789U · Substantial damageNTSB SEA78FA040Accident · 2 fatalClosedHughes 369D · New Meadows, IDJun 29, 1978 · N8380F · DestroyedNTSB LAX78FA057Accident · 3 fatalClosedCessna 170 · Grand Canyon, AZJun 28, 1978 · N4219V · DestroyedNTSB MIA78FA100Accident · 1 fatalClosedBeechcraft 65-80 · Mobile, ALJun 27, 1978 · N975SQ · DestroyedNTSB FTW78FA054Accident · 2 fatalClosedPiper PA-28 · Hebbronville, TXJun 27, 1978 · N7504R · Destroyed