NTSB investigations: Lycoming 0-290 series, CA

13 cases on aircraft whose registry engine model is Lycoming 0-290 series, where the first occurrence was “Loss of control - on ground/water”. 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

19822026
NTSB investigations: Lycoming 0-290 series, CA per year, 1982–2026: 13 cases
19821
19832
19881
19901
19931
19951
19982
19991
20001
20032

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 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 ('41506')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
  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 LAX04LA033Accident · Serious injuriesLimited investigationFinal reportDavidson-Thorpe T-18 · Coalinga, CAthe pilot's improper recovery from a bounced landing, and hi failure to maintain directional control during landing rollout.Nov 2, 2003 · N66MY · Substantial damageNTSB LAX04CA026Accident · No injuriesData collectionFinal reportPiper PA-20 · Petaluma, CAthe pilot's inadequate compensation for a crosswind condition and failure to maintain directional control that resulted in a ground loop.Oct 25, 2003 · N7409K · Substantial damageNTSB LAX00LA150Accident · Minor injuriesLimited investigationFinal reportTaylor Smith Witman W-10 · Riverside, CAfailure of the pilot to recover from a bounced landing resulting in a loss of directional control and collision with a fence.Apr 11, 2000 · N90TS · Substantial damageNTSB LAX99LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Novato, CAThe failure of the pilot to adequately compensate for the wind conditions and to maintain directional control of the aircraft while landing. A factor is the airport's failure to follow proper procedure in ensuring adequate obstacle and object free clearance…Mar 31, 1999 · N1244C · Substantial damageNTSB LAX98LA285Accident · No injuriesLimited investigationFinal reportMohr EAA Biplane P · Gilroy, CAFailure of the pilot to adequately compensate for the existing crosswind.Aug 29, 1998 · N883TM · Substantial damageNTSB LAX98LA266Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Rio Vista, CAFailure of the pilot to adequately compensate for the existing wind condition and maintain directional control on rollout.Aug 16, 1998 · N1540A · Substantial damageNTSB LAX96LA030Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Davis, CAthe pilot's failure to maintain directional control during the takeoff roll by diverting his attention.Oct 31, 1995 · N3562A · Substantial damageNTSB LAX93LA305Accident · No injuriesLimited investigationFinal reportAyres Pitts MA-1 · Greenfield, CAThe failure of the pilot to maintain directional control of the airplane during the landing roll and subsequent application of excessive braking that resulted in the airplane nosing over.Jul 5, 1993 · N81999 · Substantial damageNTSB LAX90DUQ01Accident · Minor injuriesFinal reportDavidson Throp T-18 · Camarillo, CAPilots failure to maintain directional control while landing in a crosswind.Jan 6, 1990 · N66MY · Substantial damageNTSB LAX89LA051Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chino, CAThe plt lost directional control of the acft during the landing roll and ground looped. The flight instructor reported that this was the first landing of the day and that they were staying in the traffic pattern to practice touch and go landings on rwy 26.…Nov 19, 1988 · N1441C · Substantial damageNTSB LAX83LA297Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Jackson, CAThe acft went off the rwy and collided with a ditch during landing. The tailwheel acft touched down on rwy 19 about 200 ft past the threshold and bounced. The pilot applied power to recover and lost control of the acft. The acft veered off the rwy to the…Jun 22, 1983 · N1526P · Substantial damageNTSB LAX83LA191Accident · Minor injuriesLimited investigationFinal reportWalston Thorp T-18 · Red Bluff, CAThe acft nosed over in a ditch after leaving the runway during landing. The pilot had made 3 landings and was concludinghis flight when he misjudged his turn to exit the runway and lost control of the acft. The acft went off the paved surface rolled into a…Apr 10, 1983 · N82GW · DestroyedNTSB LAX82DA211Accident · No injuriesFinal reportPiper PA-18 · Colusa, CAThe pilot reported that during a 3-point landing in calm wind conditions, the aircraft veered to the right as soon as the main gear touched down. The pilot stated that he applied full left rudder and brake, but to no avail. The plane continued to the right…Jun 7, 1982 · N2663A · Substantial damage