Skip to content

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

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

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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" = 'WA' 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')) 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\" = 'WA' 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'))
  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" = 'WA' 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'))
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 SEA95LA058Accident · No injuriesLimited investigationFinal reportMooney M20C · Omak, WAThe elevator push rod separation due to fatigue. Factors contributing to the accident were the pilot in command's failure to insure compliance with the airworthiness directive and the frozen push rod bearing.Mar 3, 1995 · N7836V · Substantial damage NTSB SEA93LA182Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Ilwaco, WAThe pilot's inadequate pre-flight planning, and his attempt to take off with the aircraft over gross weight.Aug 22, 1993 · N8267P · Substantial damage NTSB SEA92LA193Accident · No injuriesLimited investigationFinal reportCessna 172N · Snohomish, WAInadequate visual lookout by the other pilot.Aug 31, 1992 · N737TK · 2 aircraft · Destroyed NTSB SEA88LA072Accident · 1 fatalLimited investigationFinal reportSteen Skybolt GT-2 · Saint John, WAAfter tkof witnesses said the acft did a maneuver at 50-60 ft AGL that involved a steep (90 degree) banked turn to a snap roll. The biwing acft was capable of aerobatic flt and the plt had discussed aerobatic roll maneuvers on tkof with the acft co-owner. The…Apr 12, 1988 · N76JJ · Destroyed NTSB SEA87FA166Accident · 1 fatalField investigationFinal reportCessna 172RG · Kettle Falls, WAWhile on a local personal flight, plt entered a canyon into rising terrain, colliding first with a tree and then ground near crest. Investigation revealed that acft probably had performance to clear crest had tree not been struck. Circumstances indicate plt…Aug 17, 1987 · N9747B · Destroyed NTSB SEA87FA100Accident · 3 fatalField investigationFinal reportCessna 172 · Ritzville, WAOccupants of both acft were family members traveling in company for holiday. Takeoff was about one min apart with N44726 in trail. Due higher norm crz performance, N44726 overtook N5711A. Plt of N44726 reduced speed and established position about 1/2 mile to…May 24, 1987 · N5711A · 2 aircraft · Destroyed NTSB SEA87LA050Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Alderwood Manor, WAThe pilot, after exhausting all fuel in one tank, failed to select the remaining fuel tank during his approach. His unfamiliarity with the make/model of the accident aircraft is considered a factor in his failing to locate the fuel selector and switching to…Jan 29, 1987 · N6076N · Destroyed NTSB SEA85LA081Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Trinidad, WAThe pilot was operating the aircraft by flying at low altitude down the columbia river so as to avoid turbulence. During the flight a downdraft was encountered in which insufficient altitude was available to prevent the water and an unintentional ditching…Mar 30, 1985 · N772GW · Substantial damage NTSB SEA85FA028Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Gig Harbor, WAThe plt departed in the early morning hours from salem, OR, destined for Gig Harbor. Upon arrival in the destination area the plt was in radio contact with seattle apcon. The plt reported he was unable to aquire visual contact with the arpt. Vectors were…Dec 9, 1984 · N2104D · Destroyed NTSB DCA85IA003Incident · No injuriesIncident investigationFinal reportBoeing VC-137B-BN · Seattle, WADuring arrival, a Boeing VC-137B-BN, USAF #58-6970, operating as air force 2 (AF-2), was cleared for a localizer back- course apch. At 1442:49, TRACON advised AF-2 of traffic at its 10 o'clock position at 2 mi, alt unkn. At 1443:11, TRACON advised AF-2 the…Oct 18, 1984 · USAF · 2 aircraft · No damage NTSB SEA84LA076Accident · No injuriesLimited investigationFinal reportLake LA-4 · Alderwood Manor, WAAccording to a witness, he observed the acft from taxi to takeoff, then from base throughout the landing. He observed the acft with the gear down on base leg & said the plt flew a low & short final apch. He stated the plt cut power short of the rwy & the acft…Apr 3, 1984 · N6665L · Substantial damage NTSB SEA84LA051Accident · No injuriesLimited investigationFinal reportCessna 172 Rgii · Seattle, WADuring a takeoff after a touch and go landing the nose gear retracted at about the time of rotation. Power was reduced to idle and the acft slid to a stop. This acft is equipped with squat switches which prevent gear retraction when the weight of the acft…Feb 10, 1984 · N9557B · Substantial damage NTSB SEA82DA165Accident · 1 fatalFinal reportPiper PA-28-180C · Renton, WAPilot parked aircraft with engine running to discharge passenger. Passenger jumped off right wing into prop.Sep 15, 1982 · N9613J · No damage NTSB SEA82DYE06Accident · 1 fatalFinal reportBeech 23 · Greenwater, WAAt about 1620 local time on 4/24/82, the aircraft departed burley, id and proceeded on a VFR flight plan to tacoma, WA. The mountains east of seattle were obscured by an overcast ceiling beginning at 3500 ft. during a descent from 10,500 ft into the seattle…Apr 25, 1982 · N6079N · Destroyed NTSB SEA82DA049Accident · No injuriesFinal reportPiper PA-28-181 · Spokane, WAStudent pilot/copilot reset the aircraft clock in anticipation of the time zone change that would occur in flight. This caused the pilot to think he had another hour of flight time. In addition the fuel gage was found to show fuel in the right tank when all…Apr 9, 1982 · N80769 · Substantial damage NTSB SEA82DA027Accident · No injuriesFinal reportPiper PA-28-180 · Prosser, WAAfter returning from a local flight, the student pilot landed on runway 25. The wind was from 090 degrees at 5 knots. The landing was without difficulty until the nosewheel touched down, then the aircraft veered left. The pilot reported that he corrected with…Feb 7, 1982 · N8280W · Substantial damage NTSB SEA81DYP14Accident · No injuriesClosedPiper PA-28 · Coulee City, WAMay 4, 1981 · N9077J · Substantial damage NTSB SEA80FYE43Accident · Minor injuriesClosedPiper PA-28 · Gardner, WAJul 20, 1980 · N3576B · Destroyed NTSB SEA80FA033Accident · 3 fatalClosedCessna 177 · Mineral, WAJun 11, 1980 · N2235Y · Destroyed NTSB SEA80FA047Accident · 4 fatalClosedPiper PA-24 · White Pass, WADec 11, 1979 · N6171P · Destroyed NTSB SEA80DYE04Accident · No injuriesClosedMooney M20C · Everett, WAOct 27, 1979 · N6961U · Substantial damage NTSB SEA79DYE24Accident · No injuriesClosedCessna 177B · Mercer Island, WAMay 26, 1979 · N991MP · Substantial damage NTSB SEA79FA013Accident · Minor injuriesClosedPiper PA-28 · Bellingham, WANov 16, 1978 · N47226 · Destroyed NTSB SEA78FA034Accident · 2 fatalClosedPiper PA-28 · Bremerton, WAMay 21, 1978 · N1914T · Destroyed NTSB SEA78DYP13Accident · Minor injuriesClosedPiper PA-28 · Quincy, WAMar 2, 1978 · N8374W · Substantial damage NTSB SEA77FYP34Accident · Serious injuriesClosedPiper PA-28 · Mattawa, WAAug 1, 1977 · N9507J · Substantial damage NTSB SEA77FYE17Accident · No injuriesClosedBellanca 14-13 · Maple Valley, WAMay 1, 1977 · N86726 · Substantial damage NTSB SEA76DYG08Accident · No injuriesClosedCessna 177 · Quincy, WAAug 11, 1975 · N177JM · Destroyed NTSB SEA75OYE21Accident · No injuriesClosedCessna 177 · Alderwd Manr, WAOct 18, 1974 · N34555 · Substantial damage NTSB SEA75DYE07Accident · Serious injuriesClosedPiper PA-28 · Eatonville, WAAug 5, 1974 · N2171R · Substantial damage NTSB SEA74DYC58Accident · No injuriesClosedCessna 172 · Battle Grnd, WAJun 16, 1974 · N8044L · Substantial damage NTSB SEA74DYE34Accident · No injuriesClosedCessna 172 · Holly, WAJan 13, 1974 · N7234G · Substantial damage NTSB SEA74DYE18Accident · No injuriesClosedPiper PA-18 · Arlington, WASep 23, 1973 · N7474D · Substantial damage NTSB SEA73DYC29Accident · No injuriesClosedCessna 172H · Battleground, WAMay 27, 1973 · N8044L · Substantial damage NTSB SEA72DYE23Accident · No injuriesClosedPiper PA-28 · Spanaway, WAFeb 25, 1972 · N2336R · Substantial damage NTSB SEA71DWD28Accident · No injuriesClosedPiper PA-18 · Arlington, WAApr 3, 1971 · N7474D · Substantial damage NTSB SEA71FWD25Accident · No injuriesClosedPiper PA-24 · Auburn, WADec 31, 1970 · N5885P · Substantial damage NTSB SEA71DWD24Accident · No injuriesClosedHughes 269A · Chehalis, WADec 26, 1970 · N8701F · Substantial damage NTSB SEA71DWD15Accident · No injuriesClosedCessna 172 · Kenmore, WASep 27, 1970 · N7234G · Substantial damage NTSB SEA71FWD02Accident · No injuriesClosedBrantly B-2 · Bellevue, WAJul 4, 1970 · N5963X · Substantial damage NTSB SEA69F0129Accident · No injuriesClosedHughes 269A · Renton, WAOct 29, 1968 · N8772F · Destroyed NTSB SEA69F0047Accident · No injuriesClosedPiper PA-24 · Spokane, WAJul 23, 1968 · N6817P · Substantial damage NTSB SEA68D0197Accident · No injuriesClosedMooney M20E · Starbuck, WAOct 26, 1967 · N6852U · Substantial damage NTSB SEA68D0014Accident · No injuriesClosedPiper PA-28 · Mesa, WAJun 13, 1967 · N9507J · Substantial damage NTSB SEA67D0347Accident · Minor injuriesClosedCallair A-6 · Outlook, WAMay 18, 1967 · N2918G · Destroyed NTSB SEA68F0029Accident · No injuriesClosedLake LA-4 · Renton, WAApr 28, 1967 · N2012L · Substantial damage NTSB SEA67D0174Accident · No injuriesClosedPiper PA-24 · Touchet, WANov 6, 1966 · N5070P · Substantial damage NTSB SEA67D0173Accident · No injuriesClosedMooney M21 · Walla Walla, WAOct 27, 1966 · N6852U · Substantial damage NTSB SEA67F0106Accident · No injuriesClosedMooney M20B · Richland, WAAug 28, 1966 · N74545 · Substantial damage NTSB SEA67D0044Accident · No injuriesClosedMooney M20B · Bellevue, WAMay 31, 1966 · N74587 · Substantial damage