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 CHI80FA063Accident · 2 fatalClosedCessna 172 · Bois Blanc Is, MIAug 10, 1980 · N739PP · Destroyed NTSB ATL80FA084Accident · 2 fatalClosedBellanca 7KCAB · Lake Norman, NCAug 10, 1980 · N1644G · Destroyed NTSB SEA80FA040Accident · 4 fatalClosedAerofab LA-4-2 · Cascade Locks, ORAug 9, 1980 · N65640 · Destroyed NTSB MKC80FA048Accident · 3 fatalClosedPiper PA-28R · Carroll, IAAug 9, 1980 · N47741 · Destroyed NTSB ATL80FA083Accident · 1 fatalClosedCessna 150 · Henderson, KYAug 9, 1980 · N7265X · Destroyed NTSB LAX80FA131Accident · 1 fatalClosedCessna T210N · Malibu, CAAug 8, 1980 · N139BB · Destroyed NTSB LAX80FA130Accident · 2 fatalClosedMooney M20C · Elk, CAAug 8, 1980 · N6624U · Destroyed NTSB CHI80FA062Accident · 1 fatalClosedCessna 150 · Mishawaka, INAug 8, 1980 · N3118J · Destroyed NTSB FTW80FQG36Accident · 1 fatalClosedPiper PA-25 · Midkiff, TXAug 7, 1980 · N7284Z · Destroyed NTSB ATL80FA082Accident · 1 fatalClosedCessna 150 · Oswego, SCAug 7, 1980 · N7008G · Destroyed NTSB LAX80FVM37Accident · 1 fatalClosedTexas Hel OH-13H · Salinas, CAAug 6, 1980 · N10003 · Substantial damage NTSB FTW80FA100Accident · 13 fatalClosedBell 205A-1 · Houma, LAAug 6, 1980 · N95AL · Destroyed NTSB FTW80FA099Accident · 2 fatalClosedCessna 172M · Bridgeport, TXAug 6, 1980 · N9855Q · 2 aircraft · Destroyed NTSB SEA80FA039Accident · 1 fatalClosedAero Comdr 500B · Salmon, IDAug 5, 1980 · N184Z · Destroyed NTSB CHI80FEE41Accident · 1 fatalClosedMurphy RV-3 · Streator, ILAug 5, 1980 · N66CJ · Destroyed NTSB ATL80FA081Accident · 1 fatalClosedPiper PA-38 · Charlottesvle, VAAug 4, 1980 · N2484D · Substantial damage NTSB ANC80FA081Accident · 2 fatalClosedDehavnd Can DHC-3 · Togiak, AKAug 3, 1980 · N433GR · Destroyed NTSB NYC80FA064Accident · 1 fatalClosedCessna 305A · Farmingdale, NYAug 2, 1980 · N5174G · Substantial damage NTSB FTW80FQG35Accident · 1 fatalClosedPiper PA-25 · Dumas, TXAug 2, 1980 · N8561L · Destroyed NTSB CHI80FEP46Accident · 1 fatalClosedSkyhopper 20 · Oshkosh, WIAug 2, 1980 · N45802 · Substantial damage NTSB DEN80FA052Accident · 2 fatalClosedAerospatial SA315 · Meeteetse, WYAug 1, 1980 · N47294 · Destroyed NTSB CHI80FEP45Accident · 2 fatalClosedVari-Eze 01 · Oshkosh, WIAug 1, 1980 · N7EJ · Destroyed NTSB CHI80DA061Accident · 1 fatalClosedAeronca C-3 · Luray, INAug 1, 1980 · N16291 · Substantial damage NTSB LAX80DA133Accident · 1 fatalClosedBeech 35 · Shelter Cove, CAJul 31, 1980 · N119B · Destroyed NTSB ANC80FA079Accident · 4 fatalClosedCessna A185F · Kodiak, AKJul 31, 1980 · N80330 · Destroyed NTSB MIA80FA086Accident · 2 fatalClosedCessna 404 · Ft White, FLJul 30, 1980 · N37097 · Destroyed NTSB CHI80FEC26Accident · 1 fatalClosedBell 47D1 · Munith, MIJul 30, 1980 · N3656F · Substantial damage NTSB MKC80FCQ25Accident · 1 fatalClosedPiper PA-25 · Garden City, KSJul 29, 1980 · N8759L · Destroyed NTSB FTW80FA097Accident · 1 fatalClosedCessna 182Q · Vidalia, LAJul 28, 1980 · N759SS · Destroyed NTSB DEN80FA051Accident · 1 fatalClosedAerospatle 315B · Dell, MTJul 28, 1980 · N67103 · Substantial damage NTSB LAX80FA127Accident · 4 fatalClosedBeech 95 · Rubidoux, CAJul 27, 1980 · N688Q · Substantial damage NTSB SEA80DYE47Accident · 2 fatalClosedCoot B · Kelso, WAJul 26, 1980 · N7141 · Destroyed NTSB CHI80FER60Accident · 1 fatalClosedCassutt · Winona, MNJul 26, 1980 · N89MC · Destroyed NTSB CHI80FA060Accident · 1 fatalClosedPiper PA-28 · Lake City, MIJul 26, 1980 · N15336 · Destroyed NTSB ATL80FA078Accident · 3 fatalClosedPiper PA-28 · Pikeville, KYJul 26, 1980 · N8357W · Destroyed NTSB LAX80FA126Accident · 1 fatalClosedCessna 310 · Tracy, CAJul 25, 1980 · N4832B · Destroyed NTSB FTW80FA096Accident · 2 fatalClosedAero Comdr 680FLP · Iola, TXJul 25, 1980 · N6515V · Destroyed NTSB DCA80AA022Accident · 3 fatalClosedPiper PA-31 · Philadelphia, PAJul 25, 1980 · N5MS · Destroyed NTSB NYC80FA061Accident · 1 fatalClosedSchweizer SGS126 · Wurtsboro, NYJul 24, 1980 · N17905 · Destroyed NTSB CHI80FA059Accident · 2 fatalClosedCessna T310 · Cahokia, ILJul 24, 1980 · N1231G · Destroyed NTSB ATL80FA077Accident · 1 fatalClosedBellanca 8GCBC · Banks, MSJul 24, 1980 · N8652V · Destroyed NTSB LAX80FA125Accident · 2 fatalClosedSkybolt 01 · Rialto, CAJul 23, 1980 · N37631 · 2 aircraft · Destroyed NTSB MKC80FA047Accident · 1 fatalClosedPitts S1 · Centerville, IAJul 22, 1980 · N1012S · Destroyed NTSB LAX80DJA21Accident · 1 fatalClosedCessna T188C · Hawaiian Islands, HIJul 22, 1980 · N3887J · Destroyed NTSB CHI80FET21Accident · 1 fatalClosedFaulkner MS-1 · Ft Wayne, INJul 20, 1980 · N23AS · Destroyed NTSB CHI80FA058Accident · 2 fatalClosedPiper J-3 · Flushing, MIJul 20, 1980 · N42726 · Destroyed NTSB MKC80FCA22Accident · 1 fatalClosedBensen B8M · Montgomery Cy, MOJul 19, 1980 · N9981 · Substantial damage NTSB LAX80FA124Accident · 1 fatalClosedCessna 150H · Fullerton, CAJul 19, 1980 · N7216S · Destroyed NTSB LAX80FA123Accident · 1 fatalClosedGrum Amer AA-1B · Lake Hughes, CAJul 19, 1980 · N7173L · Destroyed NTSB DEN80FA049Accident · 3 fatalClosedBellanca 17 · Sterling, COJul 19, 1980 · N4066B · Destroyed