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.

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.Aug 5, 2019 · N7402D · DestroyedNTSB 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.Jul 30, 2019 · N6754J · Substantial damageNTSB 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.Jul 28, 2019 · N79575 · Substantial damageNTSB 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.Jul 27, 2019 · N82253 · Substantial damageNTSB GAA19CA468Accident · No injuriesData collectionFinal reportCessna 172 · Gaithersburg, MDThe other pilot's failure to maintain clearance from the airplane while taxiing.Jul 27, 2019 · N13796 · 2 aircraft · Minor damageNTSB 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.Jul 23, 2019 · N737DW · Substantial damageNTSB 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.Jul 21, 2019 · N6PF · Substantial damageNTSB 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.Jul 20, 2019 · N777DV · Substantial damageNTSB 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.Jul 16, 2019 · N1079M · Substantial damageNTSB 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.Jul 14, 2019 · N7833D · Substantial damageNTSB 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…Jul 14, 2019 · N6983B · Substantial damageNTSB 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.Jul 14, 2019 · N29516 · Substantial damageNTSB 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.Jul 10, 2019 · N4245J · Substantial damageNTSB 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.Jul 9, 2019 · N9161S · Substantial damageNTSB 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.Jul 8, 2019 · N9919V · Substantial damageNTSB 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.Jul 6, 2019 · N796AB · Substantial damageNTSB 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.Jul 1, 2019 · N279G · Substantial damageNTSB 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.Jun 30, 2019 · N78658 · Substantial damageNTSB 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.Jun 28, 2019 · N26498 · Substantial damageNTSB 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.Jun 27, 2019 · N3914M · Substantial damageNTSB 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.Jun 27, 2019 · N30257 · Substantial damageNTSB 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.Jun 21, 2019 · N64460 · Substantial damageNTSB 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.Jun 15, 2019 · N75903 · Substantial damageNTSB 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.Jun 14, 2019 · N84402 · Substantial damageNTSB WPR19FA163Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Antioch, CAA loss of control while conducting low-altitude, high-speed maneuvers.Jun 10, 2019 · N7943C · DestroyedNTSB 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.Jun 9, 2019 · N6865B · Substantial damageNTSB 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.Jun 7, 2019 · N7227F · Substantial damageNTSB 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.Jun 6, 2019 · N9476R · Substantial damageNTSB GAA19CA311Accident · No injuriesData collectionFinal reportCessna 172 · Culpeper, VAThe student pilot's improper landing flare, which resulted in a porpoised landing.Jun 3, 2019 · N1930V · Substantial damageNTSB CEN19LA157Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA18 · Palm City, FLA total loss of engine power due to fuel starvation.May 27, 2019 · N70699 · Substantial damageNTSB 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.May 23, 2019 · N273EB · Substantial damageNTSB 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.May 23, 2019 · N64003 · Substantial damageNTSB CEN19LA150Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · McKinney, TXThe pilot's loss of control during an attempted go-around in gusting crosswind conditions.May 23, 2019 · N1568J · DestroyedNTSB 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.May 16, 2019 · N6753W · Substantial damageNTSB 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.May 11, 2019 · N21794 · Substantial damageNTSB 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.May 7, 2019 · N7665S · Substantial damageNTSB 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.May 6, 2019 · N734DX · Substantial damageNTSB 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.May 6, 2019 · N5542U · DestroyedNTSB 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.May 1, 2019 · N733KZ · Substantial damageNTSB 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.Apr 30, 2019 · N733UF · Substantial damageNTSB 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.Apr 29, 2019 · N90LK · Substantial damageNTSB 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.Apr 29, 2019 · N3031W · Substantial damageNTSB 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.Apr 28, 2019 · N5046E · Substantial damageNTSB 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.Apr 27, 2019 · N621L · Substantial damageNTSB 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…Apr 27, 2019 · N233P · Substantial damageNTSB GAA19CA220Accident · No injuriesData collectionFinal reportCessna 172 · Prescott, AZThe student pilot's failure to maintain clearance from a fence post during taxi operations.Apr 23, 2019 · N1897V · Substantial damageNTSB 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.Apr 14, 2019 · N3821P · Substantial damageNTSB 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.Apr 11, 2019 · N9964L · Substantial damageNTSB 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.Apr 7, 2019 · N4047H · DestroyedNTSB WPR19LA102Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Placerville, CAThe partial loss of engine power due to an improperly maintained carburetor.Mar 31, 2019 · N7033Q · Substantial damage