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 CHI80FA012Accident · 3 fatalClosedCessna 210L · Fort Wayne, INNov 25, 1979 · N2034S · Destroyed NTSB CHI80FA010Accident · 1 fatalClosedCessna 150 · Wilmington, OHNov 25, 1979 · N8820S · Destroyed NTSB LAX80FA020Accident · 3 fatalClosedPiper PA-24 · Alturas, CANov 24, 1979 · N5664P · Destroyed NTSB LAX80FA017Accident · 3 fatalClosedCessna 182R · Napa, CANov 24, 1979 · N2681C · Destroyed NTSB ANC80FA015Accident · 1 fatalClosedBell 47G3B1 · Farewell, AKNov 24, 1979 · N73249 · Substantial damage NTSB SEA80FA008Accident · 2 fatalClosedNavion A · Kent, WANov 23, 1979 · N4804K · Destroyed NTSB MKC80FA009Accident · 1 fatalClosedMooney M-20J · Coffeyville, KSNov 23, 1979 · N201UP · Destroyed NTSB DEN80FTE09Accident · 1 fatalClosedWoody Push WAS-2 · Rocky Ford, CONov 23, 1979 · N8450 · Substantial damage NTSB LAX80FA019Accident · 4 fatalClosedCessna 172RG · Lassen Peak, CANov 22, 1979 · N4760R · Destroyed NTSB CHI80FEV07Accident · 1 fatalClosedAmerican AA-1B · Charleston, ILNov 22, 1979 · N6245L · Destroyed NTSB SEA80FA007Accident · 2 fatalClosedCessna T210M · Yakima, WANov 21, 1979 · N321TT · Substantial damage NTSB MKC80FA007Accident · 1 fatalClosedCessna 210 · Mountain View, MONov 21, 1979 · N732EH · Destroyed NTSB IAD80FLJ05Accident · 1 fatalClosedPiper PA-38 · Aventon, NCNov 21, 1979 · N9310T · Destroyed NTSB MKC80FA008Accident · 1 fatalClosedAmer Avco AA1-A · New Boston, MONov 20, 1979 · N9387L · Destroyed NTSB LAX80FA016Accident · 1 fatalClosedPiper PA-28 · Santa Barbara, CANov 20, 1979 · N9042K · Destroyed NTSB MIA80FA012Accident · 2 fatalClosedDouglas C-54D · Mccormick, SCNov 19, 1979 · N8060C · Destroyed NTSB MIA80DA020Accident · 1 fatalClosedBeech D50B · Missing AircraftNov 19, 1979 · N1706 · Destroyed NTSB FTW80FPM03Accident · 1 fatalClosedBenson B8M · Sand Springs, OKNov 19, 1979 · N6933 · Destroyed NTSB DEN80FA009Accident · 2 fatalClosedCessna 500 · Castle Rock, CONov 19, 1979 · N555AJ · Destroyed NTSB MIA80FA010Accident · 2 fatalClosedErco 415-C · Bishopville, SCNov 18, 1979 · N99484 · Destroyed NTSB FTW80DA015Accident · 1 fatalClosedCessna 210 · El Paso, TXNov 18, 1979 · N732ZR · Minor damage NTSB DCA80AA007Accident · 3 fatalClosedLockheed 188C · Salt Lake City, UTNov 18, 1979 · N859U · Destroyed NTSB NYC80FA011Accident · 3 fatalClosedCessna 337G · Bennington, VTNov 17, 1979 · N53560 · Destroyed NTSB FTW80FA014Accident · 2 fatalClosedCessna 152 · Lillian, TXNov 17, 1979 · N7611B · Destroyed NTSB NYC80FA010Accident · 3 fatalClosedAerostar 601P · Charlstadt, NJNov 16, 1979 · N8099J · Destroyed NTSB MKC80FA005Accident · 1 fatalClosedCessna 150D · Stet, MONov 16, 1979 · N7999Z · Destroyed NTSB MKC79FA006Accident · 1 fatalClosedPazmany PL-2 · Olathe, KSNov 16, 1979 · N72KA · Minor damage NTSB LAX80FA014Accident · 3 fatalClosedCessna 182Q · Livermore, CANov 16, 1979 · N97430 · Destroyed NTSB LAX80FA013Accident · 2 fatalClosedPiper PA-28 · Livermore, CANov 16, 1979 · N2962C · Destroyed NTSB DCA80AA021Accident · FatalClosedMartin 404 · Tusayan, AZNov 16, 1979 · N40438 · Destroyed NTSB ANC80FA012Accident · 1 fatalClosedPiper PA-20 · Palmer, AKNov 15, 1979 · N9710D · Substantial damage NTSB SEA80FA005Accident · 3 fatalClosedCessna T310R · Salem, ORNov 12, 1979 · N1316G · Destroyed NTSB UNK80X0102Accident · 1 fatalClosedPiper PA-28 · Melvin, IANov 11, 1979 · N2181D · Destroyed NTSB LAX80FUQ03Accident · 2 fatalClosedRand KR-2 · Mojave, CANov 11, 1979 · N56WP · Destroyed NTSB FTW80FA011Accident · 2 fatalClosedCessna 172M · Sugarland, TXNov 11, 1979 · N21479 · Destroyed NTSB LAX80FA012Accident · 2 fatalClosedPiper PA-28 · Phoenix, AZNov 10, 1979 · N6350W · Destroyed NTSB LAX80FVM06Accident · 1 fatalClosedBoeing A75N1 · Paicines, CANov 8, 1979 · N686W · Destroyed NTSB NYC80FAMS2Accident · 3 fatalClosedCessna 172 · Shadigee, NYNov 4, 1979 · N737TH · Destroyed NTSB LAX80DJA03Accident · 1 fatalClosedBeech C-45H · Pacific Ocean (Pacific Ocean)Nov 4, 1979 · N145DC · Destroyed NTSB LAX80FA010Accident · 1 fatalClosedMooney M20E · Mammoth Lakes, CANov 3, 1979 · N1942Y · Substantial damage NTSB FTW80FPJ03Accident · 2 fatalClosedMustang II · Nedmond, OKNov 3, 1979 · N9056U · Destroyed NTSB MIA80FA008Accident · 5 fatalClosedPiper PA-31 · Greenville, SCNov 2, 1979 · N66893 · Destroyed NTSB IAD80AA008Accident · 3 fatalClosedCessna P337H · Benson, NCNov 2, 1979 · N5KN · Destroyed NTSB IAD80FA007Accident · 5 fatalClosedMitsubishi MU-2F · Nashville, TNNov 1, 1979 · N873Q · Destroyed NTSB NYC80FA008Accident · 1 fatalClosedCessna 152 · New Bedford, MAOct 31, 1979 · N757ZW · Destroyed NTSB LAX80FA009Accident · 4 fatalClosedCessna T337C · Hesperia, CAOct 31, 1979 · N2555S · Destroyed NTSB DCA80RA003Accident · 72 fatalClosedDouglas DC-10 · Mexico City, MexicoOct 31, 1979 · N903WA · Destroyed NTSB DEN80FA008Accident · 2 fatalClosedCessna 310 · Tucumcari, NMOct 30, 1979 · N1758H · Destroyed NTSB ANC80FA008Accident · 2 fatalClosedDouglas DC-3 · Bettles, AKOct 30, 1979 · N99663 · Substantial damage NTSB DEN80FA007Accident · 1 fatalClosedCessna 182P · Farmington, NMOct 29, 1979 · N1987M · Destroyed