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 MKC78FA067Accident · 2 fatalClosedPiper PA-28 · St George, MNAug 26, 1978 · N43177 · DestroyedNTSB MIA78FA120Accident · 2 fatalClosedGrum-Amer AA1A · Toa Baja, PRAug 26, 1978 · N6330L · DestroyedNTSB IAD78FA099Accident · 2 fatalClosedPiper PA-28R · Bolton, NCAug 26, 1978 · N41786 · DestroyedNTSB IAD78FA098Accident · 2 fatalClosedCessna 210L · Hot Springs, VAAug 25, 1978 · N3JE · DestroyedNTSB DEN78FA065Accident · 6 fatalClosedMitsubishi MU-2J · Raton, NMAug 25, 1978 · N178MA · Substantial damageNTSB ANC78FA067Accident · 12 fatalClosedGrumman G-21A · Laboucher BayAug 25, 1978 · N1045 · DestroyedNTSB OAK78FA044Accident · 1 fatalClosedCessna 182Q · Eureka, CAAug 21, 1978 · N759LZ · DestroyedNTSB OAK78FVD54Accident · 1 fatalClosedGrumman TS-2A · Laytonville, CAAug 20, 1978 · N448DF · DestroyedNTSB NYC78FA082Accident · 1 fatalClosedCessna 150L · Prospect Harbr, MEAug 20, 1978 · N10391 · DestroyedNTSB MKC78FA066Accident · 2 fatalClosedCessna 172N · Blaine, MNAug 20, 1978 · N733SD · DestroyedNTSB LAX78FA067Accident · 2 fatalClosedGarcia HS A-2 · Rnch Cucamonga, CAAug 20, 1978 · N517JR · DestroyedNTSB IAD78FA097Accident · 4 fatalClosedCessna 195 · Whitesburg, KYAug 20, 1978 · N11DK · DestroyedNTSB CHI78FA060Accident · 2 fatalClosedWooddell Pusher · Fort Wayne, INAug 20, 1978 · N2542 · 2 aircraft · Substantial damageNTSB SEA78FA058Accident · 2 fatalClosedBeech C35 · Redmond, ORAug 19, 1978 · N668D · DestroyedNTSB MIA78FA116Accident · 2 fatalClosedPiper J3C · Homestead, FLAug 19, 1978 · N46917 · DestroyedNTSB FTW78FPG78Accident · 1 fatalClosedPiper PA-25 · Sherrill, ARAug 19, 1978 · N7383Z · DestroyedNTSB UNK78X0132Accident · 1 fatalClosedBell 205A · Dennison, CanadaAug 18, 1978 · N480AS · DestroyedNTSB SEA78FA057Accident · 6 fatalClosedCessna 320 · Anaconda, MTAug 18, 1978 · N24P · DestroyedNTSB OAK78FA043Accident · 1 fatalClosedBellanca 8KCAB · Caruthers, CAAug 18, 1978 · N5506Y · DestroyedNTSB MKC78FA065Accident · 3 fatalClosedBell 47-G2 · Branson, MOAug 18, 1978 · N939B · DestroyedNTSB CHI78FEP61Accident · 2 fatalClosedBeech C23 · Portage, WIAug 18, 1978 · N18952 · DestroyedNTSB FTW78FA069Accident · 2 fatalClosedAeronca 7AC · Haslet, TXAug 16, 1978 · N84521 · DestroyedNTSB SEA78FA056Accident · 2 fatalClosedCessna 172XP · Eugene, ORAug 15, 1978 · N736XU · DestroyedNTSB SEA78AM001Accident · 2 fatalClosedPiper PA-28 · Missing AircraftAug 14, 1978 · N1661J · DestroyedNTSB NYC78FA081Accident · 1 fatalClosedCessna 177 · Chatham, MAAug 14, 1978 · N34487 · Substantial damageNTSB DEN78FA060Accident · 2 fatalClosedPiper PA-28 · Edgerton, WYAug 14, 1978 · N40439 · DestroyedNTSB CHI78FEX31Accident · 1 fatalClosedCessna 172 · Evansville, INAug 14, 1978 · N7071T · DestroyedNTSB IAD78FA094Accident · 4 fatalClosedPiper PA-28 · Hemlock, WVAug 13, 1978 · N8789W · DestroyedNTSB FTW78FA067Accident · 2 fatalClosedCessna 150K · De Queen, ARAug 13, 1978 · N5969G · DestroyedNTSB FTW78FA066Accident · 1 fatalClosedBolkow BO-105 · Cameron, LAAug 13, 1978 · N17235 · DestroyedNTSB DEN78FA059Accident · 6 fatalClosedBeech 55 · Fairfield, UTAug 13, 1978 · N978V · DestroyedNTSB CHI78FEP47Accident · 1 fatalClosedChampion 7ECA · Howard, WIAug 13, 1978 · N9681S · Substantial damageNTSB CHI78FA059Accident · 2 fatalClosedMooney M20C · Valparaiso, INAug 13, 1978 · N44JH · DestroyedNTSB ANC78FA065Accident · 1 fatalClosedBeech 95-B55 · Wittier, AKAug 13, 1978 · N1078W · DestroyedNTSB MKC78FA064Accident · 1 fatalClosedGreat Lakes 2T-1A · Mason City, IAAug 12, 1978 · N3801F · DestroyedNTSB MKC78FA063Accident · 3 fatalClosedCessna 177 · Plainville, KSAug 12, 1978 · N2319Y · DestroyedNTSB MKC78FA062Accident · 4 fatalClosedPiper PA-28 · Brighton, MOAug 12, 1978 · N7245W · Substantial damageNTSB MIA79FLA34Accident · 1 fatalClosedBell 47G2 · Omega, GAAug 12, 1978 · N6729D · DestroyedNTSB DEN78FA057Accident · 5 fatalClosedPiper PA-28 · Silverplume, COAug 12, 1978 · N8719W · DestroyedNTSB CHI78FA058Accident · 1 fatalClosedPiper PA-28 · Bedford, INAug 12, 1978 · N43167 · DestroyedNTSB SEA78FYA21Accident · 1 fatalClosedAir Tractor AT-300 · Idaho Falls, IDAug 11, 1978 · N4331S · Substantial damageNTSB SEA78FA055Accident · 3 fatalClosedAero Comdr 100 · Bly, ORAug 11, 1978 · N4179X · DestroyedNTSB SEA78FA054Accident · 1 fatalClosedCessna T206 · Challis, IDAug 10, 1978 · N756LV · DestroyedNTSB SEA78FA053Accident · 1 fatalClosedStinson 108E · Enumclaw, WAAug 10, 1978 · N4122C · DestroyedNTSB IAD78FA114Accident · 1 fatalClosedBellanca 8KCAB · Princeton, KYAug 10, 1978 · N205HL · DestroyedNTSB IAD78FA092Accident · 1 fatalClosedPiper J-3 · White Marsh, MDAug 10, 1978 · N51537 · DestroyedNTSB DEN78FA056Accident · 3 fatalClosedPiper PA-24 · Carrizozo, NMAug 10, 1978 · N5338P · DestroyedNTSB MIA78DA112Accident · 1 fatalClosedSchemp Nimbus · Mt Groghan, SCAug 9, 1978 · N2WH · DestroyedNTSB IAD78FA090Accident · 1 fatalClosedPiper PA-22 · Westminister, MDAug 9, 1978 · N2851Z · DestroyedNTSB ANC78FA066Accident · 2 fatalClosedPiper PA-22 · Chandalar Lake, AKAug 9, 1978 · N7615K · Substantial damage