NTSB investigations: Lycoming 0-320 series, 2004
226 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\") = 2004
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.
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") = 2004
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" 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 ANC04LA120Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nenana, AKThe loss of engine power during takeoff-initial climb for an undetermined reason, which resulted in an emergency descent and hard landing.NTSB SEA04CA193Accident · No injuriesData collectionFinal reportPiper PA-28 · Deer Harbor, WAThe pilot's failure to perform remedial action during the landing sequence. A factor contributing to the accident was the wet runway surface.NTSB CHI04CA281Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Jackson, MICollision with a deer when it crossed the airplane's path during landing rollout. Factors were low lighting (night) conditions and the pilot's inability to maintain directional control due to the collision.NTSB DEN04LA147Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Provo, UTthe pilot's premature liftoff which resulted in failure to attain airspeed which resulted in a stall.NTSB CHI04LA283Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Houstonia, MOThe fatigue failure of the piston end of the connecting rod and the pilot's failure to maintain aircraft control during the forced landing.NTSB ATL04CA188Accident · Serious injuriesData collectionFinal reportCessna 172L · Kill Devil Hlls, NCAn in-flight encounter with a downdraft on final approach, which resulted in a loss of control of the airplane and subsequent collision with the ground.NTSB ANC04LA110Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Slana, AKThe pilot's failure to compensate for wind conditions during landing, and his failure to maintain adequate airspeed, which resulted in a loss of control, and subsequent collision with trees during an uncontrolled descent. Factors contributing to the accident…NTSB CHI04CA258Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Detroit, MIThe student pilot's failure to maintain directional control of the airplane during the landing flare and subsequent go-around. A factor was the T-hangar.NTSB SEA04CA186Accident · No injuriesData collectionFinal reportGrumman American AA-5A · Brooks, ORThe flight instructor's failure to maintain altitude/clearance on final approach to land resulting in an in-flight collision with terrain. Contributing factors were the student pilot's failure to maintain adequate airspeed during the approach and the flight…NTSB CHI04CA242Accident · No injuriesData collectionFinal reportAeronca Champion 7GCBC · Mullen, NEthe failure of the pilot to maintain direction control during gusty wind conditions on landing.NTSB ATL04CA180Accident · No injuriesData collectionFinal reportWood/Thorpe T-18 · Olive Branch, MSThe pilot's failure to maintain directional control of the airplane during landing.NTSB NYC04LA211Accident · No injuriesLimited investigationFinal reportCessna 172M · Medina, OHThe partial loss of engine power due to inadequate maintenance and by failure to comply with service instruction for low engine compression.NTSB CHI04LA253Accident · Serious injuriesLimited investigationFinal reportWilliams Glastar GS-1 · Hayward, WIThe pilot's failure to adequately compensate for the wind conditions which resulted in a loss of aircraft control. A factor associated with the accident was the gusty wind condition.NTSB ATL04CA184Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Mount Pleasant, SCGround collision with an animal (deer) during an attempted takeoff.NTSB ANC04LA118Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Kenai, AKThe pilot's selection of an unsuitable landing/takeoff site, which resulted in a loss of control and a nose over during an aborted takeoff. Factors in the accident were soft terrain, and the pilot's failure to maintain directional control.NTSB SEA04LA183Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Blaine, WAThe instructor pilot's inadequate remedial action during his student's final approach for a simulated engine out water landing.NTSB ANC04CA111Accident · No injuriesData collectionFinal reportChampion 7GCBC · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the collapse of the right main landing gear during the landing roll. A factor contributing to the accident was rough and uneven terrain.NTSB CHI04LA248Accident · No injuriesLimited investigationFinal reportCessna 172 · Gary, INThe failure of the nose wheel for undetermined reasons. A factor associated with the accident was the student pilot's failure to properly flare the airplane.NTSB CHI04CA247Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Grant, NEDirectional control not attained and the control interference encountered by the pilot during landing roll. The ditch was a contributing factor.NTSB CHI04CA246Accident · Minor injuriesData collectionFinal reportUtterback Mustang II · Kendallville, INThe pilot's improper recovery from a bounced landing and his failure to maintain aircraft control.NTSB ANC04LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Cantwell, AKAn in-flight fire for an undetermined reason, which resulted in an off-airport forced landing and subsequent destruction of the airplane by fire.NTSB FTW04LA231Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Mountain Home, TXThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB ANC04LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's failure to compensate for a crosswind during the landing roll, and his failure to maintain directional control which resulted in a loss of control, an encounter with a ditch, and the airplane nosing over. A factor in the accident was a crosswind.NTSB NYC04FA197Accident · 2 fatalField investigationFinal reportRobinson R-22 · Northport, NYAn improper maneuver by the flightcrew while attempting to avoid a kite, which resulted in mast bumping, the separation of the main rotor system, and a subsequent uncontrolled descent into water.NTSB NYC04CA200Accident · No injuriesData collectionFinal reportCessna 177 · Warrenton, VAThe pilot's incorrect aborted landing procedure, which resulted in a collision with terrain.NTSB NYC04CA198Accident · No injuriesData collectionFinal reportPettigrew, Richard RV-6A · Williamstown, NJThe pilot's improper flare, which resulted in a hard landing.NTSB FTW04LA222Accident · No injuriesLimited investigationFinal reportLancair 320 · Houston, TXThe pilot's premature lift-off before attaining adequate airspeed resulting in a stall and collision with the ground.NTSB ANC04LA096Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Paxson, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with a rock and subsequent main landing gear collapse during the landing roll. A factor contributing to the accident was rough, uneven terrain.NTSB MIA04LA122Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · West Palm Beach, FLThe partial loss of engine power due to low cylinder compression during recovery from a practice autorotation resulting in a hard landing and damage to the helicopter.NTSB LAX04CA298Accident · No injuriesData collectionFinal reportBerry Hatz CB-1 · Upland, CAthe pilot's inadequate recovery following a bounced landing, improper use of the rudder control, and failure to maintain directional control.NTSB FTW04LA215Accident · No injuriesLimited investigationFinal reportCessna 172N · New Braunfels, TXThe student pilot's failure to maintain directional control of the airplane. A contributing factor was the high wind condition.NTSB CHI04CA228Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Elkhart, INThe failure of the seat during landing roll and the subsequent pilot's airplane handling not being possible.NTSB SEA04LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Irby, WALoss of engine power for unknown reasons. Trees and rough/uneven terrain were factors.NTSB DEN04LA123Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Spanish Fork, UTthe pilot's improper inflight planning and decision making, and his failure to maintain terrain clearance. Contributing factors were his intentional low altitude flight and maneuvering, the aircraft's climb performance being exceeded, and the trees.NTSB ANC04LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Soldotna, AKThe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall and uncontrolled descent.NTSB IAD04LA036Accident · 1 fatalLimited investigationFinal reportCessna 172M · Brownville Junc, METhe pilot's continued visual flight into instrument meteorological conditions, which resulted in the airplane's controlled flight into rising terrain. Factors included the instrument meteorological conditions and the rising terrain.NTSB CHI04FA223Accident · 1 fatalField investigationFinal reportCessna 172L · Webster, WIThe high velocity impact with terrain for undetermined reasons.NTSB DEN04FA119Accident · 2 fatalField investigationFinal reportCessna 172P · Monarch Crest, COthe pilot's failure to maintain airspeed which resulted in a stall, and his decision to conduct flight beyond the performance capability of the aircraft. A contributing factor was the high density altitude, and an inadvertent stall.NTSB NYC04CA189Accident · No injuriesData collectionFinal reportCessna 172P · Wilkes-Barre, PAThe student pilot's improper flare and improper recover from a bounced landing. Factors in this accident were the crosswind condition and the partial failure of the airplane's transceiver, as reported by the pilot.NTSB IAD04LA035Accident · Serious injuriesLimited investigationFinal reportGiles Mustang II · Rainelle, WVThe partial loss of engine power due to a broken throttle mechanism, which resulted in a forced landing over unsuitable terrainNTSB SEA04LA157Accident · Serious injuriesLimited investigationFinal reportHeadrick Vans RV9A · Westport, WAFuel starvation as a result of the pilot's improper fuel management. Carburetor icing conditions and trees were a factor.NTSB NYC04FA185Accident · 2 fatalField investigationFinal reportCessna A150L · Kinnelon, NJBoth pilots inadequate visual lookout, which resulted in a midair collision.NTSB ANC04LA091Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKThe pilot's misjudged distance/altitude during the final approach phase of landing, which resulted in an undershoot and subsequent collision with terrain.NTSB FTW04CA205Accident · No injuriesData collectionFinal reportCessna 172N · Cleveland, TXThe student pilot's improper judgment of the airplanes altitude during landing. A contributing factor was the pilot's level of anxiety/apprehension after becoming lost/disoriented.NTSB MIA04FA115Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Miami, FLThe failure of company maintenance personnel to secure the push/pull tube to the left lug of the non-rotating portion of the swashplate assembly following maintenance, and the inability of the pilot to control the helicopter resulting in the in-flight…NTSB SEA04CA151Accident · No injuriesData collectionFinal reportPiper PA22-20 · Wht Sulphur Spg, MTThe failure of the private pilot receiving flight training for a tail wheel endorsement to maintain aircraft control, and his excessive braking during the landing roll, subsequently nosing over the airplane. A contributing factor was the flight instructor's…NTSB FTW04LA199Accident · 2 fatalLimited investigationFinal reportDrzymala RV-4 · Collinsville, TXThe pilot's improper in-flight planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CHI04CA211Accident · No injuriesData collectionFinal reportStamsta Wittman Tailwind W10 · Waunakee, WIThe pilot's failure to maintain proper airspeed during final approach, which resulted in the inadvertent stall/mush at a low altitude and subsequent hard landing. A factor to the accident was the pilot's unsuccessful remedial action to the encountered…NTSB DEN04LA114Accident · No injuriesLimited investigationFinal reportCessna 172N · Hurricane, UTthe student pilot's failure to maintain aircraft control during the landing. Contributing factors include the crosswind, the wind gusts, and the exceeded maximum demonstrated crosswind component.NTSB CHI04LA201Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Custer, SDThe pilot's poor preflight planning/preparation and the pilot used improper aborted takeoff procedures by not reducing the throttle. Factors associated with the accident were the high density altitude and the tailwind.