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 SEA81FYA21Accident · No injuriesClosedPiper PA-25 · Middleton, IDAug 6, 1981 · N4573Y · Destroyed NTSB SEA81DYP32Accident · Minor injuriesClosedPiper PA-28 · Warren, IDJul 23, 1981 · N2103U · Destroyed NTSB SEA81DYA19Accident · No injuriesClosedCessna 180J · Yellow Pine, IDJul 20, 1981 · N9921N · Substantial damage NTSB SEA81FYP29Accident · No injuriesClosedCessna 177 · Priest River, IDJul 19, 1981 · N2213Y · Substantial damage NTSB SEA81FA047Incident · No injuriesClosedPiper PA-34 · Boise, IDJul 17, 1981 · N40036 · Minor damage NTSB SEA81DYA20Accident · No injuriesClosedCessna 180A · Challis, IDJul 17, 1981 · N9748B · Substantial damage NTSB SEA81DYA16Accident · No injuriesClosedPiper PA-18A · Firth, IDJul 10, 1981 · N7160D · Substantial damage NTSB SEA81DYA15Accident · No injuriesClosedPiper PA-25 · Shelley, IDJul 10, 1981 · N8553L · Substantial damage NTSB SEA81IA045Incident · No injuriesClosedPiper PA-31 · Hailey, IDJun 30, 1981 · N3516A · Minor damage NTSB SEA81FA044Accident · 3 fatalClosedCessna 182Q · Burley, IDJun 26, 1981 · N759NP · Destroyed NTSB SEA81DYA13Accident · No injuriesClosedCessna 188A · Richfield, IDJun 24, 1981 · N8134G · Substantial damage NTSB SEA81FA042Accident · 3 fatalClosedPiper PA-28 · Bliss, IDJun 21, 1981 · N2214X · 2 aircraft · Destroyed NTSB SEA81DYA14Accident · No injuriesClosedPiper PA-32R · Stanley, IDJun 20, 1981 · N3402Q · Substantial damage NTSB SEA81DYA12Accident · Serious injuriesClosedPiper PA-25 · Rockford, IDJun 11, 1981 · N7312Z · Substantial damage NTSB SEA81DYA11Accident · No injuriesClosedGrumman G-164 · Monteview, IDJun 10, 1981 · N730Y · Substantial damage NTSB SEA81FA039Accident · 1 fatalClosedMaule M5235C · Dixie, IDMay 31, 1981 · N5637H · Destroyed NTSB SEA81DYP20Accident · No injuriesClosedPiper PA-28 · Lucille, IDMay 28, 1981 · N38421 · Substantial damage NTSB SEA81FA038Accident · 3 fatalClosedPiper PA-28 · Malad City, IDMay 25, 1981 · N2816F · Destroyed NTSB SEA81FYP18Accident · 1 fatalClosedGrumman G-164B · Harrison, IDMay 23, 1981 · N48574 · Substantial damage NTSB SEA81DYA09Accident · No injuriesClosedCessna 188 · Idaho Falls, IDMay 5, 1981 · N4729Q · Substantial damage NTSB SEA81FYP08Accident · No injuriesClosedCessna 172G · Lewiston, IDMar 3, 1981 · N4612L · Substantial damage NTSB SEA81FYA07Accident · 1 fatalClosedPitts S-1S · Boise, IDJan 10, 1981 · N43BW · Destroyed NTSB SEA81DYA08Accident · No injuriesClosedBellanca 7GCBC · Hailey, IDJan 8, 1981 · N4133Y · Substantial damage NTSB SEA81FA014Accident · 4 fatalClosedBeech V35A · Rexburg, IDJan 2, 1981 · N861S · Destroyed NTSB SEA81FA011Accident · 2 fatalClosedPiper PA-12 · Rexburg, IDDec 12, 1980 · N78709 · Destroyed NTSB SEA81FYA06Accident · Serious injuriesClosedCessna 150F · Caldwell, IDNov 29, 1980 · N3576L · Destroyed NTSB SEA81FA008Accident · 6 fatalClosedBeech A60 · Driggs, IDNov 27, 1980 · N17JC · Destroyed NTSB SEA81FA006Accident · No injuriesClosedPiper PA32RT · Oakley, IDNov 20, 1980 · N21842 · Substantial damage NTSB SEA81FA005Accident · 2 fatalClosedCessna U206F · Bonners Ferry, IDNov 18, 1980 · N333MH · Destroyed NTSB SEA81DYA05Accident · No injuriesClosedCessna 182P · Blackfoot, IDNov 14, 1980 · N58818 · Destroyed NTSB SEA81FYA04Accident · Serious injuriesClosedCessna 182A · Blackfoot, IDNov 1, 1980 · N4952D · Destroyed NTSB SEA81DYA03Accident · No injuriesClosedBellanca 7KCAB · Council, IDOct 28, 1980 · N41811 · Substantial damage NTSB SEA81FA003Accident · 1 fatalClosedCessna 172 · Craigmont, IDOct 26, 1980 · N9109B · Destroyed NTSB SEA81FYP03Accident · Minor injuriesClosedCessna TU206G · Salmon, IDOct 18, 1980 · N345SS · Substantial damage NTSB SEA81DYA02Accident · No injuriesClosedPiper PA-28 · Blackfoot, IDOct 6, 1980 · N15442 · Substantial damage NTSB SEA81IA001Incident · No injuriesClosedPiper PA-28 · Elk City, IDOct 5, 1980 · N21170 · Minor damage NTSB SEA81DYA01Accident · No injuriesClosedCessna 182 · Picabo, IDOct 3, 1980 · N6797M · Substantial damage NTSB SEA80FYA25Accident · Serious injuriesClosedBreezy RLU-1F · Jerome, IDSep 14, 1980 · N1PY · Destroyed NTSB SEA80FYP37Accident · Serious injuriesClosedGrum-Amer AA-1B · Coeur D'Alene, IDSep 4, 1980 · N1367R · Substantial damage NTSB SEA80DYA23Accident · No injuriesClosedBeech C24R · Soda Springs, IDAug 29, 1980 · N6021P · Substantial damage NTSB SEA80DYP35Accident · No injuriesClosedCessna 180 · Coeur D'Alene, IDAug 24, 1980 · N2487C · Substantial damage NTSB SEA80DYP32Accident · No injuriesClosedAeronca 7FC · Grangeville, IDAug 15, 1980 · N7547E · 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 SEA80DYA21Accident · No injuriesClosedCessna 150 · Horseshoe Bend, IDAug 9, 1980 · N11617 · Substantial damage NTSB SEA80FA039Accident · 1 fatalClosedAero Comdr 500B · Salmon, IDAug 5, 1980 · N184Z · Destroyed NTSB SEA80DYA24Accident · No injuriesClosedPiper J3C-65 · Blackfoot, IDAug 2, 1980 · N98484 · Substantial damage NTSB SEA80DYP31Accident · No injuriesClosedCessna 182 · Elk City, IDAug 1, 1980 · N8466M · Substantial damage NTSB SEA80DYA20Accident · No injuriesClosedWeatherly 201B · Mountain Home, IDJul 26, 1980 · N1293W · Substantial damage NTSB SEA80FYA19Accident · 1 fatalClosedCallair A-9 · Homedale, IDJul 6, 1980 · N8270H · Destroyed