Lycoming O-320-H2AD
NTSB investigations · 18
Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.engine_model_code IN ('42131')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.engine_model_code IN ('42131')
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 CEN23LA300Accident · No injuriesClass 4 · LimitedFinal reportAcrosport II · Hertford, NCThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and subsequent impact with vegetation.NTSB WPR22LA013Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Laurier, WAThe flight instructor’s delayed remedial action to prevent the airplane from landing long which, resulted in a runway overrun and collision with terrain.NTSB WPR21LA346Accident · Serious injuriesClass 4 · LimitedFinal reportGordon Scot A RV-6A · Palouse, WAThe pilot's improper landing flare, which resulted in a bounced landing and subsequent nose over.NTSB CEN20CA393Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 172 · Houston, TXThe student pilot’s failure to maintain directional control upon landing.NTSB CEN20CA307Accident · Serious injuriesClass 4 · Data collectionFinal reportVans Vans RV 6 · Imperial, NEThe pilot's inadequate preflight performance planning and his decision not to utilize all available runway during high density altitude operations which led to an inflight loss of control and subsequent collision with terrain.NTSB ERA19FA243Accident · 2 fatalClass 2 · FieldFinal reportPoberezny Acro Sport II · Jersey Shore, PAThe pilot's decision to conduct low altitude aerobatic maneuvers which resulted in an exceedance of the airplane’s critical angle of attack while maneuvering at a low altitude, which resulted in an aerodynamic stall.NTSB ERA19LA150Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · New York, NYThe pilot's decision to initiate a flight into low instrument flight rules conditions, which resulted in six missed approaches at two airports and a total loss of engine power due to fuel exhaustion. Contributing to the accident was the external pressure the…NTSB WPR19LA006Accident · 1 fatalClass 2 · LimitedFinal reportVans RV6 · Cape Girardeau, MOThe pilot's improper landing flare in gusting crosswind conditions, his failure to conduct a go-around, and his failure to maintain directional control, which resulted in a runway departure and nose-over.NTSB ANC16CA055Accident · No injuriesData collectionFinal reportKirbybilt Xcalibur · Valdez, AKThe pilot's failure to maintain an adequate glide path during landing, which resulted in the airplane landing short of the airstrip, a landing gear collapse, and subsequent substantial damage to the fuselage.NTSB CEN11LA014Accident · Serious injuriesLimited investigationFinal reportDrake Ronald A Acro Sport 1 · Fowlerville, MIThe pilot's loss of control during a go-around maneuver following a bounced landing. Contributing to the accident was the pilot's limited experience in the make and model airplane.NTSB ERA10LA007Accident · 1 fatalLimited investigationFinal reportCase Richard L VAN RV-6 · Magnolia, NCThe pilot's continued visual flight into instrument meterological conditions and his subsequent failure to maintain aircraft control. Contributing to the accident was the pilot's inadequate preflight evaluation of the weather.NTSB CEN09CA382Accident · Serious injuriesData collectionFinal reportBakeng Deuce · Beach City, TXThe loss of engine power due to fuel starvation resulting from a partially crimped fuel tank vent tube.NTSB CHI07CA004Accident · No injuriesData collectionFinal reportCessna 172N · St Charles, MOThe pilot's failure to properly judge the landing flare and his inadequate recovery from the resulting bounced landing. A contributing factor was the inadvertent pilot induced oscillation (porpoise) after initial runway contact.NTSB FTW96LA010Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Crockett, TXfailure of both magnetos to operate properly due to inadequate maintenance by other maintenance personnel. A factor was the lack of suitable terrain available for the forced landing.NTSB LAX92LA071Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZThe failure of the pilot to maintain an adequate visual lookout while taxiing the aircraft.NTSB ATL85LA162Accident · No injuriesLimited investigationFinal reportCessna 172N · Broxton, GAThe acft collided with power lines on final apch to a private airstrip. The acft was landed in a field next to the rwy. The wires were not marked. The plt reported he was aware of the large power lines near the apch end of rwy 36 but was unaware of the small…NTSB FTW82DA247Accident · No injuriesFinal reportCessna 172 · Houston, TXAfter the student pilot returned from a cross-country. He taxied into the parking area, but noticed there were no parking spaces available. While making a 180 deg turn, the right wing struck a fence post. After hitting the post, the plane turned and the…NTSB MIA77FA086Accident · 1 fatalClosedCessna 172N · Bunnell, FL
Back to Lycoming O-320-H2AD