NTSB investigations, 2009

598 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\") = 2009
    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 ERA10FA052Accident · 1 fatalField investigationFinal reportAero Commander 100 · Weston, FLThe flight's descent for undetermined reasons, resulting in the in-flight collision with terrain.Nov 8, 2009 · N4139X · Substantial damageNTSB CEN10FA044Accident · 3 fatalField investigationFinal reportBeech A36 · Spring Branch, TXThe pilot's failure to maintain control of the airplane during cruise flight in instrument meteorological conditions. Contributing to this accident was the pilot’s lack of recent experience in flying in instrument meteorological conditions.Nov 8, 2009 · N91TD · Substantial damageNTSB CEN10CA048Accident · No injuriesData collectionFinal reportCessna 150L · Galion, OHThe student pilot's failure to maintain directional control.Nov 8, 2009 · N66006 · Substantial damageNTSB ERA10CA057Accident · No injuriesData collectionFinal reportCessna 172S · Summit, DEThe student pilot’s failure to maintain directional control during takeoff.Nov 7, 2009 · N134B · Substantial damageNTSB CEN10LA049Accident · 1 fatalLimited investigationFinal reportLockwood AIR-CAM · Mount Victory, OHThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall and spin. Contributing to the accident was the pilot's unfamiliarity with the airplane subsequent to float installation.Nov 7, 2009 · N32786 · Substantial damageNTSB CEN10LA041Accident · 2 fatalLimited investigationFinal reportWicks Air Center Hornet · Bonham, TXThe pilot's loss of control shortly after takeoff due to spatial disorientation in fog and/or low-level clouds.Nov 7, 2009 · N651WA · DestroyedNTSB CEN10CA045Accident · No injuriesData collectionFinal reportCessna 150H · Paoli, INThe pilot's failure to maintain directional control of the airplane during landing.Nov 7, 2009 · N22896 · Substantial damageNTSB ANC10LA006Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Kenai, AKThe pilot's decision to fly at a low altitude in strong winds and turbulence, resulting in a loss of control and a collision with terrain.Nov 6, 2009 · N5268X · Substantial damageNTSB WPR10LA046Accident · Serious injuriesLimited investigationFinal reportEurocopter AS350BA · Globe, AZThe pilot receiving instruction’s failure to maintain adequate airspeed or control of the helicopter during a simulated hydraulic failure maneuver, which resulted in a hard landing. Contributing to the accident was the flight instructor’s delayed remedial…Nov 5, 2009 · N617LH · Substantial damageNTSB ERA10LA050Accident · Minor injuriesLimited investigationFinal reportGrumman Aircraft ENG G-111 · Ft Pierce, FLA total loss of left engine power and subsequent failure of the airplane to maintain airspeed and altitude on the remaining engine for undetermined reasons.Nov 5, 2009 · N120FB · Substantial damageNTSB ERA10FA048Accident · 2 fatalField investigationFinal reportCessna 172S · Tallahassee, FLThe pilots' spatial disorientation during flight in dark conditions, which resulted in an uncontrolled descent into terrain.Nov 5, 2009 · N5194X · DestroyedNTSB CEN10LA039Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Brenham, TXThe loss of engine power (right engine) during initial climb for undetermined reasons.Nov 4, 2009 · N725GS · Substantial damageNTSB ERA10LA047Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Fairview, NCA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight fuel planning.Nov 3, 2009 · N6896U · Substantial damageNTSB CEN10LA037Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Coldwater, MIA loss of engine power due to the separation of the No. 4 piston connecting rod as a result of inadequate torque of the connecting rod bolt.Nov 2, 2009 · N8364W · Substantial damageNTSB ERA10CA045Accident · No injuriesData collectionFinal reportBeech 77 · Gainesville, FLThe pilot's failure to maintain aircraft control during landing.Nov 1, 2009 · N6715V · Substantial damageNTSB CEN10LA035Accident · Serious injuriesLimited investigationFinal reportBlanik L-13 · Middlefield, OHThe student pilot's improper control inputs which resulted in the inadvertent stall of the glider.Nov 1, 2009 · N1142 · Substantial damageNTSB WPR10CA041Accident · No injuriesData collectionFinal reportCessna 180 · Bountiful, UTThe failure of the inner tube of the right main tire during the landing roll.Oct 31, 2009 · N1712C · Substantial damageNTSB WPR10LA040Accident · Serious injuriesLimited investigationFinal reportHallbauer Dragonfly Mark II · Las Vegas, NVThe CFI's failure to maintain directional control of the airplane during takeoff.Oct 30, 2009 · N555RX · Substantial damageNTSB WPR10LA039Accident · Minor injuriesLimited investigationFinal reportSauer KR-2S · Glendale, AZA loss of engine power due to fuel starvation as a result of a reduced fuel flow to the engine resulting from a misrouted fuel tank vent line, during initial climb.Oct 30, 2009 · N811RJ · Substantial damageNTSB ERA10FA037Accident · 3 fatalField investigationFinal reportCessna 177 · ChristianstedThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. Contributing to the accident was the pilot's failure to ensure proper loading of the airplane.Oct 29, 2009 · N3431T · DestroyedNTSB CEN10LA031Accident · 2 fatalLimited investigationFinal reportAeronca 7AC · Gaylord, MIThe pilot's failure to maintain adequate airspeed during a low altitude turn resulting in an aerodynamic stall/spin and loss of control.Oct 27, 2009 · N2239E · DestroyedNTSB CEN10FA029Accident · 1 fatalField investigationFinal reportBeech A36TC · Kalamazoo, MIThe loss of engine power for an undetermined reason.Oct 27, 2009 · C-FFIH · DestroyedNTSB CEN10CA033Accident · No injuriesData collectionFinal reportCessna 172N · Marysville, OHThe student pilot's failure to maintain directional control during landing.Oct 26, 2009 · N4753D · Substantial damageNTSB ERA10LA031Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Brooksville, FLA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight fuel planning.Oct 25, 2009 · N7220W · Substantial damageNTSB WPR10CA030Accident · No injuriesData collectionFinal reportPiper PA18 · Chandler, AZThe student pilot's failure to maintain directional control while landing.Oct 24, 2009 · N83281 · Substantial damageNTSB ERA10FA028Accident · 3 fatalField investigationFinal reportPiper PA 46-350P · Zephyrhills, FLA total loss of engine power during a night approach for undetermined reasons.Oct 24, 2009 · N98ZZ · Substantial damageNTSB ERA10CA039Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Scranton, SCThe pilot’s failure to maintain control of the helicopter.Oct 24, 2009 · N822U · Substantial damageNTSB CEN10FA027Accident · 2 fatalField investigationFinal reportCommander 114-B · Adrian, MIThe pilot did not maintain control of the airplane due to spatial disorientation while on an instrument approach in instrument meteorological conditions.Oct 23, 2009 · N6025U · Substantial damageNTSB ERA10LA026Accident · 2 fatalLimited investigationFinal reportFuji LM1 · Athens, GAAn aerodynamic stall shortly after takeoff for undetermined reasons.Oct 22, 2009 · N2121J · Substantial damageNTSB ERA10FA027Accident · 2 fatalField investigationFinal reportCessna U206G · Elizabethton, TNThe pilot’s failure to remain clear of rising terrain while maneuvering at low altitude.Oct 22, 2009 · N120MS · Substantial damageNTSB WPR10FA027Accident · 1 fatalField investigationFinal reportCessna T210G · Provo, UTA total loss of engine power due to fuel starvation as a result of the pilot’s inadequate preflight inspection.Oct 21, 2009 · N6869R · Substantial damageNTSB ERA10FA024Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Summerville, SCFlight into terrain for undetermined reasons.Oct 21, 2009 · N62635 · Substantial damageNTSB CEN10CA024Accident · No injuriesData collectionFinal reportCessna 170B · London, OHThe pilot's failure to maintain directional control during the takeoff roll.Oct 19, 2009 · N2719D · Substantial damageNTSB ERA10FA020Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Oliver Springs, TNThe pilot's loss of directional control while landing on a wet turf runway, which resulted in a runway excursion and collision with a tree.Oct 18, 2009 · N7906W · Substantial damageNTSB CEN10LA023Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Peoria, ILA loss of engine power for undetermined reasons during climb out after takeoff, which resulted in a forced landing to a roadway.Oct 18, 2009 · N3357W · DestroyedNTSB CEN10CA109Accident · No injuriesData collectionFinal reportSkistmas George Pietnpol Aircamper · Toledo, OHThe pilot's failure to maintain directional control during landing.Oct 18, 2009 · N6186L · Substantial damageNTSB WPR10CA050Accident · No injuriesData collectionFinal reportAeromot AMT-200(SU · Placerville, CAThe pilot's failure to maintain clearance from an obstacle during the landing rollout. Contributing to the accident was the presence of the brush in proximity to the runway.Oct 17, 2009 · N107MJ · Substantial damageNTSB WPR10CA020Accident · Minor injuriesData collectionFinal reportMooney M20J · Hesperia, CAThe pilot's improper glide path and failure to maintain clearance from the airport perimeter fence during the landing approach.Oct 17, 2009 · N1084Z · Substantial damageNTSB WPR10CA019Accident · Minor injuriesData collectionFinal reportCessna 172S · Honolulu, HIThe student pilot's distraction and subsequent loss of airplane control after the cabin window opened during the takeoff roll.Oct 17, 2009 · N5329L · Substantial damageNTSB ERA10LA021Accident · No injuriesLimited investigationFinal reportPalen AVRO-504K · Rhinebeck, NYA loss of engine power due to the in-flight separation of the number 3 cylinder valve rocker arm attachment hardware. Contributing to the accident was the improper maintenance inspection of the engine.Oct 17, 2009 · N4929 · Substantial damageNTSB ANC10LA005Accident · No injuriesLimited investigationFinal reportCessna P206C · Palmer, AKThe pilot's decision to land on a short gravel runway, and his failure to initiate a go-around, which resulted in an overrun and on-ground collision with a fence.Oct 17, 2009 · N8665Z · Substantial damageNTSB ERA10LA019Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · La Belle, FLThe loss of main rotor rpm due to the failure of one or more of the drive belts for undetermined reasons.Oct 15, 2009 · N3038W · Substantial damageNTSB ERA10CA016Accident · Minor injuriesData collectionFinal reportPiper PA28 · Meadville, PAA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Oct 13, 2009 · N8886E · Substantial damageNTSB WPR10CA017Accident · No injuriesData collectionFinal reportCessna 182F · Elko, NVThe pilot's failure to maintain directional control while taking off in known gusty wind conditions.Oct 12, 2009 · N3567Y · Substantial damageNTSB WPR10CA015Accident · Serious injuriesData collectionFinal reportLet Blanik L-13 · Llano, CAThe student pilot's improper use of the airbrakes while on approach for landing.Oct 11, 2009 · N948LC · Substantial damageNTSB WPR10CA013Accident · No injuriesData collectionFinal reportCessna 172H · Tucson, AZThe pilot's failure to maintain directional control during the takeoff ground roll.Oct 10, 2009 · N51302 · Substantial damageNTSB CEN10FA011Accident · 2 fatalField investigationFinal reportCessna 150F · Alexandria, LAFailure of the wingman to maintain proper separation from the lead airplane during formation maneuvers. Contributing to the accident was lead's abrupt right bank and both pilots' lack of formation training.Oct 10, 2009 · N8642S · 2 aircraft · Substantial damageNTSB WPR10LA010Accident · 1 fatalLimited investigationFinal reportCruz SE5A Replica · Phoenix, AZThe pilot's failure to maintain airspeed during initial climb, which resulted in a stall/spin and impact with the ground.Oct 9, 2009 · N3944U · Substantial damageNTSB CEN10CA020Accident · No injuriesData collectionFinal reportFranklin Pitts Special S-1 · Alamosa, COThe pilot’s failure to maintain directional control on takeoff.Oct 9, 2009 · N59JT · Substantial damageNTSB CEN10CA013Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Bingham, NEThe pilot's impairment due to alcohol consumption and failure to maintain aircraft control.Oct 9, 2009 · N54750 · Substantial damage