Lycoming O-360-C4P
NTSB investigations · 31
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 ('42289')
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 ('42289')
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 ANC24LA050Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC18-180 · Bethel, AKThe pilot's failure to maintain directional control during landing which resulted in a ground loop.NTSB WPR23LA101Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC18-180 · Dallesport, WAThe flight instructor’s failure to see and avoid a channel marker during a step taxi in preparation for takeoff on the water.NTSB ANC22LA029Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Beluga, AKThe pilot’s excessive touchdown speed, which resulted in a long landing and impact with terrain.NTSB ANC22LA006Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC-18-180 · Yukon Charlie River, AKThe pilot’s selection of an unsuitable landing site, which resulted in a nose-over.NTSB GAA19CA211Accident · No injuriesData collectionFinal reportTubbs S/Performance Air PA-18-225 · Denver, COThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB GAA19CA167Accident · No injuriesData collectionFinal reportCub Crafters CC18 · Yakima, WAThe pilot's failure to maintain directional control during landing, which resulted in a ground loop, and the flight instructor's delayed remedial action.NTSB GAA18CA541Accident · No injuriesData collectionFinal reportCub Crafters CC18 · Northway, AKThe airplane’s collision with a bird during straight-and-level flight.NTSB GAA18CA521Accident · No injuriesData collectionFinal reportCub Crafters CC18 · Fairbanks, AKThe pilot’s premature liftoff and subsequent settling of the airplane to the gravel airstrip.NTSB WPR18LA176Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 18-150 · Yellow Pine, IDThe pilot’s failure to maintain adequate airspeed while conducting a go-around and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall/spin at too low of an altitude to recover. Contributing to the accident were…NTSB GAA18CA101Accident · No injuriesData collectionFinal reportCub Crafters CC18-180 · Winnimucca, NVThe pilot’s failure to maintain directional control and her use of excessive braking during landing, which resulted in a nose-over.NTSB CEN15FA255Accident · 2 fatalField investigationFinal reportCub Crafters CC18-180 · Raton, NMThe pilot's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB ANC15TA003Accident · No injuriesFinal reportCub Crafters CC18-180 · Anchorage, AKThe pilot’s failure to maintain directional control while attempting to drag an off-airport landing site.NTSB WPR14CA339Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Lysite, WYThe pilot's failure to ensure the airplane was configured for takeoff.NTSB ERA14LA294Accident · No injuriesLimited investigationFinal reportCub Crafters CC18-180 · Pennsboro, WVA loss of engine power during initial climb for reasons that could not be determined because the postaccident engine examination did not reveal any anomalies that would have precluded normal operation.NTSB ANC11TA109Accident · No injuriesFinal reportCub Crafters CC18-180 · Palmer, AKThe pilot's excessive application of the brakes during landing, which resulted in a nose-over.NTSB CEN10CA488Accident · No injuriesData collectionFinal reportTubbs S/Performance Air PA18-225 · Denver, COThe pilot's failure to maintain control of the airplane during landing.NTSB CEN09LA190Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A · Wood Lake, NEThe pilot's failure to maintain adequate airspeed during the initial climb, which resulted in an aerodynamic stall.NTSB ANC08FA072Accident · 1 fatalField investigationFinal reportPiper PA-18 · Quinhagak, AKThe pilot's failure to maintain adequate airspeed while maneuvering at a low altitude in high winds, resulting in an aerodynamic stall and uncontrolled descent to the ground. Contributing to the accident were the high winds.NTSB SEA07CA153Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Hailey, IDThe pilot's failure to maintain directional control during the takeoff ground roll. A tailwind was a factor.NTSB ANC05LA052Accident · No injuriesLimited investigationFinal reportCub Crafters PA-18 · Fairbanks, AKThe flight instructor's inadequate supervision of the flight, and the dual student's failure to maintain directional control.NTSB ATL04LA183Accident · No injuriesLimited investigationFinal reportPiper PA-18 · San Juan, PRThe pilot's failure to apply carburetor heat which resulted in carburetor ice and the subsequent loss of engine power. A factor was weather conditions favorable for carburetor ice.NTSB ANC04FA056Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Cold Bay, AKA loss of engine power during the final approach to land for an undetermined reason, and the pilot's failure to maintain airspeed during the ensuing emergency descent, which resulted in an inadvertent stall. A factor associated with the accident was the stall.NTSB DEN99LA097Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Glenwood Sprngs, COThe pilot-in-command's failure to maintain directional control. A related factor was the gusty quartering tailwind.NTSB ANC98LA044Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Talkeetna, AKthe pilot's inadequate aircraft preflight. A factor was the inadvertent activation of the parking brake.NTSB ANC96LA073Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cold Bay, AKthe pilot's excessive taxi speed. Factors associated with the accident were: the pilot's improper preflight inspection of the airplane, and the entanglement of the left main landing gear brake and axle with wire.NTSB ANC91FA067Accident · Serious injuriesField investigationFinal reportPiper PA-18-150 · Wasilla, AKThe powerplant failure for undetermined reasons and the collision with the wires.NTSB CHI82DA220Accident · Minor injuriesFinal reportPiper PA-18 · Hobart, INDuring takeoff, the engine lost power at an altitude of about 150 to 200 ft AGL. Subsequently, during a forced landing, the aircraft flew through a row of trees when the pilot tried to reach an open area that turned out to be a grave yard. The pilot believed…NTSB FTW75FQG25Accident · No injuriesClosedPiper PA-18 · San Angelo, TXNTSB SEA73DTA04Accident · No injuriesClosedPiper PA-18 · Outlook, MTNTSB DEN71DXA21Accident · No injuriesClosedPiper PA-18 · Seely, WYNTSB DEN67A0006Accident · 1 fatalClosedPiper PA-18 · Walsh, CO
Back to Lycoming O-360-C4P