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 ERA23LA229Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · South Bethlehem, NYThe pilot’s improper decision to attempt an intersection takeoff in a tailwind when the full runway in the opposite, headwind direction was available.NTSB WPR23FA185Accident · 3 fatalClass 3 · FieldFinal reportGates Lear Jet 36A · San Clemente Island, CAThe pilots’ loss of airplane control following a catastrophic fire that started on the left side of the aft equipment bay (tail cone). The fire likely initiated from a leak from the left fuel motive flow line due to a b-nut that loosened for reasons that…NTSB CEN23LA185Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Midland, TXThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.NTSB ERA23FA219Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Reliance, TNThe pilot’s decision to continue an instrument flight into an area of forecast weather with severe to extreme turbulence associated with a line of thunderstorms, which resulted in an in-flight breakup. Contributing was the pilot’s operation of the airplane in…NTSB ERA23LA225Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20K · Hillsborough Township, NJThe partial loss of engine power due to maintenance personnel’s failure to ensure that the ignition harnesses were properly secured and the pilot’s inappropriate pitch control inputs, which resulted in the airplane exceeding its critical angle of attack and…NTSB CEN23FA174Accident · 4 fatalClass 3 · FieldFinal reportPool Cessna R172 · Victor, COThe pilot’s failure to follow established mountain flying guidance, which resulted in a loss of control and impact with trees and mountainous terrain. Contributing to the accident was the airplane’s reduced climb performance at the elevated density altitude…NTSB CEN23FA173Accident · 1 fatalClass 3 · FieldFinal reportCessna 310D · Ennis, TXThe partial loss of right engine power due to reduced fuel flow as a result of the contamination of the fuel screen.NTSB ERA23LA218Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Greenville, NCInadequate maintenance by the operator and maintenance personnel, which resulted in a loss of engine power due to oil starvation.NTSB WPR23LA177Accident · No injuriesClass 3 · LimitedFinal reportCessna 210M · Pasco, WAImproper maintenance on the fuel outlet line to the fuel servo, which resulted in the line partially separating from the fuel outlet fitting and the subsequent fuel starvation and total loss of engine power.NTSB CEN23LA175Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Brookings, SDThe student pilot’s failure to maintain pitch and directional control during the takeoff roll. Contributing to the accident, was the student pilot’s delay in relinquishing control of the airplane and the instructor's delayed reaction before the loss of…NTSB WPR23LA174Accident · No injuriesClass 4 · LimitedFinal reportCessna T210N · San Luis Obispo, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA23WA150Accident · Serious injuriesClass 5 · ForeignCessna 182 · Langley Regional, CanadaNTSB CEN23LA168Accident · No injuriesClass 3 · LimitedFinal reportCessna 182D · Batesville, MSThe pilot’s failure to maintain airplane control while landing with a left gusting crosswind. Contributing to the accident was the partial loss of engine power during the go-around.NTSB CEN23FA167Accident · 1 fatalClass 3 · FieldFinal reportTitan Tornado · Lewisville, ARThe non-certificated pilot’s failure to maintain airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.NTSB WPR23LA168Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Nyssa, ORThe pilot’s failure to maintain adequate airspeed on takeoff that resulted in an aerodynamic stall and subsequent impact with trees.NTSB ERA23LA208Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV6 · Eaton, OHThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN23LA166Accident · No injuriesClass 3 · LimitedFinal reportProtech PT2 · Columbia, MSThe pilot’s lack of proper maintenance, which allowed the fuel filters to become obstructed, leading to fuel starvation and a subsequent engine power loss.NTSB ERA23LA206Accident · Serious injuriesClass 3 · LimitedFinal reportThatcher CX4 · West Palm Beach, FLThe loss of engine power due to fuel exhaustion.NTSB CEN23LA163Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150J · Buffalo, IAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning. Contributing to the accident were the unreliable fuel quantity gauges and the improperly adjusted mixture control, which increased the fuel consumption…NTSB CEN23LA161Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Flint Township, MIThe pilot’s failure to apply carburetor heat during the landing approach, which resulted in a loss of engine power from carburetor ice.NTSB CEN23FA160Accident · Serious injuriesClass 3 · FieldFinal reportAero Vodochody L-139 · Bridgeport, TXThe pilot’s failure to maintain a stabilized approach path while checking for possible bird strike damage that resulted in a delayed go-around attempt and a collision with terrain. Contributing to the accident was the flight instructor’s distraction while…NTSB WPR23LA160Accident · No injuriesClass 3 · LimitedFinal reportRemos Remos GX · Glendale, AZA total loss of engine power caused by fatigue cracking and fracture of the crankshaft. Contributing to the accident was the operator’s failure to properly maintain the airplane.NTSB WPR23LA159Accident · No injuriesClass 4 · LimitedFinal reportVashon Ranger R7 · Upland, CAThe pilot's improper selection of the mixture control, which resulted in a total loss of engine power and a collision with the airport boundary fence during a forced landing.NTSB ERA23FA200Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · London, OHThe flight instructor’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB WPR23LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna T337G · Upland, CAThe pilot’s failure to properly flare the airplane, which resulted in a hard landing. Contributing to the accident was the pilot’s decision to fly a nonstandard traffic pattern, which resulted in an unstable approach.NTSB ERA23FA194Accident · 1 fatalClass 3 · FieldFinal reportHolland Travis E Velocity · Andrews, NCThe pilot’s failure to engage the turbocharger for takeoff and his improper decision to continue the takeoff with partial power, rather than reject the takeoff.NTSB WPR23LA158Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18A 150 · Garrison, MOThe pilot’s inadequate fuel planning which resulted in fuel starvation, a loss of engine power and a subsequent impact with terrain.NTSB ERA23LA195Accident · Serious injuriesClass 3 · LimitedFinal reportRichard Spatz RV-14A · Fallston, MDThe pilot’s failure to discontinue an unstabilized approach, resulting in an aerodynamic stall and collision with terrain.NTSB CEN23LA153Accident · Minor injuriesClass 3 · LimitedFinal reportRyan Navion A · New Waverly, TXA total loss of engine power as a result of fuel contamination.NTSB ERA23FA188Accident · 1 fatalClass 3 · FieldFinal reportMiller Glenn F RV-12 · Climax, NCThe airplane owner/builder’s inappropriate use of a lower grade fuel than that required by the airplane and engine operations manual, which resulted in engine detonation and the degradation and eventual obliteration of the Nos. 1 and 2 cylinder spark plug…NTSB CEN23LA157Accident · Minor injuriesClass 4 · LimitedFinal reportAcro Sport II · Skiatook, OKThe pilot's failure to maintain directional control during landing in a gusting crosswind.NTSB ERA23LA191Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · Danbury, CTThe flight instructor’s inadequate preflight fuel planning and oversight of the preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN23LA150Accident · Minor injuriesClass 3 · LimitedFinal reportHelicopteres Guimbal Cabri G2 · Cahokia, ILThe lack of proper attachment of the cyclic control that resulted in a loss of control during a landing approach and impact with terrain. Contributing to the accident was the improper maintenance performed.NTSB ERA23LA183Accident · No injuriesClass 4 · LimitedFinal reportPeterson Mark G Peterson A600 · Foley, ALThe loss of engine power during the initial climb due to the disconnection of the turbocharger air intake hose and clamp, and the pilot’s inadequate servicing and preflight inspection of the turbocharger air intake clamp.NTSB ERA23FA182Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Jesup, GAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in a loss of control while maneuvering for a visual landing in low ceiling and low visibility conditions. Contributing to the…NTSB ERA23FA181Accident · 4 fatalClass 3 · FieldFinal reportPiper PA32R · Venice, FLThe pilot’s decision to initiate a visual flight rules flight into dark night conditions, which resulted in spatial disorientation during the initial climb and subsequent steep banking descent into water.NTSB GAA23WA141Accident · 1 fatalClass 5 · ForeignRobinson R44 · Middlemount, AustraliaNTSB WPR23FA141Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Oxbow, ORThe pilot’s continued visual flight into instrument meteorological conditions, resulting in airframe ice accretion and a subsequent loss of airplane control.NTSB WPR23FA138Accident · 1 fatalClass 3 · FieldFinal reportAerotrike Cobra · Santa Teresa, NMThe pilot’s exceedance of the aircraft’s critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA23WA108Accident · 1 fatalClass 5 · ForeignGrumman G164 · Comercial, UruguayNTSB CEN23LA148Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · Oklahoma City, OKThe pilot’s improper landing flare, which resulted in a hard, bounced landing, runway excursion, and subsequent collision with a runway sign. Contributing to the accident was the pilot’s lack of experience in the airplane, the unstabilized approach, and…NTSB CEN23FA142Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Port Allen, LAThe pilot’s decision to continue the visual flight rules flight into deteriorating weather conditions, which resulted in spatial disorientation and the loss of aircraft control.NTSB ERA23FA163Accident · 1 fatalClass 3 · FieldFinal reportLarry F Preiss AR-1 · Gainesville, GAThe pilot's inadequate preflight inspection and his failure to detect water-contaminated fuel that resulted in a loss of engine power and subsequent impact with a wire and terrain during an attempted forced landing.NTSB CEN23LA143Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Hillsboro, MOThe pilot’s failure to maintain clearance from trees during final approach to landing.NTSB CEN23FA139Accident · 1 fatalClass 3 · FieldFinal reportBeech 58P · Lubbock, TXThe pilot’s failure to ensure a proper fuel selector position before takeoff, which resulted in a loss of left engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to maintain airplane control after the loss of left engine…NTSB CEN23LA138Accident · Serious injuriesClass 4 · LimitedFinal reportSocata TB21 · Eden Prairie, MNThe pilot’s continued flight into icing conditions in an airplane that was not equipped for icing, which led to structural icing, subsequent loss of airplane control and impact with terrain.NTSB WPR23LA126Accident · Minor injuriesClass 4 · LimitedFinal reportTrendak Taurus · Strawberry Reservoir, UTThe pilot’s failure to maintain clearance from the snow-covered lake while flying at a low altitude.NTSB CEN23LA130Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · De Kalb, TXThe pilot’s inability to maintain control of the helicopter due to his failure to maintain rotor speed. Contributing to the accident was the failure of the helicopter’s low rotor speed warning system.NTSB WPR23FA122Accident · 1 fatalClass 3 · FieldFinal reportRockwell International S-2R · Willows, CAThe pilot’s failure to maintain clearance from powerlines while flying under multiple conductors during a low-altitude aerial application flight, which resulted in propeller contact with a powerline and a subsequent loss of control.NTSB CEN23FA125Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Port O'Connor, TXThe pilot’s initiation of the visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of helicopter control. Contributing to the accident was the pilot’s flicker vertigo during the flight.