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 CEN14LA508Accident · 2 fatalLimited investigationFinal reportBrupbacher Chris CB2000 · Reserve, LAThe failure of the flight control rod bearing due to an undetected preexisting corrosion-induced crack, which resulted in the main rotor blades going to full pitch and the rotor mast folding; this allowed the pusher propeller to strike and sever the tail.NTSB WPR14CA383Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Rimrock, WAThe pilot's failure to maintain aircraft control during takeoff from a rough runway surface which resulted in an off-airport forced landing just beyond the runway.NTSB ERA14LA450Accident · Serious injuriesLimited investigationFinal reportBarger Jerry L Challenger II · Clarion, PAThe pilot's inadequate preflight planning, which resulted in a takeoff with the airplane's center of gravity aft of its limit and led the airplane to exceed its critical angle of attack and experience an aerodynamic stall during the initial climb.…NTSB ERA14CA453Accident · Minor injuriesData collectionFinal reportSchleicher ASK 21 · Wurtsboro, NYA loss of lift during the landing approach, which resulted in impact with terrain.NTSB ERA14CA449Accident · No injuriesData collectionFinal reportCessna 182A · Bethany Center, NYThe pilot's failure to maintain a directional control of the airplane during gusting wind conditions.NTSB CEN14LA507Accident · 2 fatalLimited investigationFinal reportManweiller Acro Sport II · Middletown, OHThe failure of the flying pilot to maintain airplane control after an aerodynamic stall/spin occurred during the aerobatic maneuver following a reported intermittent loss of engine power for reasons that could not be determined during postaccident…NTSB WPR14FA381Accident · 1 fatalField investigationFinal reportCessna 162 · Borrego Springs, CAThe pilot’s failure to recover from a stall, which resulted in a subsequent spin from which he did not recover because he did not immediately apply the proper stall and spin recovery techniques.NTSB ERA14LA446Accident · Minor injuriesLimited investigationFinal reportCessna 180B · Piscataquis County, METhe fatigue fracture of the No. 3 exhaust valve, which initiated at the outer surface of the valve stem and resulted in the subsequent total loss of engine power over terrain unsuitable for landing.NTSB ERA14FA445Accident · 2 fatalField investigationFinal reportNorth American T 28C · Alton, VAThe pilot’s failure to maintain altitude while performing low-level aerobatic maneuvers, which resulted in collision with terrain. Contributing to the accident was the pilot’s improper decision to attempt aerobatics at such a low altitude.NTSB ERA14CA447Accident · No injuriesData collectionFinal reportCub Crafters CC11 100 · Culpepper, VAThe failure of both pilots to maintain directional control during landing.NTSB CEN14LA519Accident · No injuriesLimited investigationFinal reportPiper PA 36-285 · Woodburn, INA loss of engine power during takeoff for reasons that could not be determined based on the available information.NTSB CEN14FA506Accident · 1 fatalField investigationFinal reportCessna 172R · Okmulgee, OKThe pilot's continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain clearance with trees and terrain.NTSB CEN14FA505Accident · No injuriesField investigationFinal reportEmbraer EMB 505 · Conroe, TXThe second-in-command's (SIC) engagement of the emergency parking brake (EPB), which decreased the airplane's braking performance and prevented it from stopping on the available runway. Contributing to the SIC's decision to engage the EPB was the…NTSB ANC14CA087Accident · No injuriesData collectionFinal reportHelio H 250 · Arctic Village, AKThe pilot's selection of an unsuitable landing/takeoff area, resulting in an inflight collision with terrain during takeoff.NTSB CEN14LA504Accident · 2 fatalLimited investigationFinal reportSaccio Thomas A Seawind 3000 · Bloomington, INAn in-flight fire for reasons that could not be determined because the examination of the airplane did not reveal the source of the fire.NTSB ERA14FA455Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Fort Gaines, GAThe pilot’s failure to maintain airplane control during flight, which resulted in a collision with a river.NTSB ANC14CA083Accident · No injuriesData collectionFinal reportCessna 175 · Ambler, AKThe pilot's decision to takeoff from a rough airstrip in gusty wind conditions, which resulted in a loss of control.NTSB ANC14CA082Accident · Minor injuriesData collectionFinal reportHelio H 295 · Prospect Creek, AKThe pilot's loss of directional control during takeoff, in gusty and variable wind conditions, resulting in a collision with terrain.NTSB WPR14LA377Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Lone Pine, CAThe fatigue failure of a propeller blade due to a propeller strike by/of an unidentified object at an unknown time.NTSB ERA14LA440Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-180 · St. Petersburg, FLA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s improper preflight fuel planning and in-flight fuel management.NTSB ERA14LA436Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Monroe, GAThe improper installation of the oil filter adapter at an unknown time, which resulted in an oil leak and subsequent oil starvation to the engine.NTSB WPR14CA396Accident · Minor injuriesData collectionFinal reportUltramagic N250 - NO Series · Phoenix, AZThe pilot's failure to maintain aircraft control while landing in downdraft and gusting wind conditions which resulted in striking trees and a subsequent hard landing.NTSB ANC14CA080Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Aniak, AKThe pilot's inability to maintain directional control of the airplane resulting in a separation of the wheel axle, resulting in a collision with terrain.NTSB ANC14CA079Accident · No injuriesData collectionFinal reportPiper PA 18-135 · Susitna, AKThe pilot's inadequate compensation for gusting, variable wind conditions during initial climb after takeoff.NTSB WPR14CA373Accident · Minor injuriesData collectionFinal reportBell 407 · Moab, UTThe pilot's failure to ensure adequate clearance from terrain while landing on sloped terrain.NTSB WPR14CA372Accident · Minor injuriesData collectionFinal reportFound Acft Canada FBA 2C1 · Cascade, IDThe pilot's failure to maintain directional control during landing.NTSB ERA14LA434Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Spruce Creek, FLA total loss of engine power due to fuel exhaustion, which resulted from the pilots’ improper preflight and in-flight fuel planning.NTSB CEN14CA496Accident · No injuriesData collectionFinal reportCessna 172M · Oxford, WIThe pilot did not compensate for the decrease in the crosswind when he descended below the tree line during the landing.NTSB CEN14FA494Accident · 1 fatalField investigationFinal reportSmith Aerostar 601P · Austin, TXThe pilot's failure to maintain sufficient clearance from trees during the single-engine landing approach. Contributing to the accident was the loss of power in the left engine due to an improperly installed rubber boot that became dislodged and was then…NTSB ERA14CA430Accident · Minor injuriesData collectionFinal reportCessna 172M · Watertown, CTThe pilot's decision to takeoff from a field which resulted in a collision with trees and the ground. Contributing to the accident was the pilot's failure to correctly identify the destination airport and runway, which resulted in an off-airport landing in…NTSB CEN14LA495Accident · No injuriesLimited investigationFinal reportNolin Vans RV-10 · Houston, TXThe total loss of engine power for reasons that could not be determined during postaccident examination.NTSB WPR14FA369Accident · 1 fatalField investigationFinal reportBackovich George C G P 5 · Reno, NVThe failure of the right wing under normal race loads due to an improper repair of the right wing spar that reduced its structural strength following a previous landing accident.NTSB ERA14FA428Accident · 2 fatalField investigationFinal reportCessna 172 · Selkirk, NYA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN14CA490Accident · Serious injuriesData collectionFinal reportBuckeye Dream · Monee, ILThe pilot's failure to see and avoid power lines while maneuvering low to the ground, which resulted in a collision and loss of control.NTSB CEN14CA488Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Belen, NMThe student pilot's improper recovery from a bounced landing.NTSB ERA14CA426Accident · Serious injuriesData collectionFinal reportSchleicher ASW 19B · Avoca, NYThe pilot's decision to attempt a return to his departure airport which resulted in the glider's encounter with atmospheric conditions where the lift was not sufficient to maintain flight and an off-airport landing.NTSB CEN14LA486Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Langola Township, MNMaintenance personnel’s failure to apply sufficient torque on the throttle control lever nut, which resulted in a loss of throttle control and subsequent loss of engine power.NTSB CEN14LA485Accident · 2 fatalLimited investigationFinal reportCismowski Tierra II · Montevideo, MNThe pilot's impaired judgment due to the use of marijuana, which led to his improper decision to fly the airplane over its maximum gross weight and his subsequent loss of airplane control during takeoff with gusting wind conditions.NTSB ANC14CA077Accident · No injuriesData collectionFinal reportCessna 185 · Gakona, AKThe pilot's inability to maintain directional control after the airplane's main landing gear tire deflated during takeoff.NTSB WPR14LA367Accident · Serious injuriesLimited investigationFinal reportPiper PA 25-235 · Warner Springs, CAThe glider pilot's failure to maintain directional control during the initial climb while being towed, which led to the tow plane's unstable flight and its subsequent aerodynamic stall. Contributing to the accident was the tow pilot's delayed release of the…NTSB ERA14LA425Accident · Minor injuriesLimited investigationFinal reportNavion Navion · Rock Hill, SCThe pilot’s improper fuel management, which resulted in the exhaustion of the fuel supply in the selected fuel tank and a subsequent total loss of engine power.NTSB ANC14CA076Accident · No injuriesData collectionFinal reportCessna U206B · Gustavus, AKThe motor vehicles operators' lack of attention, and improper decision to cross the runway with the runway alert system active, resulting in a collision with the airplane.NTSB ERA14LA424Accident · 2 fatalLimited investigationFinal reportSocata TBM 700 · Caribbean Sea, A1The design of the cabin pressurization system, which made it prone to unnecessary shutdown, combined with a checklist design that prioritized troubleshooting over ensuring that the pilot was sufficiently protected from hypoxia. This resulted in a loss of…NTSB ANC14CA074Accident · No injuriesData collectionFinal reportPiper PA 18-135 · Fairbanks, AKThe pilot's inability to maintain directional control of the airplane resulting in a runway excursion and collision with terrain.NTSB CEN14LA492Accident · No injuriesLimited investigationFinal reportCampbell Super Bearhawk · Sault Ste Marie, MIThe pilot’s inadequate flare during landing on water with a glassy condition, which resulted in the airplane nosing over.NTSB ERA14LA422Accident · No injuriesLimited investigationFinal reportAckland Jeffrey Dean SH 3R · Columbus, GAThe mechanic’s improper installation of the landing gear extend/retract switch, which resulted in the retraction of the landing gear during the aborted takeoff.NTSB ERA14FA421Accident · 1 fatalField investigationFinal reportKlaas Development Lancair IV P · Ooltewah, TNThe inadequate torque of the propeller mounting bolts and inspection of the propeller, which resulted in the fatigue fracture of the bolts and a subsequent in-flight separation of the propeller assembly.NTSB CEN14LA476Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-350P · Cortez, COThe flight instructor’s delayed decision to abort the simulated engine out maneuver, his failure to unfeather the propeller before restoring engine power, and his inadequate airspeed management, which led to an aerodynamic stall at low altitude.NTSB CEN14CA483Accident · No injuriesData collectionFinal reportRoss Alfred K/Oneill Terrence Lancair 235 · Longmont, COThe pilot's inadvertent application of the brake which resulted in the loss of directional control during the landing roll.NTSB ERA14LA418Accident · Serious injuriesLimited investigationFinal reportLorenz Stephen Kitfox Series 5 · Greene, NYThe pilot’s failure to attain adequate airspeed during the initial climb, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot’s lack of experience in the…