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 DEN80FA060Accident · 1 fatalClosedBell UH-1B · Provo, UTSep 2, 1980 · N99478 · Substantial damage NTSB ATL80FA088Accident · 1 fatalClosedAerostar 601P · Summerville, GASep 2, 1980 · N90463 · Destroyed NTSB CHI80FEE47Accident · 1 fatalClosedVari-Eze Heiman · Huntley, ILSep 1, 1980 · N5021Y · Destroyed NTSB ATL80FA087Accident · 1 fatalClosedCessna A150L · Anderson, SCSep 1, 1980 · N6082J · Destroyed NTSB ANC80FA096Accident · 2 fatalClosedBellanca 8GCBC · Glenallen, AKSep 1, 1980 · N88286 · Destroyed NTSB SEA80FAMS4Accident · 1 fatalClosedPiper PA-24 · Missing AircraftAug 31, 1980 · N21170 · Destroyed NTSB MIA80FA097Accident · 1 fatalClosedCessna 150 · Zephyrhills, FLAug 31, 1980 · N19295 · Destroyed NTSB LAX80FA137Accident · 2 fatalClosedDehavilland DH82A · Oak View, CAAug 31, 1980 · N87677 · Destroyed NTSB SEA80FA045Accident · 4 fatalClosedCessna 182Q · Skykomish, WAAug 30, 1980 · N759ZZ · Destroyed NTSB NYC80FA080Accident · 2 fatalClosedPiper PA-28 · Herkimer, NYAug 30, 1980 · CF-YFY · Substantial damage NTSB DEN80FA059Accident · 3 fatalClosedBell 206A/B · Red Lodge, MTAug 30, 1980 · N8030 · Destroyed NTSB CHI80FA066Accident · 1 fatalClosedPiper PA-28 · Antigo, WIAug 29, 1980 · N1807J · Destroyed NTSB MIA80FA096Accident · 2 fatalClosedPiper PA-31 · Vero Beach, FLAug 28, 1980 · N398GT · Destroyed NTSB MIA80FA095Accident · 2 fatalClosedCessna 172 · Wabasso, FLAug 28, 1980 · N3885L · Destroyed NTSB CHI80FA065Accident · 4 fatalClosedPiper PA-23 · East Tawas, MIAug 27, 1980 · N44EM · Destroyed NTSB LAX80FUM26Accident · 1 fatalClosedAir Tractor AT-301 · Brawley, CAAug 26, 1980 · N8544S · Destroyed NTSB LAX80FA136Accident · 1 fatalClosedHughes 369HS · Las Vegas, NVAug 26, 1980 · N9144F · Substantial damage NTSB ATL80FA086Accident · 1 fatalClosedChampion 7BCM · Lake City, SCAug 26, 1980 · N19CF · Destroyed NTSB MIA80DA094Accident · 1 fatalClosedBeech 65-80 · Pt.Maria (Gulf of Mexico)Aug 25, 1980 · N218K · Destroyed NTSB LAX80FVD37Accident · 1 fatalClosedBeech A36TC · Garberville, CAAug 25, 1980 · N66569 · Substantial damage NTSB CHI80FET27Accident · 1 fatalClosedDi Stasi Bowers · Ligonier, INAug 25, 1980 · N3392 · Substantial damage NTSB CHI80DAMS3Accident · 1 fatalClosedCessna 182G · Ludington, MIAug 24, 1980 · N2323R · Destroyed NTSB ANC80FA089Accident · 1 fatalClosedLake 4-200 · Hewitt Lake, AKAug 24, 1980 · N1108L · Substantial damage NTSB MIA80DA093Accident · 1 fatalClosedPiper PA-23 · Little Rag Is (Atlantic Ocean)Aug 23, 1980 · N5076Y · Destroyed NTSB LAX80FUW01Accident · 1 fatalClosedLockheed 382 · Otay, CAAug 23, 1980 · N18ST · Minor damage NTSB FTW80FRJ35Accident · 1 fatalClosedPiper PA-25 · Transylvania, LAAug 23, 1980 · N8503L · Destroyed NTSB NYC80FA075Accident · 1 fatalClosedPiper PA-18 · Exeter, RIAug 22, 1980 · N9863D · Substantial damage NTSB FTW80FA107Accident · 2 fatalClosedMooney M20F · Fredricksburg, TXAug 21, 1980 · N670JA · Destroyed NTSB DEN80FA057Accident · 5 fatalClosedPiper PA-32 · Choteau, MTAug 21, 1980 · N4429T · Substantial damage NTSB ANC80FA087Accident · 4 fatalClosedCessna 340A · Petersburg, AKAug 20, 1980 · N110RA · Destroyed NTSB MIA80FA092Accident · 2 fatalClosedCessna 337B · Osteen, FLAug 19, 1980 · N2313S · Destroyed NTSB CHI80FA064Accident · 1 fatalClosedSchweizer I-26E · Chardon, OHAug 19, 1980 · N2557H · Destroyed NTSB MIA80FA091Accident · 2 fatalClosedCessna 411A · Cape Coral, FLAug 18, 1980 · N1411M · Destroyed NTSB ATL80FLG18Accident · 1 fatalClosedHughes 269B · Whiteville, NCAug 18, 1980 · N9435F · Destroyed NTSB ATL80FKW19Accident · 1 fatalClosedErco 415-C · Nashville, TNAug 18, 1980 · N99446 · Destroyed NTSB DEN80FA054Accident · 1 fatalClosedPiper PA-24R · Jackson, WYAug 17, 1980 · N4560J · Substantial damage NTSB FTW80FA105Accident · 2 fatalClosedCessna 172M · Caddo, OKAug 16, 1980 · N12906 · Destroyed NTSB NYC80FA071Accident · 2 fatalClosedPiper PA-24 · Atlantic City, NJAug 15, 1980 · N8783P · Destroyed NTSB LAX80FA135Accident · 4 fatalClosedCessna T210 · Truckee, CAAug 15, 1980 · N6443B · Destroyed NTSB CHI80FEI36Accident · 1 fatalClosedDehavilland DHC-1B · Salem, OHAug 15, 1980 · N69WG · Destroyed NTSB NYC80FA070Accident · 1 fatalClosedPiper PA-30 · Cutchogue, NYAug 14, 1980 · N7094Y · Destroyed NTSB ANC80FA084Accident · 1 fatalClosedPiper PA-18 · Cordova, AKAug 13, 1980 · N2487H · Destroyed NTSB NYC80FA069Accident · 2 fatalClosedCessna 401B · Tewksbury, MAAug 12, 1980 · N2ST · Destroyed NTSB DEN80FTE69Accident · 1 fatalClosedPiper PA-25 · Mosca, COAug 12, 1980 · N6KL · Substantial damage NTSB SEA80FA043Accident · 2 fatalClosedPiper J4E · Mountain Home, IDAug 11, 1980 · N37989 · Destroyed NTSB SEA80FA042Accident · 2 fatalClosedCessna T207 · Salmon, IDAug 11, 1980 · N91115 · Destroyed NTSB NYC80FA068Accident · 3 fatalClosedCessna 172 · Burlington, CTAug 11, 1980 · N737AD · Destroyed NTSB FTW80FA103Accident · 1 fatalClosedPiper PA-28R · Lovington, NMAug 11, 1980 · N47988 · Destroyed NTSB MIA80FA090Accident · 2 fatalClosedPiper PA-31 · Dania, FLAug 10, 1980 · N27906 · Destroyed NTSB FTW80FA102Accident · 2 fatalClosedCessna 150H · Jonesboro, ARAug 10, 1980 · N6780S · Destroyed