NTSB investigations
10,137 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 CEN22FA217Accident · 1 fatalClass 3 · FieldFinal reportCessna 162 · Memphis, TNPilot incapacitation due to an acute cardiac event.NTSB CEN22FA216Accident · 1 fatalClass 3 · FieldFinal reportExpress 2000RG · Cheyenne, WYThe pilot's inability to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack while managing a loss of engine power and inflight fire, which resulted in an aerodynamic stall. Contributing factors to the accident were the loss…NTSB ERA22LA249Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Melrose, TNA total loss of engine power due to carburetor icing.NTSB ERA22LA242Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7EC · Putnam Valley, NYA total loss of engine power during cruise flight due to fuel starvation resulting from obstructed forward and aft vent outlets in the left fuel tank.NTSB CEN22FA211Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-12 · Seagraves, TXThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering, which resulted in an aerodynamic stall/spin and loss of control.NTSB ERA22LA250Accident · No injuriesClass 4 · LimitedFinal reportCessna 340 · St. Petersburg-Clearwater, FLThe pilot’s inability to stop the airplane on the available runway, which resulted in a runway excursion and collision with an airport perimeter fence.NTSB CEN22FA208Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Broomfield, COThe pilot’s failure to abort the takeoff due to degraded engine performance. Contributing to the accident was the reduced performance of the engine, the reason for which could not be determined.NTSB WPR21LA368Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Sacramento, CAThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA22WA298Accident · 5 fatalClass 5 · ForeignRobin D140 · Grenoble, FranceNTSB CEN22LA209Accident · No injuriesClass 3 · LimitedFinal reportTextron B300C · Fort Stockton, TXThe pilot’s failure to maintain directional control while landing with a single engine and maximum braking effort.NTSB ERA22FA233Accident · 1 fatalClass 3 · FieldFinal reportCessna 140 · Wayne, NEThe pilot’s exceedance of the airplane’s critical angle of attack on final approach while conducting traditional short takeoff and landing operations in gusting wind conditions, which resulted in an aerodynamic stall and spin from which the pilot could not…NTSB GAA22WA184AccidentClass 5 · ForeignRans S6-ES · Hampshire, United KingdomNTSB GAA22WA185Accident · 1 fatalClass 5 · ForeignSikorsky S61N · Tongyeong-si, KiribatiNTSB CEN22LA201Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver Sport 2S · Osawatomie, KSThe loss of engine power due to fuel exhaustion and the pilot’s failure to maintain control of the airplane during a forced landing which resulted in an aerodynamic stall.NTSB CEN22LA198Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Port Bolivar, TXThe pilot’s failure to attain a proper soft field takeoff pitch attitude during takeoff that resulted in a runway excursion and subsequent impact with a canal.NTSB WPR22LA174Accident · Serious injuriesClass 3 · LimitedFinal reportBell Helicopter Textron Canada 407 · Livermore, CALoss of engine power due to the pilot inadvertently selecting engine IDLE mode while in flight, which reduced rotor and engine speed to a level that could not sustain flight.NTSB ERA22FA223Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-250 · Athens, GAA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN22FA197Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Broomfield, COThe pilot’s failure to maintain control of the airplane for reasons that could not be determined.NTSB CEN22LA194Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · Traverse City, MIThe failure of maintenance personnel to properly torque a fuel line “B” nut, which resulted in a total loss of engine power.NTSB ERA22LA220Accident · 1 fatalClass 3 · LimitedFinal reportCirrus Design SR22 · Tybee Island, GAA loss of airplane control due to pilot incapacitation, which resulted in an overflight of his destination and subsequent descent into water.NTSB ERA22FA218Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Altha, FLThe pilot’s failure to perform a preflight weight and balance calculation and his operation of the flight at an excessive takeoff weight, resulting in an exceedance of the airplane’s critical angle of attack after liftoff and an aerodynamic stall from which…NTSB ERA22LA216Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman AA1 · Seneca, SCA dislodged air filter element, which restricted airflow to the carburetor resulting in a loss of engine power.NTSB GAA22WA171Accident · 4 fatalClass 5 · ForeignPiper PA28 · Sioux Lookout Ontario, CanadaNTSB CEN22LA185Accident · 1 fatalClass 3 · LimitedFinal reportSuperior Culver LFA · Syracuse, KSThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an inadvertent aerodynamic stall while returning to the airport following a partial loss of engine power for reasons that could not be determined.NTSB ERA22LA209Accident · Minor injuriesClass 4 · LimitedFinal reportGarlick Helicopters OH-58A+ · Oakland, FLThe pilot’s decision to continue the low-altitude aerial application flight over water conditions that degraded his depth perception, which resulted in an inadvertent collision with the water.NTSB ERA22LA204Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172A · Stockbridge, GAThe flight instructor’s delayed remedial action during an unstabilized approach, which resulted in an impact with powerlines and a subsequent loss of controlNTSB ERA22LA202Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Fountain Inn, SCThe pilot’s failure to obtain the proper touchdown point during landing, which resulted in a runway overrun and collision with a fence.NTSB WPR22LA166Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 170B · Ravensdale, WAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.NTSB WPR22LA163Accident · No injuriesClass 3 · LimitedFinal reportTextron T206H · Santa Barbara, CAThe loss of directional control for undetermined reasons. Contributing was the overstress fracture of the nose gear upper trunnion brace attach point.NTSB CEN22LA181Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172M · Manhattan, KSThe pilot’s failure to use carburetor heat during the approach and his unsuitable flight profile for an upsloping runway, which resulted in a partial loss of engine power and an impact with terrain during an attempted go-around.NTSB GAA22WA159Accident · 1 fatalClass 5 · ForeignCessna 172 · Coonagarabran, AustraliaNTSB ERA22LA194Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140B · Panama City, FLA total loss of engine power due to fuel contamination. Contributing to the accident was the inadequate maintenance and inspection of the airplane and engine by maintenance personnel, and the pilot’s inadequate preflight inspection and runup.NTSB ERA22LA192Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206B · Cedar Key, FLThe pilot’s improper fuel planning during agricultural spraying operations, which resulted in fuel starvation, a loss of engine power, and a hard landing following an autorotation.NTSB ERA22LA196Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Zebulon, NCThe flight instructor’s failure to maintain directional control with a quartering tailwind.NTSB ERA22FA189Accident · 1 fatalClass 3 · FieldFinal reportSchleicher ASW-19B · Jacksonville, FLThe pilot’s improper preflight assembly of the glider’s elevator control, which resulted in a loss of control on takeoff, and the pilot’s failure to complete a positive control check before the flight, which would have identified the disconnected elevator…NTSB WPR22LA158Accident · No injuriesClass 3 · LimitedFinal reportEuropa XS Mono · Eastsound, WAThe pilot inadvertently shut off the engine control unit, which resulted in the engine turning off before the runway landing was attained.NTSB ANC22LA029Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Beluga, AKThe pilot’s excessive touchdown speed, which resulted in a long landing and impact with terrain.NTSB WPR22LA150Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASK 21 · Valyermo, CAThe gliders encounter with atmospheric conditions where the lift was not sufficient to maintain flight and subsequent impact with mountainous terrain.NTSB ERA22LA186Accident · Serious injuriesClass 3 · LimitedFinal reportHenry L Berrier JR Arion Lightning LS-1 · Mountain City, TNA total loss of engine power due to intermittent operation of both the engine-driven fuel pump and the electric boost pump. Contributing was the pilot’s delay in rejecting the takeoff, after the initial loss of engine power, which resulted in a collision with…NTSB ERA22LA182Accident · Minor injuriesClass 3 · LimitedFinal reportAmerican AA-1 · Kennesaw, GAA loss of engine power due to the formation of carburetor ice.NTSB GAA22WA144Accident · 2 fatalClass 5 · ForeignBell 206 · Adaminaby, AustraliaNTSB WPR22LA141Accident · No injuriesClass 4 · LimitedFinal reportFernandes Dale R Glasair II S-FT · Saline Valley, CAThe pilot’s failure to establish a controlled descent rate during landing which resulted in the airplane touching down short of the runway.NTSB ERA22LA177Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 170 · Stoney Point, NCThe pilot’s failure to retract the flaps during a go-around from a bounced landing, which resulted in a collision with trees then terrain.NTSB ERA22LA176Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177RG · Gaithersburg, MDThe pilot’s failure to maintain adequate airspeed while maneuvering on final approach which resulted in a high sink rate and subsequent collision with a fence.NTSB CEN22LA163Accident · 2 fatalClass 3 · LimitedFinal reportKitfox 7 · Crowell, TXThe pilot's exceedance of the airplane's critical angle of attack during low-level flight, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.NTSB ERA22LA174Accident · Minor injuriesClass 4 · LimitedFinal reportFpna A-22 Valor · Mascotte, FLThe pilot’s incorrect positioning of both wing fuel valves, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA22LA172Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28 · Melbourne, FLA loss of engine power due to oil starvation as a result of the failure of the No. 3 crankshaft journal bearing.NTSB CEN22LA159Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RXS-8 · Yutan, NEThe pilot’s improper brace during landing which resulted in a serious injury during the landing sequence.NTSB CEN22LA158Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Garnett, KSThe pilot’s failure to maintain lateral control while hovering which resulted in a dynamic rollover.NTSB CEN22LA154Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Wade, OKThe student pilot’s failure to maintain clearance from power lines during takeoff.