Fatal NTSB investigations: Continental 0-200 series, TN

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

19682026
Fatal NTSB investigations: Continental 0-200 series, TN per year, 1968–2026: 7 cases
19681
19781
19791
19881
20011
20101
20241

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\" = 'TN' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    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 ERA25FA037Accident · 1 fatalClass 3 · FieldFinal reportCessna 150F · Wilder, TNThe student pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions at night, which resulted in controlled flight into terrain.Oct 31, 2024 · N8110S · DestroyedNTSB ERA10FA503Accident · 1 fatalField investigationFinal reportCessna 150F · Sweetwater, TNThe pilot's inadequate preflight weather planning and improper decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.Sep 26, 2010 · N7915F · Substantial damageNTSB ATL01FA059Accident · 1 fatalField investigationFinal reportCessna 150 G · Dunlap, TNThe pilot's failure to maintain flying speed that resulted in a stall and subsequent loss of control in flight.May 12, 2001 · N3370J · DestroyedNTSB ATL88FA106Accident · 2 fatalField investigationFinal reportCessna 150 · Knoxville, TNThe Cessna made a long straight in final approach. The aircraft's radio transmitter was inop. Afterward the Cessna PIC rpted that initially he saw the Beech on a left base. Later he stated the Beech was heading away from the traffic pattern. Witnesses…Mar 6, 1988 · N60371 · 2 aircraft · Minor damageNTSB IAD79FKW06Accident · 2 fatalClosedCessna 150F · Bristol, TNFeb 20, 1979 · N8555G · Substantial damageNTSB IAD79FA021Accident · 1 fatalClosedCessna 150L · Bolivar, TNDec 4, 1978 · N1540Q · Substantial damageNTSB MIA69A0006Accident · 1 fatalClosedCessna 150 · Woodbury, TNJul 31, 1968 · N5631E · 2 aircraft · Destroyed