OpenAirDocs.org

NTSB investigations: Lycoming 0-320 series, AL

7 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of control - in flight”. 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

19842026

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 c.\"eventStateOrRegion\" = 'AL' 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 ('41508')
      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\" = 250))
  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 ATL05CA062Accident · Minor injuriesData collectionFinal reportCessna 172P · Redstone Arsnl, ALThe pilot's failure to maintain adequate airspeed during approach, which resulted in an inadvertent stall and subsequent collision with the runway. Factors were the turbulence and crosswind conditions.Mar 12, 2005 · N5456K · DestroyedNTSB ATL04LA013Accident · No injuriesLimited investigationFinal reportCessna 172P · Pell City, ALThe pilot's inadequate compensation for wind and his failure to maintain directional control during landing. A factor was the crosswind.Oct 12, 2003 · N52254 · Substantial damageNTSB ATL02LA061Accident · 1 fatalLimited investigationFinal reportMoore Sammie M-Breezy · Pell City, ALThe pilot's failure to maintain flying speed, followed by an inadvertent stall spin, and subsequent collision with terrain.Mar 8, 2002 · N9167C · DestroyedNTSB MIA96FA185Accident · 1 fatalField investigationFinal reportChampion Aeronca 7GCB · Fairhope, ALfailure of the pilot to maintain adequate airspeed, while manuevering at low altitude, which resulted in an inadvertent stall and uncontrolled impact with the water. The pilot's ostentatious display and the lack of altitude to recover from a stall were…Jul 15, 1996 · N9908Y · Substantial damageNTSB ATL92LA041Accident · No injuriesLimited investigationFinal reportCessna 172I · Gadsden, ALThe improper recovery from a bounced landing by the pilot under examination, and his subsequent failure to maintain directional control. Inadequate supervision by the designated examiner was a factor.Jan 22, 1992 · N35308 · Substantial damageNTSB ATL85FA067Accident · 2 fatalField investigationFinal reportRobinson R-22 Alpha · Huntsville, ALA popping sound then a loud noise and a puff of smoke preceded the helicopter's fall to the ground, stated a 12 year old boy who said he saw the accident. Examination of the helicopter failed to disclose any trace of fire. However one main rotor blade…Dec 25, 1984 · N8475K · DestroyedNTSB ATL85LA004Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Ozark, ALThe student plt was on her fourth supervised solo flt. During the ground roll of her fourth landing the acft started to go left of the rwy centerline. The plt said she over corrected twice and ended up heading off the rwy toward a ditch. Inan attempt to…Oct 9, 1984 · N5065Z · Substantial damage