NTSB investigations, 2010

654 cases where the sequence of events included Collision with terr/obj (non-CFIT).

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\") = 2010
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 ERA10WA498Accident · Minor injuriesForeign investigationAero Commander 500 · Santo Domingo, Dominican RepublicSep 23, 2010 · N100PV · Substantial damageNTSB ERA10CA497Accident · Minor injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · New Castle, VAThe pilot's delayed decision to abort the takeoff, which resulted in a collision with terrain.Sep 22, 2010 · N8001J · Substantial damageNTSB ERA10CA496Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Marlboro, MAThe pilot’s improper touchdown point and failure to perform a go-around in a timely manner, which resulted in a runway excursion.Sep 22, 2010 · N260ND · Substantial damageNTSB WPR10LA465Accident · No injuriesLimited investigationFinal reportMooney M20C · Visalia, CAA partial loss of engine power during takeoff, which resulted from the failure of the spark plug retention mechanism.Sep 21, 2010 · N6090Q · Substantial damageNTSB WPR10CA466Accident · Minor injuriesData collectionFinal reportHiller UH-12E · Mecca, CAThe pilot's failure to maintain clearance from an obstacle while maneuvering.Sep 21, 2010 · N6053H · Substantial damageNTSB CEN10CA553Accident · Serious injuriesData collectionFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Blessing, TXThe pilot's failure to maintain clearance from wires while maneuvering.Sep 21, 2010 · N8157K · Substantial damageNTSB ANC10CA097Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Skwentna, AKThe pilot's rapid application of throttle and carburetor heat causing the engine to hesitate and lose power during takeoff following an aborted landing.Sep 21, 2010 · N24P · Substantial damageNTSB WPR10LA462Accident · 1 fatalLimited investigationFinal reportCosmos Phase II · El Mirage, CAThe pilot's improper preflight and starting procedures, which resulted in an inadvertent takeoff with the gust lock still installed.Sep 20, 2010 · N56078 · Substantial damageNTSB ERA10CA495Accident · No injuriesData collectionFinal reportSkykits Savannah · Springville, TNCollision with an unknown object during landing.Sep 20, 2010 · N63XT · Substantial damageNTSB CEN10LA560Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Schaumburg, ILThe in-flight separation of the left aft cluster fitting assembly following the loss of torque on the lock nut due to a manufacturing defect.Sep 20, 2010 · N34LB · Substantial damageNTSB CEN10CA550Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Carthage, TXA total loss of engine power during cruise flight due to fuel exhaustion as a result of the pilot’s improper fuel planning.Sep 20, 2010 · N333NA · Substantial damageNTSB CEN10CA549Accident · No injuriesData collectionFinal reportCessna 182D · Houston, TXThe loss of engine power during the initial climb due to decreased engine oil quantity and pressure as a result of the engine's oil cap not being adequately secured.Sep 20, 2010 · N9071X · Substantial damageNTSB WPR10LA468Accident · Minor injuriesLimited investigationFinal reportGiboney Thunder Mustang · Reno, NVFailure of a connecting rod bearing and two connecting rods, which resulted in a loss of engine power while maneuvering at low altitude.Sep 19, 2010 · N151G · Substantial damageNTSB ERA10LA488Accident · 1 fatalLimited investigationFinal reportSchulman Mosquito XEL · Halifax, MAThe pilot's loss of control while hovering. Contributing to the accident was the pilot’s limited experience operating the helicopter make and model.Sep 19, 2010 · UNREG · Substantial damageNTSB ERA10LA487Accident · Minor injuriesLimited investigationFinal reportNavion Navion G · Dublin, GAThe pilot's failure to properly secure the oil drain plug after changing the engine oil, which resulted in oil starvation and an engine failure during cruise flight.Sep 19, 2010 · N2448T · Substantial damageNTSB ERA10LA486Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Barnwell, SCThe failure of the No. 1 connecting rod end cap for undetermined reasons, which resulted in a total loss of engine power.Sep 19, 2010 · N799SQ · Substantial damageNTSB CEN10CA548Accident · No injuriesData collectionFinal reportPiper PA-17 · Edwardsburg, MIA total loss of engine power during takeoff due to fuel exhaustion as a result of the pilot’s improper fuel planning.Sep 19, 2010 · N4610H · Substantial damageNTSB CEN10CA547Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Houma, LAThe pilot’s inadequate compensation for the crosswind while landing, which resulted in a loss of directional control.Sep 19, 2010 · N436ND · Substantial damageNTSB WPR10LA483Accident · No injuriesLimited investigationFinal reportBoam Rans S-6S · Roberts, IDA loss of engine power due to the detachment of the left carburetor from the engine inlet manifold. Contributing to the accident was the pilot's failure to address a known engine vibration.Sep 18, 2010 · N4427M · Substantial damageNTSB ERA10LA494Accident · No injuriesLimited investigationFinal reportCessna 172D · Palm Beach, FLThe pilot's failure to use carburetor heat which led to a loss of engine power due to carburetor icing.Sep 18, 2010 · N2483Y · Substantial damageNTSB ERA10LA485Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Rainelle, WVThe improper rigging of the fuel selector by maintenance personnel, which resulted in a total loss of engine power.Sep 18, 2010 · N86BR · Substantial damageNTSB ERA10LA484Accident · No injuriesLimited investigationFinal reportBell OH-58A · Covington, TNA loss of engine power due to contamination of the helicopter's fuel supply.Sep 18, 2010 · N38FA · Substantial damageNTSB CEN10LA571Accident · Serious injuriesLimited investigationFinal reportCa Tecnam P2004 Bravo · Mason, MIA total loss of engine power for undetermined reasons, which resulted in a forced landing to a bean field.Sep 17, 2010 · N508LM · Substantial damageNTSB CEN10CA582Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Atkins, ARA partial loss of engine power during low-altitude flight for undetermined reasons.Sep 17, 2010 · N2309F · Substantial damageNTSB CEN10CA541Accident · Minor injuriesData collectionFinal reportAerolite Bearcat · Mineola, TXFailure of the oil injection pump resulting in a total loss of engine power.Sep 15, 2010 · UNREG · Substantial damageNTSB CEN10CA539Accident · No injuriesData collectionFinal reportCessna A185F · Rushville, NEThe pilot's failure to maintain directional control of the airplane during takeoff. Contributing to the accident was the loss of visual reference due to the sun glare.Sep 13, 2010 · N714AL · Substantial damageNTSB WPR10LA456Accident · Serious injuriesLimited investigationFinal reportSavage Savage-Cozy · Aurora, ORThe pilot’s failure to maintain control of the airplane following a loss of engine power in the traffic pattern; the cause of the loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not…Sep 12, 2010 · N9699 · Substantial damageNTSB CEN10CA543Accident · Serious injuriesData collectionFinal reportHead Balloons AX8-88 · Ft. Wayne, INThe pilot's selection of unsuitable terrain for the landing.Sep 12, 2010 · N2064W · No damageNTSB CEN10CA533Accident · No injuriesData collectionFinal reportPiper PA46-310P · Farmington, NMThe pilot’s premature retraction of the landing gear and the flaps during landing. Contributing to the accident was the inadvertent dimming of the cockpit lighting, resulting in a perceived unsafe gear configuration.Sep 12, 2010 · N24WW · Substantial damageNTSB ANC10LA087Accident · Serious injuriesLimited investigationFinal reportCessna 185A · Paxson, AKThe pilot's decision to make a climbing turn close to the ground in gusting wind at a low airspeed, resulting in a loss of control and collision with terrain.Sep 12, 2010 · N4038Y · Substantial damageNTSB WPR10LA464Accident · 1 fatalLimited investigationFinal reportHughes OH-6A · Majuro (Pacific Ocean)A loss of helicopter control for undetermined reasons.Sep 11, 2010 · N74LB · Substantial damageNTSB WPR10LA454Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau EA-300 · Sierra Vista, AZA loss of engine power due to metal debris contamination of the inverted oil system shuttle valve, which resulted in a disruption of oil flow and subsequent oil starvation.Sep 11, 2010 · N102EX · Substantial damageNTSB CEN10CA544Accident · No injuriesData collectionFinal reportPiper PA22 · Atkinson, NEThe pilot's failure to maintain directional control while landing with a crosswind.Sep 11, 2010 · N6064D · Substantial damageNTSB ANC10LA084Accident · No injuriesLimited investigationFinal reportPiper PA-20 · South Naknek, AKThe loss of engine power during cruise flight for an undetermined reason, resulting in an emergency landing and collision with terrain.Sep 11, 2010 · N7414K · Substantial damageNTSB ANC10CA086Accident · No injuriesData collectionFinal reportRoberts Alan W Kitfox II · Fairbanks, AKThe pilot's failure to maintain proper aircraft control during landing and the subsequent go-around, resulting in a hard landing, and a collision with a signpost.Sep 11, 2010 · N598AL · Substantial damageNTSB ERA10LA475Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Fayetteville, WVA loss of engine power due to the failure of the left magneto system’s distributor gear as a result of the improper maintenance of the magnetos by maintenance personnel.Sep 10, 2010 · N7922E · Substantial damageNTSB ERA10LA474Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · Doerun, GAA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to select an adequate forced landing site and his excess speed during the landing.Sep 10, 2010 · N2312Y · Substantial damageNTSB ERA10CA473Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Montauk, NYThe pilot's inadequate compensation for crosswind conditions which resulted in a hard landing and loss of directional control.Sep 9, 2010 · N2753M · Substantial damageNTSB CEN10LA531Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Buchanan, MIA failure of the engine's No. 3 and No. 4 cylinder valve lifters for undetermined reasons, which resulted in a total loss of engine power.Sep 9, 2010 · N3560B · Substantial damageNTSB CEN10LA526Accident · 1 fatalLimited investigationFinal reportThompson Kolb Twinstar Mark · Elkhart, INThe pilot's failure to maintain control of the airplane during the landing approach.Sep 8, 2010 · N408K · Substantial damageNTSB CEN10CA527Accident · Serious injuriesData collectionFinal reportSchweizer SGS 1-34R · Hampshire, ILThe pilot’s failure to attain the proper touchdown point, resulting in a runway overrun.Sep 8, 2010 · N1130S · Substantial damageNTSB CEN10FA520Accident · 2 fatalField investigationFinal reportCessna T210 · Mountain Home, ARThe pilot’s decision to continue flight into a known area of heavy rain and his subsequent failure to maintain aircraft control.Sep 7, 2010 · N2081U · Substantial damageNTSB WPR10FA449Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Las Vegas, NVThe pilot's inability to maintain a positive rate of climb after takeoff for undetermined reasons.Sep 6, 2010 · N36072 · Substantial damageNTSB WPR10CA425Accident · No injuriesData collectionFinal reportChris W Kleen RV-6 · Coeur D'Alene, IDThe pilot’s inadequate compensation for the crosswind that resulted in a loss of directional control.Sep 6, 2010 · N515CW · Substantial damageNTSB ERA10CA465Accident · No injuriesData collectionFinal reportStearman E75 · Jackson, GAThe pilot's diverted attention toward an unsecured engine cowl door after takeoff which resulted in his failure to maintain airspeed and altitude. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane.Sep 4, 2010 · N1370V · Substantial damageNTSB WPR10LA472Accident · No injuriesLimited investigationFinal reportCessna T188C · Craigmont, IDThe pilot's failure to maintain directional control during the landing roll.Sep 3, 2010 · N9980J · Substantial damageNTSB WPR10LA446Accident · Serious injuriesLimited investigationFinal reportBell 47G · Salinas, CAThe pilot's visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation and loss of helicopter control.Sep 3, 2010 · N4427F · Substantial damageNTSB WPR10CA447Accident · Serious injuriesData collectionFinal reportChampion 7EC · Aurora, ORThe pilot’s failure to maintain directional control during an attempted go around after landing, resulting in a runway excursion.Sep 3, 2010 · N7415B · Substantial damageNTSB CEN10FA519Accident · Serious injuriesField investigationFinal reportKwech Glasair RG Super 11S · Lake Elmo, MNThe pilot's failure to maintain control of the airplane during takeoff with gusty wind conditions, which resulted in a collision with terrain.Sep 3, 2010 · N333HK · Substantial damageNTSB CEN10CA565Accident · No injuriesData collectionFinal reportNorth American AT-6 · Blakesburg, IAThe pilot's excessive airspeed during the landing, which resulted in his decision to perform an intentional ground loop to avoid a runway overrun.Sep 3, 2010 · N77TX · Substantial damage