NTSB investigations: Lycoming 0-235 series, 2001, CA

6 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, 2001, CA per year, 1964–2026: 494 cases
19647
19654
19666
19676
19687
19696
19707
19711
19727
19732
19745
19758
19765
197713
197812
197917
198022
198111
198213
198325
198416
198515
198610
198710
198816
198913
199010
19918
19923
199310
199412
199515
19968
19976
19986
19994
200012
20016
20029
20037
200410
20055
20067
200711
20089
200911
20103
20114
20124
201311
20145
20165
20172
20182
20195
20206
20213
20225
20231
20241
20252
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\") = 2001
    AND c.\"eventStateOrRegion\" = 'CA' 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 LAX01LA263Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAthe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion and loss of engine power while on approach for landing.Jul 29, 2001 · N67418 · Substantial damageNTSB LAX01LA168Accident · Minor injuriesLimited investigationFinal reportBeech BE77 · Riverside, CAThe student pilot's failure to maintain appropriate airspeed and to configure the airplane for climb-out.May 8, 2001 · N3865D · Substantial damageNTSB LAX01LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · Hayward, CAthe student pilot's misjudged landing flare and improper use of the elevator control.May 7, 2001 · N757XS · Substantial damageNTSB LAX01LA100Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · San Jose, CAThe pilot's inadequate compensation for the existing crosswind condition and subsequent failure to maintain directional control during the landing rollout.Feb 15, 2001 · N53893 · Substantial damageNTSB LAX01FA101Accident · 4 fatalField investigationFinal reportCessna 152 · Long Beach, CAThe failure of the flight crews of both airplanes to maintain adequate visual lookout for traffic.Feb 15, 2001 · N68763 · 2 aircraft · DestroyedNTSB LAX01LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Livermore, CAThe student pilot's inadequate compensation for a tailwind during final approach and her improper recovery from a bounced landing.Jan 5, 2001 · N6165M · Substantial damage