NTSB investigations
10,140 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 GAA21WA141Accident · No injuriesClass 5 · ForeignBell 407 · Siaya County, KenyaNTSB GAA21WA130Accident · 1 fatalClass 5 · ForeignCessna 188A · Inmediaciones Municipio Paz de Ariporo, Casanare, ColombiaNTSB WPR21LA220Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-24 · Paris, IDA total loss of engine power for reasons that could not be determined.NTSB ERA21FA234Accident · 7 fatalClass 3 · FieldFinal reportCessna 501 · Smyrna, TNThe pilot’s loss of airplane control during climb due to spatial disorientation.NTSB WPR21LA208Accident · Minor injuriesClass 3 · LimitedFinal reportBoeing A75N1(PT17) · Hollister, CAThe improper installation of a relief valve spring that was shorter than the standard spring length, which slowed the response of the propeller governor to change the pitch of the blades during climbout, resulting in a partial loss of power.NTSB GAA21WA133Accident · 1 fatalClass 5 · ForeignRobinson R22 · Hay South, AustraliaNTSB ERA21FA232Accident · 1 fatalClass 3 · FieldFinal reportGulfstream American AA-5A · Crossville, TNA partial loss of engine power due to carburetor icing, which resulted in a descent and impact with terrain. Contributing to the accident was the pilot’s failure to apply carburetor heat following the initial loss of engine power.NTSB ERA21FA229Accident · 1 fatalClass 3 · FieldFinal reportMunson Roger J RV-8 · Van Cleve, KYA loss of engine power due to loss of engine oil pressure.NTSB ERA21LA226Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Lincoln Park, NJThe pilot's loss of directional control during an aborted landing in crosswind conditions.NTSB ERA21FA225Accident · 2 fatalClass 3 · FieldFinal reportFlight Design Ctsw · Winterville, NCThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall and a loss of control.NTSB CEN21LA235Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · McAllen, TXThe student pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with a runway sign.NTSB WPR21LA204Accident · Serious injuriesClass 3 · LimitedFinal reportMcclure B J Glasair III · Eugene, ORThe pilot’s loss of airplane control during the approach to landing due to an asymmetrical flap deployment for reasons that could not be determined based on the available evidence.NTSB ERA21LA222Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20K · Dawson, GAMaintenance personnel’s failure to properly secure the No. 4 connecting rod bolt nut with a cotter pin, resulting in a total loss of engine power.NTSB WPR21LA201Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Minden, NVThe pilot’s failure to maintain airplane control while on approach in microburst or windshear conditions, which resulted in impact with a runway sign.NTSB CEN21LA222Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Racine, WIThe fatigue failure of the carburetor throttle control cable, which resulted in a partial loss of engine control.NTSB WPR21LA222Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Las Vegas, NVThe flight instructor’s failure to compensate for a downdraft during takeoff, which resulted in a loss of control and collision with terrain.NTSB ERA21LA217Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Brewton, ALThe pilot’s failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall and impact with the ground.NTSB ERA21LA215Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Daytona Beach, FLBoth pilots’ failure to maintain control during the landing flare and the flight instructor’s failure to maintain control during an attempted go-around, in gusting quartering headwind conditions, which resulted in the exceedance of the airplane’s critical…NTSB CEN21LA221Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Pinckneyville, ILThe total loss of engine power due to oil starvation. The reason for the oil starvation could not be determined based on available evidence.NTSB CEN21LA219Accident · Serious injuriesClass 3 · LimitedFinal reportBeech B24R · New Lenox, ILThe total loss of engine power due to fuel contamination as a result of the pilot’s improper fueling of the airplane.NTSB WPR21LA190Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Coeur d' Alene, IDThe student pilot’s failure to maintain directional control during the landing roll, and the flight instructors delayed remedial action which resulted in a runway excursion and collision with terrain.NTSB GAA21WA132AccidentClass 5 · ForeignCessna 210 · Itaituba, BrazilNTSB GAA21WA104Accident · 2 fatalClass 5 · ForeignRobinson R22 · Durban, South AfricaNTSB WPR21LA191Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic S A N-500 · Phoenix, AZThe pilot’s inability to maintain control after the balloon's encounter with an unexpected wind gust, which resulted in a collision with a tree.NTSB WPR21LA180Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Cuba, NMThe pilot's failure to maintain lateral control during takeoff after an encounter with a gusting wind, which resulted in a wing strike.NTSB GAA21WA100Accident · 4 fatalClass 5 · ForeignBell 206 · Rio Bravo, GuatemalaNTSB ERA21LA202Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Martinsville, VAThe pilot’s improper pitch control during a go-around in gusting crosswind conditions, which resulted in a tail strike and a runway excursion.NTSB ERA21FA200Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Wingate, NCThe pilot’s failure to maintain clearance from a power line during a low-level aerial application flight, resulting in tail rotor impact with the power line, a loss of control, and subsequent impact with the ground.NTSB CEN21LA208Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 23 · Hutchinson, KSThe pilot’s failure to abort the takeoff and his high pitch attitude after takeoff, which resulted in an exceedance of the critical angle of attack and a subsequent aerodynamic stall.NTSB ERA21LA213Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-161 · Okeechobee, FLA total loss of engine power for reasons that could not be determined based on available information.NTSB ERA21LA199Accident · Serious injuriesClass 4 · LimitedFinal reportMooney M20C · Warwick, NYA loose stand-off clamp which resulted in a throttle assembly malfunction, and the inability of the engine to produce full power during the attempted takeoff.NTSB CEN21LA204Accident · 1 fatalClass 3 · LimitedFinal reportPiper J3C-65 · Slaughter, LAA total loss of engine power for reasons that could not be determined from the available evidence.NTSB CEN21FA199Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Port Aransas, TXThe pilot’s failure to maintain adequate airspeed during the go-around, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall.NTSB WPR21FA175Accident · 2 fatalClass 3 · FieldFinal reportSwearingen SA226-T(B) · Winslow, AZThe loss of engine power to the right engine for reasons that could not be determined. Contributing to the accident was the pilot’s failure to maintain control of the airplane.NTSB ERA21LA191Accident · 1 fatalClass 3 · LimitedFinal reportRobinson Helicopter R44 · Forkston, PAThe pilot’s inadequate preflight weather planning, which resulted in an inadvertent encounter with instrument meteorological conditions at night, spatial disorientation, and collision with terrain.NTSB GAA21WA119Accident · No injuriesClass 5 · ForeignSpitfire MK26 · Breighton, UK, United KingdomNTSB GAA21WA089Accident · 1 fatalClass 5 · ForeignVans RV7A · Columbia, AustraliaNTSB ERA21LA395Accident · Serious injuriesClass 4 · LimitedFinal reportSchempp Hirth Ventus C · Wagener, SCImpact with trees during a forced landing in atmospheric lift conditions that were insufficient to maintain flight. Contributing was the pilot’s delayed decision to return to the airport.NTSB CEN21LA197Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Faribault, MNThe student pilot’s failure to maintain control during takeoff in gusty wind conditions and the flight instructor’s delayed remedial action, which resulted in the airplane colliding with trees and subsequently the ground.NTSB WPR21FA170Accident · 1 fatalClass 3 · FieldFinal reportConsolidated Vultee BT-13A · Camas, WAThe pilot’s exceedance of the airplane’s critical angle of attack during an aborted landing, resulting in an aerodynamic stall and impact with terrain.NTSB ERA21FA189Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28RT-201T · Brownsville, TNThe student pilot’s continued visual flight rules flight into night instrument meteorological conditions, which resulted in spatial disorientation and a rapid uncontrolled descent into terrain. Contributing to the accident were the self-induced and external…NTSB CEN21LA214Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5B · Gonzales, TXThe pilot’s failure to maintain directional control during landing that resulted in a runway excursion and collision with a pole.NTSB WPR21LA162Accident · No injuriesClass 4 · LimitedFinal reportThrush S2R-T660 · Hermiston, ORThe pilot’s loss of directional control due to a blown tire, which resulted in a runway excursion and impact with terrain.NTSB CEN21LA191Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Caro, MIThe pilot's inadequate preflight inspection and fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA21WA081Accident · 2 fatalClass 5 · ForeignCessna 172 · Canberra, AustraliaNTSB ERA21LA183Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Weyers Cave, VAMaintenance personnel’s inadequate inspection of the rudder control system, which resulted in failure of the rudder control assembly and the pilot’s loss of control during a go-around.NTSB CEN21LA188Accident · No injuriesClass 4 · LimitedFinal reportCessna 150M · Tishomingo, OKThe pilot’s decision to abort the takeoff on encountering a wind gust and his landing beyond the end of the runway that resulted in the airplane impacting a ditch collapsing the nose landing gear.NTSB GAA21WA201AccidentClass 5 · ForeignRobinson R44 · Hertzog Ville, South AfricaNTSB ERA21FA178Accident · 1 fatalClass 3 · FieldFinal reportCessna 177B · Great Valley, NYThe pilot’s failure to maintain control during takeoff.NTSB CEN21LA185Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Schaumburg, ILThe pilot’s failure to maintain directional control during the rejected takeoff with a left quartering crosswind that shifted to a tailwind.