Fatal NTSB investigations: Continental 0-200 series
8 cases on aircraft whose registry engine model is Continental 0-200 series, 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.
Cases per year
| 1988 | 1 |
|---|---|
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2005 | 1 |
| 2007 | 3 |
Where
Latest 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17020')
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17020')
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" 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 DFW08FA004Accident · 2 fatalField investigationFinal reportCessna 150L · Castroville, TXLoss of engine power for undetermined reasons and the pilot receiving instruction's failure to maintain aircraft control resulting in the stall. A factor contributing to the accident was the instructor pilot's delayed remedial action.NTSB NYC07LA171Accident · 1 fatalLimited investigationFinal reportMidget Mustang M-1 · Covode, PAA loss of engine power for undermined reasons.NTSB SEA07LA126Accident · 1 fatalLimited investigationFinal reportCessna 150G · Pahrump, NVThe loss of engine power due to fuel contamination followed by the pilot's failure to maintain aircraft control during takeoff. Contributing factors were the pilot's inadequate preflight and an inadequate 100-hour maintenance inspection by other maintenance…NTSB ANC05FA070Accident · 1 fatalField investigationFinal reportTaylorcraft F-19 · Fairbanks, AKThe pilot's failure to maintain a minimum airspeed during a low-altitude turn to return to the airport, and his improper in-flight decision to initiate a steep, low altitude turn, which resulted in an inadvertent stall/spin, and an in-flight collision with…NTSB FTW01FA014Accident · 1 fatalField investigationFinal reportCessna 150L · Rockport, TXthe loss of engine power for undetermined reasons, and the pilot's subsequent failure to maintain control of the airplane during the ensuing forced landing.NTSB ATL98LA033Accident · 1 fatalLimited investigationFinal reportCessna 150L · Guntersville, ALThe pilot's intentional shut down of the engine in flight that resulted in the total loss of engine power. A factor was the failure of both magnetos.NTSB NYC97FA043Accident · 2 fatalField investigationFinal reportCessna 150L · Collegeville, PAThe loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed during the forced landing, which resulted in a stall and collision with the ground. A contributing factor was wind gusts.NTSB FTW89FA015Accident · 2 fatalField investigationFinal reportCessna A150K · Flint, TXThe airplane was observed flying on an easterly heading at low altitude, with the propeller stopped. One of the witnesses said the airplane was gliding toward him and when close he started running away. He said the airplane abruptly turned left and went…