NTSB investigations: Lycoming 0-235 series, 1990, FL

9 cases on aircraft whose registry engine model is Lycoming 0-235 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: Lycoming 0-235 series, 1990, FL per year, 1964–2026: 379 cases
19646
19657
19673
19683
19701
19715
19725
19733
19742
19753
19766
19774
197811
19793
19809
198111
198216
198311
198411
19859
19868
198712
19886
198914
19909
199113
19926
19937
199413
199510
19965
19978
19987
199911
20007
20017
20028
20035
20043
20058
20067
200710
20087
20096
20106
20112
20125
20131
20141
20153
20165
20176
20188
20196
20204
20212
20241
20253

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\" = 'FL' 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 ('41505'))
  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 MIA91LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · Deland, FLFailure of the instructor pilot to utilize carburetor heat in icing conditions.Dec 20, 1990 · N25945 · Substantial damageNTSB MIA91LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Palmetto, FLPoor preflight planning by the pilot due to his failure to purchase fuel before departure resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident was the inaccurate fuel gauges.Dec 16, 1990 · N67334 · Substantial damageNTSB MIA91LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa Locka, FLThe pilot's failure to maintain a positive rate of climb while maneuvering to avoid a flock of birds, resulting in an in flight collision with trees. Factor(s) included: attention diverted.Nov 25, 1990 · N25053 · Substantial damageNTSB MIA91LA013Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Miami, FLInadequate preflight of the airplane by the pilot-in-command.Oct 19, 1990 · N23665 · Substantial damageNTSB MIA90LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · Cedar Key, FLThe failure of the pilot to execute a go-around after landing long.Sep 25, 1990 · N93286 · Substantial damageNTSB MIA90LA181Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Opa-Locka, FLEngine failure due to lack of oil supply to the number 3 cylinder connecting rod for undetermined reasons. This allowed the connecting rod end cap to separate through the case resulting in oil exhaustion.Sep 1, 1990 · N70659 · Substantial damageNTSB MIA90FA106Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Marco Island, FLFuel exhaustion due to improper planning & decision by the pilot, and an inadvertent stall/spin while maneuvering for a forced landing.Apr 18, 1990 · N91309 · DestroyedNTSB MIA90LA092Accident · Minor injuriesLimited investigationFinal reportTalmadge Scott Longez · St. Petersburg, FLThe failure of maintenance personnel to properly secure the carburetor throttle cable housing.Mar 18, 1990 · N83TS · Substantial damageNTSB MIA90LA093Accident · No injuriesLimited investigationFinal reportCessna 152 · Mims, FLPilot's poor inflight monitoring of the a/c fuel state which resulted in fuel exhaustion and subsequent engine failure.Mar 14, 1990 · N66949 · Substantial damage