NTSB investigations: Lycoming 0-320 series, PA
22 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of control - in flight”. 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.
Cases per year
| 1983 | 2 |
|---|---|
| 1984 | 2 |
| 1985 | 1 |
| 1987 | 3 |
| 1991 | 2 |
| 1993 | 3 |
| 1994 | 3 |
| 1998 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2007 | 2 |
Where
Latest cases
Query with SQL
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 ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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 ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 NYC07LA175Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Collegeville, PAThe pilot's inadequate recovery from a bounced landing.NTSB NYC07LA123Accident · Serious injuriesLimited investigationFinal reportDever Stits Playmate SA11A · Connellsville, PAThe pilot's inability to maintain control of the airplane due to an undetermined physiological impairment.NTSB NYC06LA019Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Doylestown, PAThe flight instructor's inadequate remedial action, which resulted in a hard landing and subsequent rollover.NTSB IAD05LA003Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Pittsburgh, PAThe delayed remedial action by the flight instructor.NTSB NYC04LA169Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Erwinna, PAThe student pilot's failure to maintain airspeed and his failure to follow the go-around procedure which resulted in a stall.NTSB NYC98FA066Accident · 1 fatalField investigationFinal reportCessna 172P · York, PAThe pilot's failure to maintain airspeed during final approach which resulted in an inadvertent stall/spin.NTSB NYC94LA179Accident · Minor injuriesLimited investigationFinal reportCessna 172M · New London, PAThe pilot failed to maintain adequate airpseed which resulted in an inadvertent stall and inflight collision with terrain.NTSB BFO94LA133Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Freeport, PAThe student pilot's failure to maintain adequate airspeed and the instructor's inadequate supervision.NTSB NYC94LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Towanda, PAThe pilot's improper recovery from a bounced landing.NTSB BFO93FA138Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Clearfield, PAThe pilot's failure to maintain airspeed during the go-around.NTSB NYC93LA068Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Doylestown, PAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing was the lack of total experience.NTSB NYC93LA058Accident · No injuriesLimited investigationFinal reportCessna 172M · Bedford, PAThe pilot attempted to land in a cross wind, lost control of the airplane, landed off the runway, swerved towards a hanger after going threw a snow bank resulting in the left wing striking the hanger.NTSB NYC92DGM01Accident · 1 fatalFinal reportWillkins-Wayne VARI-VIGGEN · Erie, PAThe pilot lost control of the airplane at too low an altitude to recover. Factors related to the accident were the pilot's low time and experience in this type of airplane.NTSB NYC91LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Tunkhannock, PAImproper use of the flight controls by the pilot which resulted in an inadvertent stall on takeoff with insufficient altitude for recovery. Factors related to the accident was the failure of the pilot to properly set the elevator trim prior to takeoff and the…NTSB NYC88LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pottstown, PADuring soft field takeoff, the instructor pilot who was watching from the ramp, said the the student plt seemed to have excessive angle of attack and stalled the aircraft. The aircraft crashed on airport property about 1,000 feet from the start of the takeoff…NTSB NYC87LA223Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Prospectville, PAThe student plt was practicing takeoffs & landings. He rprtd that on the 2nd apch, he appeared to be landing too long, so he initiated a go-around. However, he said the acft then entered a departure stall & settled into shrubs & trees adjacent to the rwy.NTSB NYC87FA119Accident · 4 fatalField investigationFinal reportCessna 172N · Ferguson Twnshp, PAThe pilot, who had not completed his checkout in a Cessna 172, was observed to make a long landing and lift off with approximately 750 ft of runway remaining. The aircraft was observed to enter a nose high pitch attitude and drift into a right turn. The…NTSB NYC85FGM05Accident · 2 fatalFinal reportJames Postlewait RV-4 · Zelienople, PAA witness reported that when the acft was departing, the takeoff run & beginning of the climb appeared to be normal. However, at about 300 to 400 ft AGL, the left wing dropped & the acft pivoted to the left, then the plane crashed in a steep nose down…NTSB NYC85FGM01Accident · Serious injuriesFinal reportCessna 172P · West Mifflin, PAAcft landed long with excessive speed. Plt attempted a go-around but was unable to obtain sufficient flying speed before reaching the end of the rwy which drops off into a steep embankment. When the acft reached the end of the rwy ground effect was lost and…NTSB NYC85LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Farmington, PAAccording to the plt, during the landing flare the wind shifted causing the acft to drift off the left side of the rwy striking rwy lights and a pole. Winds were from 230 deg at 10 KTS gusting to 15.NTSB NYC83FA142Accident · 2 fatalField investigationFinal reportPiper PA-18A-150 · Collegeville, PADuring takeoff, the acft was observed to enter a steep climb after making a short takeoff roll. One witness estimated that the takeoff roll was about 400 ft & then the acft entered a climb at aprx a 35 deg angle. After reaching an altitude of about 200 to 300…NTSB NYC83FA071Accident · 2 fatalField investigationFinal reportCessna 172M · Mountville, PAThe acft collided with a power line and a tree before crashing to the ground during a go-around attemp. The acft had been crabbing in a cross-wind for a landing and drifting off to the right of the rwy. The pilot applied power for a go around but never…