Fatal NTSB investigations: Lycoming 0-290 series

7 cases on aircraft whose registry engine model is Lycoming 0-290 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

19852026
Fatal NTSB investigations: Lycoming 0-290 series per year, 1985–2026: 7 cases
19851
19871
19931
19952
19961
20011

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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41506')
      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 LAX01LA087Accident · 2 fatalLimited investigationFinal reportSutton Tailwind W-8L · Reno, NVThe pilot performed aerobatics at low altitude and failed to maintain clearance from the gound resulting in a collision with the terrain.Feb 4, 2001 · N12079 · DestroyedNTSB FTW97FA002Accident · 1 fatalField investigationFinal reportBell EAA Biplane P · Manzanola, COfailure of the pilot to maintain sufficient altitude/clearance above the terrain, while performing a low altitude maneuver. A factor relating to the accident was the pilot's lack of familiarity with this make and model of aircraft.Oct 2, 1996 · N145DB · DestroyedNTSB ANC95FA157Accident · 1 fatalField investigationFinal reportPiper L-21A · Kaktovik, AKThe pilot's failure to maintain adequate altitude/clearance from mountainous terrain.Aug 18, 1995 · N8373H · DestroyedNTSB ANC95FA095Accident · 1 fatalField investigationFinal reportPiper PA-18 · Nulato, AKThe pilot's failure to maintain adequate airspeed and clearance (altitude) above the water, while maneuvering at low altitude. A factor related to the accident was: the pilot's improper decision to allow a passenger to accompany the flight without a seat belt.Jul 6, 1995 · N8324 · Substantial damageNTSB LAX93FA096Accident · 1 fatalField investigationFinal reportCessna 172P · Sun City, CAThe pilot's decision to initiate VFR flight into instrument meteorological conditions. Factors which contributed to the accident were: the pilot's failure to obtain a weather briefing, the adverse weather, and the mountainous terrain.Jan 20, 1993 · N53908 · DestroyedNTSB LAX87DUJ06Accident · 1 fatalFinal reportDavis Midget Mustang · Kirkland, AZDuring a low level aerobatic flight, the aircraft collided with the terrain after completing a roll. There were no mechanical failures or malfunctions reported. The plt performed the last roll in view of two friends driving in a car near the acc scene.…Jul 3, 1987 · N7SD · DestroyedNTSB ANC85LA132Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Mccarthy, AKThe pilot-in-command was departing from a 600 foot long airstrip at a 3400 foot field elevation. The takeoff run was downslope and the pilot had to pull the airplane off the ground by use of the control stick and the application of full flaps, the 40 degree…Jul 19, 1985 · N1109A · Destroyed