Skip to content

NTSB investigations: Lycoming I0360 SER A&C, AZ

22 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

19672026

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" = 'AZ' 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\" = 'AZ' 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" = 'AZ' 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 GAA19CA079Accident · No injuriesData collectionFinal reportPilatus PC12 · Mesa, AZThe other pilot's failure to follow the air traffic controller’s instructions and his subsequent failure to maintain adequate lookout to see and avoid the other airplane on the taxiway.Nov 28, 2018 · N552TC · 2 aircraft · Minor damage NTSB WPR18LA181Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Phoenix, AZA total loss of engine power due to crankshaft failure as the result of a subsurface fatigue crack.Jun 26, 2018 · N154ME · Substantial damage NTSB WPR18FA011Accident · 1 fatalField investigationFinal reportPeterson Lancair Legacy · Bowie, AZAn in-flight loss of control due to a bird strike.Oct 19, 2017 · N259L · Substantial damage NTSB GAA17CA161Accident · No injuriesData collectionFinal reportPiper PA 28R · Phoenix, AZAn in-flight collision with a bird.Feb 20, 2017 · N962WW · Substantial damage NTSB WPR15CA115Accident · No injuriesData collectionFinal reportPiper PA 28R-201 · Phoenix, AZThe pilot under instruction's inadvertent retraction of the landing gear during the landing rollout.Feb 24, 2015 · N963WW · Substantial damage NTSB WPR14CA193Accident · No injuriesData collectionFinal reportKalman George Lancair 360 · Grand Canyon, AZThe pilot's inadequate flare, which resulted in a hard landing.May 15, 2014 · N521SH · Substantial damage NTSB WPR14CA011Accident · Serious injuriesData collectionFinal reportMooney M20J · Sedona, AZThe pilot's inadequate flare which resulted in a bounced landing and subsequent loss of aircraft control during an aborted landing.Oct 8, 2013 · N5760Y · Substantial damage NTSB WPR13LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe failure of both flight instructors to see and avoid the other airplane while providing instrument flight training, which resulted in a midair collision.Oct 5, 2012 · N8115Q · 2 aircraft · Substantial damage NTSB WPR12LA247Accident · No injuriesLimited investigationFinal reportPiper PA28R · Peoria, AZA loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.May 29, 2012 · N963WW · Substantial damage NTSB WPR11CA470Accident · No injuriesData collectionFinal reportPiper PA-28RT-201 · Chandler, AZThe certified flight instructor's and pilot-undergoing-instruction's improper flare, which resulted in a hard landing.Sep 28, 2011 · N8056B · Substantial damage NTSB WPR10LA219Accident · No injuriesLimited investigationFinal reportRogers Rutan Defiant 40 · Phoenix, AZThe failure of the pilot to ensure that the landing gear extension handle was firmly placed in the down position prior to landing.Apr 29, 2010 · N23TR · Substantial damage NTSB SEA08CA097Accident · No injuriesData collectionFinal reportPiper PA-28R-201 · Phoenix, AZThe pilot's failure to maintain directional control of the airplane during landing.Mar 28, 2008 · N963WW · Substantial damage NTSB LAX04CA063Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Morenci, AZthe pilot's excessive landing flare, which resulted in an improper touchdown and hard landing.Dec 3, 2003 · N1451T · Substantial damage NTSB LAX04LA054Accident · No injuriesLimited investigationFinal reportCessna 172S · Wikieup, AZThe pilot's selection of an en route altitude that did not provide adequate terrain clearance, and resulted in the in-flight collision with terrain. The rising terrain and the blind/box canyon were contributing factors.Nov 29, 2003 · N518ER · Substantial damage NTSB LAX04LA103Accident · No injuriesLimited investigationFinal reportMooney 20F · Scottsdale, AZthe pilot's failure to maintain directional control of the airplane during landing.Oct 12, 2003 · N7127V · Substantial damage NTSB LAX03CA248Accident · No injuriesData collectionFinal reportCessna 172S · Phoenix, AZThe student's misjudged landing flare and inadvertent entry into a porpoise pilot-induced oscillation.Jul 10, 2003 · N787WW · Substantial damage NTSB LAX92LA155Accident · No injuriesLimited investigationFinal reportBeech C-24R · Phoenix, AZThe flight instructor's inadequate supervision of the flight and the private pilot's failure to maintain airspeed. Contributing to this accident was the failure of the main landing gear due to overload.Mar 28, 1992 · N66350 · Destroyed NTSB LAX85LA288Accident · Serious injuriesLimited investigationFinal reportStarduster II · Glendale, AZThe plt crossed the arpt at midfield and made a left turn for a close in downwind. Witnesses estimated that he made a 180 deg descending turn to final. While on final the plt observed another acft which was already on final slightly aheadand slightly below…Jun 23, 1985 · N17RM · Destroyed NTSB LAX85FA073Accident · 4 fatalField investigationFinal reportMooney M20J · Grand Canyon, AZThe plt received a wx briefing and was advised of moderate rime and mixed icing in clouds. He filed an IFR flt plan and departed. While at 12000 ft, he reported encountering severe rime ice and requested a lower altitude. He stated thathe was trying to fling…Dec 16, 1984 · N4812H · Destroyed NTSB LAX82FUJ27Accident · 1 fatalFinal reportMooney M20J · Paradise Valley, AZThe pilot picked up the new aircraft from the factory at kerrville, Texas on the day of the accident. He was ferrying the plane to his home in new jersey by way of las vegas, Nevada. He declined an offer to be checked out in the plane and departed kerrville…Feb 4, 1982 · N11578 · Destroyed NTSB LAX78DUJ61Accident · No injuriesClosedStarduster SA300 · Chino Valley, AZMay 27, 1978 · N16RS · Substantial damage NTSB LAX68D0123Accident · No injuriesClosedGlobe Swift GC-1B · Peoria, AZSep 4, 1967 · N78293 · Substantial damage