NTSB investigations
10,134 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 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 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 WPR09LA431Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Oroville, CAA total loss of engine power for undetermined reasons.NTSB ERA09LA516Accident · Minor injuriesLimited investigationFinal reportSiai-Marchetti F.260 · Atlanta, GAA total loss of engine power due to a fuel system air leak as a result of a deteriorated O-ring seal in the fuel shut-off cock. Contributing to the accident was the exceedance of the suggested overhaul schedule for the fuel shut-off cock.NTSB CEN09LA561Accident · Serious injuriesLimited investigationFinal reportChampion 7KCAB · Stacy, MNA partial loss of engine power during initial climb for undetermined reasons.NTSB CEN09LA572Accident · Minor injuriesLimited investigationFinal reportWright Bruce M Avid Flyer · Hitchcock, TXA total loss of engine power for undetermined reasons.NTSB CEN09LA557Accident · No injuriesLimited investigationFinal reportCessna 150F · Rosedale, MIThe pilot's failure to maintain directional control during the takeoff ground run. Contributing to the accident were the pilot's deteriorated physical and mental capabilities.NTSB CEN09CA568Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-1C · Holland, MIThe pilot's failure to maintain control of the airplane during the landing and subsequent go-around.NTSB ANC09CA091Accident · No injuriesData collectionFinal reportHelio H-295 · Koliganek, AKA loss of engine power during cruise flight due to water in the fuel, and the pilot's inadequate preflight inspection.NTSB ERA09LA498Accident · Serious injuriesLimited investigationFinal reportHahn R-W22 Tiger Moth Rep · Symrna, TNA loss of engine power for undetermined reasons.NTSB ERA09LA496Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Mansfield, MAA loss of engine power due to carburetor icing as a result of the pilot's delayed use of carburetor heat.NTSB ERA09FA497Accident · 1 fatalField investigationFinal reportRobinson R44 · Jackson, MSThe pilot's failure to maintain adequate main rotor rpm, for undetermined reasons.NTSB ERA09LA492Accident · 1 fatalLimited investigationFinal reportBond Neal O S-9 · Saylorsburg, PAThe pilot’s excessive flight control inputs that resulted in an overload failure of the right elevator and horizontal stabilizer.NTSB ERA09LA491Accident · Minor injuriesLimited investigationFinal reportMyers Donald E Kitfox 4 · Flintstone, MDA total loss of engine power due to the lack of sufficient lubrication and the pilot/owner’s failure to adequately service the airplane’s engine.NTSB ERA09CA493Accident · No injuriesData collectionFinal reportBeech B19 · Thomasville, PAA partial loss of engine power due to a partial blockage of the carburetor fuel inlet filter.NTSB CEN09CA553Accident · No injuriesData collectionFinal reportWarner Lewis Steen · Broomfield, COThe pilot's inability to maintain directional control due to an internal mechanical failure of the left wheel that caused the wheel to seize.NTSB WPR09LA426Accident · Minor injuriesLimited investigationFinal reportSix-Chuter American Spirit · Brownsville, ORThe pilot's failure to maintain clearance from power lines.NTSB WPR09CA425Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Madras, ORThe pilot's inadequate compensation for the gusty crosswind condition and failure to maintain directional control during landing rollout.NTSB CEN09CA560Accident · No injuriesData collectionFinal reportPiper PA-12 · Gonvick, MNA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.NTSB WPR09LA422Accident · No injuriesLimited investigationFinal reportCessna 210K · Show Low, AZA total loss of engine power due to the displaced oil filter adapter gasket, which resulted in an oil leak and oil exhaustion. Contributing to the accident was the unsuitable terrain for a forced landing.NTSB WPR09LA419Accident · 2 fatalLimited investigationFinal reportJames B. Taplin RV-6 · Orland, CAThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall/spin.NTSB WPR09LA417Accident · No injuriesLimited investigationFinal reportPiper PA28R · Wendover, UTThe failure of the pilot to attain and maintain an airspeed sufficient for normal landing gear retraction during initial climb. Contributing to the accident was the pilot's failure to use the airplane's manual override landing gear system, misidentifying that…NTSB ERA09LA490Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAA total loss of engine power due to the loss of camshaft timing as a result of the displacement of the idler gear assembly.NTSB ERA09FA487Accident · 2 fatalField investigationFinal reportSocata TB20 · Pavo, GAThe pilot’s continued visual flight into instrument meteorological conditions, with embedded intense thunderstorms, heavy rain, and severe to extreme turbulence, resulting in an in-flight separation of the left wing due to overstress.NTSB ERA09LA494Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Luray, VAA total loss of engine power during initial climb for undetermined reasons.NTSB ERA09LA483Accident · 2 fatalLimited investigationFinal reportBeech C24R · Sylva, NCThe pilot's failure to maintain an adequate airspeed during an aborted landing, which resulted in an aerodynamic stall.NTSB ERA09CA485Accident · No injuriesData collectionFinal reportBell 206L-3 · White Plains, NYThe pilot's failure to disconnect the ground power unit prior to takeoff.NTSB CEN09LA551Accident · No injuriesLimited investigationFinal reportWeber Pelican · Searcy, ARA total loss of engine power due to fuel starvation as a result of the pilot's incorrect positioning of the fuel selector valve.NTSB CEN09LA549Accident · 1 fatalLimited investigationFinal reportPiper PA-15 · Lakeview, MIThe pilot's failure to maintain control of the airplane.NTSB ERA09LA481Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Rockaway, NJA total loss of engine power due to oil starvation for undetermined reasons.NTSB CEN09LA555Accident · 1 fatalLimited investigationFinal reportDestiny Powered Parachutes Destiny 2000 · Arcanum, OHThe failure of pilot to maintain an adequate visual lookout in order to avoid the collision with an aircraft on final approach to land.NTSB CEN09LA543Accident · 2 fatalLimited investigationFinal reportSportflight International Astra HKS · Bloomfield, INThe pilot's failure to maintain control of the airplane while maneuvering.NTSB CEN09CA559Accident · No injuriesData collectionFinal reportNavion Navion G · Eau Claire, MIA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management.NTSB ANC09LA088Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot’s decision to make an abrupt and steep low altitude turn just after takeoff, while attempting to return to his departure airport, resulting in an aerodynamic stall and loss of aircraft control. Contributing to the accident was the pilot’s failure to…NTSB ANC09LA086Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Chugiak, AKThe pilot’s delayed use of carburetor heat while operating in conditions conducive to carburetor icing.NTSB WPR09LA412Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Santa Barbara, CAA loss of power during approach due to fuel exhaustion for undetermined reasonsNTSB WPR09FA414Accident · 1 fatalField investigationFinal reportPiper PA-25 · Creswell, ORThe pilot's failure to maintain aircraft control during takeoff for a glider tow operation. Contributing to the accident were the tow pilot's impairment due to marijuana use and the low altitude of the flight that reduced the time available to recover from an…NTSB ERA09LA477Accident · Serious injuriesLimited investigationFinal reportVollenweider R/Hurst R F Vans RV-9A · Marianna, FLFailure of the propeller speed reduction gearbox for undetermined reasons. Contributing to the accident was the pilot’s decision to disregard the manufacturer's mandate to replace the gearbox, the manufacturer's failure to provide owners with technical…NTSB ERA09CA475Accident · Serious injuriesData collectionFinal reportPiper PA-22 · Tuskegee, ALThe pilot’s failure to maintain directional control during the aborted landing.NTSB ERA09LA476Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Fairmount, GAA total loss of engine power due to fuel starvation as a result of a contaminated fuel strainer.NTSB CEN09LA536Accident · 2 fatalLimited investigationFinal reportBrown Steen Skybolt · Harrison, OHThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.NTSB CEN09CA540Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · East Grand Forks, MNThe pilot's failure to maintain clearance with the crops while maneuvering at low altitude.NTSB WPR09LA411Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · Tonopah, NVThe pilot’s failure to maneuver the helicopter within its performance capabilities while at a low altitude in mountainous terrain and in high density altitude conditions.NTSB WPR09CA410Accident · No injuriesData collectionFinal reportPiper PA28 · Glendale, AZThe student pilot's failure to maintain directional control during the landing roll.NTSB ERA09LA469Accident · 1 fatalLimited investigationFinal reportRaytheon 58 · Teterboro, NJThe complete loss of thrust due to the second-in-command’s (SIC) inadvertent feathering of both propellers during a high-speed, low-altitude approach. Contributing to the accident was the pilot-in-command’s inadequate monitoring of the SIC’s performance.…NTSB WPR09GA407Accident · 1 fatalFinal reportAir Tractor AT-802A · Austin, NVThe pilot’s failure to maintain a stabilized approach prior to the retardant drop and his subsequent failure to release the retardant load, resulting in a stall/mush and collision with terrain.NTSB ERA09LA470Accident · No injuriesLimited investigationFinal reportCessna A188B · McRae, GAA total loss of engine power due to pre-ignition/detonation as a result of a fuel control malfunction.NTSB WPR09FA409Accident · 1 fatalField investigationFinal reportStemme S10-VT · Mackay, IDThe pilot's failure to maintain adequate airspeed while maneuvering in terrain-induced turbulent wind conditions, resulting in an inadvertent entry into a stall/spin.NTSB WPR09CA406Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Mesa, AZThe student pilot’s inadequate compensation for the crosswind condition and failure to maintain directional control during landing.NTSB WPR09CA404Accident · No injuriesData collectionFinal reportJabiru J230-SP · Reno, NVThe pilot’s failure to maintain directional control throughout the takeoff roll.NTSB ERA09LA468Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Mount Holly, NJA loss of directional control during landing for undetermined reasons.NTSB CEN09LA534Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Audubon, IAA loss of engine power due to failure of the compressor turbine resulting from exposure to elevated operating temperatures for undetermined reasons.