Skip to content

NTSB investigations: Lycoming 0-235 series, PA

124 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" = 'PA' 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\" = 'PA' 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" = 'PA' 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 NYC86LA207Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Tunkhannock, PAStudent pilot was attempting a landing at sky haven airport and landed short, bounced and landed in a left turn. At this point, the plt could not maintain directional control and ran off the runway, hit a barrel with the right gear and the acft nosed over.Aug 14, 1986 · N5888Z · Substantial damage NTSB NYC86LA197Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrisburg, PAThe student plt was on a x-country flt. He rprtd that during the flare to land at Harrisburg, PA, the acft yawed left, then after touchdown, it veered off the left side of the rwy twd a VASI installation. He steered further left to avoid the VASI, then…Aug 4, 1986 · N93454 · Substantial damage NTSB NYC85LA176Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Hookstown, PAThe instructor and student were practicing normal takeoffs and landings. According to the pilot, on the sixth landing, at the correct airspeed, the aircraft touched down on the main gear and then the noise wheel collapsed. The aircraft then nosed over.…Jul 16, 1985 · N5322Z · Substantial damage NTSB NYC84LA301Accident · No injuriesLimited investigationFinal reportCessna 152II · Washington, PAFuel exhaustion occurred 3.3 hrs into flt. Plt stated tanks appeared to be full on preflight but acft records showed 0.6 hrs flown on previous flight and acft not subsequently refueled. Aprx 1.5 gals found in tanks on post-mishap inspection.Sep 3, 1984 · N95035 · Substantial damage NTSB NYC84LA244Accident · No injuriesLimited investigationFinal reportCessna 152 · Bally, PADuring the initial climb at aprx 10 ft AGL the airspeed dropped to 40 KTS and the stall warning horn came on. The plt pushed the nose down to prevent a stall. The right wing dropped and the acft veered off the rwy on touchdown. The acft then contacted a tree…Aug 1, 1984 · N93397 · Substantial damage NTSB NYC84LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Pittsburgh, PAThe acft ballooned during the flare for landing & ended up in a nose down condition. The plt said he decided to stall the acft only a few ft off the ground as he estimated 2/3 of the rwy remained & a go-around was not necessary. The acft came to a stop on its…Apr 21, 1984 · N89880 · Substantial damage NTSB NYC84LA131Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Forty Fort, PADuring a supervised solo flt, the student plt had difficulty with directional control on his 6th landing. Subsequently, the acft swerved & the landing gear and wing were damaged.Apr 3, 1984 · N23217 · Substantial damage NTSB NYC84LA109Accident · Minor injuriesLimited investigationFinal reportBeech 77 · West Mifflin, PAThe acft landed short of the rwy and nosed over. According to the plt he felt that the acft was low on final approach and he added power. At this time the nose pitched down and the acft contacted the ground and came to rest upside down on the paved rwy.Mar 15, 1984 · N38675 · Substantial damage NTSB NYC84LA084Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Easton, PAThe student plt on his first solo flt veered off the rwy into a snowbank and nosed over. The plt said a puddle of water on the rwy contributed to the beginning of the swerve and he could not recover.Feb 4, 1984 · N91332 · Substantial damage NTSB NYC84FA039Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Wellsville, PAPrior to the flt, the plt stated that he would be flying foraprx 1/2 hr. Aprx 25 min after takeoff, ground witnesses northeast of the arpt observed the acft on a westerly heading, turning toward the arpt. Shortly after that, they saw the acft in an…Nov 27, 1983 · N81YB · Destroyed NTSB NYC83LA194Accident · No injuriesLimited investigationFinal reportGrumman AA-1C · Doylestown, PAThe student made 2 takeoffs & landings, then waited for traffic to clear the rwy before taking off again. While climbing to traffic pattern altitude on the 3rd takeoff, the eng lost power. An emergency checklist to restart the eng was not completed because of…Jul 27, 1983 · N9978U · Substantial damage NTSB NYC83LA134Accident · No injuriesLimited investigationFinal reportBeech 77 · W. Mifflin, PAThe acft landed about 20 ft short of the runway shearing the nose gear and damaging the prop. The student pilot said he encountered a 'small' windshear and he over reacted on the controls causing the acft to contact the ground short of the runway surface.Jun 5, 1983 · N66982 · Substantial damage NTSB NYC83LA002Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Bernville, PAThe pilot reported that the plane crashed after the right wing tip hit the top of a tree during landing. He reported that he had flown only 2 hrs in the last 90 days. He noted that this was only a 13 minute flight. He thought that he would have been more…Oct 3, 1982 · N3849M · Substantial damage NTSB NYC82FGT08Accident · 2 fatalFinal reportCessna A152 · Scotland, PAThe aircraft crashed after the pilot made a low pass over runway 13. At the departure end of the runway, the aircraft was observed to pull up into a 40 to 45 degree climb, then stall and enter a spin. It crashed in a near vertical descent.Mar 2, 1982 · N7378L · Destroyed NTSB NYC81FGT13Accident · No injuriesClosedAmer Avco AA-1B · Marietta, PASep 21, 1981 · N8969L · Substantial damage NTSB NYC81FHD29Accident · No injuriesClosedCessna 152 · Philadelphia, PAJun 26, 1981 · N4910B · Substantial damage NTSB NYC81DHA07Accident · No injuriesClosedPiper PA-38 · Easton, PAMar 23, 1981 · N2535A · Substantial damage NTSB NYC80FGM26Accident · No injuriesClosedCessna 152 · Connellsville, PAAug 9, 1980 · N46483 · Substantial damage NTSB NYC80FA022Accident · 1 fatalClosedCessna 152 · Indian Head, PAJan 29, 1980 · N68326 · Substantial damage NTSB NYC80DHA04Accident · No injuriesClosedPiper PA-38 · Easton, PAJan 21, 1980 · N2559C · Substantial damage NTSB NYC80FGM05Accident · Minor injuriesClosedCessna 152 · Jeannette, PAOct 30, 1979 · N757FN · Substantial damage NTSB NYC79FHA20Accident · No injuriesClosedPiper PA-38 · Prospectville, PAAug 9, 1979 · N9387T · Substantial damage NTSB NYC79FGM37Accident · No injuriesClosedGrum Amer AA-1 · Monroeville, PAJul 22, 1979 · N5908L · Substantial damage NTSB NYC79FGM31Accident · No injuriesClosedCessna 152 · West Mifflin, PAJul 3, 1979 · N757VT · Substantial damage NTSB NYC79FGT14Accident · No injuriesClosedPiper PA-18 · Lancaster, PAApr 22, 1979 · N331T · Substantial damage NTSB NYC79FGM12Accident · No injuriesClosedCessna 152 · Latrobe, PAFeb 2, 1979 · N24956 · Substantial damage NTSB NYC79FA030Accident · 2 fatalClosedGrum Amer AA-1B · Milroy, PAJan 5, 1979 · N6536L · Destroyed NTSB NYC78FA056Accident · 2 fatalClosedPiper PA-22 · Northampton, PAMay 20, 1978 · N4656Z · Destroyed NTSB NYC77FGM36Accident · No injuriesClosedGrum Amer AA1-B · Pittsburgh, PAAug 19, 1977 · N1481R · Substantial damage NTSB NYC77FHA32Accident · No injuriesClosedGrum Amer AA1-B · Yardley, PAAug 16, 1977 · N1445R · Substantial damage NTSB NYC77FHD16Accident · Minor injuriesClosedGrum Amer AA1-B · Bristol, PAJul 4, 1977 · N9686L · Substantial damage NTSB NYC76FGM38Accident · No injuriesClosedGrum Amer AA1 · Erie, PAJul 6, 1976 · N5972L · Substantial damage NTSB NYC76DHD12Accident · No injuriesClosedGrum Amer AA1-B · Bristol, PAOct 27, 1975 · N9605L · Substantial damage NTSB NYC74FGM37Accident · No injuriesClosedPiper PA-12 · Mt Pleasant, PAJun 11, 1974 · N2492M · Substantial damage NTSB NYC74DHD36Accident · No injuriesClosedAmer Avco AA1-A · Bristol, PAApr 29, 1974 · N9259L · Substantial damage NTSB NYC74FGM16Accident · Serious injuriesClosedPiper J3C-65 · Waynesburg, PAFeb 3, 1974 · N88361 · Substantial damage NTSB NYC74FHD24Accident · No injuriesClosedAmer Avco AA1-B · Bristol, PAJan 19, 1974 · N9605L · Substantial damage NTSB NYC74DHD11Accident · Minor injuriesClosedAmer Avco AA1-B · Bristol, PAAug 19, 1973 · N9627L · Destroyed NTSB NYC74DGM02Accident · No injuriesClosedPiper PA-16 · Beaver Falls, PAJul 30, 1973 · N5680H · Substantial damage NTSB NYC73FGT14Accident · No injuriesClosedCessna 140 · Thomasville, PAJun 19, 1973 · N89171 · Substantial damage NTSB NYC73FGM25Accident · Serious injuriesClosedAmer Avco AA-1 · Roulette, PAApr 15, 1973 · N5742L · Substantial damage NTSB NYC73FHA01Accident · No injuriesClosedChampion 7GCAA · Kutztown, PAJul 11, 1972 · N9090L · Substantial damage NTSB NYC72DHD31Accident · No injuriesClosedAmer Avco AA-1 · Bristol, PAMar 15, 1972 · N5767L · Substantial damage NTSB NYC71FHD53Accident · No injuriesClosedAmer Avco AA1 · Bristol, PAMay 14, 1971 · N5742L · Substantial damage NTSB NYC71FHD08Accident · No injuriesClosedChampion 7ECA · West Chester, PAAug 6, 1970 · N6384N · Substantial damage NTSB NYC71DHA10Accident · Minor injuriesClosedPiper PA-12 · Lehighton, PAAug 2, 1970 · N92518 · Substantial damage NTSB NYC71DHA06Accident · No injuriesClosedChampion 7EC · Pottstown, PAJul 25, 1970 · N2996G · Substantial damage NTSB NYC70D0114Accident · No injuriesClosedPiper PA-22 · Oxford, PAAug 9, 1969 · N5459Z · Substantial damage NTSB NYC70D0122Accident · Serious injuriesClosedPiper PA-16 · Mountain Home, PAAug 1, 1969 · N5682H · Substantial damage NTSB NYC70D0025Accident · No injuriesClosedPiper PA-22 · Warrington, PAJul 2, 1969 · N4738Z · Substantial damage