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

19822026
NTSB investigations: Continental 0-200 series, CA per year, 1982–2026: 16 cases
19822
19832
19842
19871
19892
19921
19931
19971
20001
20052
20071

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.

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.May 6, 2007 · N45316 · Substantial damageNTSB 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.May 1, 2005 · N200AL · Substantial damageNTSB LAX05CA096Accident · No injuriesData collectionFinal reportAeronca 7EC · Grass Valley, CAthe pilot's failure to maintain directional control.Feb 14, 2005 · N4725E · Substantial damageNTSB 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.Mar 7, 2000 · N6194T · Substantial damageNTSB 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.Jul 7, 1997 · N458AE · Substantial damageNTSB 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.Aug 23, 1993 · N9861J · Substantial damageNTSB 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.Aug 29, 1992 · N2421J · Substantial damageNTSB 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.Sep 2, 1989 · N6289K · Substantial damageNTSB LAX89LA096Accident · No injuriesLimited investigationFinal reportCessna 150H · Napa, CAThe cfi's delay in aborting the takeoff, leading to a loss of directional control.Jan 21, 1989 · N22988 · Substantial damageNTSB 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.Sep 7, 1987 · N704XV · Substantial damageNTSB 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.Oct 13, 1984 · N8989U · Substantial damageNTSB 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…Aug 26, 1984 · N76VP · Substantial damageNTSB 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…Apr 7, 1983 · N7243S · Substantial damageNTSB 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…Jan 11, 1983 · N19304 · Substantial damageNTSB 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.Apr 5, 1982 · N8760U · Substantial damageNTSB 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…Feb 3, 1982 · N3579T · Substantial damage