Skip to content

NTSB investigations: Lycoming 0-235 series, MN

103 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" = 'MN' 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\" = 'MN' 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" = 'MN' 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 CHI86LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Warren, MNThe pilot overflew the runway & observed some snow on the left hand side of the runway. During the landing the aircraft drifted to the left, collided with a finger drift & nosed over.Jan 14, 1986 · N95636 · Substantial damage NTSB CHI85LA281Accident · No injuriesLimited investigationFinal reportCessna 152 · Rochester, MNThe student pilot on first solo x-country was ld on the 7500 ft runway. Tower had cautioned on wake turbulance from departing DC-9. On flare sp said acft dropped in swerved left, cartwheeled and nosed down.Jul 10, 1985 · N69037 · Substantial damage NTSB CHI85LA238Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Starbuck, MNPlt landed in crosswind conditions, veered off the edge of tha rwy onto rough, unleveled terrain. The nosewheel collapsed and the aircraft nosed over.Jun 16, 1985 · N5355Z · Substantial damage NTSB CHI85LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · St. Cloud, MNThe plt stated that his ground speed was too fast during a landing due to no wind. During the go-around the acft collided with tree tops & crashed. The plt reported that he delayed his decision to perform a go-around.Oct 13, 1984 · N5221H · Substantial damage NTSB CHI84LA310Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNDuring a touch & go landing the acft veered to the right, exiting the runway. The nose wheel struck a manhole cover which protruded 12 to 18 inches above the ground. The acft nosed over upon contacting the cover. The student pilot stated that he had allowed…Jul 25, 1984 · N64985 · Substantial damage NTSB CHI84LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Detroit Lakes, MNThe acft collided with a snow embankment 15 to 20 ft short of the rwy on final approach. The acft got low and slow on final according to the instructor and he became concerned about a hard landing. As he advanced the throttle the acft hitthe embankment. The…Jan 28, 1984 · N25469 · Substantial damage NTSB CHI84LA089Accident · No injuriesLimited investigationFinal reportGrumman AA-1A · Hawley, MNThe acft ran into a snowbank during the landing roll and flipped over. The plt stated that the right brake pedal cylinder froze but this could not be confirmed during the investigation.Jan 18, 1984 · N9248L · Substantial damage NTSB CHI83LA110Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNDuring final the acft started to drift & the rate of descent increased. The plt was late in adding power & the acft touched down 75 ft short of the rwy in 20 inches of snow & nosed over.Feb 12, 1983 · N93214 · Substantial damage NTSB CHI83LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNWhile performing a touch-and-go landing, the pilot used a higher than normal speed. After touching down, the aircraft became airborne again, then began to porpoise. After about the 3rd or 4th bounce, the nose gear failed.Oct 10, 1982 · N6332P · Substantial damage NTSB CHI82DA136Accident · No injuriesFinal reportBellanca 7ECA · Maple Lake, MNThe pilot lost directional control during landing in strong crosswind conditions with gusts to 22 knots. The aircraft departed the runway and collided with a parked aircraft. The pilot stated that he was not currently proficient in crosswind landing, should…Apr 24, 1982 · N53801 · Destroyed NTSB CHI82DER17Accident · No injuriesClosedPiper PA-38 · Albert Lea, MNDec 4, 1981 · N2393G · Substantial damage NTSB CHI81FER22Accident · No injuriesClosedCessna 152 · Duluth, MNMar 4, 1981 · N6353H · Substantial damage NTSB CHI81DER18Accident · No injuriesClosedPiper PA-12 · Kelliher, MNFeb 15, 1981 · N2560M · Substantial damage NTSB CHI81DER06Accident · No injuriesClosedCessna 152 · Cloquet, MNOct 28, 1980 · N67996 · Substantial damage NTSB CHI80DER39Accident · No injuriesClosedCessna 152 · Minneapolis, MNMay 10, 1980 · N67993 · Substantial damage NTSB MKC80FER27Accident · No injuriesClosedCessna 152 · Euclid, MNMar 4, 1980 · N68811 · Substantial damage NTSB MKC80FER23Accident · No injuriesClosedCessna 152 · Shakopee, MNJan 26, 1980 · N714SZ · Substantial damage NTSB MKC80DER20Accident · No injuriesClosedPiper PA-38 · Anoka, MNJan 20, 1980 · N2536A · Substantial damage NTSB MKC80DER22Accident · No injuriesClosedPiper PA-38 · Fergus Falls, MNJan 13, 1980 · N107WC · Substantial damage NTSB MKC80DER17Accident · No injuriesClosedCessna 152 · Anoka, MNJan 13, 1980 · N24537 · Substantial damage NTSB MKC80DER13Accident · No injuriesClosedBellanca 7ECA · St James, MNNov 25, 1979 · N41689 · Substantial damage NTSB MKC80FER12Accident · No injuriesClosedCessna 152 · Minneapolis, MNNov 24, 1979 · N5461B · Substantial damage NTSB MKC80DER11Accident · No injuriesClosedPiper PA-22 · Middle River, MNNov 20, 1979 · N5035Z · Substantial damage NTSB MKC79DER59Accident · No injuriesClosedCessna 152 · Brainerd, MNJul 28, 1979 · N757ZV · Substantial damage NTSB MKC79FA036Accident · 1 fatalClosedGrumman AA-1B · Clearwater, MNJun 17, 1979 · N1459R · Destroyed NTSB MKC79FER31Accident · No injuriesClosedCessna 152 · Eden Prairie, MNMar 21, 1979 · N65572 · Substantial damage NTSB MKC79DER28Accident · No injuriesClosedCessna 152 · Blaine, MNFeb 28, 1979 · N48863 · Substantial damage NTSB MKC79DER23Accident · No injuriesClosedPiper PA-38 · Eden Prairie, MNFeb 7, 1979 · N2359D · Substantial damage NTSB MKC78FER53Accident · No injuriesClosedPiper PA-12 · St Cloud, MNJun 11, 1978 · N3138M · Substantial damage NTSB MKC77FER82Accident · No injuriesClosedBellanca 7ECA · Belle Plaine, MNSep 10, 1977 · N53745 · Substantial damage NTSB MKC77FER63Accident · No injuriesClosedGrumman AA-1B · Lakeville, MNJul 21, 1977 · N6298L · Substantial damage NTSB MKC76DER87Accident · Minor injuriesClosedGrum Amer AA-1B · Isanti, MNAug 11, 1976 · N9626L · Substantial damage NTSB MKC76DER84Accident · No injuriesClosedGrum Amer AA1-B · Red Wing, MNAug 1, 1976 · N6522L · Substantial damage NTSB MKC76DER76Accident · No injuriesClosedStarduster 2 · Eveleth, MNJul 7, 1976 · N6099 · Substantial damage NTSB MKC73DER55Accident · Minor injuriesClosedBellanca 7ECA · Redwood Fall, MNApr 28, 1973 · N90992 · Substantial damage NTSB MKC72DER65Accident · No injuriesClosedAmer Avco AA1A · Barnsville, MNJun 10, 1972 · N9250L · Substantial damage NTSB MKC72DER56Accident · No injuriesClosedPiper PA-22 · Morris, MNApr 19, 1972 · N4639Z · Substantial damage NTSB MKC72DER49Accident · No injuriesClosedPiper PA-12 · Duluth, MNApr 1, 1972 · N3752M · Substantial damage NTSB MKC72DER46Accident · No injuriesClosedAmer Avco AA1 · Stanton, MNMar 25, 1972 · N5980L · Substantial damage NTSB MKC72DER36Accident · No injuriesClosedPiper PA-12 · Silver Bay, MNFeb 5, 1972 · N7644H · Substantial damage NTSB MKC69D0390Accident · No injuriesClosedPiper PA-16 · Mcgregor, MNFeb 9, 1969 · N5994H · Substantial damage NTSB MKC69D0190Accident · No injuriesClosedPiper PA-12 · Eden Prairie, MNSep 20, 1968 · N3007M · Substantial damage NTSB MKC69D0113Accident · No injuriesClosedPiper PA-16 · Rush City, MNAug 14, 1968 · N5705H · Substantial damage NTSB MKC68F0335Accident · No injuriesClosedPiper PA-12 · Eden Prairie, MNNov 14, 1967 · N3017M · Substantial damage NTSB MKC68F0204Accident · Minor injuriesClosedPiper PA-12 · Cloquet, MNAug 27, 1967 · N2453M · Destroyed NTSB MKC67D0607Accident · No injuriesClosedPiper PA-22 · St.Paul, MNMay 11, 1967 · N5193Z · Substantial damage NTSB MKC67D0501Accident · No injuriesClosedPiper PA-22 · Whte Bear Lk, MNFeb 14, 1967 · N5193Z · Substantial damage NTSB MKC66F0437Accident · No injuriesClosedPiper PA-12 · Appleton, MNFeb 16, 1966 · N2511M · Substantial damage NTSB MKC66F0410Accident · No injuriesClosedPiper PA-12 · Lake Elmo, MNDec 18, 1965 · N78480 · Substantial damage NTSB MKC66F0083Accident · No injuriesClosedPiper PA-12 · Spring Valley, MNJun 17, 1965 · N7752H · Substantial damage