NTSB investigations: Cessna 414

6 cases on aircraft the registry lists as Cessna 414, where the first occurrence was “In flight encounter with weather”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19842026

NTSB investigations: Cessna 414 per year, 1984–2026: 6 cases
1984	2
1996	2
2000	1
2007	1

Where

Open the map

Latest cases

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2075908') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2075908')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2075908')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 DFW07FA067Accident · 2 fatalField investigationFinal reportCessna 414 · Rocksprings, TXThe pilot's failure to maintain clearance with terrain. Contributing factors were the below approach/landing minimums weather and the drizzle/mist weather conditions.Feb 9, 2007 · N69845 · Destroyed NTSB SEA00FA095Accident · 3 fatalField investigationFinal reportCessna 414 · Monarch, MTThe failure of the pilot-in-command to ensure adequate airspeed for flight during a forced descent due to airframe icing, resulting in a stall. Factors included: freezing rain conditions, airframe icing, an improper decision by the pilot-in-command to turn…May 31, 2000 · N5113G · Destroyed NTSB NYC97FA021Accident · 2 fatalField investigationFinal reportCessna 414 · Duo, WVThe pilot's inadequate inflight decision which resulted in VFR flight into instrument meteorological conditions and his failure to maintain adequate terrain clearance which resulted in an inflight collision with terrain. The low ceiling was a factor.Nov 26, 1996 · N73CP · Destroyed NTSB LAX96FA200Accident · 1 fatalField investigationFinal reportCessna 414 · Kernville, CAVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude/clearance from rising/mountainous terrain. Factors relating to the accident were: the terrain and weather conditions.May 19, 1996 · N111AH · Destroyed NTSB DEN85FA017Accident · Serious injuriesField investigationFinal reportCessna 414 · Cheyenne, WYThe acft collided with the ground during a turn to final from a circling approach (IFR) at Cheyenne airport. According to ATC, the acft was a VFR 'pop up' & was subsequently issued an IFR clearance for an approach into the airport. Examination of the acft at…Oct 23, 1984 · N1569T · Substantial damage NTSB DEN85FA015Accident · Serious injuriesField investigationFinal reportCessna 414-8 · Cheyenne, WYThe acft departed the airport in IFR conditions (snowing) & was observed staggering into the air. Shortly after takeoff the acft struck power lines & crashed into homes in a residential area. Investigation revealed that the acft had accumulated ice & in…Oct 20, 1984 · N1597T · Destroyed