NTSB investigations: Continental 0-200 series, 2000
4 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Loss of engine power(partial) - 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 | 2 |
|---|---|
| 1983 | 2 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 5 |
| 1988 | 5 |
| 1989 | 2 |
| 1990 | 6 |
| 1991 | 4 |
| 1992 | 7 |
| 1993 | 1 |
| 1994 | 2 |
| 1996 | 3 |
| 1997 | 3 |
| 1999 | 3 |
| 2000 | 4 |
| 2001 | 3 |
| 2002 | 4 |
| 2003 | 4 |
| 2006 | 1 |
| 2007 | 2 |
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\" = 354))
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" = 354))
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 CHI00LA311Accident · No injuriesLimited investigationFinal reportCessna 150H · Michigan City, INfuel contamination (water) and the pilot exceeding his landing field distance. Factors relating to this accident were the pilot inadequate preflight planning/preparation, his having to select an unsuitable landing area, the short landing area, and the marsh.NTSB NYC00LA262Accident · No injuriesLimited investigationFinal reportCessna 150L · Salem, OHA partial power loss for undetermined reasons.NTSB MIA00LA100Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Dandridge, TNthe student pilot's improper preflight that resulted in his operating an aircraft with contaminated fuel that resulted in a loss of engine power and a forced landing in the trees and damage to the aircraft. Contributing to the accident were the student's…NTSB MIA00LA076Accident · No injuriesLimited investigationFinal reportCessna 150L · Statesboro, GAThe partial loss of engine power due to undetermined reasons and unsuitable terrain encountered by the pilot-in-command (CFI), during the forced landing.