NTSB investigations: Continental 0-200 series, 2000
14 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1982 | 17 |
|---|---|
| 1983 | 16 |
| 1984 | 23 |
| 1985 | 15 |
| 1986 | 20 |
| 1987 | 19 |
| 1988 | 13 |
| 1989 | 23 |
| 1990 | 27 |
| 1991 | 14 |
| 1992 | 10 |
| 1993 | 24 |
| 1994 | 17 |
| 1995 | 12 |
| 1996 | 15 |
| 1997 | 17 |
| 1998 | 3 |
| 1999 | 10 |
| 2000 | 14 |
| 2001 | 12 |
| 2002 | 5 |
| 2003 | 8 |
| 2004 | 10 |
| 2005 | 6 |
| 2006 | 13 |
| 2007 | 7 |
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 year(c.\"eventDate\") = 2000
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\" = 353))
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") = 2000
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" = 353))
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 CHI01LA053Accident · No injuriesLimited investigationFinal reportCessna 150M · New Underwood, SDThe pilot's inadequate planning and preparation, which resulted in fuel exhaustion. A factor relating to this accident was the plowed field.NTSB FTW01LA028Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Valley Spring, TXthe loss of engine power due to fuel exhaustion after the pilot became lost during cruise flight. A contributing factor was the dark night condition.NTSB SEA01LA010Accident · No injuriesLimited investigationFinal reportCessna 150C · Sunnyslope, WAThe pilot's decision not to deviate to an alternate airport for fuel after encountering strong headwinds, resulting in fuel exhaustion. Factors contributing to the accident were the unfavorable winds and the sign impacted during the forced landing rollout.NTSB NYC01LA003Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Haverford Twp., PAA loss of engine power due to fuel exhaustion. Also causal was the pilot's inability to locate the airport. A factor in this accident was the dark night conditions.NTSB FTW01LA001Accident · No injuriesLimited investigationFinal reportCessna 150L · Nashville, ARThe pilot's failure to refuel resulting in loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB LAX00LA332Accident · No injuriesLimited investigationFinal reportCessna 120 · Sacramento, CAThe pilot's inadequate preflight planning and his improper use of carburetor heat that resulted in a loss of engine power due to carburetor icing following a delayed takeoff in conditions that were conducive to carburetor icing. A factor was the nonsuitable…NTSB NYC00LA235Accident · No injuriesLimited investigationFinal reportCessna 150F · Friendly, MDThe pilot's inability to locate the airport, which resulted in fuel exhaustion. A factor related to the accident was the night light conditions.NTSB LAX00LA290Accident · No injuriesLimited investigationFinal reportCessna 150H · Corona, CAThe student pilot's inadequate preflight planning which included improper fuel consumption calculations that led to fuel exhaustion and loss of engine power during takeoff.NTSB CHI00LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Eastport, MIthe maneuver, performed by the pilot, to avoid obstructions on highway US.31. Factors were the carburetor icing weather condition, no suitable terrain conditions, the ground terrain condition, and the impacted fence.NTSB SEA00LA122Accident · No injuriesLimited investigationFinal reportCessna 150L · Nampa, IDThe pilot's improper use of the mixture control.NTSB CHI00LA159Accident · No injuriesLimited investigationFinal reportCessna 150M · Bethalto, ILthe improper in-flight decision of the pilot to fly past the Vandalia airport onto Saint Louis Regional and the fuel exhaustion. A factor was the ditch.NTSB MIA00LA162Accident · No injuriesLimited investigationFinal reportCessna A150M · Gainesville, GAThe pilot's failure to use proper soft field landing technique while attempting a forced landing to an open field following a loss of engine power which resulted in a hard landing. Factors in the accident were weather conditions conducive to formation of…NTSB FTW00LA092Accident · No injuriesLimited investigationFinal reportCessna 150K · Davis, OKFuel exhaustion due to the student pilot becoming lost/disoriented. A factor was the lack of suitable terrain for the forced landing.NTSB SEA00LA045Accident · No injuriesLimited investigationFinal reportCessna 150H · Spangle, WAExhaustion of the fuel supply due to a leaking fuel tank system. Factors contributing to the accident were, inaccurate fuel quantity sensors, the lack of suitable terrain in the area of the forced landing, and a fence alongside the dirt upon which the pilot…