OpenAirDocs.org

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

8 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

Where

Open the map

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\") = 1997
    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 ATL98LA010Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Punta Gorda, FLThe flight instructor's improper short field takeoff procedure and his decision to abort the takeoff after rotation.Nov 20, 1997 · N93286 · Substantial damageNTSB MIA98LA034Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Palatka, FLthe student pilot's failure to properly secure the oilcap/dipstick within it's integral oil filler tube during his preflight inspection.Nov 18, 1997 · N68327 · Substantial damageNTSB ATL97LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · West Palm Beach, FLthe flight instructor's (CFI's) inaccurate assessment of fuel available for the flight, and his improper in-flight planning/decision by continuing the training flight with minimal fuel, which resulted in fuel exhaustion and loss of engine power.Aug 26, 1997 · N6216Q · Substantial damageNTSB MIA97FA188Accident · 1 fatalField investigationFinal reportBeech 77 · Fort Lauderdale, FLloss of engine power for undetermined reason(s), and failure of the student pilot to remain clear of obstructions, while attempting to make a forced landing.Jun 21, 1997 · N1821B · DestroyedNTSB MIA97LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · La Crosse, FLThe student pilot's failure to maintain a visual look out on landing rollout resulting in an on-ground collision with a berm/furrow, and subsequent nose over. Contributing to the accident was the student pilot's improper fuel management resulting in a total…Apr 10, 1997 · N5442B · Substantial damageNTSB ATL97LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Fernandina Bch, FLinadequate visual lookout by the student pilot, which resulted in a collision with a parked trailer, while his attention was diverted. The proximity of the trailer was a related factor.Mar 5, 1997 · N757HA · Substantial damageNTSB ATL97LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Key West, FLA loss of engine power for undetermined reasons, and the abrupt maneuver that resulted in an aerodynamic stall. A factor was the pilot's failure to maintain clearance from the power lines.Feb 6, 1997 · N67544 · Substantial damageNTSB MIA97LA064Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Boca Raton, FLInadequate inspection of the fuel caps by company maintenance personnel resulting in a cap with a deteriorated seal being allowed to continue in service. This allowed water to leak into the fuel tank which resulted in loss of engine power due to water…Jan 16, 1997 · N69219 · Substantial damage