NTSB investigations: Cessna 421C, FL
8 cases on aircraft the registry lists as Cessna 421C. 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.
Cases per year
| 1979 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2002 | 1 |
| 2012 | 1 |
| 2018 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND 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'))
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" = 'FL' AND c."eventCountry" = 'USA'
AND 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'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR18LA166Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421C · Plant City, FLThe pilot's delayed decision to abort the takeoff, which resulted in a runway overrun. Contributing to the accident was an engine anomaly for reasons that could not be determined based on the available information, and the pilot's failure to activate the…NTSB ERA13FA082Accident · 1 fatalField investigationFinal reportCessna 421C · Lake Worth, FLThe pilot's failure to follow established engine-out procedures and to maintain a proper airspeed after the total loss of engine power on one of the airplane’s two engines during the initial climb. Contributing to the accident was the total loss of engine…NTSB MIA02LA089Accident · No injuriesLimited investigationFinal reportCessna 421C · Tampa, FLthe fracture of the landing gear upper barrel due to fatigue cracking, caused by improper machining after the barrel was assembled during the manufacturing process, resulting in damage to the airplane.NTSB ATL97LA022Accident · Serious injuriesLimited investigationFinal reportCessna 421C · St. Petersburg, FLimproper installation of the new starter adapter by maintenance personnel.NTSB MIA94FA057Accident · 3 fatalField investigationFinal reportCessna 421C · Titusville, FLFailure of the pilot-in-command to maintain VMC resulting in the inflight loss of control. Contributing to the accident was the fatigue failure of a section of pipe adjacent to a flange which connects to the turbocharger oil outlet of the left engine assembly.NTSB MIA87LA023Accident · No injuriesLimited investigationFinal reportCessna 421C · Tampa, FLThe flt had been cleared for a visual approach behind a Lockheed L-1011 aircraft and was warned to use caution against wake turbulence. The flight encountered the wake turbulence of the L-1011 at 1600 feet. Control could not be maintained and the aircraft…NTSB MIA86FA014Accident · Minor injuriesField investigationFinal reportCessna 421C · Ft.Lauderdale, FLThe acft crashed on the arpt during an on demand air taxi flt. The plt stated that on final apch he encountered turbulence and rain. As he broke out of the rain the glare from the sun interferred with his visual perception. A go around was attempted but the…NTSB MIA79FLD59Accident · No injuriesClosedCessna 421C · Kenansville, FL