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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB DFW08LA220Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20B · Cleburne, TXLoss of control inflight for undetermined reason.NTSB CHI08LA288Accident · No injuriesLimited investigationFinal reportFantasy Air Sro Allegro 20 · Walworth, WIThe pilot's failure to maintain directional control during landing.NTSB 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…NTSB 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.NTSB 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.NTSB NYC08FA298Accident · 1 fatalField investigationFinal reportMooney M20C · Lawrenceburg, TNA loss of engine power due to fuel exhaustion.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB MIA08CA184Accident · No injuriesData collectionFinal reportGulfstream-Schweizer G-164B · Pantego, NCThe pilot's failure to maintain directional control on the landing roll out.NTSB DFW08FA218Accident · 2 fatalField investigationFinal reportRobinson R44 II · Ridgedale, MOAn in-flight loss of control for undetermined reasons.NTSB 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…NTSB 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.NTSB 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.NTSB NYC08CA295Accident · No injuriesData collectionFinal reportCessna 182A · Danielson, CTFuel exhaustion due to the pilot’s inadequate fuel consumption calculations.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB LAX08MA277Accident · 10 fatalMajor investigationFinal reportBeech A100 · Moab, UTThe pilot’s failure to maintain terrain clearance during takeoff for undetermined reasons.NTSB 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.NTSB DFW08CA216Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Wisner, LAThe loss of engine power for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ANC08TA107Accident · No injuriesFinal reportPiper PA-18-150 · Slana, AKThe pilot's failure to maintain directional control during an aborted takeoff.NTSB SEA08CA184Accident · No injuriesData collectionFinal reportWheat Excalibur EX · Moses Lake, WAThe right rudder pedal attach rivets sheared due to overload.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB MIA08LA167Accident · 1 fatalLimited investigationFinal reportAyres S2R-T15 · Morton, MSThe pilot’s failure to maintain clearance from trees during low altitude maneuvering.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB DFW08CA213Accident · Serious injuriesData collectionFinal reportAerotrike Spirit · Vinland Valley, KSThe flight instructor's failure to maintain control of the sport aircraft on takeoff.NTSB 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.