NTSB investigations: Lycoming 0-320 series, 2019
125 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\") = 2019
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") = 2019
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 ANC19FA042Accident · 4 fatalField investigationFinal reportPiper PA22-150 · Girdwood, AKThe pilot's failure to maintain clearance from terrain due to his impairment from alcohol consumption.NTSB CEN19LA265Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Fairhope, ALFailure of the No. 3 exhaust valve and the subsequent loss of engine power due to engine operation with an excessively lean fuel mixture over a period of time.NTSB CEN19CA239Accident · No injuriesData collectionFinal reportCessna 172 · Oshkosh, WIThe pilot's improper fuel planning and decision to not divert to a closer airport when the planned flight profile changed, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA19CA500Accident · No injuriesData collectionFinal reportPiper PA18 · Tok, AKThe pilot's failure to maintain directional control during landing and his excessive rudder input, which resulted in a runway excursion and landing gear collapse.NTSB GAA19CA468Accident · No injuriesData collectionFinal reportCessna 172 · Gaithersburg, MDThe other pilot's failure to maintain clearance from the airplane while taxiing.NTSB GAA19CA448Accident · No injuriesData collectionFinal reportCessna 172 · Van Nuys, CAThe pilot's failure to maintain directional control during landing with a left quartering crosswind, which resulted in a runway excursion and impact with runway lighting.NTSB ANC19TA037Accident · Serious injuriesClass 4Final reportPiper PA19 · Skwentna, AKThe pilot’s loss of directional control during a go-around and his failure to assess the wind conditions appropriately before a landing attempt.NTSB WPR19CA197Accident · Minor injuriesData collectionFinal reportAvid Avid Magnum · Yellow Pine, IDThe pilot's improper decision to land on a rough, grass airstrip, which resulted in the nose landing gear collapsing and a subsequent nose-over.NTSB GAA19CA424Accident · No injuriesData collectionFinal reportCessna 172 · Grand Canyon, AZThe pilot's failure to maintain lateral control during landing in gusting wind conditions, which resulted in the left wing striking the ground.NTSB ERA19LA227Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Hastings, FLThe pilot’s failure to secure the engine primer control, which resulted in an overly rich fuel/air mixture and degraded engine performance. Contributing to the accident was the pilot’s failure to abort the takeoff in a timely manner.NTSB CEN19LA224Accident · No injuriesClass 3 · LimitedFinal reportPiper PA18 · Osceola, WIThe failure of the right horizontal stabilizer during takeoff, resulting in a loss of control and forced landing. Contributing to the accident was the installation of an unapproved stabilizer frame and failure of maintenance personnel to identify…NTSB CEN19LA223Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 177 · Elkhart, INAn inadvertent engine start of the airplane and subsequent takeoff without the pilot on-board for reasons that could not be determined based on available evidence.NTSB GAA19CA430Accident · No injuriesData collectionFinal reportPiper PA28 · Wasilla, AKThe pilot's improper landing flare, which resulted in an aerodynamic stall and subsequent hard landing, runway excursion, and collision with a sign.NTSB GAA19CA438Accident · No injuriesData collectionFinal reportBeech 19 · Columbia Station, OHThe pilot's failure to see and avoid tall grass along the side of the runway during the takeoff roll, which resulted in his loss of directional control, a runway excursion, and nose-over.NTSB ANC19LA032Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Newport, ORThe pilot's improper verification of the fuel quantity during the preflight inspection, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB CEN19LA214Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA18 · Bay City, MIThe pilot's failure to maintain airspeed and his exceedance of the airplane's critical angle of attack during a banner drop and pickup, which resulted in an aerodynamic stall and a subsequent loss of control.NTSB WPR19TA186Accident · No injuriesClass 3Final reportGlasair SH II · San Bernardino, CAA fuel leak caused by age-degraded fuel hoses, which resulted in a total loss of engine power and fire before takeoff. Contributing to the accident was inadequate maintenance.NTSB GAA19CA439Accident · Minor injuriesData collectionFinal reportCessna 172 · Manteo, NCThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN19LA187Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Danbury, TXA failed electrical relay, which provided an improper indication of a governor and clutch problem, which resulted in the pilot conducting a precautionary landing during which he failed to maintain sufficient main rotor speed.NTSB GAA19CA385Accident · No injuriesData collectionFinal reportPiper PA 12 · Skwentna, AKThe pilot's use of excessive brakes during an aborted takeoff, which resulted in a nose-over.NTSB GAA19CA377Accident · No injuriesData collectionFinal reportCessna 177 · Pleasanton, KSThe pilot's loss of yaw control during takeoff with a right quartering headwind in gusting wind conditions, which resulted in a collision with trees.NTSB WPR19LA176Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Fullerton, CAPartial loss of engine power during takeoff due to an age-degraded carburetor heat valve seal, which detached and partially blocked the carburetor air inlet. Contributing to the accident was an inadequate maintenance inspection.NTSB GAA19CA367Accident · Minor injuriesData collectionFinal reportCessna 172 · Lebanon, KYThe pilot's failure to maintain directional control during landing in gusting crosswind conditions, which resulted in a runway excursion, impact with a ditch, and subsequent nose-over.NTSB GAA19CA362Accident · No injuriesData collectionFinal reportCessna 172 · Tampa, FLThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and subsequent nose-over.NTSB WPR19FA163Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Antioch, CAA loss of control while conducting low-altitude, high-speed maneuvers.NTSB GAA19CA333Accident · No injuriesData collectionFinal reportPiper PA22 · Riverside, CAThe pilot's failure to the maintain the runway heading during landing with a crosswind, which resulted in impact with runway lighting and a subsequent ground loop during the landing roll.NTSB GAA19CA350Accident · No injuriesData collectionFinal reportPiper PA28 · Nowdoinham, METhe flight instructor's delayed decision to abort the takeoff from a wet, grass runway with insufficient runway remaining, which resulted in a runway overrun and the airplane going down an embankment.NTSB ERA19TA195Accident · No injuriesClass 3Final reportPiper PA28 · Westminster, MDThe pilot's failure to maintain directional control during recovery from a bounced landing, which resulted in a runway excursion.NTSB GAA19CA311Accident · No injuriesData collectionFinal reportCessna 172 · Culpeper, VAThe student pilot's improper landing flare, which resulted in a porpoised landing.NTSB CEN19LA157Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA18 · Palm City, FLA total loss of engine power due to fuel starvation.NTSB GAA19CA312Accident · No injuriesData collectionFinal reportCessna 172 · Nogalas, AZThe student pilot's failure to maintain adequate clearance from a parked fuel truck. Contributing to the accident were the student’s failure to follow company policy and the flight instructor’s delayed remedial action.NTSB ERA19TA192Accident · No injuriesClass 3Final reportCessna 172 · Stafford, VAThe pilot’s failure to maintain directional control while landing in gusting crosswind conditions, which resulted in a runway excursion.NTSB CEN19LA150Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · McKinney, TXThe pilot's loss of control during an attempted go-around in gusting crosswind conditions.NTSB GAA19CA272Accident · No injuriesData collectionFinal reportPiper PA28 · Maitland, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion, the total loss of engine power, and subsequent impact with a car during an emergency landing on a road.NTSB GAA19CA258Accident · Serious injuriesData collectionFinal reportCessna 172 · Dexter, MIThe airplane's failure to maintain a climb for reasons that could not be determined based on the available evidence.NTSB CEN19FA138Accident · 1 fatalClass 2 · FieldFinal reportChampion 7GCAA · Schlater, MSThe pilot's failure to maintain the proper airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a stall.NTSB GAA19CA247Accident · No injuriesData collectionFinal reportCessna 172 · Auburn, CAThe pilot's improper retraction of the flaps during a go-around and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB ERA19FA164Accident · 1 fatalField investigationFinal reportPiper PA28 · Foley, ALA partial loss of engine power due to a stuck exhaust valve and the flight instructor's exceedance of the airplane's critical angle of attack following the loss of power, which resulted in an aerodynamic stall at low altitude.NTSB ERA19FA161Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Tyrone, PAThe pilot’s continued visual flight rules flight into instrument meteorological conditions, resulting in controlled flight into trees and terrain.NTSB ERA19TA166Accident · Minor injuriesClass 3Final reportCessna 172 · New Bern, NCThe student pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.NTSB WPR19FA124Accident · 2 fatalClass 3 · FieldFinal reportVans RV 6 · Ridgefield, WAThe pilots' inadvertent exceedance of the airplane's critical angle of attack following an inflight collision with a bird.NTSB ERA19LA162Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Melbourne, FLA partial loss of engine power due to carburetor icing, and the flight instructor’s failure to effectively use carburetor heat while operating at an idle engine power setting in conditions conducive to carburetor icing.NTSB GAA19CA228Accident · No injuriesData collectionFinal reportBellanca 7GCAA · Lincoln, CAThe pilot receiving instruction's failure to maintain directional control during landing, which resulted in an attempted go-around and collision with a trench, and the flight instructor's delayed remedial action during the landing.NTSB GAA19CA237Accident · No injuriesData collectionFinal reportVans RV 6 · Chandler, OKThe pilot's overapplication of the brakes during landing on a grass runway, which resulted in a nose-over.NTSB CEN19LA129Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 23 · Sulphur Spring, TXThe pilot’s inadequate preflight inspection, during which he failed to detect the water contamination in the left fuel, which resulted in a partial loss of power in the left engine. Contributing to the accident was the total loss of power in the right engine…NTSB GAA19CA220Accident · No injuriesData collectionFinal reportCessna 172 · Prescott, AZThe student pilot's failure to maintain clearance from a fence post during taxi operations.NTSB GAA19CA205Accident · No injuriesData collectionFinal reportPiper PA22 · Seward, AKThe pilot's failure to maintain directional control during an attempted go-around, which resulted in impact with a snowbank.NTSB GAA19CA203Accident · No injuriesData collectionFinal reportCessna 172 · Fullteron, CAThe student pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and nose-over.NTSB ERA19LA144Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R22 · Clover, VAThe pilot's inadequate visual lookout, which resulted in a collision with trees. Contributing to the accident was the pilot’s decision to takeoff at night without adequate runway lighting.NTSB WPR19LA102Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Placerville, CAThe partial loss of engine power due to an improperly maintained carburetor.