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 CEN14CA460Accident · No injuriesData collectionFinal reportAviat Husky · Steamboat Springs, COThe student rated pilot's inadvertent flight control input resulting in a ground loop and substantial damage to the right wing.NTSB WPR14FA320Accident · 1 fatalField investigationFinal reportMooney M20L - NO Series · San Diego, CAThe pilot's failure to achieve climb performance and maintain sufficient airspeed during a go-around, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's failure…NTSB ERA14LA369Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Helena, ALA total loss of engine power for reasons that could not be determined due to postcrash fire damage.NTSB CEN14CA422Accident · No injuriesData collectionFinal reportPiper PA 32-300 · Warsaw, INThe pilot failed to maintain directional control during landing.NTSB ANC14LA058Accident · No injuriesLimited investigationFinal reportDehavilland DHC 2 · Talkeetna, AKThe pilot’s inadequate preflight inspection that did not detect that the bulk fuel tank was full and led to an unanticipated heavy airplane weight and his failure to use the entire soft, wet, and muddy airstrip length for takeoff, which resulted in a takeoff…NTSB WPR14CA328Accident · No injuriesData collectionFinal reportBeech A36 - Undesignat · San Carlos, CAThe pilot's failure to maintain directional control during taxi.NTSB ERA14CA367Accident · No injuriesData collectionFinal reportCessna 162 · Winchester, VAThe student pilot's failure to maintain aircraft control during an aborted landing.NTSB CEN14FA396Accident · Serious injuriesField investigationFinal reportRender RV 9A · Oshkosh, WIThe pilot's failure to establish a stabilized approach and to maintain airspeed during final approach over obstacles resulting in a stall/mush.NTSB ERA14CA366Accident · Minor injuriesData collectionFinal reportCessna 150M · Waterloo, NYThe pilot's failure to maintain adequate clearance from obstructions while on approach to the runway.NTSB CEN14LA433Accident · No injuriesLimited investigationFinal reportSutton William J Stits Playmate SA11A · Bridgeport, TXThe pilot’s loss of airplane control during takeoff after encountering rapidly changing wind conditions.NTSB CEN14LA398Accident · Serious injuriesLimited investigationFinal reportHughes 369D · West Liberty, OHA total loss of engine power, which resulted from fuel exhaustion due to the pilot’s failure to adequately monitor the fuel quantity during the flight.NTSB WPR14FA316Accident · 1 fatalField investigationFinal reportMeyer Legacy · Lolo Pass, IDThe fatigue fracture of an engine connecting rod, which resulted in a catastrophic engine failure and a forced landing in unsuitable terrain.NTSB ANC14LA056Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Dillingham, AKThe pilot’s failure to maintain directional control during the landing due to his decision to attempt a landing with a quartering tailwind, which resulted in a ground loop and impact with the runway surface.NTSB WPR14LA315Accident · Minor injuriesLimited investigationFinal reportErcoupe 415 C · Susanville, CAThe pilot’s failure to follow the checklist while starting the engine and to lock the engine primer plunger, which resulted in the partial loss of engine power during cruise flight in high density altitude conditions.NTSB ERA14CA365Accident · No injuriesData collectionFinal reportCessna 182B · Clayton, GAThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a tree and then obstacles during the subsequent aborted takeoff.NTSB CEN14LA393Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33A · Pueblo, COA total loss of engine power due to fuel starvation, which resulted from the pilot’s improper fuel management and resulted in a forced landing on unsuitable terrain.NTSB CEN14FA389Accident · 2 fatalField investigationFinal reportFedersen Walter Lancair IVP · Findlay, OHAn in-flight fire for reasons that could not be determined due to the extent of impact and fire damage.NTSB WPR14LA312Accident · Minor injuriesLimited investigationFinal reportRoscher Frederick Thunder Mustang · Spanish Springs, NVA complete loss of engine power during climb for reasons that could not be determined due to the severity of postcrash fire damage to the airplane.NTSB WPR14CA314Accident · No injuriesData collectionFinal reportCessna 182Q · Warren, IDThe pilot's attempt to depart on an unpaved road, which he mistook for the unpaved runway. Contributing to the accident was the fact that the road and the runway were conjoined for the first few hundred feet of the runway.NTSB ERA14LA361Accident · No injuriesLimited investigationFinal reportHiller UH 12E · Wadesboro, NCA partial loss of engine power due to the failure of the No. 2 engine accessory gearbox bearing for reasons that could not be determined based on the available information.NTSB CEN14CA392Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Caputa, SDThe student pilot's improper takeoff procedure and the flight instructor's failure to take control of the airplane and abort the takeoff.NTSB ANC14CA061Accident · No injuriesData collectionFinal reportAviat A 1 · Ketchikan, AKThe pilot's decision to takeoff from a remote mountain lake in variable wind. Contributing to the accident was the pilots delayed decision to abort the takeoff.NTSB ERA14LA368Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer A/C G-164B · Bonifay, FLA partial blockage of the No. 2 bearing oil nozzle jet by bearing material, which resulted in oil starvation and the subsequent failure of the No. 2 bearing and total loss of engine power.NTSB ERA14CA357Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Lafollette, TNThe pilot's failure to maintain directional control during a go-around in gusty crosswind conditions.NTSB ERA14LA351Accident · Serious injuriesLimited investigationFinal reportSiler Ronald E Ultrastar · Halifax, PAA total loss of engine power for reasons that could not be determined because the engine was not recovered. Contributing to the accident was the pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during…NTSB ERA14FA350Accident · 2 fatalField investigationFinal reportWilderoder Great Lakes 2TIA · Lillian, ALA loss of engine power due to an inoperative magneto and possible carburetor ice, which resulted in a forced landing into unsuitable terrain. Contributing to the accident was an inadequate magneto overhaul by unknown personnel and the modification to the…NTSB CEN14CA395Accident · No injuriesData collectionFinal reportCessna A188B · Milford, NEThe pilot's improper engine mixture setting which reduced available engine power, and his inadvertent retraction of flaps which resulted in an impact with crops and terrain.NTSB WPR14LA308Accident · Serious injuriesLimited investigationFinal reportMdhi 369D · Oso, WAThe pilot/mechanic’s failure to properly perform required inspections of the main rotor blades at the necessary intervals, which resulted in an in-flight separation of a main rotor blade due to disbonding and fatigue cracking. Contributing to the accident was…NTSB ERA14CA352Accident · No injuriesData collectionFinal reportCessna 172M · Chatham, MAThe pilot's failure to maintain directional control during takeoff, resulting in a runway excursion and collision with trees.NTSB CEN14LA387Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Flushing, MIThe pilot receiving instruction’s failure to maintain directional control during the takeoff roll. Contributing to the accident was the flight instructor not having access to brake controls, which limited his ability to regain directional control at slower…NTSB WPR14FA302Accident · 2 fatalField investigationFinal reportCessna 172K · Littlefield, AZThe pilot's failure to maintain airplane control when the airplane encountered high gusting wind while conducting low altitude flight in a narrow canyon, which resulted in an inflight collision with terrain.NTSB WPR14CA342Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll in variable wind conditions, resulting in a ground-loop.NTSB ERA14CA348Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Titusville, FLThe student pilot's failure to initiate the decelerative flare during autorotation and the CFI's delayed remedial action, which resulted in a hard landing.NTSB WPR14WA304Accident · 1 fatalForeign investigationCessna 182 - L · Albury Aerodrome, AustraliaOn July 20, 2014 about 1600 local time, a Cessna 182L airplane, Australian registration VH-TRS, collided with terrain near Albury Aerodrome, New South Wales, Australia. The airplane sustained substantial damage and the pilot was fatally injured. The airplane…NTSB WPR14FA303Accident · 4 fatalField investigationFinal reportCessna 182L · Sedona, AZThe pilot’s failure to maintain adequate airspeed and his exceedance the airplane’s critical angle-of attack while maneuvering through a canyon in high-density altitude conditions at low altitude, which resulted in an aerodynamic stall.NTSB ERA14LA347Accident · Serious injuriesLimited investigationFinal reportColt Balloons 160A · Clinton, MAThe pilot's inadequate preflight and inflight planning and improper landing site selection and approach path, which resulted in the balloon contacting powerlines during landing. Contributing to the accident was the Federal Aviation Administration's inadequate…NTSB WPR14CA319Accident · No injuriesData collectionFinal reportBell 206B · Salinas, CAThe pilot's failure to ensure adequate clearance from ground obstacles during takeoff which resulted in loss of aircraft control.NTSB WPR14CA301Accident · Minor injuriesData collectionFinal reportErcoupe 415 C · Hubbart, ORThe pilot's failure to maintain aircraft control and proper alignment during approach for landing in gusting wind conditions.NTSB ERA14FA345Accident · 3 fatalField investigationFinal reportMooney M20F · North Elba, NYThe pilot’s failure to maintain adequate airspeed for the airplane’s configuration and flight profile, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall/spin.NTSB ERA14CA364Accident · No injuriesData collectionFinal reportCessna 177B · Falmouth, MAThe pilot's misjudgment of speed and distance on final approach resulting in a touchdown near the departure end of the runway, a runway excursion, and collision with trees.NTSB CEN14LA385Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Wichita Falls, TXA partial loss of engine power, which resulted in a forced landing on unsuitable terrain. The reason for the loss of engine power could not be determined during postaccident examination.NTSB ANC14LA055Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palmer, AKThe pilot’s inadvertent application of excessive brake pressure during landing on a rough surface, which resulted in a nose-over.NTSB WPR14CA299Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Hoopa, CAThe pilot's inadequate approach and excessive airspeed which resulted in a long landing and subsequent runway overrun onto rough terrain.NTSB WPR14CA296Accident · Serious injuriesData collectionFinal reportBell 47G 2A · Merced, CAThe pilot's failure to adequately monitor the environment to maintain clearance from the power pole guide wire during low level maneuvering.NTSB CEN14LA376Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 401B · Ellis, KSThe noninstrument-rated pilot’s inadequate preflight weather planning and subsequent inadvertent encounter with instrument meteorological conditions, which resulted in spatial disorientation and the loss of airplane control. Contributing to the accident was…NTSB WPR14LA298Accident · No injuriesLimited investigationFinal reportPiper PA 30 · Othello, WAThe partial loss of engine power for reasons that could not be determined based on the available information.NTSB CEN14FA369Accident · 3 fatalField investigationFinal reportAgusta A109E · Newkirk, NMThe pilot's inadvertent visual flight into instrument meteorological conditions, which resulted in a loss of helicopter control.NTSB WPR14CA294Accident · Minor injuriesData collectionFinal reportThrush S2RHG T65 · Parma, IDThe pilot's decision to take off with a tailwind, which resulted in the airplane not attaining sufficient airspeed for takeoff.NTSB ERA14LA342Accident · Serious injuriesLimited investigationFinal reportHolmlund Victor P Auriga · Manville, NJThe pilot’s improper preflight fuel planning and in-flight fuel monitoring, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA14FA343Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · North Captiva Island, FLThe pilot’s failure to secure the cargo in the cargo compartment, which resulted in a weight shift that led to the center of gravity exceeding its aft limit during a go-around attempt and a subsequent aerodynamic stall. Also causal to the accident were the…