NTSB investigations
10,153 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 ERA24LA178Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Manassas, VAThe pilot’s failure to apply carburetor heat before reducing engine power during a prolonged descent while operating in environmental conditions conducive to the development of carburetor ice, which resulted in a total loss of engine power due to carburetor…NTSB CEN24LA158Accident · No injuriesClass 3 · LimitedFinal reportJacobson SE5A Replica · Luther, OKThe pilot’s failure to use carburetor heat, which resulted in fuel starvation during the initial climb, a loss of engine power, and impact with terrain.NTSB WPR24FA124Accident · 1 fatalClass 3 · FieldFinal reportGulfstream 695A · San Bernardino, CAThe pilot’s continued use of the airplane’s autopilot after flight into moderate to severe icing conditions, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB GAA24WA145Accident · 3 fatalClass 5 · ForeignBell 206 · Meico City, MexicoNTSB GAA24WA152Accident · Minor injuriesClass 5 · ForeignCessna A188 · Zona bananera, Ciénaga - Magdalena, ColombiaNTSB CEN24LA155Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32-301 · Sullivan, MOA bearing failure that resulted in fatigue failure of the crankshaft and a subsequent total loss of engine power.NTSB ERA24LA177Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Carrabassett, METhe pilot’s failure to attain a proper touchdown point while landing in gusty wind conditions.NTSB ERA24LA169Accident · No injuriesClass 4 · LimitedFinal reportSnyder Robert L Challenger II · Hendersonville, NCA loss of engine power for undetermined reasons.NTSB ERA24LA168Accident · No injuriesClass 4 · LimitedFinal reportCessna 208 · Ellington, CTThe pilot’s failure to maintain a proper glidepath to the runway, which resulted in a runway undershoot and collision with terrain.NTSB ERA24LA163Accident · Serious injuriesClass 3 · LimitedFinal reportEvektor-Aerotechnik A S Harmony LSA · Seffner, FLThe improper installation of the fuel line that connected the fuel pump to the four-way distributor, which resulted in fuel starvation when the line became disconnected.NTSB ERA24FA160Accident · 1 fatalClass 3 · FieldFinal reportArthur B Canning Merlin Lite · Mulberry, FLThe pilot/builder’s modifications of the motorglider’s engine, which resulted in an excessively lean fuel air mixture, preignition, piston failure, and a subsequent total loss of engine power during the initial climb. Contributing to the outcome was the…NTSB CEN24LA145Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20E · Alpine, ARThe improper maintenance of the cabin air and exhaust system which resulted in a cracked exhaust pipe and damaged cabin air tubing, and the subsequent elevated carbon monoxide levels in the cockpit and a forced landing to unsuitable terrain after the pilot…NTSB ERA24LA214Accident · No injuriesClass 3 · LimitedFinal reportBeech 95B55 · St. Augustine, FLThe incomplete extension of the landing gear into the down-and-locked position for reasons that could not be determined. .NTSB CEN24LA144Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28 · Muncie, INThe pilot’s spatial disorientation and subsequent loss of control while maneuvering outside established instrument approach procedures in instrument meteorological conditions, which resulted in an impact with terrain. Contributing to the accident was the…NTSB WPR24FA119Accident · 2 fatalClass 3 · FieldPreliminary reportDaher TBM700 · Truckee, CAOn March 30, 2024, at 1837 Pacific daylight time, a Daher TBM 700 (960), N960LP, was substantially damaged when it was involved in an accident in Truckee, California. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code…NTSB WPR24LA120Accident · No injuriesClass 4 · LimitedFinal reportBeecraft Bonanza · Angel Fire, NMThe pilot's failure to maintain directional control of the airplane during takeoff with a gusting crosswind..NTSB ERA24LA158Accident · Serious injuriesClass 3 · LimitedFinal reportJmmt Vans RV9A · Jasper, GAThe total loss of engine power due to fuel starvation for reasons that could not be determined due to impact-related damage.NTSB WPR24LA118Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL18 · Phoenix, AZThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA24LA152Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Opelika, ALA partial loss of engine power due to a combination of fuel/oil contamination in the fuel injector assembly.NTSB WPR24LA117Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Acton, CAThe pilots inability to fully turn off the carburetor heat which resulted in a reduction of engine power and reduced climb performance. Contributing to the accident was the pilots delayed recovery from the simulated emergency landing.NTSB CEN24LA138Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Aitkin, MNThe student pilot’s failure to maintain directional control during the takeoff in crosswind conditions.NTSB WPR24FA112Accident · 1 fatalClass 3 · FieldFinal reportHolmes William B AIR Creation Twin · Gila Bend, AZThe pilot’s loss of control and subsequent collision with a mesquite tree on approach to land.NTSB ERA24LA143Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Blackshear, GAA catastrophic engine failure due to oil starvation, which resulted in a total loss of engine power.NTSB WPR24LA114Accident · No injuriesClass 4 · LimitedFinal reportMooney M20K · Farmington, CAThe pilot’s improper preflight fuel planning that resulted in the loss of engine power due to fuel exhaustion.NTSB ERA24LA146Accident · No injuriesClass 4 · LimitedFinal reportBeech A23 24 · Somerset, PAThe student pilot’s failure to maintain directional control, and the flight instructor’s lack of remedial action during a landing attempt in a gusty wind, which resulted in a loss of directional control and runway excursion.NTSB CEN24LA137Accident · No injuriesClass 3 · LimitedFinal reportEnstrom Helicopter 280C · Port Lavaca, TXThe pilot’s improper manual engine mixture management which resulted in a loss of power. Contributing to the accident was the mechanic’s improper setting of the idle mixture adjustment and the pilot’s decision to take off with a known mechanical deficiency.NTSB ERA24LA140Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Logan, WVThe pilot’s delayed decision to perform a go-around while attempting to land on a wet runway with a tailwind, which resulted in a runway overrun and collision with trees.NTSB ERA24LA139Accident · No injuriesClass 3 · LimitedFinal reportBeech K35 · Front Royal, VAA total loss of engine power due to fuel starvation as a result of the pilot’s mismanagement of the airplane’s fuel supply.NTSB CEN24LA133Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Falcon, COThe flight instructor’s failure to maintain control during takeoff which resulted in an aerodynamic stall and an impact with terrain.NTSB GAA24WA115Accident · No injuriesClass 4 · ForeignCessna 172S · Guna, IndiaNTSB GAA24WA108AccidentClass 5 · ForeignCessna 172M · Wilson Airport, KenyaNTSB ERA24FA127Accident · 5 fatalClass 3 · FieldFinal reportPiper PA32RT · Nashville, TNThe pilot’s failure to ensure the proper placement of the fuel selector during the approach and landing, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB GAA24WA110Accident · 1 fatalClass 5 · ForeignZenith CH-801 · Bunberry, AustraliaNTSB ERA24LA129Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL11 · Fort Myers, FLThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN24FA125Accident · 2 fatalClass 3 · FieldFinal reportGlobe GC-1B · Afton, MNThe pilot’s failure to maintain airplane control while maneuvering, which resulted in an aerodynamic stall and spin.NTSB ERA24LA128Accident · No injuriesClass 3 · LimitedFinal reportCub Crafters PA18-150 · Edgewater, FLMaintenance personnel’s failure to detect the worn aileron cable during the most recent inspections, which resulted in the separation of the aileron control cable and a subsequent loss of airplane control during landing.NTSB ERA24LA124Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Sanford, FLA total loss of engine power due to fuel starvation and the flight crew’s mismanagement of the available fuel.NTSB CEN24LA124Accident · Minor injuriesClass 4 · LimitedFinal reportSearey Classic · Winchester, TXThe pilot’s failure to attain/maintain airplane control during a landing approach that resulted in an uncontrolled descent and an impact with the lake.NTSB ERA24LA125Accident · No injuriesClass 4 · LimitedFinal reportWaco UPF-7 · Atlanta, GAThe pilot’s failure to maintain directional control during the landing in gusting crosswind conditions.NTSB ERA24LA122Accident · No injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Cape Coral, FLA total loss of engine power due to fuel starvation as a result of the pilot’s failure to properly secure a fuel supply line.NTSB CEN24LA118Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182P · Charleston, MSThe pilot’s failure to attain/maintain aircraft control during an approach for landing that resulted in an impact with terrain.NTSB ANC24LA016Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Hana, HIThe pilot’s failure to ensure the passenger’s gear was properly secured before departure.NTSB ANC24LA014Accident · No injuriesClass 4 · LimitedFinal reportBenjamin Pratt Bearhawk Patrol · Galena, AKA loss of engine power as a result of carburetor ice. Contributing to the outcome was the pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB ERA24LA119Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASW 27-18 · Polk City, FLThe glider pilot’s misjudged altitude, which resulted in an off-airport landing and collision with a fence.NTSB WPR24LA085Accident · Serious injuriesClass 3 · LimitedFinal reportEvektor-Aerotechnik A S Harmony LSA · Santa Ana, CAA loss of airplane control due to wake turbulence resulting from the instructor pilot’s decision to continue the landing into a drifting wake vortex.NTSB WPR24LA088Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32R-301T · Spanish Fork, UTThe pilot's failure to ensure proper placement of the fuel selector, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR24LA087Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20K · Burley, IDThe failure of the pilot to fly a stabilized approach during an emergency landing with a tailwind, which resulted in a bounced landing and subsequent runway excursion during the landing roll. Contributing to the accident was the pilot’s inadequate preflight…NTSB CEN24MA111Accident · 6 fatalClass 2 · MajorFinal reportAirbus Helicopters EC 130 · Halloran Springs, CAThe pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the company’s inadequate oversight of its…NTSB CEN24LA114Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Wayside, TXThe student pilot’s improper fuel management during the cross-country flight, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN24LA112Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Tupelo, MSThe pilot’s failure to maintain clearance from water during a dark night landing.