Skip to content

Final NTSB investigations: Lycoming 0-235 series, ND

27 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 per year

19652026

Where

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" = 'ND' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Completed' 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\" = 'ND' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Completed'
    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" = 'ND' AND c."eventCountry" = 'USA'
  AND c."completionStatus" = 'Completed'
  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 CEN18FA277Accident · 1 fatalClass 2 · FieldFinal reportCessna 152 · Fort Rice, NDThe pilot's failure to use carburetor heat in conditions that were conducive to serious carburetor icing, which resulted in a loss of engine power, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall. Contributing to the…Jul 17, 2018 · N24515 · Substantial damage NTSB CEN18LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA 12 · Dickinson, NDThe pilot’s failure to attain adequate airspeed during the short field takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.Nov 22, 2017 · N4040M · Substantial damage NTSB CEN09LA277Accident · 2 fatalLimited investigationFinal reportChampion 7GCBC · Surrey, NDThe pilot’s failure to maintain control of the airplane during an abrupt pull-up maneuver, which resulted in an aerodynammic stall at low altitude.May 3, 2009 · N5106T · Destroyed NTSB CHI00LA245Accident · No injuriesLimited investigationFinal reportCessna 152 · Arthur, NDthe water contamination found in the fuel and the pilot misjudging his altitude during the emergency procedure. A factor was the terrain condition of the corn crop.Aug 5, 2000 · N7385W · Substantial damage NTSB CHI00LA202Accident · No injuriesLimited investigationFinal reportCessna 152 · Park River, NDdirectional control not being maintained by the pilot during landing.Jul 13, 2000 · N69066 · Substantial damage NTSB CHI96LA347Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Fargo, NDthe pilot's failure to maintain directional control of the airplane during the landing. A factor was the crosswind.Sep 24, 1996 · N68ME · Substantial damage NTSB CHI96LA220Accident · 1 fatalLimited investigationFinal reportGrumman AA5B · Fryburg, NDthe pilot's VFR flight into instrument meteorological conditions. Factors were the fog, low ceiling, and rising terrain.Jun 25, 1996 · N6249L · Substantial damage NTSB CHI94LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Casselton, NDthe student's failure to attain proper runway alignment and to maintain directional control. A factor related to the accident was the snow covered runway.Jan 13, 1994 · N5329B · Substantial damage NTSB CHI92LA042Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fargo, NDThe pilot's improper interpretation of instructions issued by air traffic control specialist, and the pilot's poor inflight planning and decision(s). Factors associated with the accident are the confusing communications by the air traffic control specialist,…Dec 23, 1991 · N757YK · Substantial damage NTSB DEN89FA155Accident · Serious injuriesField investigationFinal reportPiper PA-16 · Minot, NDFailure of the airframe tubing (longeron) at the lower forward door frame due to corrosion. A contributing factor was failure of maintenance personnel to comply with service bulletin #819.Jul 5, 1989 · N5295H · Destroyed NTSB DEN89LA099Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Devils Lake, NDInadequate compensation for wind conditions by the pilot, which resulted in loss of directional control and an inadvertent ground loop/swerve. Contributing factors were: the crosswind and the pilot's lack of familiarity with the aircraft.Apr 5, 1989 · N7523K · Substantial damage NTSB DEN89LA073Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Forks, NDThe failure of the pilot to correct a ground loop swerve. A lack of total flight experience is considered to be a contributing factor.Feb 6, 1989 · N89038 · Substantial damage NTSB DEN86LA202Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Minot, NDAccording to the plt, the flt proceeded normally until he arrived at an airstrip sw of Minot for a landing. Several low approaches were made before he elected to land. He said that after the touchdown and during his landing roll, the acft swerved and went…Jul 19, 1986 · N2355A · Substantial damage NTSB DEN86LA062Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Hope, NDThe plt stated the citabria he was piloting failed to obtain flying speed before reaching the end of the snow covered private airstrip. According to the pilot, he aborted the takeoff too late. The acft contacted a snowbank and nosed over. The plt said that…Jan 3, 1986 · N50384 · Substantial damage NTSB DEN82DA097Accident · No injuriesFinal reportCessna 152 · Grand Forks, NDDuring landing, the student pilot bounced and then touched down hard. The nose gear failed and the firewall and propeller were damaged. The fixed base operator reported light turbulence.May 26, 1982 · N5329B · Substantial damage NTSB DEN81FTG17Accident · No injuriesClosedCessna 152 · Bismarck, NDAug 4, 1981 · N5324H · Substantial damage NTSB DEN81FTG04Accident · Minor injuriesClosedBellanca 7ECA · Grand Forks, NDNov 23, 1980 · N5047G · Substantial damage NTSB MKC79FTG01Accident · No injuriesClosedCessna 152 · Grand Forks, NDOct 31, 1978 · N757SH · Substantial damage NTSB MKC78DTG14Accident · No injuriesClosedPiper PA-12 · Rugby, NDSep 1, 1978 · N3752M · Substantial damage NTSB MKC76DTG12Accident · Serious injuriesClosedBellanca 7ECA · Goodrich, NDDec 21, 1975 · N90992 · Minor damage NTSB MKC75FTG25Accident · No injuriesClosedPiper PA-18 · Fessenden, NDJun 21, 1975 · N7115K · Substantial damage NTSB MKC75FTG05Accident · No injuriesClosedAmer Avco AA1-B · Fargo, NDJul 21, 1974 · N4SU · Substantial damage NTSB MKC74FTG16Accident · Minor injuriesClosedPiper PA-12 · Oakes, NDJun 1, 1974 · N3896M · Substantial damage NTSB MKC74FTG06Accident · Minor injuriesClosedAmer Avco AA-1B · Fargo, NDSep 25, 1973 · N9939L · Substantial damage NTSB MKC73DTG23Accident · No injuriesClosedPiper PA-18 · Sawyer, NDJun 28, 1973 · N7223K · Substantial damage NTSB MKC67D0459Accident · No injuriesClosedPiper PA-22 · Grand Forks, NDFeb 3, 1967 · N5136Z · Substantial damage NTSB MKC66F0147Accident · No injuriesClosedPiper PA-16 · Max, NDAug 14, 1965 · N5389H · Substantial damage