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 SEA67D0358Accident · No injuriesClosedCessna 185 · Gooding, IDJun 18, 1967 · N9862X · Substantial damage NTSB SEA67A0072Accident · 2 fatalClosedPiper PA-18 · Parma, IDJun 10, 1967 · N2879P · Destroyed NTSB SEA67D0338Accident · No injuriesClosedPiper PA-28 · Salmon, IDJun 3, 1967 · N9640J · Substantial damage NTSB SEA67D0349Accident · Minor injuriesClosedCallair A-9 · American Falls, IDJun 1, 1967 · N7210V · Destroyed NTSB SEA67D0340Accident · Minor injuriesClosedPiper PA-28 · Aberdeen, IDMay 31, 1967 · N4130U · Substantial damage NTSB SEA67D0351Accident · No injuriesClosedCallair A-9 · Arimo, IDMay 28, 1967 · N8270H · Substantial damage NTSB SEA67D0336Accident · No injuriesClosedPiper PA-18 · Malad City, IDMay 28, 1967 · N3599Z · Substantial damage NTSB SEA67D0318Accident · No injuriesClosedCessna 195A · Carey, IDMay 27, 1967 · N1512D · Substantial damage NTSB SEA67D0348Accident · No injuriesClosedPiper PA-18 · Burley, IDMay 22, 1967 · N7668D · Substantial damage NTSB SEA67D0352Accident · No injuriesClosedCessna 140 · Blackfoot, IDMay 21, 1967 · N76775 · Substantial damage NTSB SEA67A0064Accident · 2 fatalClosedPiper PA-22 · Rupert, IDMay 15, 1967 · N7151B · Destroyed NTSB SEA67D0308Accident · No injuriesClosedPiper PA-25 · Craigmont, IDMay 3, 1967 · N6542Z · Substantial damage NTSB SEA67D0310Accident · Minor injuriesClosedPiper PA-28 · Horsebend, IDApr 24, 1967 · N7512R · Substantial damage NTSB SEA67A0060Accident · No injuriesClosedHiller UH-12E · Orofino, IDApr 21, 1967 · N5388V · Substantial damage NTSB SEA67D0334Accident · No injuriesClosedStearman A-75 · Moscow, IDApr 15, 1967 · N9082H · Substantial damage NTSB SEA67F0309Accident · No injuriesClosedSchweizer SGU222 · Boise, IDApr 9, 1967 · N9943J · Substantial damage NTSB SEA67D0269Accident · No injuriesClosedPiper PA-28 · Soda Springs, IDApr 1, 1967 · N7049R · Substantial damage NTSB SEA67A0056Accident · 2 fatalClosedPiper PA-23 · Leadore, IDMar 28, 1967 · N4459P · Destroyed NTSB SEA67D0268Accident · No injuriesClosedBellanca 14-19 · Caldwell, IDMar 21, 1967 · N7683B · Substantial damage NTSB SEA67D0249Accident · Minor injuriesClosedCessna 182 · Riggins, IDFeb 20, 1967 · N5110D · Destroyed NTSB SEA67D0260Accident · No injuriesClosedCessna 172 · Kellogg, IDFeb 19, 1967 · N8093B · Substantial damage NTSB SEA67D0243Accident · No injuriesClosedPiper PA-22 · Burley, IDFeb 18, 1967 · N2755P · Substantial damage NTSB SEA67D0220Accident · No injuriesClosedCessna 337 · Malad City, IDJan 13, 1967 · N2126X · Substantial damage NTSB SEA67D0218Accident · No injuriesClosedNavion A · Boise, IDDec 24, 1966 · N5235K · Substantial damage NTSB SEA67D0199Accident · No injuriesClosedCessna 172 · Dubois, IDDec 4, 1966 · N1691F · Substantial damage NTSB SEA67D0198Accident · No injuriesClosedTaylorcraft BC12-D · Jerome, IDNov 20, 1966 · N39230 · Substantial damage NTSB SEA67D0177Accident · No injuriesClosedCessna 150 · Twin Falls, IDNov 5, 1966 · N8800S · Substantial damage NTSB SEA67D0178Accident · Minor injuriesClosedCessna 150 · Wayan, IDNov 2, 1966 · N4800X · Substantial damage NTSB SEA67D0164Accident · Minor injuriesClosedAeronca 7AC · Twin Falls, IDOct 29, 1966 · N3085E · Substantial damage NTSB SEA67F0170Accident · No injuriesClosedPiper PA-18 · Weiser, IDOct 28, 1966 · N4395A · Substantial damage NTSB SEA67A0035Accident · 2 fatalClosedCessna 180C · Ngrangeville, IDOct 20, 1966 · N9175T · Substantial damage NTSB SEA67A0034Accident · 3 fatalClosedBeech 35 · Stanley, IDOct 15, 1966 · N3234V · Destroyed NTSB SEA67F0143Accident · No injuriesClosedPiper J4 · Homedale, IDOct 2, 1966 · N22961 · Substantial damage NTSB SEA67D0159Accident · Minor injuriesClosedCessna 150 · Avery, IDOct 1, 1966 · N5812E · Destroyed NTSB SEA67A0028Accident · 5 fatalClosedCessna 185E · Ngrangeville, IDSep 23, 1966 · N1590F · Destroyed NTSB SEA67A0024Accident · No injuriesClosedBell 47G-3 · Challis, IDSep 17, 1966 · N8461E · Substantial damage NTSB SEA67A0023Accident · 3 fatalClosedPiper PA-23 · Stanley, IDSep 14, 1966 · N4242P · Substantial damage NTSB SEA67F0096Accident · 1 fatalClosedWaco UPF-7 · Wilder, IDAug 12, 1966 · N170E · Destroyed NTSB SEA67F0101Accident · Serious injuriesClosedSchweizer 1-26B · Ketchum, IDAug 5, 1966 · N2763R · Substantial damage NTSB SEA67D0094Accident · No injuriesClosedCessna 182 · Caldwell, IDAug 2, 1966 · N9940B · Substantial damage NTSB SEA67D0066Accident · Minor injuriesClosedPiper PA-24 · Challis, IDJul 24, 1966 · N7870P · Substantial damage NTSB SEA67A0006Accident · 3 fatalClosedCessna 172 · Cascade, IDJul 24, 1966 · N988TA · Substantial damage NTSB SEA67D0090Accident · No injuriesClosedPiper PA-18 · Hamer, IDJul 23, 1966 · N7083D · Substantial damage NTSB SEA67D0088Accident · No injuriesClosedCessna 210 · Rigby, IDJul 20, 1966 · N7476E · Substantial damage NTSB SEA67D0067Accident · Minor injuriesClosedPiper PA-18A · Rupert, IDJul 18, 1966 · N7886D · Destroyed NTSB SEA67D0038Accident · No injuriesClosedPiper PA-18A · Clover, IDJul 15, 1966 · N7284D · Substantial damage NTSB SEA67A0003Accident · 1 fatalClosedStinson L-5 · Emmett, IDJul 15, 1966 · N58990 · Destroyed NTSB SEA67D0072Accident · No injuriesClosedCessna 180 · Genesee, IDJul 12, 1966 · N9488C · Substantial damage NTSB SEA67D0063Accident · No injuriesClosedAeronca 7FC · Twin Falls, IDJul 10, 1966 · N7686E · Substantial damage NTSB SEA67D0036Accident · No injuriesClosedCessna 182 · Riggins, IDJul 10, 1966 · N3401S · Substantial damage