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 SEA67D0031Accident · No injuriesClosedLuscombe 8A · Montpelier, IDJul 10, 1966 · N20687 · Substantial damage NTSB SEA67D0016Accident · No injuriesClosedTaylorcraft BC12-D · Hailey, IDJul 3, 1966 · N39230 · Substantial damage NTSB SEA67D0037Accident · Serious injuriesClosedBellanca 14-13 · Mackay, IDJul 2, 1966 · N41878 · Destroyed NTSB SEA67D0030Accident · No injuriesClosedLuscombe 8E · Idaho City, IDJun 29, 1966 · N1332K · Substantial damage NTSB SEA67D0023Accident · No injuriesClosedPiper PA-18A · Idaho Falls, IDJun 27, 1966 · N7165B · Substantial damage NTSB SEA67D0080Accident · No injuriesClosedPiper PA-24 · Challis, IDJun 25, 1966 · N8982P · Substantial damage NTSB SEA67D0039Accident · Serious injuriesClosedStinson 108 · Buhl, IDJun 25, 1966 · N97306 · Destroyed NTSB SEA67D0058Accident · Minor injuriesClosedPiper PA-24 · Montpelier, IDJun 21, 1966 · N7093P · Substantial damage NTSB SEA67D0012Accident · No injuriesClosedAeronca 15AC · Coeur D'Alene, IDJun 19, 1966 · N1346H · Substantial damage NTSB SEA67D0057Accident · Serious injuriesClosedLuscombe 8A · Challis, IDJun 18, 1966 · N45554 · Destroyed NTSB SEA67D0025Accident · No injuriesClosedCessna 172 · Atomic City, IDJun 17, 1966 · N3826L · Substantial damage NTSB SEA66A0064Accident · 1 fatalClosedPiper PA-18A · St Anthony, IDJun 2, 1966 · N3490Z · Destroyed NTSB SEA66D0279Accident · No injuriesClosedPiper PA-22 · Boise, IDMay 30, 1966 · N5368Z · Substantial damage NTSB SEA67D0011Accident · Minor injuriesClosedCessna 180A · Albion, IDMay 28, 1966 · N7770A · Destroyed NTSB SEA67D0015Accident · No injuriesClosedPiper PA-18A · Swan Valley, IDMay 27, 1966 · N7165B · Substantial damage NTSB SEA66D0300Accident · No injuriesClosedCessna 180 · Grace, IDMay 27, 1966 · N2269C · Substantial damage NTSB SEA66A0061Accident · Minor injuriesClosedCessna 206 · Elk City, IDMay 25, 1966 · N206KA · Substantial damage NTSB SEA66D0283Accident · No injuriesClosedCessna 150C · Orofino, IDMay 16, 1966 · N1964Z · Substantial damage NTSB SEA66D0282Accident · No injuriesClosedCessna 182 · Grangeville, IDMay 15, 1966 · N3824D · Substantial damage NTSB SEA67D0024Accident · Serious injuriesClosedPiper PA-28 · Big Springs, IDMay 14, 1966 · N8108W · Destroyed NTSB SEA66D0269Accident · No injuriesClosedCessna 120 · Boise, IDMay 10, 1966 · N76892 · Substantial damage NTSB SEA66D0263Accident · Minor injuriesClosedPiper PA-22 · Union, IDMay 1, 1966 · N5830P · Substantial damage NTSB SEA66D0246Accident · No injuriesClosedCessna 180 · Moose Creek, IDApr 29, 1966 · N6531A · Substantial damage NTSB SEA66D0244Accident · No injuriesClosedCessna 175 · Challis, IDApr 10, 1966 · N7254M · Substantial damage NTSB SEA66F0234Accident · No injuriesClosedPiper PA-25 · Nezperce, IDApr 6, 1966 · N7686Z · Destroyed NTSB SEA66D0236Accident · No injuriesClosedStinson 6A · Burley, IDMar 26, 1966 · N9718K · Substantial damage NTSB SEA66F0238Accident · Minor injuriesClosedBoeing A-75 · Culdesc, IDMar 24, 1966 · N56236 · Substantial damage NTSB SEA66D0243Accident · No injuriesClosedBeech K35 · Blackfoot, IDMar 17, 1966 · N6039E · Substantial damage NTSB SEA66F0233Accident · No injuriesClosedCessna 150 · Boise, IDMar 16, 1966 · N8324G · Substantial damage NTSB SEA66D0232Accident · No injuriesClosedCessna 175 · Grace, IDMar 6, 1966 · N9204B · Minor damage NTSB SEA66A0045Accident · 2 fatalClosedPiper PA-24 · New Plymouth, IDFeb 24, 1966 · N7831P · Destroyed NTSB SEA66D0231Accident · No injuriesClosedCessna 182 · Gooding, IDFeb 20, 1966 · N8761X · Substantial damage NTSB SEA66D0215Accident · No injuriesClosedCessna 150 · Council, IDFeb 20, 1966 · N5822E · Substantial damage NTSB SEA66F0209Accident · No injuriesClosedCessna 172D · Twin Falls, IDFeb 12, 1966 · N2796U · Substantial damage NTSB SEA66A0042Accident · 2 fatalClosedPiper PA-24 · Osburn, IDFeb 2, 1966 · N6351P · Destroyed NTSB SEA66D0201Accident · No injuriesClosedMooney M20B · Featherville, IDDec 28, 1965 · N74741 · Substantial damage NTSB SEA66F0175Accident · Minor injuriesClosedPiper PA-24 · Idaho Falls, IDNov 30, 1965 · N7163P · Substantial damage NTSB SEA66A0033Accident · 2 fatalClosedNavion A · Lowman, IDNov 20, 1965 · N4203K · Destroyed NTSB SEA66A0029Accident · 1 fatalClosedTaylorcraft BC12-D · Blackfoot, IDNov 2, 1965 · N36328 · Destroyed NTSB SEA66F0155Accident · Serious injuriesClosedPiper PA18A · Homedale, IDOct 31, 1965 · N7195D · Substantial damage NTSB SEA66D0170Accident · No injuriesClosedPiper J-3 · Carey, IDOct 30, 1965 · N32949 · Substantial damage NTSB SEA66F0156Accident · Minor injuriesClosedBriegleb BG-7 · Rexburg, IDOct 17, 1965 · N4565K · Substantial damage NTSB SEA66A0026Accident · 2 fatalClosedStinson V-77 · Boise, IDOct 16, 1965 · N60361 · Destroyed NTSB SEA66F0128Accident · No injuriesClosedCessna 180 · Nampa, IDOct 11, 1965 · N2223C · Substantial damage NTSB SEA66D0137Accident · No injuriesClosedMooney M20E · Twin Falls, IDSep 23, 1965 · N5733Q · Substantial damage NTSB SEA66D0127Accident · No injuriesClosedLuscombe 8A · Priest River, IDSep 18, 1965 · N45831 · Substantial damage NTSB SEA66D0119Accident · No injuriesClosedBird CK · Notus, IDSep 11, 1965 · N765N · Substantial damage NTSB SEA66D0131Accident · No injuriesClosedStinson 108-2 · Bonner Ferry, IDSep 10, 1965 · N265C · Substantial damage NTSB SEA66F0102Accident · Minor injuriesClosedPitts Psig · Idaho Falls, IDSep 4, 1965 · N86G · Substantial damage NTSB SEA66F0135Accident · No injuriesClosedBeechcraft K35 · Cottonwood, IDAug 28, 1965 · N5387E · Substantial damage