NTSB investigations: Lycoming O-360-A1A
78 cases on aircraft whose registry engine model is Lycoming O-360-A1A. 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41594'))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41594'))
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 WPR09CA306Accident · No injuriesData collectionFinal reportJenkins Jack Glastar SP · Coupeville, WAThe pilot’s improper landing flare that resulted in a hard landing on soft/grassy terrain.NTSB CEN09LA236Accident · Serious injuriesLimited investigationFinal reportArgence RV-8 · Angleton, TXThe pilot's failure to maintain clearance from trees during initial climbout.NTSB ANC08FA087Accident · 3 fatalField investigationFinal reportIversen Glastar SH-4 · Kenai, AKThe pilot's failure to maintain adequate airspeed during maneuvering flight, which resulted in an aerodynamic stall and uncontrolled descent to the ground. Contributing to the accident was the airplane's overgross weight condition.NTSB SEA08LA057Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Sonoma, CAThe departing pilot's inadequate visual lookout.NTSB NYC08LA027Accident · Minor injuriesLimited investigationFinal reportVans RV-7A · West Point, VAA loss of engine power for undetermined reasons.NTSB DFW07CA200Accident · Minor injuriesData collectionFinal reportVans RV-7A · Vernon, TXThe pilot's failure to maintain control of the airplane while landing. A contributing factor was the prevailing tailwind.NTSB ATL07CA096Accident · Minor injuriesData collectionFinal reportBurk RV-6A · Laurel, MDThe pilot's improper landing flare resulting in an inadvertent stall and hard landing, which resulted in the airplane sliding off the runway and nosing over.NTSB DFW07CA093Accident · No injuriesData collectionFinal reportDwayne Smith RV-6 · Fort Worth, TXThe loss of engine power during cruise flight for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC06CA225Accident · No injuriesData collectionFinal reportPiper PA-25-180 · Mount Holly, NJThe pilot's improper starting procedure, which resulted in an uncontrolled taxi, and collision with a parked airplane.NTSB DEN06CA117Accident · No injuriesData collectionFinal reportGordon Vans RV-6 · Erie, COthe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the crosswind.NTSB DEN05LA121Accident · 1 fatalLimited investigationFinal reportSheel Vans RV-8 · Fort Collins, COthe pilot inadvertently stalling the airplane and descending into the ground. Contributing factors were the pilot's inadequate preflight planning/preparation and his failure to refuel the airplane, resulting in a loss of engine power due to fuel exhaustion.NTSB MIA05LA136Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B2B · Ft. Pierce, FLThe pilot's inadequate preflight planning/preparation, and failure to refuel the helicopter prior to takeoff which resulted in fuel exhaustion and a loss of engine power during the landing.NTSB DEN05CA095Accident · No injuriesData collectionFinal reportVans RV-6A · Trinidad, COthe pilot's inadequate compensation for wind and his inadequate recovery from a bounced landing.NTSB MIA05LA052Accident · No injuriesLimited investigationFinal reportPaul Pajak RV-6A · Sanford, FLThe pilots failure to use carburetor heat in conditions conducive to carburetor icing which resulted in loss of engine power and collision with trees and ground during the resultant forced landing.NTSB NYC04LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Philadelphia, PAThe inadequate visual lookout by the pilot of RV-6A and his failure to maintain clearance while taxiing, which resulted in an on-ground collision with the Piper.NTSB MIA04LA012Accident · No injuriesLimited investigationFinal reportHeadburg RV6 · Wellington, FLthe failure of the dual student pilot to maintain airspeed, and the CFI to properly supervise the dual student, which resulted in an inadvertent stall, and subsequent impact with an embankment, during a simulated loss of engine power.NTSB SEA04LA004Accident · No injuriesLimited investigationFinal reportSeabase Magnum · Olney, MTThe pilot's failure to adequately preflight the aircraft to verify the fuel quantity, resulting in fuel exhaustion and the loss of engine power during cruise flight. Contributing factors were the pilot's failure to refuel the aircraft and the soft terrain.NTSB SEA03LA154Accident · Serious injuriesLimited investigationFinal reportBollinger RV-6A · Wenatchee, WAFuel starvation following the separation of a purge valve assembly as a result of the builders failure to re-safety the face retaining/stop screw on the fuel vapor purge valve after the safety wire on the subject screw was removed in order to change the…NTSB DEN03LA058Accident · No injuriesLimited investigationFinal reportAviat A-1B · Englewood, COthe pilot's failure to maintain directional control of the airplane, resulting in an inadvertent ground loop. A contributing factor was the gusty winds.NTSB DEN01LA101Accident · No injuriesLimited investigationFinal reportGarrett Starduster TOO SA300 · Woodrow, COa precautionary landing on unsuitable terrain which was rough and uneven. Factors were deteriorating weather in the form of freezing rain, snow, and decreasing visibility.NTSB MIA00LA259Accident · No injuriesLimited investigationFinal reportEugene L. Capozzi VAN RV-6A · Bayou La Batre, ALThe pilots failure to maintain airspeed during final approach result in the aircraft stalling and descending uncontrolled until ground impact.NTSB CHI86LA040Accident · No injuriesLimited investigationFinal reportCessna 177 · Crookston, MNWhile doing a 270 degree turn on base leg for runway realignment the pilot permitted the acft to fly into the ground.NTSB ANC85LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe plt reported that when he departed seward. The fuel gages indicated there was aprx 15 gal on board. About 5 min from the intended destination, the eng lost power from fuel exhaustion while the left fuel gage showed there was 5 gal remaining. During an…NTSB LAX81DVG16Accident · No injuriesClosedCessna 177 · Napa, CANTSB NYC80FGM01Accident · Minor injuriesClosedCessna 177 · Jeannette, PANTSB MKC76DCJ38Accident · No injuriesClosedPiper PA-28 · Hallam, NENTSB NYC73FNA11Accident · Serious injuriesClosedCessna 177 · Nantucket, MANTSB MKC69F0280Accident · No injuriesClosedPiper PA-12 · Beach, ND