NTSB investigations: Lycoming 0-320 series, 2015
123 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 year(c.\"eventDate\") = 2015
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'))
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 year(c."eventDate") = 2015
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'))
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 CEN15FA325Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Truth or Consequences, NMThe student pilot's improper decision to conduct a flight in dark night conditions without a solo night flight endorsement and his subsequent loss of airplane control.NTSB ANC15CA055Accident · No injuriesData collectionFinal reportChampion 7GCBC · Skweetna, AKThe pilot's improper decision to land on an unsuitable landing surface which resulted in a nose over.NTSB CEN15CA324Accident · Serious injuriesData collectionFinal reportAero Commander 100 · San Antonio, TXThe pilot's improper decision to attempt flight with an unairworthy airplane and improper starting procedure that resulted in an uncontrolled takeoff without the pilot aboard. Contributing was the inoperative airplane battery/engine starter.NTSB ANC15CA054Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Talkeetna, AKThe pilot's inadequate compensation for wind conditions, and improper recovery from a bounced landing resulting in a loss of control and collision with terrain.NTSB ANC15CA059Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Beluga, AKThe pilot's decision to land with insufficient obstacle clearance. The pilot's failure to maintain directional control after landing resulting in a collision with terrain.NTSB GAA15CA188Accident · No injuriesData collectionFinal reportChampion 7GCAA · Kingsland, TXThe pilot's failure to maintain pitch attitude which resulted in an aerodynamic stall, hard landing and a loss of directional control.NTSB ERA15LA266Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 5 · Southbridge, MAThe pilot’s decision to abort the takeoff with insufficient runway remaining, which resulted in a runway excursion.NTSB WPR15FA215Accident · 2 fatalField investigationFinal reportPiper PA 22-160 · Twin Sisters Mtn, WAThe noninstrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.NTSB CEN15LA301Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-140 · Oakdale, LAThe pilot's inadequate preflight planning resulting in the airplane not having adequate performance to climb and clear the trees off the end of the dirt runway.NTSB CEN15LA296Accident · Serious injuriesLimited investigationFinal reportColonial C 1 · Chico, TXA loss of engine power due to fuel exhaustion. Contributing to the accident was the unsnapped fuel bladder, which resulted in an inaccurate fuel quantity indication, and the pilot's inadequate preflight fuel planning, during which he relied solely on the fuel…NTSB WPR15CA207Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Carlsbad, CAThe pilot's failure to manage the fuel system properly during a banner tow operation resulting in a loss of engine power due to fuel starvation.NTSB GAA15CA162Accident · No injuriesData collectionFinal reportCessna 172N · Lubbock, TXThe student pilot's improper flare during landing which resulted in abnormal runway contact and damage to the firewall.NTSB CEN15FA289Accident · 1 fatalField investigationFinal reportCessna 172P · Bartlett, ILThe pilot’s loss of airplane control for reasons that could not be determined because an examination of the airplane did not reveal any preimpact abnormalities.NTSB ERA15LA257Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Galax Hillsville, VAThe pilot's failure to maintain adequate airspeed while turning onto the final approach leg of the traffic pattern, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB ANC15CA045Accident · No injuriesData collectionFinal reportJohnson Gary PA 18 Super CUB KIT · Palmer, AKThe pilot's excessive use of brakes during the landing roll resulting in a nose over.NTSB GAA15CA144Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Williston, NDThe pilot's failure to maintain directional control, which resulted in a runway excursion, and a collision with runway marking signs.NTSB GAA15CA156Accident · No injuriesData collectionFinal reportCessna 172N · Vernal, UTThe pilot's failure to maintain directional control during landing in crosswind conditions, which resulted in a runway excursion and an impact with an airport sign.NTSB ERA15FA241Accident · Serious injuriesField investigationFinal reportPiper PA-22 · Laconia, NHA total loss of engine power for reasons that could not be determined because of insufficient evidence found during postaccident examination of the airframe and engine.NTSB ERA15LA237Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Hampton, NHThe pilot’s failure to properly set the stabilator trim prior to takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.NTSB CEN15FA269Accident · 1 fatalField investigationFinal reportGrumman American Avn. AA-5 · Fredericksburg, TXThe pilot's failure to maintain adequate airspeed following a partial loss of engine power during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Also causal was the mechanic's…NTSB ANC15CA040Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Soldotna, AKThe pilot's loss of directional control during takeoff in gusty crosswind conditions.NTSB ANC15CA039Accident · No injuriesData collectionFinal reportPiper PA 18-150 · McCarthy, AKThe pilot's excessive use of wheel brakes during landing, resulting in a nose over.NTSB GAA15CA130Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Swanton, OHThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion, and a collision with a sign.NTSB CEN15FA264Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Kadoka, SDThe pilot's failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in the airplane’s wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall.NTSB GAA15CA111Accident · No injuriesData collectionFinal reportCessna 177 · Clewiston, FLThe pilot's improper level off and flare in crosswind conditions, which resulted in a loss of control and hard landing.NTSB ANC15LA035Accident · 1 fatalLimited investigationFinal reportPiper PA 18-150 · McCarthy, AKThe pilot's failure to ensure adequate clearance from the spinning propeller while traversing the area between the leading edge of the wing and the nose of the airplane. Contributing to the accident was the decision to leave the cockpits of the airplanes…NTSB ANC15LA034Accident · Minor injuriesLimited investigationFinal reportPiper PA 22 · Skwentna, AKThe pilot's failure to follow the airplane's operating limitations by rapidly opening the throttle, which resulted in a loss of engine power. Contributing to the accident was the pilot's decision to maneuver the airplane at low altitude even though he was not…NTSB ERA15CA222Accident · No injuriesData collectionFinal reportCessna 172P · Mitchellville, MDThe pilot’s improper landing flare, which resulted in a bounced landing and damage to the airplane.NTSB GAA15CA088Accident · Minor injuriesData collectionFinal reportCessna 172M · Sussex, NJThe pilot's failure to remove the gust lock during the preflight inspection, resulting in a loss of control and collision with trees during takeoff.NTSB ERA15FA220Accident · 1 fatalField investigationFinal reportGulfstream American AA-5A · Rowdy, KYThe noninstrument-rated pilot’s decision to continue visual flight rules flight in instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB GAA15CA081Accident · Serious injuriesData collectionFinal reportCitabria 7GCBC · Winnsboro, SCThe pilot's execution of a steep left turn at low altitude during an aborted landing, which resulted in an aerodynamic stall, and a collision with terrain.NTSB CEN15LA237Accident · No injuriesLimited investigationFinal reportPiper PA-22 · St. Charles, MOA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ANC15CA028Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Seward, AKThe pilot's excessive braking during landing, which resulted in a nose over.NTSB WPR15LA164Accident · No injuriesLimited investigationFinal reportPiper PA28 - 140 · El Cajon, CAThe pilot's improper in-flight fuel management, which resulted in fuel exhaustion in the selected tank, and his delayed movement of the fuel selector handle to the other tank, which resulted in a loss of engine power due to fuel starvation.NTSB GAA15CA079Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Princeton, NJThe pilot's failure to maintain directional control during the landing, resulting in a runway excursion.NTSB ANC15CA026Accident · No injuriesData collectionFinal reportPiper PA 22-150 · Talkeetna, AKThe private pilot's failure to maintain clearance from a spruce tree during final approach, which resulted in a loss of control and hard landing. Contributing to the accident was the flight instructor's failure to adequately monitor the landing.NTSB WPR15FA161Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Juntura, ORThe pilot's failure to see and avoid power lines while intentionally maneuvering at low altitude for the aerial observation flight.NTSB ANC15CA025Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Anchorage, AKThe pilot's excessive use of brakes to maintain directional control, which resulted in a nose over.NTSB CEN15LA228Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-161 · Ranger, TXA total loss of engine power during cruise flight due to piston fatigue cracking for reasons that could not be determined due to postfracture smearing damage.NTSB GAA15CA063Accident · Minor injuriesData collectionFinal reportCessna 172P · Los Angeles, CAThe student pilot's failure to maintain attitude control during the landing flare, resulting in a hard landing.NTSB GAA15CA049Accident · No injuriesData collectionFinal reportCessna 172M · Clearwater, FLThe pilot's excessive airspeed during landing, which resulted in abnormal runway contact, a runway excursion, and substantial damage to the airplane.NTSB WPR15FA152Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Mt Tom, ORThe noncertificated pilot's continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation leading to the pilot's loss of control of the airplane and subsequent collision with mountainous terrain.NTSB ANC15CA022Accident · Serious injuriesData collectionFinal reportPiper PA 18A 150 · Nondalton, AKThe pilot's failure to maintain control of the airplane while taking off with a gusting crosswind.NTSB WPR15LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA 18-150 · La Quinta, CAMaintenance personnel’s failure to properly repair a propeller deformation, which resulted in a fatigue crack, separation of a propeller blade tip, and forced landing onto uneven terrain.NTSB GAA15CA058Accident · No injuriesData collectionFinal reportCessna 172P · TamuningThe student pilot's failure to maintain pitch control, resulting in a hard landing.NTSB ERA15CA196Accident · No injuriesData collectionFinal reportCessna 172P · Sebastian, FLThe pilot's misjudged airspeed and glidepath, which resulted in a landing area overshoot and runway excursion.NTSB ERA15LA187Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lancaster, NYThe loss of engine power during takeoff for reasons that could not be determined during postaccident examination of the engine or testing of the carburetor.NTSB WPR15LA146Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Hilo, HIWater contamination in the fuel system due to the flight instructor’s and pilot receiving instruction’s failure to drain all the water from the system during the preflight inspection, which resulted in a loss of engine power.NTSB GAA15CA070Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Cornelia, GAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB ERA15FA171Accident · 2 fatalField investigationFinal reportPiper PA28 · West Chester, PAThe failure of the flight instructor and the pilot to abort the takeoff after the airplane experienced a partial loss of engine power with adequate runway remaining, and their subsequent failure to maintain adequate airspeed, which led to the airplane…