NTSB investigations: Cessna 421A, 1983
3 cases on aircraft the registry lists as Cessna 421A. 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
| 1969 | 2 |
|---|---|
| 1970 | 1 |
| 1971 | 4 |
| 1972 | 3 |
| 1973 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 2 |
| 1979 | 2 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 3 |
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 4 |
| 1993 | 1 |
| 1994 | 2 |
| 1997 | 1 |
| 2000 | 1 |
| 2010 | 1 |
| 2013 | 1 |
| 2014 | 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 year(c.\"eventDate\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2076012'))
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 year(c."eventDate") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2076012'))
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 DEN83FA193Accident · 1 fatalField investigationFinal reportCessna 421A · West Jordan, UTInvestigation revealed that the plt aborted two takeoff attempts due to a 'roughness' in one eng. Not able to duplicate the roughness during subsequent ground checks, the plt departed. At an alt of 300 AGL the left eng began to surge and the right eng,…NTSB FTW83LA300Accident · No injuriesLimited investigationFinal reportCessna 421A · Forth Worth, TXThe acft ran off the departure end of the rwy and collided with a fence and septic tank complex. The plt said he attempted to use the brakes without success. The acft had an annual inspection on 5/5/83. The brakes were examined afterthe accident. The brake…NTSB ATL83AA235Accident · 8 fatalFinal reportCessna 421A · Atmore, ALAbout 20 mins after takeoff the plt reported the right eng had lost power & the acft would not maintain alt. Vectors were provided for an emergency landing, but the acft crashed in a wooded area about 3 mi from the arpt. There was evidence that the gear &…