NTSB investigations: Continental 0-200 series, 2000, CA

7 cases on aircraft whose registry engine model is Continental 0-200 series. 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

19642026
NTSB investigations: Continental 0-200 series, 2000, CA per year, 1964–2026: 793 cases
196420
196524
196646
196749
196850
196945
197042
197138
197229
197323
197434
197525
197628
197727
197826
197923
198016
198115
198210
198311
198413
198511
198612
19879
198811
19898
19909
19914
19926
199310
19944
19958
19966
19974
19985
19996
20007
200111
20022
20032
20041
20058
20064
20073
20083
20093
20113
20124
20132
20151
20161
20173
20184
20194
20203
20217
20226
20254

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.\"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'))
  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 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…Sep 9, 2000 · N76261 · Substantial damageNTSB LAX00LA301Accident · Minor injuriesLimited investigationFinal reportFollmer Q200 · Corona, CAThe failure and separation of one wooden propeller blade for undetermined reasons.Aug 15, 2000 · N8427 · DestroyedNTSB LAX00LA296Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Carlsbad, CAA catastrophic internal engine failure for undetermined reasons.Aug 12, 2000 · N6500T · DestroyedNTSB 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.Aug 9, 2000 · N7011S · Substantial damageNTSB LAX00LA237Accident · No injuriesLimited investigationFinal reportCessna 150M · El Monte, CAThe inadequate maintenance inspection by other maintenance personnel of the exhaust system that resulted in an eroded muffler that allowed hot gases to impinge on magneto wiring and resulted in loss of engine power. A factor was the soft terrain at the forced…Jun 21, 2000 · N704QJ · 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 LAX00LA081Accident · No injuriesLimited investigationFinal reportCessna 150F · Windsor, CAThe pilot's inadequate preflight planning in that he did not perform a fuel calculation, and his failure to verify the fuel quantity on board the airplane, which resulted in fuel exhaustion and subsequent collision with the ground.Jan 29, 2000 · N8281F · Substantial damage