OpenAirDocs.org

NTSB investigations: Lycoming 0-320 series, FL

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

19832026

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\" = 230))
  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 MIA01LA101Accident · No injuriesLimited investigationFinal reportRobinson R22 · Okeechobee, FLan in-flight collision with the ground during a simulated engine failure, and autorotation, which resulted in the tailboom separating. A contributing factor in this accident was the pilot allowed the rotor rpm to decay which resulted in inadequate rotor rpm…Mar 16, 2001 · N666BH · Substantial damageNTSB ATL97LA144Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Belleview, FLthe pilot's improper in-flight planning/decision, and his delay in initiating a go-around, which resulted in a hard touchdown, loss of directional control, and collision with objects (fence and trees).Sep 28, 1997 · N3402Z · Substantial damageNTSB MIA92LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Ft Walton Beach, FLThe pilot misjudged his altitude while turning on final approach over water to land at an airport.Jul 19, 1992 · N3292Z · Substantial damageNTSB MIA88FA262Accident · 1 fatalField investigationFinal reportCommens Midget Mustang I · Davie, FLThe private pilot flying the homebuilt aircraft crashed into a swamp, and there were no witnesses. The aircraft was located 4 days later. Friends of the pilot recalled that in the 3 weeks prior to the accident the pilot had bragged to them about the high 'g'…Aug 30, 1988 · N35LC · DestroyedNTSB MIA86FA199Accident · Serious injuriesField investigationFinal reportRobinson R22 · Islamorada, FLWitnesses reported seeing the helicopter flying at approximately 8 to 10 feet off the water. The helicopter entered a left turn and as the turn progressed the helicopter descended striking the water with a skid and cartwheeling.Jul 4, 1986 · N2385X · DestroyedNTSB MIA83LA141Accident · No injuriesLimited investigationFinal reportCessna 172M · Ocean Way, FLThe acft collided with the muddy bank of the intercoastal waterway during the 2nd of two low passes and nosed over when the nose gear dug in. Witnesses report seeing the acft pass at a low altitude. The pilot stated that while flying at lowalt he heard a loud…May 13, 1983 · N71409 · Substantial damage