NTSB investigations: Lycoming O&VO-360 series, TX

9 cases on aircraft whose registry engine model is Lycoming O&VO-360 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations: Lycoming O&VO-360 series, TX per year, 1982–2026: 9 cases
1982	1
1986	1
1995	1
1999	1
2000	1
2002	1
2003	2
2004	1

Where

Open the map

Latest cases

Query with SQL

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" = '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 ('41514') 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

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\" = '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 ('41514')
      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.

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" = '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 ('41514')
    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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB FTW04LA060Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Encino, TXThe pilot's failure to maintain clearance from a tree while hovering.Jan 12, 2004 · N7061V · Substantial damage NTSB FTW04FA037Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Sugar Land, TXThe pilots failure to maintain clearance with powerlines during a VFR approach. Contributing factors were the prevailing dark night conditions,and the high winds.Dec 10, 2003 · N47413 · Destroyed NTSB FTW03LA168Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Encinal, TXThe pilot's failure to maintain clearance from a tree. A contributing factor was the pilot's diverted attention.Jun 8, 2003 · N854WT · Substantial damage NTSB FTW02LA266Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Freer, TXThe pilot's failure to maintain clearance with the power lines while manuevering. A factor was the sunglare.Sep 26, 2002 · N888MH · Substantial damage NTSB FTW00LA122Accident · No injuriesLimited investigationFinal reportMooney M20A · Houston, TXThe pilot's delayed go-around and his failure to maintain the aircraft's clearance with trees.Apr 5, 2000 · N8159E · Substantial damage NTSB FTW99LA216Accident · No injuriesLimited investigationFinal reportCessna 172RG · Celina, TXThe failure of the pilot in command to use all of the available runway for takeoff.Aug 7, 1999 · N9620B · Substantial damage NTSB FTW95LA281Accident · No injuriesLimited investigationFinal reportCessna 172RG · Weston, TXThe pilot receiving instruction's failure to maintain clearance with power lines while maneuvering at low altitude and the flight instructor's inadequate supervision. A factor was the instructor's decision to allow the simulation to continue to such a low…Jun 29, 1995 · N9502D · Substantial damage NTSB FTW86LQG17Accident · No injuriesFinal reportMcculloch J-2 · Stanton, TXPilot attempted take off from pasture. Just after lift off the nose gear caught on a single strand electric fence and brought aircraft to a stop where it rolled over. The plts flt time was not reported or available.Jul 28, 1986 · N4319G · Destroyed NTSB FTW82DA362Accident · No injuriesFinal reportPiper PA-28-180 · Weslaco, TXThe plt overshot an approach to rwy 13 & went around. The crosswind leg was extended to give the plt more room. The plt turned on final & lined up on a street paralleling the rwy. Just prior to touchdown the plt saw the "x" painted on the street & executed a…Sep 2, 1982 · N7890W · Substantial damage