Skip to content

NTSB investigations, ID

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA' 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.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
  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."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA'
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 SEA80DYA18Accident · Minor injuriesClosedCessna 172 · Donnelly, IDJul 6, 1980 · N6388E · Substantial damage NTSB SEA80DYA17Accident · Minor injuriesClosedCessna 182 · Mccall, IDJun 28, 1980 · N71856 · Destroyed NTSB SEA80DYP25Accident · Minor injuriesClosedCessna R172K · Mullen, IDJun 26, 1980 · N758KG · Destroyed NTSB SEA80FA035Accident · 3 fatalClosedPiper PA-28 · Couer D'Alene, IDJun 22, 1980 · N2204F · Destroyed NTSB SEA80DYA16Accident · Minor injuriesClosedCessna T188C · Fairfield, IDJun 19, 1980 · N2903J · Substantial damage NTSB SEA80FYA15Accident · Minor injuriesClosedBell 206A · Boise, IDJun 7, 1980 · N7068J · Substantial damage NTSB SEA80FYA14Accident · No injuriesClosedPiper PA-25 · Burley, IDJun 5, 1980 · N6486Z · Substantial damage NTSB SEA80DYA13Accident · Minor injuriesClosedCessna T188C · American Falls, IDMay 22, 1980 · N91964 · Substantial damage NTSB SEA80FA025Accident · 3 fatalClosedDouglas DC-3C · Athol, IDApr 11, 1980 · N64490 · Destroyed NTSB SEA80FA024Accident · 1 fatalClosedCessna T210L · Pocatello, IDApr 6, 1980 · N260DW · Destroyed NTSB SEA80DYP16Accident · Minor injuriesClosedCessna 172 · Orofino, IDMar 31, 1980 · C-GMEJ · Substantial damage NTSB SEA80FYA11Accident · Serious injuriesClosedCassutt 3M · Boise, IDMar 16, 1980 · N11XR · Destroyed NTSB SEA80DYA10Accident · No injuriesClosedCessna 185D · Challis, IDMar 8, 1980 · N5895T · Substantial damage NTSB SEA80DYA09Accident · No injuriesClosedCessna 152 · Blackfoot, IDMar 1, 1980 · N24755 · Substantial damage NTSB SEA80DYA08Accident · No injuriesClosedCessna 170B · Mccall, IDFeb 12, 1980 · N2713D · Substantial damage NTSB SEA80DYP12Accident · No injuriesClosedPiper PA-38 · Sandpoint, IDJan 31, 1980 · N24563 · Substantial damage NTSB SEA80FYA06Accident · Serious injuriesClosedCessna 210E · Burley, IDJan 23, 1980 · N2352F · Substantial damage NTSB SEA80FA016Accident · 4 fatalClosedCessna 182Q · Murphy, IDJan 17, 1980 · N94839 · Destroyed NTSB SEA80DYA05Accident · No injuriesClosedMooney M20E · Burley, IDDec 21, 1979 · N1306W · Substantial damage NTSB SEA80DYA04Accident · No injuriesClosedAerosport Quail · Idaho Falls, IDDec 18, 1979 · N47075 · Substantial damage NTSB SEA80FYP06Accident · Serious injuriesClosedCessna 305A · Sandpoint, IDDec 9, 1979 · N5264G · Substantial damage NTSB SEA80FA014Accident · 2 fatalClosedCessna 182 · Idaho Falls, IDDec 9, 1979 · N470PP · Destroyed NTSB SEA80FA012Accident · 2 fatalClosedAeronca 65-CA · Mountain Home, IDDec 8, 1979 · N31929 · Substantial damage NTSB SEA80FA011Accident · 2 fatalClosedBeech V35A · Sublett, IDDec 7, 1979 · N7950R · Destroyed NTSB SEA80FA010Accident · 1 fatalClosedCessna 210 · Malad City, IDDec 7, 1979 · N9524T · Destroyed NTSB SEA80DYA03Accident · No injuriesClosedHiller Acft UH-12E · Stanley, IDNov 26, 1979 · N571H · Substantial damage NTSB SEA80FYM05Accident · Minor injuriesClosedCessna R172E · Grass Valley, IDNov 14, 1979 · N14465 · Destroyed NTSB SEA80DYP04Accident · No injuriesClosedCessna 182 · Dixie, IDNov 11, 1979 · N8971G · Substantial damage NTSB SEA80DYA02Accident · No injuriesClosedAmer Avco AA1-C · Rexburg, IDOct 17, 1979 · N9526U · Substantial damage NTSB SEA80FA003Accident · 1 fatalClosedCessna 182L · Macks Inn, IDOct 15, 1979 · N42641 · Destroyed NTSB SEA80FA002Accident · 2 fatalClosedAerospatial SA315B · Swan Valley, IDOct 8, 1979 · N219RM · Destroyed NTSB SEA80FYP01Accident · No injuriesClosedCessna 182C · Lewiston, IDOct 2, 1979 · N8489T · No damage NTSB SEA79FA061Accident · 2 fatalClosedBellanca 7KCAB · Athol, IDSep 30, 1979 · N8884 · Destroyed NTSB SEA79FYP44Accident · Serious injuriesClosedBellanca 7GCAA · Clearwater, IDSep 29, 1979 · N5186T · Destroyed NTSB SEA79DYA32Accident · No injuriesClosedCessna 180K · Mountain Home, IDSep 23, 1979 · N63595 · Substantial damage NTSB SEA79DYA31Accident · No injuriesClosedCessna 182 · Bancroft, IDSep 19, 1979 · N1909M · Substantial damage NTSB SEA79DYA28Accident · No injuriesClosedCessna 150 · Prairie, IDSep 3, 1979 · N704BL · Substantial damage NTSB SEA79DYA30Accident · Serious injuriesClosedCallair A-9 · Grandview, IDSep 2, 1979 · N7223V · Destroyed NTSB SEA79DYA29Accident · No injuriesClosedCessna 152 · Burley, IDSep 1, 1979 · N757FG · Substantial damage NTSB SEA79DYA26Accident · No injuriesClosedCessna R172K · Rexburg, IDAug 30, 1979 · N58BD · Substantial damage NTSB SEA79DYA24Accident · No injuriesClosedCessna T210 · Forney, IDAug 18, 1979 · N73HK · Substantial damage NTSB SEA79FYP41Accident · No injuriesClosedBeech 95-B55 · Sandpoint, IDAug 15, 1979 · N6220V · Substantial damage NTSB SEA79DYA27Accident · No injuriesClosedAir Tractor AT-301 · Newdale, IDAug 10, 1979 · N8791S · Substantial damage NTSB SEA79FA049Accident · 6 fatalClosedCessna T210M · Pistol Creek, IDAug 4, 1979 · N6286B · Destroyed NTSB SEA79FYA22Accident · 1 fatalClosedCallair A-9 · Mt.Home, IDAug 1, 1979 · N7205V · Destroyed NTSB SEA79FYA21Accident · Minor injuriesClosedCallair A-9 · Hammett, IDJul 24, 1979 · N8286H · Destroyed NTSB SEA79DYP36Accident · No injuriesClosedCessna 185 · Slate Creek, IDJul 16, 1979 · N9899X · Substantial damage NTSB SEA79FA046Accident · 1 fatalClosedPiper PA-38 · Bellevue, IDJul 14, 1979 · N9320T · Destroyed NTSB SEA79FA044Accident · Serious injuriesClosedCessna 182G · Challis, IDJul 10, 1979 · N3158Y · Destroyed NTSB SEA79DYP32Accident · Serious injuriesClosedGrumman G-164A · Lewiston, IDJul 3, 1979 · N25SK · Substantial damage