OpenAirDocs.org

NTSB investigations: Lycoming 0-320 series, FL

18 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “In flight collision with object”. 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

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\" = '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 ('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\" = 220))
  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 NYC08CA055Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Tallahassee, FLThe pilot's misjudged clearance over obstacles during final approach.Dec 8, 2007 · N5921D · Substantial damageNTSB MIA06CA134Accident · Minor injuriesData collectionFinal reportCessna 172N · Pensacola, FLThe student pilot's failure to raise the wing flaps for a go-around resulting in the airplane not climbing and an in-flight collision with trees.Sep 3, 2006 · N1210F · Substantial damageNTSB MIA06CA009Accident · No injuriesData collectionFinal reportCessna 172N · Punta Gorda, FLThe in-flight collision with a bird resulting in substantial damage to the airplane.Oct 2, 2005 · N952AC · Substantial damageNTSB MIA03FA066Accident · 1 fatalField investigationFinal reportCessna 172P · Osteen, FLThe intentional suicidal act by the pilot-in-command resulting in the in-flight collision with trees then the ground.Feb 25, 2003 · N97890 · DestroyedNTSB ATL00LA059Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Indiantown, FLThe student pilot's failure to maintain altitude clearance during initial climb following takeoff during the commission of a crime, resulting in an in-flight collision with a tree.Jun 5, 2000 · N337VH · Substantial damageNTSB MIA97LA007Accident · No injuriesLimited investigationFinal reportCessna 172N · Fruitland Park, FLThe pilot's inadequate compensation for wind conditions and failure to maintain proper runway alignment during takeoff. The unfavorable wind condition was a related factor.Oct 19, 1996 · N5155E · Substantial damageNTSB MIA93FA160Accident · 4 fatalField investigationFinal reportPiper PA-28 · Morriston, FLVFR flight by the pilot(s) into instrument meteorological conditions (IMC) and failure to maintain adequate altitude (or clearance) from the tower. The proximity of the tower/guy wires and weather condition were related factors.Jul 21, 1993 · N5096W · DestroyedNTSB MIA93LA132Accident · No injuriesLimited investigationFinal reportCessna 172N · Immokalee, FLThe decision of the pilot to buzz and his failure to maintain adequate visual lookout.Apr 12, 1993 · N6542J · Substantial damageNTSB MIA92LA136Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Live Oak, FLImproper planning/decision by the pilot, and his improper use of the mixture control, which resulted in his failure to attain sufficient altitude to clear trees near the departure end of the runway. The proximity of trees was a related factor.Jun 11, 1992 · N3413T · Substantial damageNTSB MIA90LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Immokalee, FLFailure of the pilot to maintain proper altitude and his failure to maintain adequate visual lookout to see and avoid obstructions. The static line (obstruction) was a contributing factor.Nov 3, 1989 · N4129E · Substantial damageNTSB MIA86LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Sanford, FLWhile on approach to runway the pilots vision was restricted by the glare from the rising sun. The pilot failed to see the operating approach light system which is located in the closed first 2000 feet of runway, and collided with the approach light system.…Sep 23, 1986 · N8200Z · Substantial damageNTSB MIA86FA181Accident · 1 fatalField investigationFinal reportRobinson R22 HP · Lk Buena Vista, FLMotorists obsd the helicopter flying low ovr & along an interstate hiway. In the vicinity of a hiway rest area, the helicopter maneuvered to the side of the hiway, then flew back ovr the median. Two witnesses said it came to a hover, then started to continue…Jun 14, 1986 · N8400C · DestroyedNTSB MIA86LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Leesburg, FLThe plt stated that while attempting to takeoff from a private airstrip his left main wheel hit a barbed wire fence causing the left wing to strike the ground & separate from the acft.Dec 28, 1985 · N8408F · Substantial damageNTSB MIA85LA172Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Orlando, FLThe plt reported that after he arrived & was on an apch to land, he noted 'tape' across the rwy. He remained airborne until the acft passed over 'the taped off area.' He then landed the acft on the rwy which was rough & bumpy. The plt stated that the acft was…May 17, 1985 · N210JA · Substantial damageNTSB MIA83LA161Accident · No injuriesLimited investigationFinal reportCessna 172P · Pensacola, FLThe plt reported that he descended to aprx 50 ft AGL to demonstrate flt at low altitude to his passengers. While flying over a pasture at this altitude, the acft struck a pine tree, damaging the right wing. The plt experienced no control problems & returned…Jun 18, 1983 · N64079 · Substantial damageNTSB MIA83LA040Accident · No injuriesLimited investigationFinal reportCessna 172J · Lowell, FLWhile attempting a go-around maneuver, the aircraft tail struck treetops that were located at the departure end of runway 18. The pilot landed the aircraft safely and discovered damage to the right horizontal stabilizer and the fuselage.Nov 28, 1982 · N79412 · Substantial damageNTSB MIA83LA016Accident · No injuriesLimited investigationFinal reportCessna 172 · St. Augustine, FLUpon landing, the pilot noticed he was too high and executed a go-around. On the next landing the aircraft veered left on the landing roll so the pilot again attempted a go-around. On liftoff the nosewheel hit the airport perimeter fence and the aircraft came…Oct 19, 1982 · N12927 · Substantial damageNTSB MIA82FLD14Accident · 1 fatalFinal reportCessna 172M · Odessa, FLWhile maneuvering at low altitude, the aircraft struck a power line and crashed into a field about 1000 ft south of the airport. The accident occurred at night in heavy fog. An examination of the cable marks on the wreckage indicated the aircraft was in a…Jan 8, 1982 · N80264 · Destroyed