NTSB investigations: Continental 0-200 series, CA
16 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Loss of control - on ground/water”. 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 | 2 |
| 1987 | 1 |
| 1989 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2005 | 2 |
| 2007 | 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\" = 260))
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" = 260))
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 LAX07CA284Accident · Minor injuriesData collectionFinal reportCessna 150M · Sonoma, CAThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control while landing.NTSB LAX05LA154Accident · No injuriesLimited investigationFinal reportKittleson Quickie Q-200 · Santa Barbara, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control.NTSB LAX05CA096Accident · No injuriesData collectionFinal reportAeronca 7EC · Grass Valley, CAthe pilot's failure to maintain directional control.NTSB LAX00LA120Accident · No injuriesLimited investigationFinal reportCessna 150E · Reedley, CAA loose seat latch which permitted the seat to move aft to a position where the pilot could no longer reach the controls.NTSB LAX97LA234Accident · No injuriesLimited investigationFinal reportCessna 150G · Barstow, CAThe student pilot's inability to attain directional control of the aircraft due to an improperly adjusted parking brake spring.NTSB LAX93LA334Accident · No injuriesLimited investigationFinal reportCessna A150M · Sacramento, CAThe dual student pilot's failure to maintain directional control, improper use of the flight controls, and failure to relinquish the flight controls to the CFI. The soft dirt was a factor in this accident.NTSB LAX92LA370Accident · No injuriesLimited investigationFinal reportCessna 150G · Woodland, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll. Factors in the accident were the students lack of total experience and the soft nature of the recently plowed field the aircraft encountered.NTSB LAX89LA299Accident · No injuriesLimited investigationFinal reportCessna 150M · Riverside, CAThe student pilot's failure to maintain directional control, which resulted in an inadvertent ground swerve. Factors related to the accident were: the student's lack of recent experience and improper training by her flight instructor.NTSB LAX89LA096Accident · No injuriesLimited investigationFinal reportCessna 150H · Napa, CAThe cfi's delay in aborting the takeoff, leading to a loss of directional control.NTSB LAX87LA329Accident · No injuriesLimited investigationFinal reportCessna 150 · Franklin, CAThe student pilot was on his first flight in the aircraft after it had been modified with a tail wheel conversion. During the landing, he lost control and the aircraft ground looped. No preimpact part failure or malfunction was evident.NTSB LAX85LA017Accident · No injuriesLimited investigationFinal reportCessna 150M · Camarillo, CAPlt lost directional control of acft just prior to takeoff rotation. Acft continued off left side of rwy into a plowed field despite attempted remedial action. Nose gear collapsed.NTSB LAX84LA456Accident · No injuriesLimited investigationFinal reportCessna 150G · Apple Valley, CAThe student was receiving instruction in soft field landings & rudder control during the landing roll-out. A downwind approach was made to rwy 18 which had a downward gradient of 1.5%. Flaps were used for the approach & the acft touched down about 1/3 of the…NTSB LAX83LA182Accident · No injuriesLimited investigationFinal reportCessna 150H · Corona, CAThe acft nosed over during the landing roll while being used on a dual instructional flight. The instructor was demonstrating night landing technique to her student. During the last landing directional control was lost when the nosegear touched down. The acft…NTSB LAX83LA070Accident · No injuriesLimited investigationFinal reportCessna 150L · Palo Alto, CAThe pilot and his passenger returned to the airport after a local night flight. Upon landing the nose wheel began to shimmy and then the aircraft departed the left side of the runway. After leaving the runway the nose gear collapsed. During his pre-flight the…NTSB LAX82DA128Accident · No injuriesFinal reportCessna 150 · Mendota, CAThe pilot stated he was looking out the left window for the taxiway when the aircraft ran off the runway into a soft field.NTSB LAX82DVM10Accident · No injuriesFinal reportTaylorcraft F19 · Mt. Hamilton, CAAfter landing, the pilot's right heel slipped off of the right heel brake while he was applying brakes. Subsequently, the aircraft veered to the left before he released the left brake. The right main gear collapsed as the aircraft stopped in a small ditch…