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 UNK64X4013Accident · Serious injuriesClosedBell 47G3 · Elk River, IDSep 16, 1964 · N8417E · Destroyed NTSB UNK64X3895Accident · No injuriesClosedAeronca 7AC · Firth, IDSep 10, 1964 · N85635 · Substantial damage NTSB UNK64X3662Accident · No injuriesClosedBeechcraft E35 · Gooding, IDAug 29, 1964 · N7399B · Substantial damage NTSB UNK64X3520Accident · No injuriesClosedInterstate S1A · Grace, IDAug 21, 1964 · N37341 · Substantial damage NTSB UNK64X3512Accident · No injuriesClosedCessna 150 · Mountain Home, IDAug 21, 1964 · N6653T · Substantial damage NTSB UNK64X3333Accident · Minor injuriesClosedPiper PA11 · Moscow, IDAug 11, 1964 · N4546M · Destroyed NTSB UNK64X3273Accident · No injuriesClosedStinson 108 · Montour, IDAug 8, 1964 · N97935 · Substantial damage NTSB UNK64X3255Accident · No injuriesClosedCessna 150 · Home, IDAug 7, 1964 · N4434U · Destroyed NTSB UNK64X3118Accident · No injuriesClosedPiper PA22 · Bonners Ferry, IDJul 30, 1964 · N9612D · Substantial damage NTSB UNK64X3084Accident · No injuriesClosedCessna 140 · Weiser, IDJul 28, 1964 · N2370V · Substantial damage NTSB UNK64X3034Accident · No injuriesClosedBoeing E75 · Craigmont, IDJul 25, 1964 · N5685N · Substantial damage NTSB UNK64X3031Accident · No injuriesClosedCessna 180 · Hegler, IDJul 25, 1964 · N4923A · Substantial damage NTSB UNK64X3025Accident · Serious injuriesClosedPiper PA25 · Shoshone, IDJul 25, 1964 · N7040Z · Destroyed NTSB UNK64X3024Accident · Serious injuriesClosedPiper PA22 · Loon Creek, IDJul 25, 1964 · N2676A · Destroyed NTSB UNK64X2964Accident · No injuriesClosedPiper PA-18 · Filer, IDJul 21, 1964 · N9104D · Substantial damage NTSB UNK64X2954Accident · 1 fatalClosedPiper PA-11 · Cottonwood, IDJul 21, 1964 · N78639 · Destroyed NTSB UNK64X2948Accident · 1 fatalClosedGrumman TBM-3 · Gibbonsville, IDJul 20, 1964 · N7016C · Destroyed NTSB UNK64X2940Accident · 1 fatalClosedPiper PA18A · Hansen, IDJul 20, 1964 · N8687D · Destroyed NTSB UNK64X2916Accident · No injuriesClosedBoeing PT17 · Roberts, IDJul 19, 1964 · N53479 · Substantial damage NTSB UNK64X2887Accident · No injuriesClosedConvair PB4Y2 · Challis, IDJul 17, 1964 · N9681C · Substantial damage NTSB UNK64X2882Accident · No injuriesClosedStearman E75 · Hansen, IDJul 17, 1964 · N58983 · Substantial damage NTSB UNK64X2844Accident · No injuriesClosedPiper PA18 · Garden Valley, IDJul 15, 1964 · N7195D · Substantial damage NTSB UNK64X2836Accident · Serious injuriesClosedCessna 182 · Cascade, IDJul 14, 1964 · N3443U · Substantial damage NTSB UNK64X2835Accident · Serious injuriesClosedCallair A9 · Malta, IDJul 14, 1964 · N3607G · Destroyed NTSB UNK64X2690Accident · No injuriesClosedBoeing A75N1 · Brangeville, IDJul 6, 1964 · N75321 · Substantial damage NTSB UNK64X2679Accident · No injuriesClosedBoeing A75N1 · Genesee, IDJul 6, 1964 · N58712 · Substantial damage NTSB UNK64X2597Accident · No injuriesClosedCessna 180 · Hamet, IDJul 1, 1964 · N3144C · Substantial damage NTSB UNK64X2554Accident · Minor injuriesClosedTravel Aire 6000B · Mccall, IDJun 28, 1964 · N9038 · Destroyed NTSB UNK64X2434Accident · No injuriesClosedBeechcraft AT11 · Chamberlin, IDJun 22, 1964 · N8069H · Substantial damage NTSB UNK64X2433Accident · No injuriesClosedPiper PA18A · Swan Valley, IDJun 22, 1964 · N7172D · Substantial damage NTSB UNK64X2415Accident · No injuriesClosedBeechcraft D35 · Kimberly, IDJun 21, 1964 · N2918B · Destroyed NTSB UNK64X2392Accident · No injuriesClosedNavion NAV4 · Lewiston, IDJun 20, 1964 · N91786 · Substantial damage NTSB UNK64X2334Accident · No injuriesClosedAeronca 11AC · Minidoka, IDJun 17, 1964 · N86116 · Substantial damage NTSB UNK64X2152Accident · Minor injuriesClosedPiper PA24 · Boise, IDJun 6, 1964 · N5109P · Destroyed NTSB UNK64X2128Accident · No injuriesClosedCessna 140 · Boise, IDJun 5, 1964 · N76680 · Substantial damage NTSB UNK64X2017Accident · Minor injuriesClosedBell 47G3B · Muldoon, IDMay 30, 1964 · N8491E · Substantial damage NTSB UNK64X1970Accident · Serious injuriesClosedCessna 172 · Lewiston, IDMay 27, 1964 · N4067F · Substantial damage NTSB UNK64X1903Accident · No injuriesClosedAeronca 7BCM · Idaho City, IDMay 23, 1964 · N6057C · Substantial damage NTSB UNK64X1890Accident · 1 fatalClosedPiper J3F-65 · Dixie, IDMay 22, 1964 · N40912 · Destroyed NTSB UNK64X1818Accident · No injuriesClosedPiper PA22 · Blackfoot, IDMay 18, 1964 · N5002Z · Substantial damage NTSB UNK64X1761Accident · Minor injuriesClosedCallair A9 · Roseworth, IDMay 14, 1964 · N9668Z · Destroyed NTSB UNK64X1652Accident · No injuriesClosedCessna 172 · Arco, IDMay 7, 1964 · N7564X · Substantial damage NTSB UNK64X1575Accident · No injuriesClosedCessna 182 · Orogrande, IDMay 2, 1964 · N5379B · Substantial damage NTSB UNK64X1509Accident · No injuriesClosedBeechcraft B35 · St Charles, IDApr 29, 1964 · N8798A · Substantial damage NTSB UNK64X1336Accident · No injuriesClosedCessna 180 · St Anthony, IDApr 16, 1964 · N3330D · Substantial damage NTSB UNK64X1014Accident · No injuriesClosedCessna 150 · Paris, IDMar 22, 1964 · N4499V · Substantial damage NTSB UNK64X0859Accident · No injuriesClosedPiper PA23 · Idaho Falls, IDMar 9, 1964 · N4818P · Substantial damage NTSB UNK64X0797Accident · No injuriesClosedPiper PA18 · Coeur Dalene, IDMar 3, 1964 · N2629A · Substantial damage NTSB UNK64X0762Accident · No injuriesClosedCessna 182 · Shepp Ranch, IDFeb 29, 1964 · N2056R · Substantial damage NTSB UNK64X0648Accident · No injuriesClosedBeechcraft 35 · Idaho Falls, IDFeb 22, 1964 · N5579D · Substantial damage