Skip to content

NTSB investigations: Lycoming 0-235 series, OR

88 cases on aircraft whose registry engine model is Lycoming 0-235 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" = 'OR' 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 ('41505')) 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\" = 'OR' 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 ('41505'))
  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" = 'OR' 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 ('41505'))
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 SEA86LA025Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Imnaha, ORPrior to takeoff the pilot taxied through a lot of slush. A nose over occurred while attempting to land on a snow covered clearing. The nose over probably occurred due to very deep snow on the landing area and frozen brakes.Nov 12, 1985 · N3534M · Substantial damage NTSB SEA85LA216Accident · No injuriesLimited investigationFinal reportCessna 152 · Independence, ORThe plt descended to a low alt over a river to look for birds. While over the river the plt spotted pwr lines at an alt of aprx 75 ft AGL. An attempt was made to fly under the lines, but the tail contacted the wires severing aprx 6 inches off the top portion…Aug 18, 1985 · N49282 · Substantial damage NTSB SEA85LA092Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Hampton, ORThe student plt made a precautionary landing due to being lost and low on fuel. The airstrips surface was 1000 ft of dirt and sand with a fence at the departure end. Takeoff data based on gross weight, zero wind, 4000 ft elevation at 80 degrees, on a hard…Apr 13, 1985 · N9861L · Substantial damage NTSB SEA83LA081Accident · No injuriesLimited investigationFinal reportSmith Miniplane · Near Rainier, ORAprx 20 min after takeoff, the engine lost power. Several restarts were initiated; however, the engine would not continue running. During an emergency landing on sandy terrain, the nose gear dug in & the acft nosed over the plt described the loss of power as…Apr 15, 1983 · N94R · Substantial damage NTSB SEA82DA144Accident · No injuriesFinal reportCessna 152-II · Grants Pass, ORThe instructor pilot stated that the student was having difficulty aligning the aircraft with the runway during the landing approach. As they approached the runway he instructed the student to "get the nose up." At an altitude of approximately three feet, the…Aug 17, 1982 · N6139M · Substantial damage NTSB SEA82DA109Accident · No injuriesFinal reportPiper PA-12 · Eugene, ORThe pilot was high and fast on approach and bounced on the first touchdown. On the second touchdown the aircraft swerved and the left main landing gear collapsed.Jul 13, 1982 · N3171M · Substantial damage NTSB SEA82FYM17Accident · 1 fatalFinal reportPiper PA-18 · Yamhill, ORDuring takeoff the aircraft veered off the right side of runway 8 and collided with a split rail fence. The aircraft then crossed a gravel road and struck a wire cattle fence catching on fire within seconds after coming to a stop. The winds were out of the…Jun 1, 1982 · N7525K · Destroyed NTSB SEA81DYM13Accident · No injuriesClosedBellanca 7ECA · Molalla, ORJan 10, 1981 · N8668 · Substantial damage NTSB SEA79FYK28Accident · No injuriesClosedCessna 152 · Creswell, ORSep 7, 1979 · N89487 · Substantial damage NTSB SEA79DXK12Accident · No injuriesClosedAmer Avco AA1-B · Chiloquin, ORMay 20, 1979 · N9876L · Substantial damage NTSB SEA78FYM53Accident · No injuriesClosedBellanca 7ECA · Hillsboro, ORSep 30, 1978 · N4183Y · Substantial damage NTSB SEA78FYM27Accident · No injuriesClosedAmer Avco AA-1 · Oregon City, ORApr 23, 1978 · N6130L · Substantial damage NTSB SEA78FYK12Accident · Minor injuriesClosedConrad Daphne · Roseburg, ORMar 17, 1978 · N29613 · Substantial damage NTSB SEA78DYM11Accident · No injuriesClosedCessna 152 · Dayton, ORDec 18, 1977 · N757JM · Substantial damage NTSB SEA77DYM35Accident · No injuriesClosedCessna 152 · Pendleton, ORMay 27, 1977 · N714UJ · Substantial damage NTSB SEA77DYK05Accident · No injuriesClosedPiper PA-22 · Denmark, ORMar 4, 1977 · N4739Z · Substantial damage NTSB SEA77FYI03Accident · Minor injuriesClosedGrum Amer AA1-B · Medford, ORNov 30, 1976 · N9699L · Substantial damage NTSB SEA75DYC01Accident · No injuriesClosedAmer Avco AA1-A · Sandy, ORJul 3, 1974 · N6368L · Substantial damage NTSB SEA74DYC33Accident · No injuriesClosedAmer Avco AA-1A · Lagrande, ORFeb 28, 1974 · N9343L · Substantial damage NTSB SEA74DYC24Accident · No injuriesClosedPiper PA-22 · Mosier, ORNov 17, 1973 · N5912Z · Substantial damage NTSB SEA74FYI06Accident · No injuriesClosedCessna 140 · Klamath Fals, ORJul 28, 1973 · N72166 · Substantial damage NTSB SEA73DYC34Accident · No injuriesClosedPiper PA-12 · Sandy, ORJun 6, 1973 · N7754H · Substantial damage NTSB SEA72FYC40Accident · No injuriesClosedPiper PA-12 · Oregon City, ORMay 5, 1972 · N2954M · Substantial damage NTSB SEA72DYC19Accident · No injuriesClosedPiper PA-12 · Kimberley, ORAug 27, 1971 · N3480M · Substantial damage NTSB SEA72FYC17Accident · No injuriesClosedPiper PA-22 · Portland, ORAug 19, 1971 · N5037Z · Substantial damage NTSB SEA69A0055Accident · 2 fatalClosedPiper PA-16 · La Grande, ORMay 16, 1969 · N6853K · Destroyed NTSB SEA69A0054Accident · No injuriesClosedCessna 182B · Salem, ORMay 12, 1969 · N2380G · 2 aircraft · Substantial damage NTSB SEA69F0163Accident · No injuriesClosedPiper PA-16 · Oregon City, OROct 27, 1968 · N6855K · Substantial damage NTSB SEA69D0110Accident · Minor injuriesClosedPiper PA-22 · Reedsport, ORAug 7, 1968 · N4917Z · Substantial damage NTSB SEA69F0076Accident · No injuriesClosedPiper J5A · Beaverton, ORJul 23, 1968 · N35692 · Substantial damage NTSB SEA68D0091Accident · Minor injuriesClosedPiper PA-18 · Imnaha, ORSep 2, 1967 · N7533K · Destroyed NTSB SEA69F0125Accident · 1 fatalClosedPiper J5C · Seaside, ORJul 14, 1967 · N68295 · Destroyed NTSB SEA67D0324Accident · No injuriesClosedPiper PA-14 · Milton Frewtr, ORMay 7, 1967 · N5145H · Substantial damage NTSB SEA68F0010Accident · No injuriesClosedPiper PA-16 · Sisters, ORMay 6, 1967 · N5779H · Substantial damage NTSB SEA66A0054Accident · 1 fatalClosedPiper PA-16 · Sutherlin, ORMay 6, 1966 · N5744H · Destroyed NTSB SEA65F0074Accident · No injuriesClosedPiper PA-22 · Albany, ORMay 5, 1965 · N5398Z · Substantial damage NTSB UNK64X3320Accident · Minor injuriesClosedPiper PA22 · Drewsey, ORAug 10, 1964 · N4871Z · Substantial damage NTSB UNK64X1501Accident · Minor injuriesClosedPiper PA12 · Beaver Creek, ORApr 28, 1964 · N98905 · Substantial damage