Skip to content

NTSB investigations, ID

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 SEA72FYG11Accident · 1 fatalClosedCessna 188 · Craigmont, IDSep 8, 1971 · N9738V · Destroyed NTSB SEA72DYG14Accident · Minor injuriesClosedPiper PA-28 · Coeur Dalene, IDSep 7, 1971 · N5770F · Destroyed NTSB SEA72DYG10Accident · No injuriesClosedCessna 172 · Salmon, IDSep 6, 1971 · N8538X · Substantial damage NTSB SEA72FYG08Accident · Serious injuriesClosedBellanca 14-13 · Orofino, IDAug 29, 1971 · N74450 · Substantial damage NTSB SEA72DYA10Accident · No injuriesClosedAeronca 7BCM · Boise, IDAug 27, 1971 · N6057C · Substantial damage NTSB SEA72DYA12Accident · No injuriesClosedCessna 150 · Rexburg, IDAug 23, 1971 · N22281 · Substantial damage NTSB SEA72DYA11Accident · No injuriesClosedPiper PA-18 · Burley, IDAug 21, 1971 · N8562C · Substantial damage NTSB SEA72DYG07Accident · Minor injuriesClosedCessna 175 · Mullan, IDAug 15, 1971 · N9342B · Substantial damage NTSB SEA72DYA08Accident · Serious injuriesClosedAeronca 7AC · Twin Falls, IDAug 13, 1971 · N83896 · Destroyed NTSB SEA72DYA06Accident · No injuriesClosedCessna 182 · Emmett, IDJul 31, 1971 · N2782G · Destroyed NTSB SEA72DYA04Accident · No injuriesClosedPiper PA-25 · Firth, IDJul 27, 1971 · N6054Z · Substantial damage NTSB SEA72AS003Accident · 2 fatalClosedPiper PA-22 · Mountain Home, IDJul 27, 1971 · N6924B · Destroyed NTSB SEA72DYA07Accident · No injuriesClosedHiller UH12-E · Bliss, IDJul 23, 1971 · N5345V · Substantial damage NTSB SEA72FYA03Accident · Minor injuriesClosedCallair A-9 · Parma, IDJul 20, 1971 · N7214V · Substantial damage NTSB SEA72DYA02Accident · No injuriesClosedPiper PA-12 · Wendell, IDJul 18, 1971 · N3580M · Substantial damage NTSB SEA72FYA01Accident · No injuriesClosedStinson 108-3 · Boise, IDJul 17, 1971 · N6392M · Substantial damage NTSB SEA71DYG61Accident · No injuriesClosedTaylorcraft BC12-D · Priest Lake, IDJun 27, 1971 · N44445 · Substantial damage NTSB SEA71DYA41Accident · Minor injuriesClosedPiper J-3 · Paris, IDJun 26, 1971 · N38631 · Substantial damage NTSB SEA71DYA40Accident · No injuriesClosedCessna 188 · Kimberly, IDJun 22, 1971 · N9891V · Substantial damage NTSB SEA71DYA39Accident · No injuriesClosedPiper PA-11 · Newdale, IDJun 20, 1971 · N4687M · Substantial damage NTSB SEA71DYA38Accident · No injuriesClosedPiper PA-25 · Blackfoot, IDJun 20, 1971 · N7283Z · Substantial damage NTSB SEA71DYA37Accident · No injuriesClosedCallair A-9B · Albion, IDJun 19, 1971 · N7698V · Substantial damage NTSB SEA71DYA36Accident · Serious injuriesClosedPiper PA-25 · Idaho Falls, IDJun 15, 1971 · N7118Z · Destroyed NTSB SEA71FYA35Accident · Serious injuriesClosedPiper PA-28 · Boise, IDJun 13, 1971 · N6786W · Substantial damage NTSB SEA71DYA33Accident · No injuriesClosedPiper PA-23 · Blackfoot, IDMay 28, 1971 · N1172P · Substantial damage NTSB SEA71FYA32Accident · No injuriesClosedConvair 240-14 · Buhl, IDMay 14, 1971 · N1015G · Substantial damage NTSB SEA71DYA31Accident · No injuriesClosedCessna 182L · Montpelier, IDMay 7, 1971 · N42150 · Substantial damage NTSB SEA71DXM29Accident · No injuriesClosedCessna 140 · Atomic City, IDApr 12, 1971 · N90124 · Substantial damage NTSB SEA71DXM30Accident · No injuriesClosedCessna 170B · Mc Call, IDApr 3, 1971 · N8232A · Substantial damage NTSB SEA71DXM28Accident · No injuriesClosedCessna 150 · Burley, IDMar 27, 1971 · N7368X · Substantial damage NTSB SEA71DXM27Accident · Minor injuriesClosedPiper PA-23 · Carey, IDMar 12, 1971 · N1488P · Destroyed NTSB SEA71DXM26Accident · No injuriesClosedPiper PA-28 · Burley, IDFeb 28, 1971 · N7063R · Substantial damage NTSB SEA71AS037Accident · 2 fatalClosedPiper PA-18 · St.Anthony, IDFeb 20, 1971 · N7180 · Destroyed NTSB SEA71DXM25Accident · No injuriesClosedPiper PA-32 · Preston, IDFeb 12, 1971 · N3213W · Substantial damage NTSB SEA71FYM24Accident · Serious injuriesClosedCessna 421B · Gannett, IDFeb 6, 1971 · N8025Q · Substantial damage NTSB SEA71DXM22Accident · No injuriesClosedPiper PA-18 · Stone, IDJan 27, 1971 · N1249A · Substantial damage NTSB SEA71DXM23Accident · No injuriesClosedPiper PA-22 · Ketchum, IDJan 25, 1971 · N7415D · Substantial damage NTSB SEA71DXM21Accident · Minor injuriesClosedPiper PA-23 · Glenns Ferry, IDJan 23, 1971 · N3232P · Substantial damage NTSB SEA71DXM20Accident · No injuriesClosedPiper PA-22 · Fairfield, IDJan 11, 1971 · N3550P · Substantial damage NTSB SEA71AS034Accident · 3 fatalClosedPiper PA-28 · Rogerson, IDJan 10, 1971 · N95124 · Destroyed NTSB SEA71DXM19Accident · No injuriesClosedPiper PA-22 · Middleton, IDJan 9, 1971 · N629A · Substantial damage NTSB SEA71DXM18Accident · No injuriesClosedHughes 269B · Atlanta, IDJan 7, 1971 · N9427F · Substantial damage NTSB SEA71AS032Accident · No injuriesClosedPiper PA-32 · Orofino, IDJan 7, 1971 · N4270R · Substantial damage NTSB SEA71AS031Accident · 2 fatalClosedDehavilland DH125 · B0ise, IDDec 28, 1970 · N36MK · Destroyed NTSB SEA71DWG35Accident · No injuriesClosedPiper PA-22 · Hayden Lake, IDDec 12, 1970 · N5372Z · Substantial damage NTSB SEA71FXM17Accident · No injuriesClosedBeech G35 · Caldwell, IDDec 11, 1970 · N4469D · Substantial damage NTSB SEA71DXM16Accident · No injuriesClosedCessna 182D · American Falls, IDNov 28, 1970 · N8761X · Substantial damage NTSB SEA71AS028Accident · 1 fatalClosedPiper PA-24 · Kimberly, IDNov 26, 1970 · N6703P · Destroyed NTSB SEA71AS027Accident · 4 fatalClosedPiper PA-24 · St.Charles, IDNov 25, 1970 · N8724P · Destroyed NTSB SEA71DXM15Accident · Minor injuriesClosedCessna 172H · Twin Falls, IDOct 31, 1970 · N1665F · Substantial damage