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 SEA68D0255Accident · No injuriesClosedPiper PA-12 · Driggs, IDMar 3, 1968 · N2965M · Substantial damage NTSB SEA68D0274Accident · No injuriesClosedAero Comdr B-1 · Moscow, IDFeb 28, 1968 · N7281V · Substantial damage NTSB SEA68D0250Accident · No injuriesClosedPiper PA-28 · Picabo, IDFeb 17, 1968 · N9188J · Substantial damage NTSB SEA68D0243Accident · No injuriesClosedPiper PA-12 · Mccall, IDFeb 6, 1968 · N2577M · Substantial damage NTSB SEA68D0248Accident · No injuriesClosedPiper PA-12 · Elk River, IDFeb 3, 1968 · N2505M · Substantial damage NTSB SEA68D0236Accident · No injuriesClosedPiper PA-28 · Arco, IDJan 23, 1968 · N9747W · Substantial damage NTSB SEA68D0246Accident · No injuriesClosedMaule M-4 · Idaho Falls, IDJan 20, 1968 · N4621T · Substantial damage NTSB SEA68D0244Accident · Serious injuriesClosedCessna 120 · Sandpoint, IDJan 20, 1968 · N77000 · Substantial damage NTSB SEA68A0044Accident · 1 fatalClosedCessna 180H · Coeur D-Alene, IDJan 2, 1968 · N8234V · Destroyed NTSB SEA68D0221Accident · No injuriesClosedPiper PA-18 · Preston, IDDec 10, 1967 · N1148A · Substantial damage NTSB SEA68D0187Accident · No injuriesClosedCessna P206 · Grace, IDNov 4, 1967 · N2677X · Substantial damage NTSB SEA68D0186Accident · No injuriesClosedPiper PA-28 · Picabo, IDNov 2, 1967 · N6655W · Substantial damage NTSB SEA68D0183Accident · No injuriesClosedPiper PA-24 · Burley, IDOct 19, 1967 · N5109P · Substantial damage NTSB SEA68D0157Accident · No injuriesClosedNavion A · Burley, IDOct 13, 1967 · N91188 · Substantial damage NTSB SEA68D0145Accident · No injuriesClosedCessna 150 · Rexburg, IDOct 10, 1967 · N8292F · Substantial damage NTSB SEA68D0162Accident · Minor injuriesClosedTaylorcraft BC12-D · Ketchum, IDOct 6, 1967 · N95561 · Substantial damage NTSB SEA68A0028Accident · No injuriesClosedHiller UH-12E · Priest River, IDSep 27, 1967 · N90465 · Substantial damage NTSB SEA68D0146Accident · No injuriesClosedCessna 170A · Montpelier, IDSep 23, 1967 · N1351D · Substantial damage NTSB SEA68D0124Accident · No injuriesClosedBeech H35 · Caldwell, IDSep 13, 1967 · N5490D · Substantial damage NTSB SEA68D0090Accident · No injuriesClosedNavion A · Burley, IDSep 4, 1967 · N5123K · Substantial damage NTSB SEA68D0129Accident · No injuriesClosedCessna 182 · Bridge, IDSep 2, 1967 · N8644T · Substantial damage NTSB SEA68D0105Accident · No injuriesClosedPiper PA-32 · Stanley, IDSep 1, 1967 · N3669W · Substantial damage NTSB SEA68D0101Accident · No injuriesClosedGrumman TBM-3E · Elk City, IDAug 25, 1967 · N4173A · Substantial damage NTSB SEA68D0086Accident · No injuriesClosedGrumman G-164 · Jerome, IDAug 25, 1967 · N654U · Substantial damage NTSB SEA68D0104Accident · No injuriesClosedCessna 182 · Bovill, IDAug 24, 1967 · N3739U · Substantial damage NTSB SEA68D0100Accident · No injuriesClosedGrumman TBM · Grangeville, IDAug 23, 1967 · N68683 · Substantial damage NTSB SEA68D0108Accident · No injuriesClosedPiper PA-24 · Gannett, IDAug 20, 1967 · N6319P · Substantial damage NTSB SEA68A0017Accident · 2 fatalClosedCessna 170 · Avery, IDAug 17, 1967 · N3420C · Destroyed NTSB SEA68D0107Accident · No injuriesClosedGrumman TBM · Coeur D Alene, IDAug 14, 1967 · N7157C · Substantial damage NTSB SEA68D0074Accident · No injuriesClosedPiper PA-28 · Caldwell, IDAug 7, 1967 · N9225W · Substantial damage NTSB SEA68D0084Accident · No injuriesClosedWaco UMF · Mccall, IDAug 6, 1967 · N14076 · Substantial damage NTSB SEA68F0065Accident · No injuriesClosedCessna 172 · St.Maries, IDAug 3, 1967 · N4299L · Substantial damage NTSB SEA68D0113Accident · No injuriesClosedPiper PA-28 · Soda Springs, IDAug 1, 1967 · N7049R · Substantial damage NTSB SEA68D0053Accident · No injuriesClosedPiper PA-23 · Caldwell, IDJul 31, 1967 · N6194Y · Substantial damage NTSB SEA68D0119Accident · Minor injuriesClosedCessna 182 · Downey, IDJul 30, 1967 · N6000B · Destroyed NTSB SEA68D0063Accident · No injuriesClosedPiper PA-18 · Burley, IDJul 25, 1967 · N73890 · Substantial damage NTSB SEA68F0060Accident · Minor injuriesClosedTaylorcraft DC-65 · Mountain Home, IDJul 21, 1967 · N62798 · Substantial damage NTSB SEA68D0035Accident · No injuriesClosedStinson 108 · Challis, IDJul 18, 1967 · N252C · Destroyed NTSB SEA68D0034Accident · No injuriesClosedPiper PA-18 · Challis, IDJul 14, 1967 · N4030Z · Substantial damage NTSB SEA68D0042Accident · Serious injuriesClosedFairchild PC-6CH · Mccall, IDJul 9, 1967 · N358F · Substantial damage NTSB SEA68D0041Accident · Minor injuriesClosedPiper PA-25 · Genesee, IDJul 5, 1967 · N4535Y · Destroyed NTSB SEA68D0117Accident · No injuriesClosedPiper PA-24 · Rockland, IDJul 3, 1967 · N7535P · Substantial damage NTSB SEA68F0024Accident · No injuriesClosedMooney M20C · Peck, IDJul 2, 1967 · N6822U · Substantial damage NTSB SEA68D0023Accident · No injuriesClosedCessna 182 · Elk River, IDJun 24, 1967 · N3200U · Substantial damage NTSB SEA67A0075Accident · 2 fatalClosedNavion L-17A · Ketchum, IDJun 21, 1967 · N9645C · Destroyed NTSB SEA68F0038Accident · No injuriesClosedNavion A · Mayfield, IDJun 20, 1967 · N91189 · Substantial damage NTSB SEA68D0036Accident · No injuriesClosedPiper PA-25 · Glenns Ferry, IDJun 19, 1967 · N7719Z · Destroyed NTSB SEA68D0005Accident · Minor injuriesClosedBoeing PT-17 · Idaho Falls, IDJun 19, 1967 · N58985 · Substantial damage NTSB MKC68F0382Accident · No injuriesClosedPiper PA-25 · Wardell, IDJun 19, 1967 · N6679Z · Substantial damage NTSB SEA68D0033Accident · No injuriesClosedNavion A · Twin Falls, IDJun 18, 1967 · N5562V · Substantial damage