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 MIA81FA011Accident · 1 fatalClosedCessna 404 · Gowers Corner, FLOct 30, 1980 · N37093 · Destroyed NTSB MIA81FA010Accident · 3 fatalClosedPiper PA-28R · Jacksonville, FLOct 30, 1980 · N444JS · Destroyed NTSB ATL81FA010Accident · 1 fatalClosedBellanca 8KCAB · Woodland, GAOct 30, 1980 · N4108Y · Destroyed NTSB NYC81FA007Accident · 1 fatalClosedBeech 95-C55 · Canisteo, NYOct 29, 1980 · N171W · Destroyed NTSB SEA81FA003Accident · 1 fatalClosedCessna 172 · Craigmont, IDOct 26, 1980 · N9109B · Destroyed NTSB MIA81FA009Accident · 2 fatalClosedCessna 152 · Cedar Key, FLOct 26, 1980 · N4755H · Destroyed NTSB DEN81DTE05Accident · 1 fatalClosedCessna 182Q · Grand Junction, COOct 26, 1980 · N735YM · Destroyed NTSB MIA81FA008Accident · 3 fatalClosedBeech E18S · Gainesville, FLOct 24, 1980 · N65V · Destroyed NTSB MIA81FA007Accident · 2 fatalClosedPiper 601P · Wilma, FLOct 23, 1980 · N8250J · Destroyed NTSB LAX81FA008Accident · 2 fatalClosedHughes 369 · Santa Rosa, CAOct 23, 1980 · N8304F · Destroyed NTSB ATL81FA008Accident · 4 fatalClosedCessna 310 · Milledgeville, GAOct 23, 1980 · N5882M · Destroyed NTSB MIA81FA006Accident · 2 fatalClosedBellanca 8KCAB · Ft Lauderdale, FLOct 21, 1980 · N99AM · Destroyed NTSB MIA81FA004Accident · 1 fatalClosedPiper PA-32R · Weeki Wachee, FLOct 19, 1980 · N1714H · Destroyed NTSB ANC81FA004Accident · 2 fatalClosedCessna U20GF · Deadhorse, AKOct 19, 1980 · N59199 · Destroyed NTSB LAX81FVG01Accident · 2 fatalClosedPorterfield 35W · Citrus Heights, CAOct 18, 1980 · N18520 · Destroyed NTSB LAX81FA006Accident · 3 fatalClosedSikorsky S58DT · Lovelock, NVOct 17, 1980 · N94523 · Destroyed NTSB DEN81FA008Accident · 4 fatalClosedAero Cmdr 500B · Buffalo, WYOct 17, 1980 · N6395U · Substantial damage NTSB DEN81FA007Accident · 3 fatalClosedBeech 65 · Sula, MTOct 17, 1980 · N35CS · Destroyed NTSB DEN80FAMS1Accident · 2 fatalClosedMooney M20F · Buffalo, WYOct 17, 1980 · N9182V · Destroyed NTSB MKC81FA005Accident · 2 fatalClosedCessna 207 · Cedar Rapids, IAOct 16, 1980 · N91026 · Destroyed NTSB LAX81FA004Accident · 1 fatalClosedCessna T210 · Sacramento, CAOct 16, 1980 · N6137B · Destroyed NTSB FTW81FA005Accident · 4 fatalClosedGrum Amer AA-5B · Madill, OKOct 16, 1980 · N28252 · Destroyed NTSB SEA81FA002Accident · 1 fatalClosedCessna 182Q · Ashland, OROct 15, 1980 · N735PZ · Destroyed NTSB FTW81FA004Accident · 2 fatalClosedBeech V35A · Cedar Hill, TXOct 15, 1980 · N1780A · Destroyed NTSB DEN81FA006Accident · 1 fatalClosedCessna 182K · Rock Springs, WYOct 15, 1980 · N2463Q · Substantial damage NTSB LAX81FA002Accident · 4 fatalClosedPiper PA-28 · Crestline, CAOct 14, 1980 · N2212D · Destroyed NTSB CHI81FCA02Accident · 2 fatalClosedAlvarez Polli · Grantfork, ILOct 14, 1980 · N1035S · Destroyed NTSB CHI81FA001Accident · 3 fatalClosedCessna 337H · Waterford, MIOct 14, 1980 · N1333L · 2 aircraft · Destroyed NTSB LAX81FVD04Accident · 1 fatalClosedB/Gt Lakes BS-1 · Livermore, CAOct 13, 1980 · N13BS · Destroyed NTSB DEN80FA005Accident · 1 fatalClosedTaylorcraft BC12-D · St.Ignatius, MTOct 13, 1980 · N95518 · Substantial damage NTSB ATL81FA007Accident · 4 fatalClosedCessna T188C · Theodore, ALOct 11, 1980 · N2181J · 2 aircraft · Destroyed NTSB MIA81FA001Accident · 4 fatalClosedPiper PA-28 · Aguadilla, PROct 10, 1980 · N707XQ · Destroyed NTSB ATL81FA006Accident · 4 fatalClosedCessna 172 · Roanoke, VAOct 10, 1980 · N7644T · Destroyed NTSB ATL81FA005Accident · 3 fatalClosedBeech 35 · Dargan, MDOct 10, 1980 · N418F · Destroyed NTSB FTW81FPM01Accident · 1 fatalClosedBenson B8M · Tulsa, OKOct 9, 1980 · N475 · Destroyed NTSB ATL81FA003Accident · 1 fatalClosedCessna R182 · Treasure Is, FLOct 9, 1980 · N4437R · Substantial damage NTSB MKC81FA004Accident · 1 fatalClosedPiper J3C-65 · Senath, MOOct 8, 1980 · N98058 · Destroyed NTSB FTW81FA003Accident · 1 fatalClosedCessna 182A · Kentwood, LAOct 7, 1980 · N2015G · Destroyed NTSB MKC81FA003Accident · 2 fatalClosedCessna 182H · Newcastle, WYOct 6, 1980 · N3460S · Destroyed NTSB ANC81FA001Accident · 1 fatalClosedCessna 185F · Le Duc Lake, AKOct 6, 1980 · N21749 · Substantial damage NTSB NYC81FA001Accident · 2 fatalClosedLake 4-200 · Little Egg, NJOct 4, 1980 · N875SR · Destroyed NTSB LAX81FUQ01Accident · 2 fatalClosedNo.American P-510 · Lancaster, CAOct 4, 1980 · N51MP · Destroyed NTSB LAX81FUM01Accident · 1 fatalClosedAir Tractor AT-300 · Imperial, CAOct 4, 1980 · N4356S · Destroyed NTSB DEN81FTE01Accident · 2 fatalClosedStarduster SA-30 · Brighton, COOct 4, 1980 · N3843 · Destroyed NTSB DEN81FA001Accident · 3 fatalClosedHughes 369HS · Silverton, COOct 4, 1980 · N9153F · Substantial damage NTSB SEA81FYM01Accident · 1 fatalClosedWalker Mini · Trout Lake, WAOct 2, 1980 · N249KY · Destroyed NTSB LAX80FVA03Accident · 2 fatalClosedPiper PA-32 · Merced, CAOct 2, 1980 · N21307 · Destroyed NTSB LAX81FVA01Accident · 3 fatalClosedPiper PA-28 · Groveland, CAOct 1, 1980 · N9689C · Destroyed NTSB ATL81FA001Accident · 1 fatalClosedCessna 210 · Cartersville, GAOct 1, 1980 · N6956N · Destroyed NTSB MIA80FA114Accident · 2 fatalClosedPiper PA-23 · Chattahoochee, FLSep 30, 1980 · N56675 · Destroyed