NTSB investigations: Continental 0-200 series, CA
7 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Hard landing”. 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
| 1985 | 1 |
|---|---|
| 1986 | 2 |
| 1991 | 1 |
| 1993 | 1 |
| 1998 | 1 |
| 1999 | 1 |
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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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\" = 200))
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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
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" = 200))
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 LAX99LA239Accident · No injuriesLimited investigationFinal reportCessna 150K · Hesperia, CAThe pilot's misjudged landing flare point and failure to maintain an adequate airspeed margin, resulting in a stall and hard landing.NTSB LAX98LA080Accident · No injuriesLimited investigationFinal reportCessna 150F · San Carlos, CAThe pilot's excessive airspeed, which resulted in a bounced landing, and, his failure to ensure that his seat locking pin was engaged, which caused his seat to move backwards during the touchdown and resulted in his loss of directional control.NTSB LAX93LA094Accident · No injuriesLimited investigationFinal reportCessna 150 · Torrance, CA1) The pilot misjudging the airplane's landing flare, and 2) the pilot's improper recovery from a bounced landing. A factor in this accident was the pilot's lack of total aircraft experience.NTSB LAX92LA073Accident · No injuriesLimited investigationFinal reportCessna 150F · Lancaster, CAThe pilot misjudging the landing flare. A factor in the accident was the pilot's lack of total flight experience.NTSB LAX86LA345Accident · No injuriesLimited investigationFinal reportCessna 150 · Modesto, CAAt the end of one leg of a solo cross-country flight the student pilot experienced a hard landing which resulted in a porpoise on the rwy. The pilot did not realize the severity of the initial bounce and tried to re-flare the aircraft without adding power.…NTSB LAX86LA125Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodland, CAA Cessna 150 collided with the runway surface after the nose wheel collapsed. The student pilot indicated that during the landing flare his attention was diverted by an object that flashed into his view. He overflared to avoid the object and landed hard on…NTSB LAX85LA205Accident · No injuriesLimited investigationFinal reportCessna 150M · Concord, CAThe student was practicing touch & go takeoffs and landings. On the fifth approach to a landing the student plt reported that the acft was a little high and he applied full flaps. The acft bounced on initial touch down. While attempting to recover from the…