Skip to content

NTSB investigations: Lycoming 0-235 series, NH

22 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" = 'NH' 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\" = 'NH' 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" = 'NH' 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 ERA23LA095Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ECA · Hampton, NHThe pilot’s failure to maintain directional control of the airplane while landing in crosswind conditions, which resulted in a runway excursion.Dec 26, 2022 · N2895Z · Substantial damage NTSB ERA14CA195Accident · No injuriesData collectionFinal reportCessna 140 · Colebrook, NHThe pilot's decision to power out of soft snow with a gusty quartering tailwind which resulted in the tail of the airplane rising and the airplane nosing over.Apr 10, 2014 · N2143N · Substantial damage NTSB NYC07CA103Accident · No injuriesData collectionFinal reportChampion 7ECA · Nashua, NHThe pilot's misjudged altitude while maneuvering for a banner pickup, which resulted in the banner rope becoming entangled in the airplane's landing gear, and a hard landing, during the ensuing emergency off airport landing.Apr 23, 2007 · N6341N · Substantial damage NTSB NYC04LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Jaffrey, NHThe loss of engine power for undetermined reasons.Jul 7, 2004 · N2489M · Substantial damage NTSB NYC00LA170Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · Nashua, NHThe flight instructor's delayed corrective action.Jun 19, 2000 · N761XA · Substantial damage NTSB BFO92LA110Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Belmont, NHInadequate in-flight planning/decision by the pilot.Jul 22, 1992 · N93361 · Substantial damage NTSB NYC92LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Orford, NHThe student pilot became lost and disoriented.Dec 11, 1991 · N48156 · Substantial damage NTSB NYC91LA200Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Alton, NHThe pilot's improper use of carburetor heat, which resulted in a loss of engine power.Aug 1, 1991 · N4436M · Substantial damage NTSB NYC90LA228Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Franconia, NHThe landing of the airplane in unsuitable terrain, due to the mechanical failure of the engine center muffler baffle, which blocked the exhaust flow, resulting in a loss of power.Sep 23, 1990 · N2770M · Substantial damage NTSB NYC88LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Concord, NHThe student pilot was attempting a landing at Concord municipal airport. The aircraft touched down hard, bounced and at this time the pilot applied full throttle in an attempt to abort the landing and go around. However the aircraft veered left and struck…Feb 18, 1988 · N6341H · Substantial damage NTSB NYC87LA060Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Randolph, NHStudent pilot on a cross country instructional flight became disoriented, decided to return to departure airport. However seeing that he was running low on fuel looked for an airport to land to refuel and find out his location. He decided to make a…Jan 17, 1987 · N2430G · Destroyed NTSB NYC86LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Nashua, NHThe student pilot was performing touch and go landings at boire field when he applied power to takeoff, he was distracted by the flap control setting. During this distraction the aircraft drifted to the left. Full right rudder was used in an attempt to…Feb 24, 1986 · N303DW · Substantial damage NTSB NYC84LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · Laconia, NHThe acft ballooned during landing and came down hard on the nose gear which collapsed. The plt said a gust of wind had made the acft ascend about 20-50 ft after which it fell to the rwy. He reported the prevailing wind was variable from 270 to 290 deg a 12…Apr 28, 1984 · N5171B · Substantial damage NTSB NYC82DA190Accident · No injuriesFinal reportCessna 152 · Lebanon, NHThe pilot landed at the uncontrolled airport to refuel. After receiving an in-person weather briefing, he filed a VFR flight plan. He contacted the fss on the airport advisory frequency and advised that he ws taxiing and would be making an intersection…Aug 10, 1982 · N89255 · 2 aircraft · Substantial damage NTSB NYC82DA024Accident · No injuriesFinal reportCessna 152 · Enfield, NHWhile the student pilot was on a solo cross-country flight, the engine lost power and then ran intermittently. The power loss occurred while the plane was over a snow covered lake at 6500 ft MSL. The pilot elected to land on the lake. After touchdown, the…Jan 19, 1982 · N68292 · Substantial damage NTSB NYC81FA082Accident · 2 fatalClosedGulf Amer AA-1B · Richmond, NHSep 7, 1981 · N1446R · Destroyed NTSB NYC80FNC10Accident · No injuriesClosedCessna 152 · Keene, NHJan 31, 1980 · N5282B · Substantial damage NTSB NYC78FA066Accident · 1 fatalClosedGrum Amer AA1-C · Tamsworth, NHJun 25, 1978 · N9544U · Destroyed NTSB NYC75FNC04Accident · Minor injuriesClosedGrumman TR-2 · Twin Mountain, NHJul 13, 1974 · N9962L · Substantial damage NTSB NYC73FNC72Accident · No injuriesClosedAmer Avco AA-1 · Manchester, NHMay 1, 1973 · N6139L · Substantial damage NTSB UNK65X1305Accident · Minor injuriesClosedPiper PA-22 · Nashua, NHJan 17, 1965 · N5939Z · 2 aircraft · Substantial damage NTSB UNK65X1233Accident · No injuriesClosedPiper PA12 · Grafton, NHJan 5, 1965 · N4408M · Substantial damage