NTSB investigations: Cessna 421C

7 cases on aircraft the registry lists as Cessna 421C, where the first occurrence was “Loss of engine power”. 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

19862026

NTSB investigations: Cessna 421C per year, 1986–2026: 7 cases
1986	1
1994	2
1995	1
1996	1
1999	1
2005	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 ('2076016', '2076017') 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" = 350)) 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 ('2076016', '2076017')
      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\" = 350))
  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 ('2076016', '2076017')
    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" = 350))
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 CHI05FA212Accident · Minor injuriesField investigationFinal reportCessna 421C · Wheeling, ILThe pilot's improper in-flight decision to execute a go-around without raising the landing gear and raising the flaps to the full UP position, resulting in low airspeed and the airplane stalling. Contributing factors to the accident included the pilot's…Aug 5, 2005 · N421KC · Destroyed NTSB MIA99FA180Accident · 4 fatalField investigationFinal reportCessna 421C · Charlotte, NCThe failure of the pilot to shutdown the right engine and feather the propeller after a reported loss of power in the engine shortly after takeoff resulting in the airplane descending, colliding with trees and then the ground.Jun 14, 1999 · N421LL · Destroyed NTSB ATL97LA022Accident · Serious injuriesLimited investigationFinal reportCessna 421C · St. Petersburg, FLimproper installation of the new starter adapter by maintenance personnel.Dec 8, 1996 · N5195C · Substantial damage NTSB LAX95FA319Accident · 8 fatalField investigationFinal reportCessna 421C · Beaver Dam, AZFailure of the pilot to maintain adequate airspeed, while maneuvering on approach, which resulted in an inadvertent stall/spin and uncontrolled collision with terrain. Factors relating to the accident were: the pilot allowed the aircraft weight and balance…Sep 2, 1995 · N6234G · Destroyed NTSB LAX94FA257Accident · 2 fatalField investigationFinal reportCessna 421C · Carlsbad, CAA loss of engine power for undetermined reasons. The pilot's failure to raise the flaps and maintain altitude were factors in the accident.Jun 15, 1994 · N421AG · Destroyed NTSB FTW94FA082Accident · 2 fatalField investigationFinal reportCessna 421C · San Antonio, TXImproper servicing of the airplane with jet fuel, which resulted in preignition and/or detonation and subsequent failure of pistons in both engines. A factor related to the accident was: the lack of a restrictive mating nozzle on the refueling truck.Feb 10, 1994 · N741CA · Destroyed NTSB ATL86FA227Accident · No injuriesField investigationFinal reportCessna 421C · Nashville, TNDuring a normal takeoff the pilot experienced a dual engine failure about 10 feet above the runway. The pilot stated that he landed on the remaining runway and attempted an 80 degree left turn onto taxiway 'c'. The aircraft failed to negotiate the turn at the…Aug 25, 1986 · N5299J · Substantial damage