NTSB investigations: Lycoming 0-235 series, 2018

40 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, 2018 per year, 1964–2026: 4,597 cases
1964137
1965122
196698
196792
196878
196954
197074
197182
197273
197368
197468
197569
197664
197786
1978152
1979167
1980153
1981147
1982148
1983149
1984148
1985101
198699
1987120
1988111
1989100
199086
199185
199268
199373
199472
199584
199674
199777
199869
199958
200076
200176
200267
200353
200461
200572
200647
200755
200846
200950
201030
201136
201239
201335
201419
201523
201642
201733
201840
201933
202030
202123
202232
202325
202410
202523
202615

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\") = 2018
    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 CEN19LA064Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Horseshoe Bay, TXThe pilot's inadequate preflight and in-flight fuel planning, which resulted in the total loss of engine power due to fuel exhaustion.Dec 29, 2018 · N6202M · Substantial damageNTSB ERA19LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Bell Glade, FLA partial loss of engine power due to the No. 1 cylinder's valve keeper becoming dislodged, which ultimately resulted in the intake valve becoming stuck in the valve guide and in the loss of compression to the cylinder.Dec 17, 2018 · N4886B · Substantial damageNTSB GAA19CA080Accident · No injuriesData collectionFinal reportPiper PA 12 · Burlington, WAThe pilot's failure to maintain directional control while landing in crosswind conditions.Nov 29, 2018 · N3619M · Substantial damageNTSB ERA19LA022Accident · No injuriesLimited investigationFinal reportPiper PA22 · Brownstown, INThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation. Contributing to the outcome was the student…Oct 20, 2018 · N5581Z · DestroyedNTSB GAA19CA006Accident · No injuriesData collectionFinal reportZenair CH 2000 · Topeka, KSThe pilot's improper landing flare, which resulted in a hard, bounced landing and a subsequent runway excursion.Oct 6, 2018 · N642AM · Substantial damageNTSB GAA19CA019Accident · No injuriesData collectionFinal reportChampion 7ECA · Cleveland, TXThe pilot’s failure to maintain directional control while landing in a gusting crosswind conditions.Oct 5, 2018 · N36268 · Substantial damageNTSB GAA19CA025Accident · No injuriesData collectionFinal reportCessna 152 · Lakeland, FLThe pilot's improper landing flare, which resulted in a hard, bounced landing and the nose gear collapsing.Oct 1, 2018 · N24752 · Substantial damageNTSB GAA19CA003Accident · No injuriesData collectionFinal reportCessna 152 · Farmingdale, NJThe pilot’s failure to maintain clearance from a vehicle while taxiing for departure.Oct 1, 2018 · N94658 · Substantial damageNTSB ANC18FA071Accident · 2 fatalField investigationFinal reportPiper PA-12-150 · Healy, AKAn impact with terrain for reasons that could not be determined based on the available information.Sep 23, 2018 · N7511H · Substantial damageNTSB ERA18LA259Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Augustine, FLThe partial loss of engine power due to a fractured exhaust valve, which resulted in a forced landing on unsuitable terrain and a subsequent rollover.Sep 8, 2018 · N6469P · Substantial damageNTSB GAA18CA535Accident · No injuriesData collectionFinal reportPiper PA 12 · Talkeetna, AKThe pilot’s failure to maintain pitch control on uneven terrain during the landing roll, which resulted in a nose-over.Sep 5, 2018 · N7690H · Substantial damageNTSB GAA18CA522Accident · No injuriesData collectionFinal reportPiper PA 12 · Rexburg, IDThe pilot's improper landing flare, which resulted in the airplane bouncing and a subsequent loss of directional control, a runway excursion, and impact with a fence.Sep 2, 2018 · N4077M · Substantial damageNTSB GAA18CA530Accident · No injuriesData collectionFinal reportPiper PA 12 · Edgewood, NMThe pilot’s failure to maintain directional control during the landing roll.Jul 29, 2018 · N4159M · Substantial damageNTSB GAA18CA461Accident · No injuriesData collectionFinal reportCessna 152 · Oak Harbor, WAThe student pilot's improper landing flare, which resulted in a hard, bounced landing.Jul 27, 2018 · N152LT · Substantial damageNTSB CEN18FA277Accident · 1 fatalClass 2 · FieldFinal reportCessna 152 · Fort Rice, NDThe pilot's failure to use carburetor heat in conditions that were conducive to serious carburetor icing, which resulted in a loss of engine power, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall. Contributing to the…Jul 17, 2018 · N24515 · Substantial damageNTSB GAA18CA427Accident · Minor injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot’s inadvertent encounter with thunderstorm conditions and her failure to maintain a proper landing flare in a crosswind, which resulted in a bounced landing.Jul 16, 2018 · N5551L · Substantial damageNTSB GAA18CA426Accident · No injuriesData collectionFinal reportPiper PA 20 · Dayton, OHThe pilot's inadequate compensation for variable crosswind conditions during landing, which resulted in a runway excursion.Jul 14, 2018 · N7492K · Substantial damageNTSB GAA18CA500Accident · No injuriesData collectionFinal reportCessna 152 · Sacramento, CAThe student pilot's improper landing flare, which resulted in a hard, bounced landing.Jun 30, 2018 · N4962L · Substantial damageNTSB GAA18CA419Accident · No injuriesData collectionFinal reportCessna 152 · Panama City, FLThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.Jun 30, 2018 · N89887 · Substantial damageNTSB ERA18LA175Accident · Minor injuriesLimited investigationFinal reportAircraft Mfg & Development CH 2000 · Newburyport, MAThe pilot's failure to adequately compensate for existing crosswind conditions during the final approach and landing flare, which led to the airplane drifting left of the runway, and his delayed decision to go around, which resulted in the airplane touching…Jun 20, 2018 · N239AM · Substantial damageNTSB GAA18CA350Accident · No injuriesData collectionFinal reportCessna 152 · Denison, TXThe student pilot’s improper landing flare in crosswind conditions, which resulted in a hard, bounced landing.Jun 14, 2018 · N67404 · Substantial damageNTSB GAA18CA357Accident · No injuriesData collectionFinal reportBellanca 7ECA · Fairbanks, AKThe airplane’s collision with a bird while maneuvering.Jun 6, 2018 · N8646V · Substantial damageNTSB ERA18LA158Accident · No injuriesClass 3 · LimitedFinal reportBellanca 7ECA · Warsaw, KYThe pilot’s inadequate preflight performance planning, and his delayed decision to abort the takeoff, which resulted in a ground loop.Jun 3, 2018 · N8698 · Substantial damageNTSB GAA18CA320Accident · No injuriesData collectionFinal reportPiper PA 12 · Nulato, AKThe pilot’s improper landing flare, which resulted in a hard landing on upsloping terrain, and his subsequent failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in…Jun 2, 2018 · N3937M · Substantial damageNTSB GAA18CA302Accident · No injuriesData collectionFinal reportTaylorcraft F21 · Payette, IDThe student pilot’s failure to maintain directional control during landing with a crosswind and his subsequent failure to maintain airspeed during an aborted landing, which resulted in a collision with terrain and nose-over.May 28, 2018 · N2004U · Substantial damageNTSB WPR18LA148Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Hillsboro, ORThe partial loss of engine power during a go-around due to the loose copper electrode finger inside the left magneto.May 26, 2018 · N152GB · Substantial damageNTSB GAA18CA343Accident · Serious injuriesData collectionFinal reportAmerican AA · Port Orange, FLThe pilot’s inadequate preflight inspection of the fuel, which resulted in fuel exhaustion and a subsequent total loss of engine power.May 24, 2018 · N5787L · Substantial damageNTSB CEN18LA173Accident · Serious injuriesLimited investigationFinal reportGrumman American Avn. AA 1B · Hamilton, OHThe loss of engine power during takeoff for reasons that could not be determined because postaccident examination revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.May 15, 2018 · N6550L · Substantial damageNTSB GAA18CA279Accident · No injuriesData collectionFinal reportChampion 7ECA · Morrilton, ARThe pilot’s failure to maintain directional control in variable crosswind conditions.May 12, 2018 · N6333N · Substantial damageNTSB GAA18CA261Accident · Minor injuriesData collectionFinal reportZenair CH 2000 · Naples, FLThe student pilot’s improper landing flare, which resulted in a bounced landing.May 7, 2018 · N699ZA · Substantial damageNTSB WPR18LA135Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 152 · Tamiami, FLThe non-instrument-rated pilot’s loss of control during an encounter with instrument meteorological conditions at night. Contributing to the accident was the pilot's decision to depart on the flight without obtaining approval to fly at night in accordance…May 4, 2018 · N6198Q · Substantial damageNTSB GAA18CA242Accident · No injuriesData collectionFinal reportSeno Louis C SR KIS · Eagle Lake, TXThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions.Apr 29, 2018 · N66SK · Substantial damageNTSB CEN18LA151Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Cullman, ALThe pilot’s inadvertent engine shutdown due to excessive leaning of the engine and his subsequent inability to restart the engine.Apr 25, 2018 · N89904 · Substantial damageNTSB GAA18CA227Accident · No injuriesData collectionFinal reportIrvin Stephen D Rutan Long E Z · Tucson, AZThe pilot’s excessive ground speed and loss of directional control while exiting the taxiway.Apr 22, 2018 · N8714S · Substantial damageNTSB GAA18CA215Accident · No injuriesData collectionFinal reportPage Russell L Long EZ · Wakefield, VAThe pilot’s failure to secure the canopy before flight, which resulted in the airplane striking a fence during the approach. Contributing to the accident was the pilot’s failure to follow the Before Takeoff checklist and In-flight Canopy Opening checklist…Apr 13, 2018 · N27RP · Substantial damageNTSB WPR18LA118Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Bozeman, MTThe student pilot and flight instructor's failure to see and avoid the stationary airplane during taxi, which resulted in a ground collision.Apr 4, 2018 · N621ZC · 2 aircraft · Substantial damageNTSB GAA18CA177Accident · No injuriesData collectionFinal reportCessna 152 · Snohomish, WAThe pilot’s decision to land with a tailwind and in his failure to maintain pitch control of the airplane in gusting wind conditions.Mar 12, 2018 · N6509L · Substantial damageNTSB CEN18LA114Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Odessa, TXThe pilot’s improper takeoff procedures and his failure to abort the takeoff, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s lack of experience in the airplane.Mar 1, 2018 · N6699B · Substantial damageNTSB GAA18CA130Accident · No injuriesData collectionFinal reportPiper PA 16 · Phoenix, AZThe pilot’s failure to maintain directional control while landing in crosswind conditions.Feb 13, 2018 · N5726H · Substantial damageNTSB WPR18FA075Accident · 1 fatalField investigationFinal reportCessna 152 · Concord, CAA loss of control for reasons that could not be determined based on the available information.Jan 29, 2018 · N93316 · Substantial damage