Skip to content

NTSB investigations · 123

Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('2076405', '2073325') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('2076405', '2073325')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2076405', '2073325')
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 LAX83FA034Accident · 1 fatalField investigationFinal reportCessna 340A · Orinda, CAAfter departing san jose, CA, the plt climbed to an alt of 4600 ft MSL & proceeded toward novato, CA. From 1528 to 1533 PST, radar data showed that the acft was level at 4600 ft on a heading of 330 deg at 180 fts ground speed. Radar info showed that the acft…Nov 13, 1982 · N29HT · Destroyed NTSB MKC82DA054Accident · No injuriesFinal reportCessna 340A · Lincoln, NEThe pilot tookoff from runway 17L at 1705 CST. After takeoff, he encountered a vibration. He decided to land and was cleared for runway 14. Reportedly, the vibration increased at 130 knots. The pilot reduced the power to decrease his speed and remain under…Apr 7, 1982 · N82GB · Substantial damage NTSB LAX82FA109Accident · 3 fatalField investigationFinal reportCessna 340A · 12 N.E. Burbank, CAAfter takeoff, the pilot was cleared to proceed on an IFR flight plan. After being cleared to 15,000 ft MSL, he reported having trouble maintaining his airspeed and subsequently declared an emergency. Shortly after that, radar contact was lost. The aircraft…Mar 17, 1982 · N98546 · Destroyed NTSB SEA82DA021Accident · No injuriesFinal reportCessna 340A · Sunriver, ORThe instructor was providing dual instruction to a private pilot with no previous time in this nor any multi- engine aircraft. Also, the pirvate pilot had not flown within the previous 90 days. He initiated a takeoff on runway 18 with the wind from 210…Jan 28, 1982 · N4604N · Substantial damage NTSB CHI82DA056Accident · No injuriesFinal reportCessna 340A · Near Lansing, MIDuring flight over lake Michigan at 13,000 feet, the pilot noticed that the throttle, mixture and propeller controls to one of the engines began binding. The controls to the other engine remained normal. He descended to 9000 feet and continued at reduced…Jan 19, 1982 · N4140G · Substantial damage NTSB DEN82FA014Accident · Minor injuriesClosedCessna 340A · Pueblo, CODec 31, 1981 · N6272N · Destroyed NTSB DEN81FTM42Accident · No injuriesClosedCessna 340A · Vernal, UTSep 22, 1981 · N2696H · Substantial damage NTSB ANC81FA108Accident · 4 fatalClosedCessna 340A · Ketchikan, AKSep 5, 1981 · N2695A · Destroyed NTSB CHI81FA078Accident · 2 fatalClosedCessna 340A · St Charles, ILJul 18, 1981 · N5416J · Destroyed NTSB CHI81DA050Accident · No injuriesClosedCessna 340A · Robinson, ILApr 22, 1981 · N4155A · 2 aircraft · Substantial damage NTSB ATL81FA043Accident · 7 fatalClosedCessna 340A · Chapel Hill, NCFeb 7, 1981 · N8682K · Destroyed NTSB CHI81FEE18Accident · Serious injuriesClosedCessna 340A · Sugar Grove, ILJan 21, 1981 · N26711 · Destroyed NTSB ATL81IA017Incident · No injuriesClosedCessna 340A · Rome, GANov 20, 1980 · N44RK · Minor damage NTSB ANC80FA087Accident · 4 fatalClosedCessna 340A · Petersburg, AKAug 20, 1980 · N110RA · Destroyed NTSB MKC80FA030Accident · 2 fatalClosedCessna 340A · Minneapolis, MNApr 8, 1980 · N98547 · Destroyed NTSB NYC80DHA05Accident · No injuriesClosedCessna 340 · Princeton, NJFeb 15, 1980 · N6303X · Substantial damage NTSB FTW80FA034Accident · No injuriesClosedCessna 340 · Rosenberg, TXJan 10, 1980 · N8178G · Substantial damage NTSB MKC79FCG75Accident · Minor injuriesClosedCessna 340A · Topeka, KSAug 24, 1979 · N800BC · Substantial damage NTSB DEN79DTE75Accident · No injuriesClosedCessna 340 · Colorado City, COAug 19, 1979 · N1536G · Substantial damage NTSB DEN78FA055Accident · Serious injuriesClosedCessna 340 · Riverton, WYJul 30, 1978 · N1381G · Destroyed NTSB LAX77FA052Accident · 1 fatalClosedCessna 340A · Corona, CAJun 20, 1977 · N98621 · Destroyed NTSB MIA68A0028Accident · 4 fatalClosedCessna 172H · Robertstown, GASep 1, 1967 · N2697L · Destroyed NTSB MKC66D0514Accident · No injuriesClosedCessna 172 · Mexico, MOApr 17, 1966 · N4113L · Substantial damage

Back to Cessna 340A