Skip to content

NTSB investigations: Lycoming I0360 SER A&C, PA

18 cases on aircraft whose registry engine model is Lycoming I0360 SER A&C. 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

19712026

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" = '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 ('41511')) 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 ('41511'))
  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 ('41511'))
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 ERA15LA366Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bally, PAThe pilot's failure to maintain altitude during low-level aerobatic maneuvers. Contributing to the accident were the pilot's improper decision to attempt the low-level aerobatic maneuvers and his impairment due to psychiatric conditions and the medications he…Sep 21, 2015 · N347SP · Substantial damage NTSB ERA15LA177Accident · No injuriesLimited investigationFinal reportMooney M20J · Allentown, PAA total loss of engine power during takeoff due to an interruption of fuel flow to the engine. The reason for the interruption of the fuel flow could not be determined during postaccident examination and testing.Apr 6, 2015 · N4826H · Substantial damage NTSB ERA12CA247Accident · No injuriesData collectionFinal reportMooney M20J · Butler, PAThe pilot’s failure to extend the landing gear before landing.Mar 23, 2012 · N58135 · Substantial damage NTSB ERA09CA404Accident · No injuriesData collectionFinal reportCessna 172 · York, PAThe student pilot's improper recovery from a bounced landing.Apr 13, 2009 · N144ME · Substantial damage NTSB NYC07CA137Accident · Minor injuriesData collectionFinal reportPiper PA-28RT-201 · Tinicum, PAThe instrument-rated pilot's failure to maintain runway alignment by instruments after encountering fog during the initial climb. A factor was the foggy weather conditions.Jun 13, 2007 · N3023U · Substantial damage NTSB NYC06LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Philadelphia, PAA fatigue failure of the number 3 cylinder attachment studs, which resulted in a loss of engine power and subsequent forced landing.Apr 9, 2006 · N901AV · Substantial damage NTSB NYC04FA077Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Corry, PAThe loss of partial engine power for undetermined reasons, and the pilot's lost of control after performing an evasive maneuver to avoid trees during a forced landing at night. Factors related to the accident were a rough running engine and the pilot's…Feb 27, 2004 · N4166P · Substantial damage NTSB NYC03CA209Accident · No injuriesData collectionFinal reportWells Pitts S1S · Duncannon, PAThe pilot's failure to maintain directional control while landing. Factors were the gusting cross winds.Sep 27, 2003 · N465JW · Substantial damage NTSB NYC98LA072Accident · No injuriesLimited investigationFinal reportMooney M20J · Avoca, PAa bird strike.Feb 28, 1998 · N1173N · Substantial damage NTSB IAD96FA126Accident · 1 fatalField investigationFinal reportAerotek Pitts Special S-1S · Pittsburgh, PAThe pilot's utilization of airspeeds greater than the manufacturer recommended maneuvering airspeeds which exceed the design limits of the airplane and resulted in the subsequent failure of the wing spar.Aug 4, 1996 · N2HT · Destroyed NTSB NYC88LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Beaver Falls, PADuring hand-propping of Piper PA-28R, the passenger slipped and fell into the turning prop. He received a serious head injury.Nov 11, 1987 · N8364N · No damage NTSB NYC86LA071Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Johnstown, PAThe flight was enroute from louisville Kentucky to Connecticut. While cruising at 9000 ft an engine power loss was experienced. An emergency was declared. The ATC set up an ILS approach to runway 33 at Johnstown, PA. However the pilot could not maintain…Feb 3, 1986 · N1144P · Destroyed NTSB NYC85FGT02Accident · 2 fatalFinal reportJones Marquart MA-5 · New Oxford, PABefore flying a short distance to thomasville to refuel, the plt added 3 to 4 gal of auto fuel to the acft. At thomasville, the acft was serviced with 20.1 gal of aviation fuel. While taxiing to takeoff, the eng stopped & was restarted twice. After departing…Aug 6, 1985 · N168FJ · Destroyed NTSB NYC83LA251Accident · No injuriesLimited investigationFinal reportMooney M20J · Erie, PADuring takeoff, the eng lost power at aprx 50 ft AGL after the gear was retracted. The plt reported that his only safe reaction was to land with the gear retracted on 'what little rwy was left.' Water was found in the gascolator & right fuel tank. The acft…Sep 19, 1983 · N25XX · Substantial damage NTSB NYC83LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · West Chester, PAThe plt reported that during the takeoff roll, some oscillation in the controls for the nosewheel steering was noted. At about 45 KTS, he applied back pressure to lighten the load on the nosewheel as he had done in the past. He reported that since he was only…Apr 13, 1983 · N2943F · Substantial damage NTSB NYC82DA057Accident · No injuriesFinal reportPiper PA-28RT-201 · Avoca, PAThe pilot encountered icing conditions while descending from 5000 to 4000 ft near his destination. He was cleared for an immediate ILS approach. He maintained 110 knots on final approach until inside the middle marker. At that point, he applied one notch of…Mar 17, 1982 · N2962W · Substantial damage NTSB NYC74FGT08Accident · No injuriesClosedPiper PA-28R · Deer Lake, PASep 21, 1973 · N2685R · Substantial damage NTSB NYC72DGM18Accident · No injuriesClosedStarduster TOO · Indiana, PASep 22, 1971 · N2361 · Substantial damage