NTSB investigations: Lycoming 0-320 series, 2018

138 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\") = 2018
    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 CEN18LA346Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Shreveport, LAThe student pilot's overshoot of the runway, which resulted from her misperception of an engine issue due to her failure to maintain proper pitch control during initial climb.Aug 22, 2018 · N4275Q · Substantial damageNTSB WPR18TA236Accident · Minor injuriesClass 3Final reportPiper PA28 · Mokuleia, HIA total loss of engine power due to fuel starvation as a result of the flight instructor's inadequate preflight inspection.Aug 21, 2018 · N98146 · Substantial damageNTSB GAA18CA504Accident · No injuriesData collectionFinal reportPiper PA18 · McGrath, AKThe pilot’s failure to maintain directional control during takeoff in a crosswind.Aug 20, 2018 · N6727A · Substantial damageNTSB GAA18CA497Accident · No injuriesData collectionFinal reportPiper PA18 · Stony RIver, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.Aug 18, 2018 · N3872Z · Substantial damageNTSB ERA18LA224Accident · No injuriesClass 3 · LimitedFinal reportGlasair SHA · Greenville, NCA total loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the pilot’s misjudgment of the airplane’s glidepath during the forced landing, which resulted in the airplane touching…Aug 18, 2018 · N38WS · Substantial damageNTSB CEN18FA336Accident · 1 fatalField investigationFinal reportCessna 172 · Rhome, TXThe pilot's inadequate maintenance of the airplane, which resulted in a total loss of engine power due to fuel starvation when organic debris restricted available fuel to the carburetor, and the pilot's impairment due to the ingestion of alcohol, which…Aug 17, 2018 · N2893Q · Substantial damageNTSB GAA18CA520Accident · No injuriesData collectionFinal reportPiper PA18 · Tyonek, AKThe pilot’s failure to maintain directional control during landing in gusting wind conditions.Aug 15, 2018 · N4165Z · Substantial damageNTSB GAA18CA490Accident · Serious injuriesData collectionFinal reportCessna 172 · DePere, WIThe pilot’s failure to maintain lateral control and his subsequent failure to maintain the runway heading during an attempted go-around, which resulted in impact with trees.Aug 14, 2018 · N1085U · Substantial damageNTSB WPR18LA241Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Afton, WYThe pilot’s failure to maintain terrain clearance after an encounter with a downdraft while maneuvering in a valley with a high-density altitude, which resulted in impact with trees and terrain.Aug 13, 2018 · N5660J · Substantial damageNTSB GAA18CA494Accident · No injuriesData collectionFinal reportPiper PA18 · Gilliam Glacier, AKThe pilot's improper decision to take off in gusting crosswind conditions, which resulted in a loss of control and collision with terrain.Aug 12, 2018 · N9884D · Substantial damageNTSB GAA18CA483Accident · No injuriesData collectionFinal reportRobinson R22 · Ocean City, NJThe flight instructor's decision to conduct hover practice at a lower altitude than recommended and his delayed remedial action during recovery from an unstable hover, which resulted in a dynamic rollover.Aug 10, 2018 · N92TR · Substantial damageNTSB GAA18CA479Accident · No injuriesData collectionFinal reportPiper PA28 · Merritt Island, FLThe pilot's exceedance of the airplane's critical angle of attack while maneuvering to avoid a bird during the landing flare, which resulted in an aerodynamic stall.Aug 9, 2018 · N487JK · Substantial damageNTSB GAA18CA478Accident · No injuriesData collectionFinal reportCessna 172 · Crystal River, FLThe pilot’s improper landing flare, which resulted in a hard landing.Aug 6, 2018 · N9608H · Substantial damageNTSB CEN18LA316Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Wiley, COThe pilot's failure to maintain proper clearance from the sprinkler guy-wire, which resulted in the airplane’s collision with the wire during a visual approach to landing.Aug 5, 2018 · N90990 · Substantial damageNTSB GAA18CA471Accident · Minor injuriesData collectionFinal reportCessna 172 · Dowagiac, MIThe pilot's failure to maintain bank control during takeoff.Aug 4, 2018 · N8994V · Substantial damageNTSB ERA18LA210Accident · Minor injuriesClass 3 · LimitedFinal reportChampion 7GCAA · Lakewood, NJThe pilot's failure to use carburetor heat in weather conditions conducive to carburetor icing, which resulted in a partial loss of engine power due to the formation of carburetor ice, a forced landing and impact with terrain.Aug 4, 2018 · N87000 · Substantial damageNTSB WPR18LA216Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Big Creek, IDThe pilot's failure to maintain directional control during the landing roll.Aug 1, 2018 · N57477 · Substantial damageNTSB WPR18LA205Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 177 · San Diego/El Cajon, CAThe pilot’s inadequate preflight planning, which resulted in his exceedance of the airplane's maximum gross weight, which lead to the airplane's poor climb performance, and a subsequent loss of control and impact with terrain.Jul 28, 2018 · N3477T · Substantial damageNTSB GAA18CA452Accident · No injuriesData collectionFinal reportCessna 172 · Wadsworth, OHThe pilot’s failure to maintain directional control during landing.Jul 28, 2018 · N4855G · Substantial damageNTSB CEN18LA299Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Columbia, ILThe airplane's inability to climb due to reduced engine power as a result of insufficient compression in all cylinders and fouled spark plugs in the No. 2 cylinder while operating near its maximum gross weight.Jul 28, 2018 · N624FL · Substantial damageNTSB GAA18CA433Accident · No injuriesData collectionFinal reportCessna 172 · Colorado Springs, COThe student pilot’s failure to maintain directional control during landing in gusting crosswind conditions.Jul 22, 2018 · N99243 · Substantial damageNTSB CEN18LA281Accident · No injuriesLimited investigationFinal reportPiper PA28 · Shreveport, LAThe partial loss of engine power for reasons that could not be determined based on the available evidence.Jul 19, 2018 · N7080F · Substantial damageNTSB GAA18CA588Accident · No injuriesData collectionFinal reportCessna 172 · Chicago, ILThe student pilot's failure to maintain clearance from a truck while taxiing.Jul 17, 2018 · N969RR · Substantial damageNTSB GAA18CA428Accident · No injuriesData collectionFinal reportCessna 172 · Nashville, TNThe pilot's improper landing flare, which resulted in a bounced landing.Jul 17, 2018 · N7880G · Substantial damageNTSB ERA18FA194Accident · 4 fatalField investigationFinal reportPiper PA34 · Miami, FLThe failure of both pilots in both airplanes to see and avoid the other airplane as they converged nearly head-on at the same altitude.Jul 17, 2018 · N16281 · 2 aircraft · DestroyedNTSB GAA18CA422Accident · No injuriesData collectionFinal reportPiper PA18S · Palmer, AKThe pilot's failure to maintain pitch control during the landing roll.Jul 16, 2018 · N3982Z · Substantial damageNTSB ERA18FA189Accident · 1 fatalField investigationFinal reportRutan Defiant · Plainville, CTThe pilot's loss of airplane control during climb for reasons that could not be determined based on the available information.Jul 12, 2018 · N17DR · Substantial damageNTSB ERA18LA190Accident · No injuriesClass 3 · LimitedFinal reportGlasair SH2 · Passadumkeag, MEA total loss of engine power due to a fatigue fracture of the crankshaft.Jul 11, 2018 · N352GL · Substantial damageNTSB GAA18CA391Accident · No injuriesData collectionFinal reportCessna 172 · Troy, MIThe student pilot’s failure to maintain a proper landing flare, which resulted in a hard, porpoised landing during an aborted go-around.Jul 2, 2018 · N6508K · Substantial damageNTSB ERA18LA182Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 25 · Flat Rock, ALThe failure of the right landing gear during takeoff due to a fatigue failure, which resulted in a runway excursion.Jun 30, 2018 · N6307Z · Substantial damageNTSB CEN18FA242Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Arthur, NEThe pilot's failure to recover from a spin for reasons that could not be determined based on the available information.Jun 29, 2018 · N9026L · Substantial damageNTSB GAA18CA402Accident · No injuriesData collectionFinal reportPiper PA28 · Rolla, MOA collision with a deer on the runway during the takeoff roll at night.Jun 28, 2018 · N7104F · Substantial damageNTSB GAA18CA385Accident · No injuriesData collectionFinal reportPiper PA18 · Anchorage, AKThe pilot’s overapplication of the brakes during landing, which resulted in a nose-over.Jun 28, 2018 · N4714Y · Substantial damageNTSB GAA18CA376Accident · No injuriesData collectionFinal reportPiper PA 18 · Cantwell, AKThe pilot's failure to see and avoid a post during a go-around following a landing on unsuitable terrain.Jun 25, 2018 · N249T · Substantial damageNTSB ANC18FA050Accident · 2 fatalField investigationFinal reportPiper PA 18-150 · Delta Junction, AKUndetermined based on the available evidence.Jun 24, 2018 · N8664Y · Substantial damageNTSB GAA18CA583Accident · No injuriesData collectionFinal reportPiper PA18 · Llano, TXThe pilot's receiving instruction’s improper landing flare and his failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall.Jun 21, 2018 · N9496D · Substantial damageNTSB GAA18CA363Accident · No injuriesData collectionFinal reportPiper PA22 · Yakutat, AKThe pilot’s failure to maintain directional control during landing.Jun 19, 2018 · N9819D · Substantial damageNTSB GAA18CA355Accident · No injuriesData collectionFinal reportPiper PA18 · Salcha, AKThe pilot’s overapplication of the brakes during landing, which resulted in a nose-over.Jun 17, 2018 · N9098D · Substantial damageNTSB ANC18LA079Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Fullerton, CAThe National Transportation Safety Board did not determine the probable cause of this event and does not plan to issue a report or open a public docket. The investigation of this event is being conducted under the jurisdiction of the Federal Bureau of…Jun 17, 2018 · N734RS · Substantial damageNTSB WPR18LA173Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 28-140 · Hartford, CTA loss of engine power for undetermined reasons because postaccident examination of the engine and fuel system did not reveal any anomalies that would have precluded normal operation, which led to the pilot’s forced landing and subsequent runway overshoot and…Jun 16, 2018 · N1782J · Substantial damageNTSB GAA18CA367Accident · No injuriesData collectionFinal reportPiper PA 18 · Wasilla, AKThe pilot’s failure to maintain directional control during landing in gusting tailwind conditions.Jun 15, 2018 · N3764Z · Substantial damageNTSB CEN18FA227Accident · 2 fatalField investigationFinal reportCessna 172N · Rotan, TXThe pilot's reckless decision to conduct low-level flight over a canyon, resulting in the airplane's impact with power lines and terrain.Jun 15, 2018 · N734BS · DestroyedNTSB GAA18CA329Accident · No injuriesData collectionFinal reportDobbs George Coot · Malone, WIThe pilot’s improper decision to take off with a known structural issue, which resulted in hull damage.Jun 7, 2018 · N100TN · Substantial damageNTSB GAA18CA362Accident · No injuriesData collectionFinal reportPiper PA18 · Healy, AKThe pilot’s overapplication of the brakes during the landing roll, which resulted in a nose-over.Jun 4, 2018 · N57787 · Substantial damageNTSB GAA18CA324Accident · No injuriesData collectionFinal reportPiper PA 22 · Talkeetna, AKThe flight instructor’s improper landing flare and failure to maintain a proper descent rate during approach, which resulted in a hard landing.Jun 4, 2018 · N7257D · Substantial damageNTSB GAA18CA307Accident · No injuriesData collectionFinal reportPiper PA28 · Butler, KYThe pilot’s improper fuel management, which resulted in fuel starvation.May 27, 2018 · N95410 · Substantial damageNTSB GAA18CA303Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot’s failure to maintain directional control during the landing roll with a tailwind.May 27, 2018 · N4018E · Substantial damageNTSB ERA18FA150Accident · 1 fatalField investigationFinal reportPiper PA28 · Chesapeake, VAThe pilot's loss of airplane control due to spatial disorientation during the departure climb in instrument meteorological conditions.May 22, 2018 · N6177W · DestroyedNTSB GAA18CA291Accident · Minor injuriesData collectionFinal reportPiper PA28 · Farmingdale, NYThe pilot’s exceedance of the airplane’s critical angle of attack during short final, which resulted in an aerodynamic stall and hard landing.May 21, 2018 · N5560W · Substantial damageNTSB GAA18CA290Accident · No injuriesData collectionFinal reportPiper PA 14 · Vashon, WAThe pilot’s failure to maintain directional control of the airplane during the takeoff roll due to his right foot inadvertently applying pressure to both rudder pedals.May 20, 2018 · N1423P · Substantial damage