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 DFW08LA220Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20B · Cleburne, TXLoss of control inflight for undetermined reason.Aug 31, 2008 · N30WK · Substantial damageNTSB CHI08LA288Accident · No injuriesLimited investigationFinal reportFantasy Air Sro Allegro 20 · Walworth, WIThe pilot's failure to maintain directional control during landing.Aug 31, 2008 · N1005W · Substantial damageNTSB CHI08FA269Accident · 3 fatalField investigationFinal reportBell 206L-1 · Greensburg, INThe in-flight separation of a main rotor blade due to a fatigue failure of the blade spar, rendering the helicopter uncontrollable, and the manufacturer's production of main rotor blades with latent manufacturing defects, which precipitated the fatigue…Aug 31, 2008 · N37AE · DestroyedNTSB ANC08LA113Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Galena, AKThe en route loss of engine power due to a mechanic's failure to tighten a fuel line fitting, which became disconnected in flight.Aug 31, 2008 · N4886U · Substantial damageNTSB ANC08CA115Accident · No injuriesData collectionFinal reportPiper PA-22 · Fairbanks, AKThe pilot's selection of an unsuitable landing site, resulting in a main landing gear collapse during the landing roll.Aug 31, 2008 · N3414A · Substantial damageNTSB NYC08FA298Accident · 1 fatalField investigationFinal reportMooney M20C · Lawrenceburg, TNA loss of engine power due to fuel exhaustion.Aug 30, 2008 · N6480U · Substantial damageNTSB NYC08CA300Accident · Serious injuriesData collectionFinal reportQuicksilver MXL II · Barceloneta, PRThe student pilot's failure to maintain control of the airplane during an aborted landing. Contributing to the accident were the high winds.Aug 30, 2008 · N594TC · Substantial damageNTSB LAX08LA288Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Gerlach, NVThe pilot's failure to maintain aircraft control during an uncommanded pitch-up during the takeoff.Aug 30, 2008 · N287SR · Substantial damageNTSB CHI08CA275Accident · No injuriesData collectionFinal reportCessna 150H · Bay City, MIThe loss of engine power during descent due to carburetor icing. Contributing to the accident was the collapse of the nose landing gear due to rough terrain.Aug 30, 2008 · N23461 · Substantial damageNTSB SEA08LA190Accident · 1 fatalLimited investigationFinal reportLien Zodiac 601 XL · Coeur d'Alene, IDThe pilot's failure to maintain aircraft control after the engine experienced a loss of power. Contributing to the accident was the mixture control arm separating from the fuel metering valve shaft.Aug 29, 2008 · N9881T · Substantial damageNTSB MIA08CA184Accident · No injuriesData collectionFinal reportGulfstream-Schweizer G-164B · Pantego, NCThe pilot's failure to maintain directional control on the landing roll out.Aug 29, 2008 · N8137K · Substantial damageNTSB DFW08FA218Accident · 2 fatalField investigationFinal reportRobinson R44 II · Ridgedale, MOAn in-flight loss of control for undetermined reasons.Aug 29, 2008 · N41411 · DestroyedNTSB LAX08FA286Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Las Vegas, NVA loss of power in the right engine due to an in-flight fuel-fed fire in the right engine compartment that, while the exact origin could not be determined, was likely related to the right engine-driven fuel pump, its fuel supply line, or fitting. Contributing…Aug 28, 2008 · N212HB · Substantial damageNTSB DFW08LA217AccidentLimited investigationFinal reportCessna 172A · Albuquerque, NMThe pilot's failure to maintain proper glide angle during the landing approach which resulted in a collision with a pole. Contributing to the accident were the pilot's lack of qualification, experience and the high density altitude.Aug 28, 2008 · N6539B · Substantial damageNTSB NYC08LA293Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Bristol, NHThe pilot's failure to clear the trees during takeoff due to a partial loss of engine power for undetermined reasons.Aug 27, 2008 · N2088Q · Substantial damageNTSB NYC08CA295Accident · No injuriesData collectionFinal reportCessna 182A · Danielson, CTFuel exhaustion due to the pilot’s inadequate fuel consumption calculations.Aug 27, 2008 · N169DP · Substantial damageNTSB DFW08TA224Accident · Minor injuriesFinal reportAir Tractor AT-802A · Meeker, COThe pilot's improper decision to continue an aerial application following an uncommanded opening of the cabin door in flight, and his subsequent failure to maintain control of the airplane.Aug 27, 2008 · N189LA · Substantial damageNTSB CHI08CA266Accident · No injuriesData collectionFinal reportAir Tractor AT-301A · Jasper, MNThe pilot's failure to assure the primer control was locked during the aircraft preflight. Factors associated with the accident were the low altitude at which the airplane was operating, the fence, the roadway, and the ditch.Aug 25, 2008 · N3654T · Substantial damageNTSB DFW08FA212Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Yuma, COThe pilot's failure to maintain control of the airplane after an encounter with instrument meteorological conditions.Aug 24, 2008 · N5476P · Substantial damageNTSB DFW08CA214Accident · No injuriesData collectionFinal reportBellanca 14-19-2 · Keller, TXThe pilot's inadequate preflight inspection of the airplane which resulted in an attempted takeoff without fuel present in the selected fuel tank.Aug 24, 2008 · N7653B · Substantial damageNTSB CHI08CA264Accident · No injuriesData collectionFinal reportCessna 172 · Pullman, MIA complete loss of engine power for undetermined reasons. A contributing factor was the rough terrain encountered during the forced landing.Aug 24, 2008 · N3901R · Substantial damageNTSB CHI08CA262Accident · No injuriesData collectionFinal reportSchweizer G-164B · Nielsville, MNThe pilot's failure to maintain directional control of the airplane during the crosswind landing. Factors associated with the accident were the crosswind and the rough terrain.Aug 23, 2008 · N773D · Substantial damageNTSB ANC08CA112Accident · No injuriesData collectionFinal reportRobinson R44 · Iliamna, AKThe pilot's failure to see a wire cable prior to colliding with it. Factors contributing to the accident were the non-routine positioning of the wire cable, and the ground crew's failure to advise the pilot that the wire had been re-routed.Aug 23, 2008 · N291VB · Substantial damageNTSB NYC08LA287Accident · Serious injuriesLimited investigationFinal reportBell 206A · Barnesville, PAThe pilot's failure to maintain control of the helicopter during the low-speed, low-altitude maneuver which resulted in a loss of tail rotor effectiveness.Aug 22, 2008 · N67AR · Substantial damageNTSB MIA08CA170Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · Satartia, MSThe pilot's inadequate visual lookout resulting in the in-flight collision with a 40-foot-tall antenna.Aug 22, 2008 · N1520X · Substantial damageNTSB LAX08MA277Accident · 10 fatalMajor investigationFinal reportBeech A100 · Moab, UTThe pilot’s failure to maintain terrain clearance during takeoff for undetermined reasons.Aug 22, 2008 · N601PC · Substantial damageNTSB LAX08LA274Accident · 3 fatalLimited investigationFinal reportKillgore Velocity · North Las Vegas, NVA partial loss of engine power during initial climb due to the detachment of the engine supercharger drive belt. The detachment resulted from the owner/builder's inadequate installation of the supercharger system and belt-tensioning adjustment.Aug 22, 2008 · N415MK · DestroyedNTSB DFW08CA216Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Wisner, LAThe loss of engine power for undetermined reasons.Aug 22, 2008 · N2391Z · Substantial damageNTSB LAX08LA272Accident · 1 fatalLimited investigationFinal reportSocata Rallye 235E · San Martin, CAThe pilot's incapacitation due to severe unrecognized coronary artery disease that resulted in a loss of aircraft control.Aug 21, 2008 · N711BZ · DestroyedNTSB LAX08CA275Accident · No injuriesData collectionFinal reportPiper PA-11 · Sheridan, WYThe pilot's inadequate compensation for the existing gusty wind conditions and likely windshear encounter and his failure to maintain an adequate airspeed that resulted in a stall/mush.Aug 21, 2008 · N1106T · Substantial damageNTSB SEA08FA187Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Springerville, AZThe pilot's failure to attain and maintain an adequate airspeed during takeoff in high density altitude conditions that resulted in an aerodynamic stall.Aug 20, 2008 · N5316L · Substantial damageNTSB DFW08LA210Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Caldwell, TXA loss of engine power in flight due to fuel exhaustion as a result of the pilot's failure to secure the right wing's fuel cap, leading to fuel being siphoned from the tank during flight.Aug 20, 2008 · N92780 · Substantial damageNTSB CHI08CA260Accident · No injuriesData collectionFinal reportCessna A188B · Camanche, IAThe pilot took off on an unsuitable airstrip which resulted in the airplane becoming prematurely airborne with inadequate airspeed after it contacted a rise in the terrain.Aug 20, 2008 · N53243 · Substantial damageNTSB LAX08CA276Accident · No injuriesData collectionFinal reportCessna 177RG · Lake Tahoe, CAThe pilot's inadequate compensation for the wind and density altitude conditions and failure to attain and maintain an adequate airspeed that resulted in a stall/mush.Aug 19, 2008 · N8053G · Substantial damageNTSB ANC08TA107Accident · No injuriesFinal reportPiper PA-18-150 · Slana, AKThe pilot's failure to maintain directional control during an aborted takeoff.Aug 19, 2008 · N4151T · Substantial damageNTSB SEA08CA184Accident · No injuriesData collectionFinal reportWheat Excalibur EX · Moses Lake, WAThe right rudder pedal attach rivets sheared due to overload.Aug 18, 2008 · N2505Q · Substantial damageNTSB SEA08CA183Accident · Minor injuriesData collectionFinal reportGrumman Acft Eng G-164A · Hazelton, IDThe pilot's inadequate compensation for the tailwind and failure to attain and maintain airspeed, which resulted in an inadvertent stall. The tailwind was a contributing factor.Aug 18, 2008 · N6702Q · Substantial damageNTSB SEA08FA185Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Olalla, WAThe complete loss of engine power due to the accumulation of ice in the carburetor as a result of the pilot's failure to use carburetor heat.Aug 17, 2008 · N301MA · DestroyedNTSB SEA08CA181Accident · No injuriesData collectionFinal reportEberle Pitts S1S · Show Low, AZThe pilot failed to maintain directional control during landing. Contributing to the accident was the pilot's limited experience in the airplane.Aug 17, 2008 · N39124 · Substantial damageNTSB SEA08CA180Accident · No injuriesData collectionFinal reportCessna 177 · Glendale, AZThe loss of engine power due to vapor lock. Contributing to the accident was the high atmospheric temperature.Aug 17, 2008 · N29304 · Substantial damageNTSB NYC08LA281Accident · 1 fatalLimited investigationFinal reportRoberto P. Garcia Nieuport 24bis · Rhinebeck, NYThe pilot's failure to maintain control of the airplane while maneuvering, resulting in an aerodynamic stall and spin.Aug 17, 2008 · N5246 · Substantial damageNTSB MIA08LA167Accident · 1 fatalLimited investigationFinal reportAyres S2R-T15 · Morton, MSThe pilot’s failure to maintain clearance from trees during low altitude maneuvering.Aug 17, 2008 · N4015P · Substantial damageNTSB DFW08LA206Accident · 1 fatalLimited investigationFinal reportBalloon Works Firefly 7-15 · Mountain Grove, MOAn on-board fire following a propane leak. Contributing to the accident was the lack of training/experience of the non-certificated pilot.Aug 17, 2008 · N90897 · Substantial damageNTSB SEA08LA179Accident · 1 fatalLimited investigationFinal reportCessna 177 · St. Johns, AZThe failure of both pilots to abort the takeoff when a suitable climb rate could not be attained. Contributing to the accident was the reduction of available power due to the camshaft lobe and lifter corrosion/wear, the high density altitude, and the CFI’s…Aug 16, 2008 · N3487T · Substantial damageNTSB NYC08LA280Accident · Minor injuriesLimited investigationFinal reportSocata MS894A · Fulton, NYA loss of engine power due to fatigue failure of the crankshaft and the No. 3 engine cylinder connecting rod as a result of improper machining of the engine crankshaft during engine overhaul by maintenance personnel.Aug 16, 2008 · N31BF · Substantial damageNTSB MIA08LA166Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche P2002 Sierra · Woodbine, NJThe student pilot's failure to maintain airspeed during a go-around. Contributing to the accident was the student pilot's degraded emotional/mental state due to stress.Aug 16, 2008 · N494ES · Substantial damageNTSB CHI08CA257Accident · No injuriesData collectionFinal reportAir Tractor AT-400A · Luverne, MNThe failure of the compressor turbine blades which resulted in the loss of power. Factors associated with the accident were the low altitude and the trees.Aug 16, 2008 · N7307W · Substantial damageNTSB CHI08CA256Accident · Minor injuriesData collectionFinal reportCessna 172N · Huntington, INThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the pilot's inadvertent use of the toe brake.Aug 16, 2008 · N733KC · Substantial damageNTSB DFW08CA213Accident · Serious injuriesData collectionFinal reportAerotrike Spirit · Vinland Valley, KSThe flight instructor's failure to maintain control of the sport aircraft on takeoff.Aug 15, 2008 · N226MB · Substantial damageNTSB DEN08FA141Accident · 4 fatalField investigationFinal reportCessna 182T · Georgia Pass, COThe pilot's failure to maintain aircraft control after inadvertantly encountering instrument meteorological conditions. Contributing to the accident were the pilot's failure to obtain a weather brief and the severe weather conditions.Aug 15, 2008 · N487TC · Destroyed