NTSB investigations: Cessna 414A, 1997
3 cases on aircraft the registry lists as Cessna 414A. 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
| 1965 | 1 |
|---|---|
| 1978 | 1 |
| 1979 | 1 |
| 1981 | 2 |
| 1982 | 2 |
| 1983 | 2 |
| 1984 | 4 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 2 |
| 1990 | 2 |
| 1992 | 2 |
| 1993 | 1 |
| 1995 | 1 |
| 1997 | 3 |
| 1998 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2004 | 2 |
| 2006 | 4 |
| 2007 | 2 |
| 2008 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2019 | 2 |
| 2022 | 1 |
| 2024 | 1 |
| 2026 | 2 |
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\") = 1997
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2075907', '2075910'))
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") = 1997
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2075907', '2075910'))
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 MIA98FA047Accident · 2 fatalField investigationFinal reportCessna 414A · Guyton, GAInadequate maintenance of the cabin pressurization system, which resulted in inadequate pressurization and incapacitation of the pilot due to the hypoxia. Also causal was the pilot's failure to adequately monitor the cabin pressurization system.NTSB ATL97LA124Accident · Minor injuriesLimited investigationFinal reportCessna 414A · Anderson, SCthe pilot misjudged distance and speed on final approach to land and failed to attain a proper touchdown point during the landing, which resulted in an overrun of the runway and collision with a fence. A related factor was the loss of engine power during…NTSB CHI97LA066Accident · No injuriesLimited investigationFinal reportCessna 414 · Springfield, MOthe pilot's continued flight into known icing conditions with an inadequate windscreen deicing system and the diminished visual lookout. Factors were the icing weather conditions and the windscreen ice.