OpenAirDocs.org

NTSB investigations: Lycoming 0-320 series, NH

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\" = 'NH' 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 IAD05LA108Accident · No injuriesLimited investigationFinal reportRobinson R22 · Nashua, NHThe flight instructor's failure to maintain aircraft control during a introductory flight and his inadequate remedial actions.Jul 22, 2005 · N8041J · Substantial damageNTSB NYC92LA154Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Keene, NHAn inadvertent stall during flap retraction, following an aborted landing.Aug 10, 1992 · N738FW · Substantial damageNTSB NYC91LA081Accident · No injuriesLimited investigationFinal reportCessna 172P · Nashua, NHThe failure of the pilot to compensate for wind conditions during landing, resulting in a loss of control and collision with a tree.Mar 1, 1991 · N97313 · Substantial damageNTSB NYC88LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Georges Mills, NHWitnesses reported the wind was gusty and there were whitecaps on the lake when the acft attempted to takeoff. The plt said that when the acft had climbed to a sufficient altitude he began a left turn to climb over the lake. After the turn was started the…Aug 16, 1988 · N2906M · Substantial damageNTSB NYC86LA220Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Rochester, NHPilot made a steep descent and lost directional control. The aircraft collided with the ground while still turning causing the helicopter to roll over.Aug 21, 1986 · N2276X · Substantial damageNTSB NYC85FA109Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · No. Hampton, NHOn April 20, 1985, a Piper PA-28-140, flown by a student plt, crashed during an attempted go-around at north Hampton, NH, while on a pleasure flt. The wx was clear, winds were light and variable with unlimited visibility. The tough rwy is 2050 ft long and 300…Apr 20, 1985 · N95043 · DestroyedNTSB NYC84LA261Accident · No injuriesLimited investigationFinal reportTeal TSC 1A · Moultonboro, NHThe acft struck the tail of an acft as it was beginning to proceed in a go-around. The plt said he was unaware of the collision with the parked acft until the subsequent landing. The collision was the result of the acft in flt drifting downwind off the rwy…Aug 3, 1984 · N2002T · Substantial damage