Skip to content

NTSB investigations, ID

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 SEA66F0091Accident · Serious injuriesClosedPiper PA28 · Blackfoot, IDAug 10, 1965 · N5267W · Destroyed NTSB SEA66F0072Accident · No injuriesClosedPiper PA-22 · Nampa, IDAug 8, 1965 · N6753B · Substantial damage NTSB SEA66F0069Accident · No injuriesClosedBeechcraft S-35 · Hailey, IDAug 5, 1965 · N8922U · Substantial damage NTSB SEA66F0068Accident · Minor injuriesClosedBeechcraft J-35 · Pocatello, IDAug 4, 1965 · N8332D · Substantial damage NTSB SEA66D0059Accident · No injuriesClosedPiper PA-28 · Soda Springs, IDJul 21, 1965 · N8108W · Substantial damage NTSB SEA66A0005Accident · 1 fatalClosedBeech 35 · 4w Malta, IDJul 19, 1965 · N8710A · Destroyed NTSB SEA66F0049Accident · No injuriesClosedPiper PA-24 · Boise, IDJul 16, 1965 · N5811P · Substantial damage NTSB SEA66F0022Accident · No injuriesClosedPiper PA-18A · Idaho Falls, IDJul 13, 1965 · N7172D · Destroyed NTSB SEA66F0020Accident · Minor injuriesClosedPiper PA-18A · Burley, IDJul 13, 1965 · N4874A · Destroyed NTSB SEA66D0043Accident · No injuriesClosedCessna 206 · Sellway, IDJul 11, 1965 · N5229U · Substantial damage NTSB SEA66D0027Accident · No injuriesClosedCessna 180 · Burley, IDJul 10, 1965 · N2787X · Substantial damage NTSB SEA66F0048Accident · Minor injuriesClosedBoeing A75 · Homedale, IDJul 9, 1965 · N4812V · Substantial damage NTSB SEA66F0019Accident · No injuriesClosedPiper PA-18A · Rockford, IDJul 9, 1965 · N7160D · Substantial damage NTSB SEA66A0003Accident · 2 fatalClosedBeech C-45H · Salmon, IDJul 9, 1965 · N9327Z · Destroyed NTSB SEA66F0096Accident · No injuriesClosedPiper PA-18A · Copeland, IDJun 24, 1965 · N1987P · Substantial damage NTSB SEA66D0017Accident · No injuriesClosedCessna 180 · Cascade, IDJun 20, 1965 · N1693C · Destroyed NTSB SEA66F0057Accident · No injuriesClosedFairchild M62C · Homedale, IDJun 18, 1965 · N56110 · Substantial damage NTSB SEA66F0067Accident · No injuriesClosedPiper PA-18A · Paul, IDJun 7, 1965 · N7284D · Destroyed NTSB SEA65F0072Accident · No injuriesClosedCessna 182 · Boise, IDJun 7, 1965 · N1951X · Substantial damage NTSB SEA65F0067Accident · No injuriesClosedBoeing B75N1 · Reubens, IDJun 3, 1965 · N68441 · Substantial damage NTSB SEA66F0047Accident · No injuriesClosedBeechcraft 35 · Caldwell, IDJun 2, 1965 · N3166V · Substantial damage NTSB SEA65F0061Accident · Serious injuriesClosedCessna 172 · Lewiston, IDMay 22, 1965 · N7404X · Substantial damage NTSB SEA65F0069Accident · No injuriesClosedBeechcraft 35 · Blackfoot, IDMay 13, 1965 · N476B · Substantial damage NTSB SEA65D0052Accident · No injuriesClosedCessna 182A · Weiser, IDMay 11, 1965 · N2381G · Substantial damage NTSB SEA65F0041Accident · No injuriesClosedNo American SNJ-5 · Caldwell, IDApr 22, 1965 · N9822C · Destroyed NTSB SEA65F0045Accident · Serious injuriesClosedPiper J-3 · Meadows, IDApr 7, 1965 · N69081 · Substantial damage NTSB SEA65F0023Accident · No injuriesClosedBeech K35 · Boise, IDApr 2, 1965 · N6034E · Substantial damage NTSB SEA65D0034Accident · No injuriesClosedMooney M18C · Idaho Falls, IDMar 20, 1965 · N4073 · Destroyed NTSB SEA65D0040Accident · No injuriesClosedCessna 310 · Soda Springs, IDMar 16, 1965 · N82W · Substantial damage NTSB SEA65F0018Accident · No injuriesClosedCallair A-9 · Genesee, IDMar 9, 1965 · N8268H · Substantial damage NTSB SEA65D0017Accident · 1 fatalClosedCessna 170B · Glenns Ferry, IDMar 8, 1965 · N1957C · Destroyed NTSB SEA65F0056Accident · No injuriesClosedCessna 182 · Twin Falls, IDMar 2, 1965 · N8761X · Substantial damage NTSB SEA65D0024Accident · No injuriesClosedPiper PA-18A · Bancroft, IDFeb 24, 1965 · N7676D · Substantial damage NTSB SEA65D0011Accident · No injuriesClosedPiper PA24 · Challis, IDFeb 2, 1965 · N9003T · Substantial damage NTSB UNK65X1205Accident · No injuriesClosedBrantly B2 · Peck, IDDec 31, 1964 · N5917X · Substantial damage NTSB UNK65X1161Accident · Serious injuriesClosedCessna 172 · Swan Valley, IDDec 27, 1964 · N7026A · Destroyed NTSB UNK65X0900Accident · No injuriesClosedBeechcraft B33 · Arco, IDDec 2, 1964 · N8631M · Substantial damage NTSB UNK65X0634Accident · No injuriesClosedPiper PA18 · Valley County, IDNov 9, 1964 · N2267A · Substantial damage NTSB UNK65X0621Accident · Minor injuriesClosedSchweizer 126A · Cedar Falls, IDNov 8, 1964 · N2714Z · Substantial damage NTSB UNK65X0434Accident · No injuriesClosedPiper PA23 · Payette, IDOct 25, 1964 · N4075P · Substantial damage NTSB UNK65X0362Accident · No injuriesClosedMooney M20E · Idaho Falls, IDOct 21, 1964 · N1984Y · Substantial damage NTSB UNK65X0298Accident · 1 fatalClosedCessna 185A · Fish Lake, IDOct 16, 1964 · N1687Z · Destroyed NTSB UNK65X0189Accident · No injuriesClosedCessna 180 · Gooding, IDOct 8, 1964 · N2864A · Substantial damage NTSB UNK64X4189Accident · Serious injuriesClosedSchweizer 126A · Hollister, IDSep 27, 1964 · N27082 · Destroyed NTSB UNK64X4184Accident · No injuriesClosedCessna 180 · Boise, IDSep 27, 1964 · N1698C · Destroyed NTSB UNK64X4182Accident · No injuriesClosedPiper PA18 · Salmon River, IDSep 27, 1964 · N7533K · Substantial damage NTSB UNK64X4134Incident · Minor injuriesClosedBoeing 707 300 · Malad City, IDSep 25, 1964 · N759PA · No damage NTSB UNK64X4130Accident · No injuriesClosedCessna 175 · Blackfoot, IDSep 24, 1964 · N7397M · Substantial damage NTSB UNK64X4099Accident · No injuriesClosedPiper PA28 · Montpelier, IDSep 22, 1964 · N6043W · Substantial damage NTSB UNK64X4022Accident · No injuriesClosedAeronca 7EC · Cavendish, IDSep 17, 1964 · N4317C · Substantial damage