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 CHI79DA033Accident · 1 fatalClosedCessna 150M · Adrian, MIMar 15, 1979 · N9280U · Destroyed NTSB OAK79FVA21Accident · 1 fatalClosedPiper PA-36 · Los Banos, CAMar 14, 1979 · N9946P · Destroyed NTSB LAX79IA033Incident · 1 fatalClosedCessna T210L · Lancaster, CAMar 14, 1979 · N123DH · No damage NTSB FTW79IA063Incident · 1 fatalClosedBoeing 747 · Dallas, TXMar 14, 1979 · N601BN · No damage NTSB FTW79FA066Accident · 1 fatalClosedCessna 182Q · Granite, OKMar 14, 1979 · N735JH · Destroyed NTSB FTW79FA062Accident · 1 fatalClosedCessna R172K · Uvalde, TXMar 14, 1979 · N736TN · Destroyed NTSB CHI79FA031Accident · 3 fatalClosedAerostar 601P · Columbus, OHMar 14, 1979 · N8061J · Destroyed NTSB FTW79FPA12Accident · 1 fatalClosedThorp TA-18 · Allen, TXMar 11, 1979 · N199S · Destroyed NTSB FTW79DA061Accident · 2 fatalClosedBeech 65-A80 · New Orleans, LAMar 11, 1979 · N10QH · Substantial damage NTSB NYC79FA029Accident · 4 fatalClosedPiper PA-31 · Springfield, VTMar 10, 1979 · N27530 · Substantial damage NTSB FTW79FA060Accident · 4 fatalClosedCessna 172N · Dequincy, LAMar 10, 1979 · N737XR · Destroyed NTSB DCA79AA012Accident · 3 fatalClosedNord-Avion 262 · Marina Del Rey, CAMar 10, 1979 · N418SA · Destroyed NTSB SEA79FA024Accident · 1 fatalClosedCessna 195 · Vancouver, WAMar 9, 1979 · N195BC · Destroyed NTSB OAK79FAMS4Accident · 1 fatalClosedPiper PA-28 · Missing AircraftMar 9, 1979 · N8875J · Destroyed NTSB MIA79FLD48Accident · 1 fatalClosedPiper PA-32 · Vero Beach, FLMar 9, 1979 · N2114C · Destroyed NTSB FTW79FA059Accident · 2 fatalClosedHughes 369D · Angleton, TXMar 9, 1979 · N58333 · Destroyed NTSB DEN79FA029Accident · 2 fatalClosedPiper PA-24 · Corinne, UTMar 8, 1979 · N6914P · Destroyed NTSB SEA79FA023Accident · 3 fatalClosedLake 4-200 · Battle Ground, WAMar 7, 1979 · N1229L · Destroyed NTSB LAX80FA051Accident · 3 fatalClosedCessna 172 · Eureka, CAMar 7, 1979 · N6788A · Destroyed NTSB IAD79FA038Accident · 1 fatalClosedBellanca 8KCAB · Queenstown, MDMar 7, 1979 · N31278 · Destroyed NTSB FTW79FRG21Accident · 2 fatalClosedVarieze 1 · Austin, TXMar 7, 1979 · N95DB · Destroyed NTSB NYC79FA028Accident · 4 fatalClosedPiper PA-28R · Palmerton, PAMar 4, 1979 · N5964V · Destroyed NTSB NYC79FA027Accident · 1 fatalClosedPiper PA-28 · Newark, NJMar 4, 1979 · N6630J · Destroyed NTSB DEN79AA028Accident · 4 fatalClosedRockwell 114 · Fairfield, UTMar 4, 1979 · N4804W · Destroyed NTSB OAK79AA020Accident · 4 fatalClosedBeech 95 · Elko, NVMar 3, 1979 · N644SE · Destroyed NTSB NYC79FA026Accident · 2 fatalClosedCessna 172 · Poland, MEMar 3, 1979 · N738HR · Substantial damage NTSB IAD79FA037Accident · 2 fatalClosedBeech K35 · Charlottesvlle, VAMar 3, 1979 · C-FLUT · Destroyed NTSB LAX79FVA18Accident · 1 fatalClosedBell OH13H · Shafter, CAMar 2, 1979 · N9001T · Destroyed NTSB FTW79FA058Accident · 6 fatalClosedBeech BE-58P · Turpin, OKMar 2, 1979 · N6050S · Destroyed NTSB DEN79FA027Accident · 2 fatalClosedCessna 210 · Limon, COMar 2, 1979 · N761MV · Destroyed NTSB CHI79FA030Accident · 4 fatalClosedCessna 310B · Galesburg, ILMar 2, 1979 · N5384A · Destroyed NTSB SEA79FA022Accident · 2 fatalClosedCessna 140 · Yakima, WAMar 1, 1979 · N1701N · Destroyed NTSB SEA79DYE15Accident · 1 fatalClosedRobertson P210N · Port Townsend, WAMar 1, 1979 · N4797P · Destroyed NTSB DCA79AA011Accident · 8 fatalClosedBeech BE-70 · Gulfport, MSMar 1, 1979 · N777AE · Destroyed NTSB SEA79FA021Accident · 1 fatalClosedCessna T210P · Lavina, MTFeb 28, 1979 · N6995N · Destroyed NTSB MIA79FA055Accident · 1 fatalClosedCessna 150 · Albany, GAFeb 27, 1979 · N11306 · Destroyed NTSB IAD79FA036Accident · 1 fatalClosedCessna 310 · Bristol, VAFeb 27, 1979 · N5927M · Destroyed NTSB FTW79FA056Accident · 1 fatalClosedCessna 182P · Weston, TXFeb 27, 1979 · N9897E · Destroyed NTSB MKC79FA019Accident · 1 fatalClosedCessna 172M · Fort Scott, KSFeb 26, 1979 · N1539V · Substantial damage NTSB MIA79FA054Accident · 3 fatalClosedBeech 58 · Greenville, MSFeb 26, 1979 · N2055K · 2 aircraft · Destroyed NTSB DEN79FA024Accident · 2 fatalClosedCessna T206 · Brigham City, UTFeb 26, 1979 · N868BJ · Destroyed NTSB MIA79FLD42Accident · 1 fatalClosedCessna 172B · Orlando, FLFeb 25, 1979 · N7850X · No damage NTSB MIA79FA053Accident · 2 fatalClosedPiper PA-23 · St Petersburg, FLFeb 25, 1979 · N5861Y · Destroyed NTSB DEN79FA023Accident · 4 fatalClosedCessna 206 · Moose, WYFeb 24, 1979 · N114CK · Destroyed NTSB NYC79FA024Accident · 2 fatalClosedCessna 172K · Dover Plains, NYFeb 23, 1979 · N736FW · Destroyed NTSB IAD79FA035Accident · 4 fatalClosedPiper PA-32R · Glenville, KYFeb 23, 1979 · N2754Q · Destroyed NTSB IAD79FA033Accident · 3 fatalClosedPiper PA-31T · Baltimore, MDFeb 23, 1979 · N6123A · Destroyed NTSB FTW79FA052Accident · 1 fatalClosedCessna 210G · Jennings, LAFeb 23, 1979 · N687ST · Destroyed NTSB MKC79FA017Accident · 3 fatalClosedCessna 421A · Kansas City, MOFeb 22, 1979 · N77PM · Destroyed NTSB LAX79FA032Accident · 2 fatalClosedCessna T310R · Long Beach, CAFeb 22, 1979 · N78347 · Destroyed