NTSB investigations, 2008

753 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\") = 2008
    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 CHI08CA252Accident · No injuriesData collectionFinal reportHiller UH-12E · Cokato, MNThe pilot did not visually identify and maintain clearance with the power lines, and the pilot's inability to maintain control of the helicopter once it contacted the power lines. Factors associated with the accident were the low altitude operations being…Aug 15, 2008 · N945HA · Substantial damageNTSB SEA08LA178Accident · 1 fatalLimited investigationFinal reportKolb Mark III · Richland, WAThe pilot's failure to maintain an adequate airspeed above stall speed while executing a steeply banked turn in the traffic pattern.Aug 14, 2008 · N18EX · Substantial damageNTSB DEN08IA143Incident · No injuriesIncident investigationFinal reportRaytheon C90A · Jasper, TXThe impact with a bird during initial takeoff climb.Aug 14, 2008 · N688LL · Minor damageNTSB DEN08FA140Accident · Serious injuriesField investigationFinal reportAircraft Mfg & Dev. CH601XLi · Farmersville, TXThe inadvertent tail stall and subsequent loss of airplane control as a result of the open canopy. Contributing to the accident was the inadequate emergency procedures provided by the airplane manufacturer and the inadequate design of the canopy latching…Aug 14, 2008 · N451BB · Substantial damageNTSB CHI08CA254Accident · No injuriesData collectionFinal reportBell 47G-3B · Kenyon, MNThe pilot's inadequate preflight planning which resulted in the helicopter settling with power.Aug 14, 2008 · N47AH · Substantial damageNTSB CHI08CA253Accident · No injuriesData collectionFinal reportCessna 172R · Cincinnati, OHThe student pilot's inadequate recovery from a bounced landing. Contributing to the accident were the improper flare and excessive airspeed.Aug 14, 2008 · N21SZ · Substantial damageNTSB ANC08CA108AccidentData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's failure to maintain clearance from a tarp used as a marker at the departure end of the takeoff area.Aug 14, 2008 · N3573Z · Substantial damageNTSB DEN08CA142Accident · No injuriesData collectionFinal reportAerotek Pitts Special S-1S · Crawford, COthe pilot's failure to maintain directional control during takeoff. Contributing to the accident were wind gusts and rough terrain.Aug 13, 2008 · N362JW · Substantial damageNTSB CHI08CA251Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301B · Monticello, IAPoor preflight planning in that the pilot failed to assure an adequate fuel supply was on board for the flight which resulted in fuel exhaustion. Factors associated with the accident were the low altitude of the airplane when the loss of power occurred and…Aug 13, 2008 · N3161D · Substantial damageNTSB SEA08CA177Accident · Minor injuriesData collectionFinal reportAnglin RV-6 · Puyallup, WAThe complete loss of engine power for undetermined reasons. Contributing to the accident were hidden obstructions (tree stumps) in the field of long grass within which the pilot executed his forced landing.Aug 12, 2008 · N14JA · Substantial damageNTSB MIA08FA163Accident · 3 fatalField investigationFinal reportBeech G35 · South Easton, MAThe pilot's failure to maintain control of the airplane while attempting to execute an instrument approach in instrument meteorological conditions. Contributing to the accident was the pilot's lack of instrument currency.Aug 12, 2008 · N4615D · DestroyedNTSB CHI08CA213Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Ida Grove, IAA failure of the turbocharger blower which resulted in the partial loss of power. Factors associated with the accident were the low altitude of the airplane and the embankment.Aug 12, 2008 · N45029 · Substantial damageNTSB DEN08LA139Accident · 1 fatalLimited investigationFinal reportDickey RV-6A · Muskogee, OKThe pilot's improper decision to continue flight under visual flight rules into an area of reduced visibility weather conditions, which resulted in the pilot's spatial disorientation and subsequent loss of aircraft control. Contributing to the accident was…Aug 11, 2008 · N22163 · DestroyedNTSB DEN08LA138Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Heber Springs, ARthe improper installation of the PC line on the engine which resulted in a partial loss of engine power. Contributing to the accident was the trees encountered during the forced landing.Aug 11, 2008 · N832AH · Substantial damageNTSB CHI08CA243Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Cosmos, MNThe pilot's failure to maintain clearance from the guide wire while maneuvering on an aerial application flight. Contributing to the accident was the presence of the guide wire.Aug 11, 2008 · N7297Z · Substantial damageNTSB ANC08FA104Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Sitka, AKA loss of engine power in flight due to fuel exhaustion resulting from the pilot's inadequate fuel planning and navigation.Aug 11, 2008 · N98HA · Substantial damageNTSB NYC08CA276Accident · No injuriesData collectionFinal reportCessna A188B · Gardner, FLThe pilot's misjudged distance/altitude during takeoff.Aug 10, 2008 · N4494Q · Substantial damageNTSB LAX08FA265Accident · 3 fatalField investigationFinal reportCessna R172K · Rock Springs, WYThe failure of both pilots to see and avoid each other's aircraft.Aug 10, 2008 · N758NH · 2 aircraft · DestroyedNTSB LAX08CA264Accident · Minor injuriesData collectionFinal reportCessna 152 · Oceanside, CAA loss of engine power due to fuel exhaustion that was caused by the pilot's inadequate fuel consumption calculations and failure to refuel the airplane en route.Aug 10, 2008 · N46974 · Substantial damageNTSB DFW08FA204Accident · 1 fatalField investigationFinal reportCessna 182 · Cassville, MOThe pilot's failure to maintain control of the airplane after an inadvertent encounter with instrument meteorological conditions resulting in the subsequent impact with terrain. Contributing to the accident was the pilot's self-induced pressure to conduct the…Aug 10, 2008 · N214MT · DestroyedNTSB CHI08CA250Accident · No injuriesData collectionFinal reportPiper J-3 · North Branch, MNThe loss of engine power as a result of oil starvation to the number one rod bearing and number one connecting rod. Contributing to the accident was the rough terrain.Aug 10, 2008 · N42080 · Substantial damageNTSB CHI08CA246Accident · No injuriesData collectionFinal reportAir Tractor AT-802A · Turton, SDThe failure of the starter generator which resulted in the subsequent loss of engine power. Contributing to the accident were the low altitude at which the airplane was operating, the tall grass, and the ditch.Aug 10, 2008 · N9078G · Substantial damageNTSB NYC08CA278Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Dresden, TNThe pilot's failure to maintain the proper altitude/clearance while on final approach.Aug 9, 2008 · N9365W · Substantial damageNTSB MIA08LA162Accident · Serious injuriesLimited investigationFinal reportNorth Wing Apache CLA · Boynton Beach, FLThe failure of the pilot to maintain control of the aircraft.Aug 9, 2008 · N3880A · Substantial damageNTSB LAX08CA262Accident · Minor injuriesData collectionFinal reportLet Blanik L-13 · Bend, ORThe pilot's misjudged distance/altitude which resulted in an undershoot while on final approach to land. Factors contributing to the accident were the lack of thermal lift (sinking air), and the lack of suitable terrain for the off-airport landing.Aug 9, 2008 · N62345 · Substantial damageNTSB DEN08LA137Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Ventus 2A · Brackettville, TXThe failure of the pilot of N777UN to exit the thermal upon losing visual contact with the other gliders, resulting in a midair collision.Aug 9, 2008 · N777UN · 2 aircraft · Substantial damageNTSB CHI08CA249Accident · No injuriesData collectionFinal reportMorane-Saulnier MS-760/B · St Paul, MNRestriction of the elevator controls due to the presence of the seat belt buckled around the co-pilot control stick. An additional cause was the failure of the pilot to verify that the flight controls were unobstructed before flight. Contributing factors were…Aug 9, 2008 · N69X · Substantial damageNTSB CHI08CA247Accident · No injuriesData collectionFinal reportBellanca 17-30A · Waukegan, ILThe pilot's inability to maintain directional control of the airplane following a failure of the right brake.Aug 9, 2008 · N1289R · Substantial damageNTSB ANC08CA102Accident · No injuriesData collectionFinal reportCessna 182 · Cantwell, AKThe pilot's misjudged distance while step-taxiing after landing. Factors in the accident were rain showers, wind, and spray from the airplane's propeller.Aug 9, 2008 · N82Y · Substantial damageNTSB CHI08CA242Accident · No injuriesData collectionFinal reportSchweizer G-164A · Jefferson, IAThe loss of engine power for an undetermined reason and the unsuitable terrain encountered during the forced landing. The corn crop was a factor.Aug 8, 2008 · N73PB · Substantial damageNTSB SEA08CA173Accident · Minor injuriesData collectionFinal reportCosmos Phase II · Carson City, NVThe pilot's inadequate compensation for the crosswind conditions. Contributing to the accident was the crosswind.Aug 7, 2008 · N311RT · Substantial damageNTSB SEA08CA172Accident · Serious injuriesData collectionFinal reportLyons Navajo HKS · Waterville, WAThe pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident was a microburst condition.Aug 7, 2008 · N1762C · Substantial damageNTSB CHI08CA241Accident · Minor injuriesData collectionFinal reportFalk Zodiac HDS-601 · Middleton, WIThe pilot's inadequate compensation for the crosswind. The crosswind was a factor.Aug 7, 2008 · N9043A · Substantial damageNTSB NYC08LA273Accident · No injuriesLimited investigationFinal reportOuzts Rodney Rutan-LongEZ · Winder, GAThe failure of the left brake due to contamination of the brake fluid.Aug 6, 2008 · N622EZ · Substantial damageNTSB NYC08LA270Accident · 2 fatalLimited investigationFinal reportPiper PA-12 · Brownsboro, ALThe pilot’s failure to ensure the fuel valve was on prior taxi and takeoff. Contributing to the accident was the pilot’s failure to maintain airspeed following loss of engine power due to fuel starvation.Aug 5, 2008 · N7820H · Substantial damageNTSB DEN08LA131Accident · Serious injuriesLimited investigationFinal reportFlynn Van Munk · Erie, COA loss of engine power due to carburetor icing. The reason for the loss of aircraft control was not determined.Aug 5, 2008 · N41832 · Substantial damageNTSB CHI08CA238Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Buffalo, NDThe pilot's excessive descent rate and his failure to maintain clearance from terrain during the spray run entry.Aug 5, 2008 · N57UP · Substantial damageNTSB SEA08CA171Accident · No injuriesData collectionFinal reportde Havilland Beaver DHC-2 MK.1 · Kenmore, WAThe pilot's failure to maintain aircraft control while water taxiing. Contributing to the accident were the pilot's failure to compensate for the wind condition and a tailwind.Aug 4, 2008 · N53BV · Substantial damageNTSB LAX08FA256Accident · 5 fatalField investigationFinal reportCessna 172K · Gearhart, ORThe pilot's failure to maintain aircraft control during the initial climb after takeoff due to spatial disorientation.Aug 4, 2008 · N828CC · DestroyedNTSB DFW08CA203Accident · Serious injuriesData collectionFinal reportCollard Dragonfly · Big Sping, TXLoss of aircraft control due to inadvertent penetration of a dust devil.Aug 4, 2008 · N793TW · Substantial damageNTSB NYC08LA264Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Palakta, FLThe partial loss of engine power for undetermined reasons.Aug 3, 2008 · N39758 · Substantial damageNTSB NYC08LA263Accident · 1 fatalLimited investigationFinal reportOsborne Challenger II · Fairdealing, KYThe pilot's failure to maintain adequate airspeed while climbing into rising terrain at low altitude, which resulted in an aerodynamic stall and uncontrolled descent.Aug 3, 2008 · N69ER · Substantial damageNTSB NYC08CA269Accident · Minor injuriesData collectionFinal reportCessna 172M · Jefferson, NCA loss of directional control during the takeoff roll for undetermined reasons. Contributing to the severity of the event was the descending embankment adjacent to the runway.Aug 3, 2008 · N73594 · Substantial damageNTSB NYC08CA267Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Windsor, VAThe student pilot's improper maneuvering at low altitude.Aug 3, 2008 · N33964 · Substantial damageNTSB LAX08CA255Accident · No injuriesData collectionFinal reportPiper PA-20 · Grass Valley, CAThe pilot's failure to maintain directional control due to his foot slipping off one rudder pedal while braking.Aug 3, 2008 · N7635K · Substantial damageNTSB MIA08CA157Accident · No injuriesData collectionFinal reportCessna 172 · Wingate, NCThe student pilot's failure to maintain control of the airplane during a go-around.Aug 2, 2008 · N6026A · Substantial damageNTSB MIA08CA154Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Mc Kinnon, TNThe pilot's inadequate fuel consumption calculations which led to fuel exhaustion and subsequent loss of engine power.Aug 2, 2008 · N4377J · Substantial damageNTSB CHI08CA237Accident · Serious injuriesData collectionFinal reportPowrachute PC 2000 · Goodfield, ILThe insufficient aircraft performance data available to the pilot and the inadequate preflight planning/preparation by the pilot. Contributing to the accident were the trees and density altitude.Aug 2, 2008 · N9338W · Substantial damageNTSB MIA08LA156Accident · Minor injuriesLimited investigationFinal reportDiamond DA-20-C1 · Peachtree City, GAA partial loss of engine power for undetermined reasons.Aug 1, 2008 · N227RD · Substantial damageNTSB LAX08CA252Accident · No injuriesData collectionFinal reportCessna 152 · Glendale, AZThe student pilot's misjudged altitude and distance, and failure to attain the proper touchdown point, that led to a landing overrun.Aug 1, 2008 · N757PS · Substantial damage