NTSB investigations: Lycoming 0-320 series
14,588 cases on aircraft whose registry engine model is Lycoming 0-320 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.
Cases, newest first
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508'))
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 WPR17LA018Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 1C · Hemet, CAThe pilot’s failure to ensure that sufficient fuel was available for the flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA17CA067Accident · No injuriesData collectionFinal reportCessna 172 · Concord, NHThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA17WA049Accident · 3 fatalForeign investigationCessna 172N · Kingston, JamaicaOn November 18, 2016, about 1335 eastern standard time, a Cessna 172N, United Stated registration N101KA, operated by the Caribbean Aviation Training Centre, was destroyed when it impacted a building in Greenwich Farm, Kingston 13, Jamaica. The pilot and two…NTSB GAA17CA076Accident · No injuriesData collectionFinal reportCessna 172 · Salmon, IDThe airplane's encounter with a depression in a dirt runway during takeoff, which resulted in a tail strike.NTSB GAA17CA057Accident · No injuriesData collectionFinal reportPiper PA18 · Mouth of The Big Susitna River, AKThe pilot’s decision to take off with a gusting quartering tailwind and his subsequent loss of airplane control.NTSB CEN17FA026Accident · 1 fatalField investigationFinal reportRoe Cleo Wittman Tailwind W10 · Pearland, TXThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during a climbing turn after takeoff, which resulted in an aerodynamic stall/spin. Contributing to the accident was the pilot's inadequate training…NTSB GAA17CA035Accident · Minor injuriesData collectionFinal reportPiper PA 28 · Fresno, CAThe pilot’s exceedance of the airplane’s critical angle of attack during departure due to being distracted by looking for his phone.NTSB CEN17FA016Accident · 2 fatalField investigationFinal reportMakela RV-4 · Oregonia, OHThe pilot's decision to fly at a low altitude, which resulted in the collision with a zipline.NTSB CEN17LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA 18-150 · Jasper, TXA partial loss of engine power for reasons that could not be determined, because an examination of the airplane did not identify a specific reason for the loss of engine power.NTSB GAA17CA027Accident · Minor injuriesData collectionFinal reportPiper PA18 · Palmer, AKThe airplane's encounter with a depression while the pilot applied excessive braking during the landing roll on a grass airstrip, which resulted in a nose-over.NTSB GAA17CA026Accident · Serious injuriesData collectionFinal reportPiper PA 28 · Latrobe, PAThe pilot’s unstabilized approach, which resulted in the airplane’s wing striking the ground while the pilot was maneuvering to realign with the runway.NTSB GAA17CA022Accident · No injuriesData collectionFinal reportAllen Robert RV6 · Ocala, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing.NTSB GAA17CA012Accident · No injuriesData collectionFinal reportCessna 172 · Ocean Springs, MSThe pilot's failure to maintain airplane control while landing in windy conditions.NTSB GAA17CA019Accident · No injuriesData collectionFinal reportPiper PA18 · Hanna, WYThe pilot's failure to maintain directional control during the landing roll in shifting wind conditions.NTSB GAA17CA011Accident · No injuriesData collectionFinal reportFuller Neil H Glasair SH 2 · Bellingham, WAThe pilot’s failure to maintain directional control during the takeoff roll in crosswind conditions, which resulted in a runway excursion.NTSB CEN17LA006Accident · No injuriesLimited investigationFinal reportCessna 172K · Wilmot, WIA failure of the No. 1 piston pin plug due to corrosion in the cylinder barrel, which resulted in oil contamination, oil starvation to the crankshaft connecting rod bearings, and a subsequent partial loss of engine power.NTSB CEN17LA004Accident · No injuriesLimited investigationFinal reportVolaircraft 10A · Mandan, NDThe student pilot’s failure to maintain the proper approach path on landing, which resulted in impact with terrain short of the runway.NTSB GAA17CA001Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Fairbanks, AKThe pilot’s improper crosswind correction, which resulted in a loss of pitch control and nose-over.NTSB ERA17LA005Accident · No injuriesLimited investigationFinal reportPiper PA28 · Laurel, MSA total loss of engine power due to a stuck carburetor float. The reason the carburetor float became stuck could not be determined because postaccident examination of the float and needle/seat revealed no anomalies.NTSB CEN17LA003Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Taylor, TXA total loss of engine power due to fuel starvation as a result of debris obstructing the fuel strainer screen and corrosion of the fuel strainer bowl.NTSB ERA16LA330Accident · Serious injuriesLimited investigationFinal reportTatkovsky James G Safari · Andover, NHThe noncertificated pilot’s failure to maintain helicopter control during initial climb.NTSB ERA16FA329Accident · 1 fatalField investigationFinal reportCessna 172 · Laytonsville, MDThe pilot/mechanic's failure to maintain airspeed following a loss of engine power, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Also causal was the pilot/mechanic's failure to service the engine…NTSB GAA16CA516Accident · No injuriesData collectionFinal reportPiper PA 18 · Kotzebue, AKThe pilot’s selection of unsuitable terrain for an off-airport precautionary landing, which resulted in a nose-over.NTSB GAA16CA515Accident · Serious injuriesData collectionFinal reportCessna 172 · Pittsfield, MAThe student pilot’s failure to maintain an appropriate descent rate and runway alignment during the landing flare, which resulted in the airplane touching down left of the runway and impacting a ditch.NTSB ERA16FA324Accident · 3 fatalField investigationFinal reportCessna 120 · North Collins, NYThe failure of the second airplane's pilot to see and avoid the first airplane as he was overtaking the first airplane.NTSB CEN16LA387Accident · Minor injuriesLimited investigationFinal reportPahnke Vernon A Vans RV 9A · Newark, ILThe pilot's failure to properly assemble the fuel pump, which resulted in the loss of fuel pressure and the subsequent partial loss of engine power.NTSB ANC16CA073Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Soldotna, AKThe pilot’s failure to maintain an adequate glidepath during landing, which resulted in an unintended touchdown before the chosen landing area.NTSB CEN16LA382Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-140 · Wooster, OHA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB GAA16CA511Accident · No injuriesData collectionFinal reportCessna 172 · Auburn, CAThe pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB GAA16CA490Accident · No injuriesData collectionFinal reportPiper PA 28 · Parkersburg, WVThe flight instructor’s delayed remedial action during the approach for landing, which resulted in impact with terrain short of the runway threshold. Contributing to the accident was the student pilot’s failure to maintain an appropriate descent rate during…NTSB GAA16CA483Accident · No injuriesData collectionFinal reportCessna 172 · Covington, GAThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA16CA482Accident · No injuriesData collectionFinal reportPiper PA18 · Gulkana, AKThe pilot’s failure to maintain clearance from a tree while maneuvering at low altitude.NTSB ERA16FA309Accident · 2 fatalField investigationFinal reportCessna 172 · Hollywood, FLThe pilot's inadequate preflight and in-flight weather planning, which resulted in continued flight into a thunderstorm and a subsequent loss of airplane control.NTSB GAA16CA487Accident · No injuriesData collectionFinal reportCessna 172 · Anchorage, AKThe airplane’s encounter with a developing sink hole during taxi on the ramp area.NTSB ANC16FA061Accident · 5 fatalField investigationFinal reportCessna 208 · Russian Mission, AKThe failure of both pilots to see and avoid each other while in level cruise flight, which resulted in a midair collision.NTSB GAA16CA460Accident · No injuriesData collectionFinal reportCessna 172 · Winchester, VAThe student pilot's incorrect pitch control during the landing flare, which resulted in a porpoise, a loss of directional control, and a runway excursion.NTSB GAA16CA456Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot's improper soft field landing technique on a soft grass airstrip, which resulted in a nose over.NTSB ANC16LA060Accident · Serious injuriesLimited investigationFinal reportPiper PA 18-150 · Salcha, AKThe pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in an in-flight collision with terrain.NTSB CEN16LA348Accident · No injuriesLimited investigationFinal reportPiper PA 18-180 · Colorado Springs, COThe pilot's failure to maintain directional control after encountering a wind gust during the landing roll, which resulted in a ground loop.NTSB CEN16FA333Accident · 1 fatalField investigationFinal reportCessna 172N · Terre Haute, INThe pilot's failure to maintain a normal approach path to the runway, which resulted in the airplane colliding with a tree and a house during final approach. Contributing to the accident was the pilot's lack of recent flight experience.NTSB GAA16CA447Accident · No injuriesData collectionFinal reportCessna 172 · Williamsport, PAThe student pilot's distraction during taxi operations, which resulted in the airplane's left wing impacting a hangar.NTSB CEN16LA329Accident · Serious injuriesLimited investigationFinal reportCollins RV6A · Pekin, ILThe pilot's failure to latch the canopy before takeoff, and his subsequent distraction and failure to maintain control while attempting to close the open canopy, which resulted in an aerodynamic stall.NTSB GAA16CA473Accident · No injuriesData collectionFinal reportCessna 172 · Fulton, MOThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in the airplane porpoising.NTSB GAA16CA428Accident · No injuriesData collectionFinal reportGrumman American Avn. AA 5A · Reno, NVThe pilot's failure to see and avoid fence posts during landing, which resulted in substantial damage to the wings.NTSB GAA16CA417Accident · No injuriesData collectionFinal reportCessna 172 · Everett, WAThe pilot's failure to maintain clearance from the building door, which resulted in substantial damage to the left wing.NTSB GAA16CA413Accident · Minor injuriesData collectionFinal reportCessna 172 · Cross Keys, NJThe pilot's failure to maintain lateral bank control during final approach, which resulted with an impact with a tree and substantial damage to the left and right wings.NTSB GAA16CA419Accident · No injuriesData collectionFinal reportCessna 172 · Lewiston, MTThe pilot's failure to ensure that his seat was adjusted and locked, which resulted in his seat sliding aft during the takeoff roll, and the subsequent loss of directional control and runway excursion.NTSB CEN16LA309Accident · No injuriesLimited investigationFinal reportCessna 172K · Neenah, WIA loss of engine power due to oil starvation, which resulted from the pilot, who was not a certified airframe and powerplant mechanic, removing the vacuum pump from the engine, and his misconception that he could operate the airplane without the pump.NTSB GAA16CA397Accident · No injuriesData collectionFinal reportOlmsted Charles A RV · Dwight, ILThe pilot's delayed action to perform an aborted landing, which resulted in a nose over and substantial damage to the firewall, fuselage, and empennage.NTSB WPR16LA140Accident · Minor injuriesLimited investigationFinal reportPiper PA 23-150 · Kona, HIThe total loss of power in both engines during cruise flight for reasons that could not be determined because the airplane was not recovered from the ocean.