NTSB investigations: Continental 0-200 series, 2012

8 cases on aircraft whose registry engine model is Continental 0-200 series, where the defining event was Loss of control in flight. 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

20082026
NTSB investigations: Continental 0-200 series, 2012 per year, 2008–2026: 68 cases
20081
20097
20102
20118
20128
20135
20142
20157
20161
20173
20182
20191
20201
20213
20223
20238
20243
20251
20262

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\") = 2012
    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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240'))
  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 CEN13CA087Accident · No injuriesData collectionFinal reportCessna 150F · Red Oak, IAThe loss of control while landing due to the solo student pilot's delay to execute a go-around and his improper control inputs during a bounced landing.Nov 20, 2012 · N8000S · Substantial damageNTSB ERA13CA051Accident · No injuriesData collectionFinal reportCessna 150L · Seneca Falls, NYThe pilot’s inadequate compensation for wind conditions during landing, which resulted in an impact with a drainage ditch.Oct 21, 2012 · N1791Q · Substantial damageNTSB ERA12FA583Accident · 2 fatalField investigationFinal reportCessna 150M · Fredericksburg, VAThe pilot's failure to maintain airplane control during initial climb. Contributing to the accident was the pilot's impairment due to alcohol.Sep 29, 2012 · N66246 · Substantial damageNTSB CEN12LA552Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Tribune, KSThe pilot's failure to maintain clearance from a corn crop.Aug 17, 2012 · N6006J · Substantial damageNTSB ERA12CA390Accident · No injuriesData collectionFinal reportCessna 150H · Alabaster, ALThe pilot's failure to maintain directional control while landing in gusting wind conditions.Jun 9, 2012 · N6963S · Substantial damageNTSB ANC12LA031Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Fairbanks, AKThe student pilot did not control the airplane’s pitch attitude, which resulted in an aerodynamic stall during the takeoff initial climb. Contributing to the accident was the pilot’s failure to use the pre-takeoff checklist.Apr 22, 2012 · N7911F · Substantial damageNTSB ERA12FA151Accident · 1 fatalField investigationFinal reportCessna 150G · Quincy, FLThe non-instrument-rated pilot’s spatial disorientation in night instrument meteorological conditions, which resulted in his inability to maintain controlled flight. Contributing to the accident was the pilot’s improper decision to take off in deteriorating…Jan 23, 2012 · N73JK · Substantial damageNTSB CEN12LA133Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Denmark, WIThe pilot’s loss of control due to his alcohol impairment. Contributing to the accident was the pilot's decision to fly at night with a known interior lighting malfunction.Jan 12, 2012 · N60676 · Substantial damage