Skip to content

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB SEA79FA041Accident · 2 fatalClosedBellanca 7GCBC · Big Sky, MTJul 1, 1979 · N6397V · Destroyed NTSB LAX79FAMS3Accident · 2 fatalClosedPiper PA-28 · Missing AircraftJul 1, 1979 · N3494M · Destroyed NTSB CHI79FA054Accident · 2 fatalClosedCessna 140 · Springbrook, WIJul 1, 1979 · N1972J · Destroyed NTSB MIA79FA100Accident · 2 fatalClosedCessna 150J · Missing AircraftJun 30, 1979 · N60936 · Destroyed NTSB SEA79FYA18Accident · 1 fatalClosedCessna 188 · Aberdeen, IDJun 29, 1979 · N8225G · Destroyed NTSB FTW79FA090Accident · 2 fatalClosedLuscombe 8A · Winnsboro, LAJun 29, 1979 · N45950 · Destroyed NTSB NYC79FA050Accident · 2 fatalClosedPiper PA-12 · Stillmanville, NJJun 27, 1979 · N4293M · Destroyed NTSB ANC79FA063Accident · 2 fatalClosedBeech B19 · Anchorage, AKJun 27, 1979 · N24042 · Destroyed NTSB LAX79FA058Accident · 2 fatalClosedBeech 35 · Redlands, CAJun 26, 1979 · N4455V · Destroyed NTSB OAK79FA033Accident · 4 fatalClosedCessna 182A · Albion, CAJun 25, 1979 · N5969B · Destroyed NTSB OAK79DAMS6Accident · 2 fatalClosedPiper PA-28 · Maui, HIJun 25, 1979 · N30775 · Destroyed NTSB CHI79FA053Accident · 1 fatalClosedAeronca 11AC · Chippewa Falls, WIJun 25, 1979 · N9408E · Destroyed NTSB MKC79FCA19Accident · 2 fatalClosedDavis DA2B · Bowling Green, MOJun 23, 1979 · N74FJ · Destroyed NTSB FTW79FA089Accident · 2 fatalClosedBeech V35B · Pampa, TXJun 23, 1979 · N2028P · Destroyed NTSB SEA79FA040Accident · 1 fatalClosedBellanca 7KCAB · Laurel, MTJun 22, 1979 · N1833G · Destroyed NTSB MKC79FA037Accident · 1 fatalClosedCessna 182Q · Dawson, NDJun 22, 1979 · N456LH · Destroyed NTSB LAX79FUT01Accident · 1 fatalClosedDouglas DC-7C · Daggett, CAJun 22, 1979 · N357AL · Destroyed NTSB OAK79FXQ26Accident · 1 fatalClosedVickers T-65 · Minden, NVJun 20, 1979 · N9023N · Destroyed NTSB IAD79FA058Accident · 3 fatalClosedCessna 421B · Charleston, WVJun 19, 1979 · N69733 · Destroyed NTSB NYC79FA049Accident · 3 fatalClosedPiper PA-28 · Flushing, NYJun 18, 1979 · N9283C · Destroyed NTSB MIA79FKG49Accident · 1 fatalClosedPiper PA-25 · Wrightsville, GAJun 18, 1979 · N9534P · Destroyed NTSB FTW79DA088Accident · 1 fatalClosedMitsubishi MU-2B · New Orleans, LAJun 18, 1979 · N222LR · Substantial damage NTSB MKC79FA036Accident · 1 fatalClosedGrumman AA-1B · Clearwater, MNJun 17, 1979 · N1459R · Destroyed NTSB MIA79FLT06Accident · 1 fatalClosedPitts S1-C · Southaven, MSJun 17, 1979 · N20JH · Destroyed NTSB LAX79FVM27Accident · 1 fatalClosedBensen B8M · Paso Robles, CAJun 17, 1979 · N1450 · Destroyed NTSB DCA79AA019Accident · 1 fatalClosedDehavilland DHC-6 · Hyannis, MAJun 17, 1979 · N383EX · Destroyed NTSB MIA79FA097Accident · 2 fatalClosedCessna 150L · Meridian, MSJun 16, 1979 · N19192 · Destroyed NTSB MIA79FAQ96Accident · 1 fatalClosedBeech 65 · Preston, GAJun 13, 1979 · N111WP · Destroyed NTSB FTW79FRG41Accident · 1 fatalClosedAir Tractor AT-301 · Elsa, TXJun 13, 1979 · N4412S · Destroyed NTSB MIA79FA094Accident · 2 fatalClosedDouglas DC-3 · Ft Lauderdale, FLJun 12, 1979 · N427W · Destroyed NTSB LAX79FA059Accident · 4 fatalClosedCessna 177 · Long Beach, CAJun 9, 1979 · N29482 · Destroyed NTSB FTW79FPG51Accident · 1 fatalClosedPiper PA-36 · Tupelo, ARJun 9, 1979 · N59673 · Destroyed NTSB CHI79FA052Accident · 2 fatalClosedBeech 99 · Chicago, ILJun 9, 1979 · N454SA · Destroyed NTSB SEA79FA039Accident · 1 fatalClosedCessna T337F · Seattle, WAJun 8, 1979 · N6322S · Destroyed NTSB LAX79FA056Accident · 2 fatalClosedBeech B23 · Oxnard, CAJun 8, 1979 · N29SM · Destroyed NTSB IAD79FA056Accident · 3 fatalClosedBeech C24R · Woodbridge, VAJun 7, 1979 · N18969 · Destroyed NTSB MIA79FA093Accident · 1 fatalClosedBeech 95 · Leesburg, FLJun 6, 1979 · N2032C · Destroyed NTSB IAD79FA055Accident · 2 fatalClosedBell 47G3B1 · Washington, DCJun 6, 1979 · N25MP · Destroyed NTSB MKC79FCQ27Accident · 1 fatalClosedStitts JD1 · Wichita, KSJun 5, 1979 · N3JD · Destroyed NTSB MIA79FA092Accident · 3 fatalClosedPiper PA-22 · Redlick, MSJun 5, 1979 · N9560D · Destroyed NTSB CHI79FA051Accident · 1 fatalClosedBeech 24R · Traverse City, MIJun 4, 1979 · N6561R · Destroyed NTSB NYC79FA048Accident · 1 fatalClosedCessna 150H · Dalton, NHJun 3, 1979 · N7052S · Destroyed NTSB LAX79FA064Accident · 2 fatalClosedPiper PA-28 · Oceanside, CAJun 3, 1979 · N4695T · Destroyed NTSB MKC79FCQ25Accident · 1 fatalClosedCallair A-9B · Yates Center, KSJun 2, 1979 · N7766V · Substantial damage NTSB MIA79FA091Accident · 3 fatalClosedBeech C23 · Tuscaloosa, ALJun 1, 1979 · N1955L · Destroyed NTSB IAD79FA053Accident · 1 fatalClosedCessna 172N · Mackville, KYJun 1, 1979 · N1667E · Destroyed NTSB MIA79FAMS2Accident · 2 fatalClosedCessna 182 · Missing AircraftMay 31, 1979 · N618WC · Destroyed NTSB IAD80FA041Accident · 2 fatalClosedCessna 182 · Waynesville, NCMay 31, 1979 · N618WC · Destroyed NTSB FTW79FA084Accident · 2 fatalClosedCessna 150 · Pearsall, TXMay 31, 1979 · N717LC · Destroyed NTSB DCA79AA018Accident · 17 fatalClosedDehavilland DHC-6 · Rockland, MEMay 30, 1979 · N68DE · Destroyed