NTSB investigations: Lycoming 0-320 series, 2005

192 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\") = 2005
    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 DFW05CA237Accident · Minor injuriesData collectionFinal reportCessna 172M · Amarillo, TXThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall. Contributing factors were the reported loss of engine power for undetermined reasons and the high density altitude.Sep 14, 2005 · N19998 · DestroyedNTSB MIA05LA155Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Ocean Springs, MSThe pilot's mismanagement of available fuel and continued operation with the fuel selector set to the left tank position, which resulted in fuel starvation and subsequent loss of engine power.Sep 13, 2005 · N901NS · Substantial damageNTSB ANC05FA144Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Nenana, AKThe pilot's failure to maintain minimum airspeed to avoid a stall while maneuvering, which resulted in a loss of control, a stall/spin, and impact with terrain. Factors associated with the accident were an aerobatic maneuver, and a stall/spin.Sep 13, 2005 · N36237 · Substantial damageNTSB ANC05CA140Accident · No injuriesData collectionFinal reportPiper PA-18 · Nenana, AKThe pilot's improper recovery from a bounced landing during the landing roll, which resulted in a loss of control and a nose over.Sep 13, 2005 · N7761D · Substantial damageNTSB ANC05CA146Accident · No injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a collision with a tree. A factor contributing to the accident was a tailwind.Sep 12, 2005 · N1755P · Substantial damageNTSB NYC05LA141Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Marstons Mills, MAThe pilot's failure to attain a climb during takeoff which resulted in a diminished climb rate and subsequent collision with trees. Factors were the turf runway and a tailwind.Sep 10, 2005 · N6777W · Substantial damageNTSB ATL05CA159Accident · No injuriesData collectionFinal reportPiper 28 · Andulusia, ALThe pilot's inadequate planning of the fuel supply, which resulted in fuel exhaustion and loss of engine power.Sep 10, 2005 · N8153N · Substantial damageNTSB IAD05LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Babylon, NYA broken piston and exhaust valve tappet which resulted in a total loss of engine power, and a forced landing to unsuitable terrain. A contributing factor was the failure of the operator to overhaul the engine at the manufacturer's recommended interval.Sep 6, 2005 · N8270M · Substantial damageNTSB CHI05CA253Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Rockton, ILThe pilot's excessive descent rate on approach for landing and the settling with power condition subsequently encountered. Contributing factors were the pilot's failure to reduce the descent rate prior to entering the settling with power condition and his…Sep 4, 2005 · N61LA · Substantial damageNTSB SEA05LA185Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mead, WASeparation of the tailwheel assembly spring resulting in a loss of directional control and subsequent collision with a berm. The berm was a factor in the accident.Sep 1, 2005 · N1829P · Substantial damageNTSB LAX05LA324Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Mountain City, NVThe pilot's failure to maintain airspeed while maneuvering in mountainous terrain, which led to a stall and impact with trees and terrain.Aug 31, 2005 · N2333J · Substantial damageNTSB LAX05LA283Accident · 1 fatalLimited investigationFinal reportAvions Robin R.2160 · Avalon, CAThe flight instructor's unsuccessful recovery from a spin. The underlying reason was not determined.Aug 31, 2005 · N216RN · DestroyedNTSB ANC05CA132Accident · No injuriesData collectionFinal reportCessna 172 · Tyonek, AKThe pilot's inadequate compensation for wind conditions during takeoff-initial climb, which resulted in a loss of control, and subsequent in-flight collision with a creek. A factor associated with the accident is a sudden windshift.Aug 29, 2005 · N4714F · Substantial damageNTSB CHI05LA243Accident · 1 fatalLimited investigationFinal reportAllensworth Baby Belle · El Dara, ILThe manufacturer failed to specify a relief radius on the tail rotor spindle drawings, which resulted in the spindle being manufactured with an inadequate relief radius at the point of fatigue failure.Aug 28, 2005 · N9094P · DestroyedNTSB NYC05CA136Accident · Minor injuriesData collectionFinal reportHanek Pitts S1S · Mercer, PAThe pilot's failure to maintain directional control during takeoff, which resulted in an on ground encounter with crops. A factor in this accident was the crosswind condition, as reported by the pilot.Aug 23, 2005 · N184MH · Substantial damageNTSB LAX05CA276Accident · No injuriesData collectionFinal reportCessna 172N · Ramona, CAthe pilot's failure to maintain directional control during landing.Aug 22, 2005 · N734MY · Substantial damageNTSB CHI05CA241Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Brodhead, WIThe pilot's misjudged distance/altitude which resulted in an undershoot. A related factor was the vehicle the airplane contacted.Aug 20, 2005 · N2373P · Substantial damageNTSB ANC05TA126Accident · No injuriesFinal reportPiper PA-18-150 · Cold Foot, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing down during the landing roll. A factor associated with the accident was the rough and uneven terrain.Aug 20, 2005 · N13833 · Substantial damageNTSB LAX05CA268Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Reno, NVThe pilot's inadequate compensation for the crosswind gust and failure to maintain lateral and directional control during the landing flare.Aug 14, 2005 · N6045D · Substantial damageNTSB ANC05CA152Accident · No injuriesData collectionFinal reportPiper PA-18 · Wiseman, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over during the landing roll. Factors contributing to the accident were a short landing area, and pressure to conduct the flight, which the pilot stated was a rescue situation.Aug 13, 2005 · N9950Q · Substantial damageNTSB MIA05LA148Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Lantana, FLThe CFI's delayed remedial action to recover from a practice autorotation with planned power recovery resulting in a hard landing.Aug 11, 2005 · N8320A · Substantial damageNTSB CHI05LA226Accident · 2 fatalLimited investigationFinal reportPiper PA-28-161 · Culver, INThe loss of engine power while maneuvering due to partial failure of the left magneto, and the flight instructor's failure to maintain sufficient airspeed to avoid a stall. An additional cause was improper maintenance by company maintenance personnel,…Aug 10, 2005 · N4512Q · Substantial damageNTSB DEN05LA123Accident · No injuriesLimited investigationFinal reportForbes Rutan Long EZE · Albuquerque, NMa total electrical failure due to a short in the master relay, causing the main fuse to open. Contributing factors included an inadequate electrical design by the airplane's builder, a low-output alternator, a cement wall, and unsuitable terrain on which to…Aug 7, 2005 · N16WF · Substantial damageNTSB ANC05LA127Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tyonek, AKThe instructor pilot's inadvertent touchdown during a low pass, and attempted go-around, which resulted in an in-flight collision with terrain, and nose over.Aug 6, 2005 · N4774A · Substantial damageNTSB SEA05LA162Accident · 2 fatalLimited investigationFinal reportHarmon/Lance RV-4 · Coolin, IDThe pilot's failure to maintain clearance from trees while maneuvering to base leg for landing. Trees and inadequate in-flight planning were factors.Aug 5, 2005 · N683RV · Substantial damageNTSB CHI05CA219Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Watertown, WIThe flightcrew's failure to maintain directional control during landing rollout.Aug 5, 2005 · N515KG · Substantial damageNTSB SEA05LA163Accident · No injuriesLimited investigationFinal reportSteele Safari · Leavenworth, WAThe failure of the tail rotor drive shaft during cruise flight. Factors include soft, grassy terrain at the location where the pilot executed the autorotational landing.Aug 4, 2005 · N13MA · Substantial damageNTSB SEA05CA159Accident · No injuriesData collectionFinal reportCessna 172M · Hoquiam, WAThe pilot's failure to maintain clearance from a fence. The fence was a factor.Aug 4, 2005 · N724TM · Substantial damageNTSB LAX05FA255Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · San Luis Obispo, CAThe pilot's continued flight into instrument meteorological conditions, and his failure to maintain clearance from the rising hilly terrain. Contributing factors were the pilot's inexperience regarding flying during the dark, nighttime condition, and the low…Aug 2, 2005 · N4401X · DestroyedNTSB DFW05CA203Accident · No injuriesData collectionFinal reportCessna 172M · El Dorado, ARThe student pilot's improper landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.Aug 2, 2005 · N80735 · Substantial damageNTSB NYC05LA125Accident · No injuriesLimited investigationFinal reportCessna 172P · Caldwell, NJThe pilot's improper flare, which resulted in a hard landing. A factor was a partial loss of engine power, as reported by the pilot, for undetermined reasons.Jul 28, 2005 · N98730 · Substantial damageNTSB CHI05CA205Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Holland, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall, and subsequent collision with trees. Contributing to the accident were the trees.Jul 28, 2005 · N602EA · DestroyedNTSB ANC05CA108Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Aleknagik, AKThe pilot's inadequate compensation for the gusty crosswind conditions during an aborted takeoff, which resulted in an on ground collision with a tree. Factors associated with the accident are the gusty crosswind, and the pilot's failure to maintain…Jul 26, 2005 · N6195D · Substantial damageNTSB IAD05LA113Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chatham, VAThe pilot's failure to ensure that the fuel selector valve was properly engaged, which resulted in fuel starvation and subsequent loss of engine power.Jul 24, 2005 · N3818P · Substantial damageNTSB IAD05LA108Accident · No injuriesLimited investigationFinal reportRobinson R22 · Nashua, NHThe flight instructor's failure to maintain aircraft control during a introductory flight and his inadequate remedial actions.Jul 22, 2005 · N8041J · Substantial damageNTSB NYC05CA122Accident · No injuriesData collectionFinal reportGulfstream American AA-5A · Schroon Lake, NYThe pilot's misjudgment of speed/distance which resulted in an overrun.Jul 21, 2005 · N26784 · Substantial damageNTSB ANC05CA103Accident · No injuriesData collectionFinal reportCessna 172 · Kenai, AKThe pilot's selection of an unsuitable landing area, which resulted in a nose over. A factor associated with the accident was swampy terrain.Jul 21, 2005 · N7886G · Substantial damageNTSB LAX05CA240Accident · No injuriesData collectionFinal reportCessna 172N · North Las Vegas, NVthe student pilot's failure to maintain directional control.Jul 20, 2005 · N4961D · Substantial damageNTSB CHI05FA194Accident · 1 fatalField investigationFinal reportCessna 172P · Jackson, WIThe pilot not maintaining aircraft control for undetermined reasons while maneuvering.Jul 20, 2005 · N65875 · DestroyedNTSB ATL05CA132Accident · No injuriesData collectionFinal reportCessna 172P · Savannah, GAThe pilot's failure to maintain directional control on landing roll out resulting in a ground loop, and on ground collision of the right wing with the ground.Jul 18, 2005 · N5299K · Substantial damageNTSB SEA05LA147Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yellow Pine, IDThe pilot's selection of unsuitable terrain for takeoff, and his failure to maintain directional control after the aircraft's right main gear contacted a small dirt mound during the takeoff roll at the remote grass airstrip. Factors include the pilot's…Jul 17, 2005 · N721JW · Substantial damageNTSB SEA05LA145Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bonners Ferry, IDThe pilot's failure to maintain terrain clearance while maneuvering. Mountainous terrain was a factor.Jul 17, 2005 · N120ER · Substantial damageNTSB MIA05LA135Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Gulfport, MSA loss engine power for undetermined reasons, that resulted in a forced landing, and damage to the helicopter during the landing.Jul 16, 2005 · N2614D · Substantial damageNTSB LAX05CA230Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe student pilot's failure to maintain clearance from a fuel truck, and the flight instructor's inadequate supervision.Jul 12, 2005 · N9886K · Substantial damageNTSB NYC05FA117Accident · 2 fatalField investigationFinal reportCarlstrom Long EZ · Lewes, DEThe Long EZ pilot's failure to maintain clearance from the RV-8 airplane, which resulted in a mid-air collision during a formation flight.Jul 10, 2005 · N78LC · 2 aircraft · DestroyedNTSB ANC05CA099Accident · No injuriesData collectionFinal reportCessna 172 · Akiachak, AKThe pilot's delay in aborting the landing, which resulted in the airplane running off the end of the runway and nosing over. A factor associated with the accident was the rough/uneven terrain off the end of the runway.Jul 9, 2005 · N73788 · Substantial damageNTSB IAD05LA096Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Cape May, NJA partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain to perform a forced landing.Jul 5, 2005 · N6289Z · Substantial damageNTSB IAD05LA095Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5 · Branchville, NJAn electrical fire of unknown origin. A factor in the accident was the pilot's failure to perform the In-Flight Electrical Fires checklist.Jul 5, 2005 · N6061L · Substantial damageNTSB SEA05CA140Accident · No injuriesData collectionFinal reportPiper PA-22 · Kamaih, IDFuel starvation due to the pilot's improper placement of the fuel selector, resulting in a loss of engine power, and collision with terrain.Jul 3, 2005 · N1735P · Substantial damageNTSB ANC05LA094Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Whittier, AKThe pilot's becoming lost/disoriented while maneuvering due to inadequate in-flight planning/decision making, which resulted in fuel exhaustion and a forced landing in tree-covered terrain. A factor contributing to the accident was fuel exhaustion.Jul 3, 2005 · N8626V · Substantial damage