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

7 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, 2008, 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\") = 2008
    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 MIA08CA171Accident · Minor injuriesData collectionFinal reportCessna 152 · Ormond Beach, FLBoth pilots' inadequate preflight inspection of the fuel.Aug 23, 2008 · N65436 · Substantial damageNTSB MIA08LA125Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe failure of the No. 3 connecting rod cap due to oil starvation. Contributing to the accident was the contamination of the engine oil.Jun 22, 2008 · N757HA · Substantial damageNTSB MIA08CA113Accident · No injuriesData collectionFinal reportCessna 152 · Okeechobee, FLThe student pilot's improper recovery from a bounced landing.Jun 6, 2008 · N6173L · Substantial damageNTSB NYC08CA161Accident · Minor injuriesData collectionFinal reportCessna 152K · Okeechobee, FLThe loss of engine power during cruise flight due to fuel contamination, and the pilot's inadequate preflight inspection.Apr 14, 2008 · N67334 · Substantial damageNTSB NYC08CA092Accident · Minor injuriesData collectionFinal reportKral Series 5 Kitfox · Fruitland Park, FLThe pilot's failure to maintain adequate clearance from obstructions during the landing approach. Contributing to the accident was the reduced visibility due to sunglare and haze.Feb 3, 2008 · N97GK · DestroyedNTSB NYC08CA094Accident · Minor injuriesData collectionFinal reportPiper J3-C65 · Hollywood, FLThe pilot's failure to maintain directional control while landing. Contributing was the gusty crosswind condition.Jan 29, 2008 · N2143M · Substantial damageNTSB NYC08CA080Accident · No injuriesData collectionFinal reportCessna C-152 · Labelle, FLThe pilot's improper decision to takeoff from an inadequate field after a forced landing.Jan 11, 2008 · N48251 · Substantial damage