NTSB investigations: Continental 0-200 series, 1990, TX

9 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, 1990, TX per year, 1964–2026: 506 cases
19647
196522
196626
196734
196819
196922
197020
197120
197212
197316
197426
19756
197616
197712
197813
197915
19809
19818
198211
19835
198412
19857
19865
19878
19886
19896
19909
19916
19925
19939
19946
19956
19964
19974
19984
19999
20002
20014
20023
20034
20047
20051
20066
20076
20082
20092
20101
20111
20121
20133
20151
20164
20174
20183
20192
20205
20211
20224
20236
20242
20254
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\") = 1990
    AND c.\"eventStateOrRegion\" = 'TX' 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 FTW91LA021Accident · Serious injuriesLimited investigationFinal reportCessna 150E · Amarillo, TXAn underpowered takeoff attempt due to incorrectly set magnetos. Contributing was the transmission lines.Dec 7, 1990 · N3956U · DestroyedNTSB DEN91LA023Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Clifton, TXInadvertent stall. Factors were: tailwind, wrong runway selected, and failure to raise flaps.Nov 25, 1990 · N23467 · Substantial damageNTSB FTW90LA182Accident · No injuriesLimited investigationFinal reportCessna 150M · Arlington, TXThe pilot's failure to properly flare the airplane for landing and his failure to initiate the proper recovery procedures following the bounced landing.Sep 24, 1990 · N66689 · Substantial damageNTSB DEN90LA178Accident · No injuriesLimited investigationFinal reportCessna 150J · League City, TXGround collision with an object during the landing roll during a forced landing following a complete power loss. The reason for the power loss is undetermined.Aug 26, 1990 · N60774 · Substantial damageNTSB FTW90LA165Accident · No injuriesLimited investigationFinal reportCessna 150M · Kerrville, TXThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's failure to refuel. Contributing to the accident was the pilot becoming lost.Aug 25, 1990 · N704XJ · Substantial damageNTSB FTW90LA155Accident · No injuriesLimited investigationFinal reportCessna 150H · Houston, TXFuel exhaustion due to refueling not performed.Aug 10, 1990 · N7285S · Substantial damageNTSB FTW90LA149Accident · No injuriesLimited investigationFinal reportCessna 150M · Alvord, TXThe failure of the engine to develop full rated power for unknown reasons.Jul 31, 1990 · N704FS · Substantial damageNTSB FTW90FA138Accident · 1 fatalField investigationFinal reportMingess-Bennett M30 · New Braunfels, TXFailure of the pilot in the overtaking aircraft (N97RJ) to see-and-avoid the aircraft that had been leading (N911HG). Factors related to the accident were: the lack of ability for the pilot in the lead aircraft (911HG) to be able see other aircraft in the…Jul 7, 1990 · N97RJ · 2 aircraft · DestroyedNTSB FTW90FA063Accident · 1 fatalField investigationFinal reportCessna 172M · Tomball, TXFailure of the pilot in Cessna 150, N714RS, to comply with the air traffic control clearance, and failure of both pilots to maintain adequate visual lookout to see-and-avoid each other. Factors related to the accident were: physical impairment of the pilot in…Feb 4, 1990 · N128S · 2 aircraft · Destroyed