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 SEA77FA026Accident · 2 fatalClosedCessna 180 · Newdale, IDApr 10, 1977 · N2974A · Destroyed NTSB SEA77FYP21Accident · No injuriesClosedCessna 182D · Kingston, IDApr 3, 1977 · N8712X · Substantial damage NTSB SEA77DYA16Accident · Minor injuriesClosedAero Comdr 500B · Twin Falls, IDApr 2, 1977 · N223LH · Destroyed NTSB SEA77FYA15Accident · No injuriesClosedCessna 150L · Boise, IDMar 21, 1977 · N1215Q · Substantial damage NTSB SEA77DA022Accident · Minor injuriesClosedCessna TU206F · Warren, IDMar 21, 1977 · N1912U · Substantial damage NTSB SEA77FYA14Accident · No injuriesClosedPiper PA-28 · Emmett, IDMar 20, 1977 · N4388X · Substantial damage NTSB SEA77FA021Accident · 2 fatalClosedGrum Amer AA-5 · Clifton, IDMar 19, 1977 · N7198L · Destroyed NTSB SEA77DYA13Accident · No injuriesClosedTaylorcraft BC12D · American Falls, IDMar 15, 1977 · N44280 · Substantial damage NTSB SEA77DYA12Accident · Minor injuriesClosedCessna 421B · Soda Springs, IDFeb 23, 1977 · N3380Q · Substantial damage NTSB SEA77FYA10Accident · Serious injuriesClosedCessna 185 · Rexburg, IDFeb 20, 1977 · N412AM · Substantial damage NTSB SEA77DYA11Accident · Minor injuriesClosedCessna 172 · Boise, IDFeb 20, 1977 · N80691 · Substantial damage NTSB SEA77FA018Accident · 3 fatalClosedPiper PA-28 · Carey, IDFeb 10, 1977 · N937CC · Destroyed NTSB SEA77DYP18Accident · No injuriesClosedBellanca 7ECA · Orofino, IDFeb 5, 1977 · N4141Y · Substantial damage NTSB SEA77FYA09Accident · Serious injuriesClosedBell 214B1 · Salmon, IDJan 26, 1977 · N225RM · Substantial damage NTSB SEA77DYP16Accident · No injuriesClosedCessna 421A · Sandpoint, IDJan 12, 1977 · N421MF · Substantial damage NTSB SEA77DYP15Accident · No injuriesClosedCessna 170B · Lewiston, IDDec 20, 1976 · N2392D · Substantial damage NTSB SEA77FYA08Accident · No injuriesClosedPiper PA-28R · Glenns Ferry, IDNov 27, 1976 · N4513F · Substantial damage NTSB SEA77FA008Accident · 1 fatalClosedPiper PA-28R · Sandpoint, IDNov 22, 1976 · N15987 · Destroyed NTSB SEA77FYA06Accident · Minor injuriesClosedCessna 150L · Mountain Home, IDNov 14, 1976 · N6788G · Substantial damage NTSB SEA77DYA05Accident · Minor injuriesClosedCessna 150 · Blackfoot, IDNov 6, 1976 · N4047J · Substantial damage NTSB SEA77DYA07Accident · No injuriesClosedCessna T210K · Challis, IDOct 27, 1976 · N8231M · Substantial damage NTSB SEA77FYA04Accident · Serious injuriesClosedSchweizer SGU222 · Boise, IDOct 24, 1976 · N2787Z · Substantial damage NTSB SEA77DYA03Accident · Minor injuriesClosedLake LA-4 · Boise, IDOct 20, 1976 · N6023V · Substantial damage NTSB SEA77DYG01Accident · No injuriesClosedCessna 182D · Cottonwood, IDOct 17, 1976 · N8713X · Destroyed NTSB SEA77DYA02Accident · Minor injuriesClosedPiper PA-22 · Malta, IDOct 9, 1976 · N8439D · Substantial damage NTSB SEA77DYA01Accident · No injuriesClosedStinson 108 · Soda Springs, IDOct 8, 1976 · N97182 · Substantial damage NTSB SEA77FYG04Accident · Serious injuriesClosedCessna 172 · Grangeville, IDOct 2, 1976 · N1641F · No damage NTSB SEA76DYG67Accident · No injuriesClosedHiller Acft UH-12E · Clark Fork, IDSep 27, 1976 · N62409 · Substantial damage NTSB SEA76DYA48Accident · No injuriesClosedHiller Acft UH-12E · Jerome, IDSep 8, 1976 · N62346 · Substantial damage NTSB SEA76AS075Accident · 1 fatalClosedPiper PA-28 · Mountain Home, IDSep 6, 1976 · N5916W · Substantial damage NTSB SEA76FYA46Accident · 4 fatalClosedPiper PA-22 · American Falls, IDAug 27, 1976 · N1401C · Destroyed NTSB SEA76AS072Accident · 1 fatalClosedPiper PA-23 · Blackfoot, IDAug 27, 1976 · N4306P · Destroyed NTSB SEA76AS073Accident · 1 fatalClosedCessna TU206E · Salmon, IDAug 25, 1976 · N1383M · Destroyed NTSB SEA76DYA44Accident · No injuriesClosedAero Comdr 600S2R · Rexburg, IDAug 2, 1976 · N4990X · Substantial damage NTSB SEA76FYG70Accident · 1 fatalClosedCessna 188 · Lewiston, IDJul 30, 1976 · N53151 · Destroyed NTSB SEA76DYA45Accident · No injuriesClosedCallair B1A · Newdale, IDJul 29, 1976 · N7260V · Substantial damage NTSB SEA76AS063Accident · 4 fatalClosedBeech H35 · Mccall, IDJul 24, 1976 · N5423D · Destroyed NTSB SEA76FYA42Accident · Minor injuriesClosedPiper PA-25 · Parma, IDJul 21, 1976 · N6748Z · Destroyed NTSB SEA76DYA41Accident · No injuriesClosedPiper PA-25 · Fruitland, IDJul 20, 1976 · N6751Z · Destroyed NTSB SEA76DYA40Accident · Minor injuriesClosedPiper PA-25 · Hamer, IDJul 16, 1976 · N4618Y · Substantial damage NTSB SEA76FYG71Accident · No injuriesClosedCessna 310Q · Coolin, IDJul 15, 1976 · N7709Q · Substantial damage NTSB SEA76DYA39Accident · No injuriesClosedHughes 269A · Gooding, IDJul 10, 1976 · N7432F · Substantial damage NTSB SEA76DYA36Accident · No injuriesClosedBell 47G3B2 · Gooding, IDJul 8, 1976 · N1424W · Substantial damage NTSB SEA76FYA35Accident · 1 fatalClosedAero Comdr A-9 · Nampa, IDJul 7, 1976 · N8400V · Destroyed NTSB SEA76DYA34Accident · No injuriesClosedCessna A188B · Grays Lake, IDJul 7, 1976 · N53216 · Substantial damage NTSB SEA76DYA33Accident · Minor injuriesClosedCallair A-9 · Grandview, IDJul 6, 1976 · N7214V · Substantial damage NTSB SEA76AS059Accident · 5 fatalClosedGrum Amer AA-5A · Boise, IDJul 5, 1976 · N9724U · Destroyed NTSB SEA76DYG59Accident · Minor injuriesClosedPiper PA-12 · Worley, IDJun 30, 1976 · N3131M · Substantial damage NTSB SEA76DYA31Accident · No injuriesClosedPiper PA-24 · Burley, IDJun 30, 1976 · N9327P · Substantial damage NTSB SEA76FYG62Accident · No injuriesClosedCessna 188B · Lewiston, IDJun 29, 1976 · N9919G · Substantial damage