NTSB investigations: Lycoming 0-320 series, 1987, TX

6 cases on aircraft whose registry engine model is Lycoming 0-320 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-320 series, 1987, TX per year, 1964–2026: 916 cases
196428
196525
196630
196727
196834
196933
197030
197116
197224
197314
197420
197518
197626
197723
197823
197924
198019
198122
198225
198314
198411
198511
198613
19876
19887
19897
19908
199110
199211
199316
19944
19958
199613
199713
199810
199913
200011
20019
200217
200320
200414
200510
200614
20077
200813
200910
201011
201112
20127
20137
201410
201511
20168
20177
20186
20196
202013
20219
202211
202310
20249
20257
202611

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\") = 1987
    AND c.\"eventStateOrRegion\" = 'TX' 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'))
  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 FTW87LA207Accident · Minor injuriesLimited investigationFinal reportMooney M20 · Livingston, TXDrg a practice touch-&-go lndg, the acft bounced. The plt applied power to abort the lndg, but lost directional control of the acft. It drifted left toward trees, so he initiated a climb to fly over the obstructions. However, the acft stalled & collided with…Sep 3, 1987 · N894B · Substantial damageNTSB FTW87LA157Accident · No injuriesLimited investigationFinal reportCessna 172L · Houston, TXWhile lndg, the student plt had flared the acft in a rgt x-wind with gusts to 13 KTS. Subsequently, the acft drifted left & the left main gear went into soft mud. The acft then veered to the left and was damaged.Jul 3, 1987 · N3980Q · Substantial damageNTSB FTW87LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Port Aransas, TXThe engine lost power while on the downwind leg of the traffic pattern. The pilot made a 180 degree turn and attempted to reach the runway. Touchdown occurred about 15 feet short and the landing gear impacted a sandy embankment. The aircraft then slid to a…May 24, 1987 · N6426W · Substantial damageNTSB FTW87FA087Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Leakey, TXFlight instructor and student pilot flying Piper PA-28-140 departed uncontrolled airport after switching fuel tanks on runway. Fuel selector valve was inadvertently moved to off position by student pilot. Aircraft engine quit on initial climb at approximately…Mar 31, 1987 · N4602R · Substantial damageNTSB FTW87LA076Accident · No injuriesLimited investigationFinal reportCessna 172P · Roanoke, TXAircraft ballooned twice after touchdown followed by hard landing on nosegear resulting in substantial damage.Mar 13, 1987 · N64943 · Substantial damageNTSB FTW87LA046Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Worth, TXThe nose gear strut depressed more than normal following what the student plt thought was a normal touchdown and the acft veered off the rwy. As control was lost, the nose gear tire blew and the acft subsequently struck a VASI light collapsing the nose gear.…Jan 21, 1987 · N4901G · Substantial damage