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 WPR12FA040Accident · 1 fatalField investigationFinal reportCessna T337 · Casper, WYThe pilot's failure to maintain airspeed and airplane control while maneuvering in low visibility and icing conditions.NTSB ERA12CA075Accident · No injuriesData collectionFinal reportBellanca 17-30A · Pine Mountain, GAThe pilot's inadequate directional control during landing, which resulted in a runway excursion.NTSB ERA12FA074Accident · Serious injuriesField investigationFinal reportBeech 95-C55 · Ulysses, PAThe total loss of left engine power due to fuel starvation, and the pilot’s improper configuration of the fuel system during remedial actions, which resulted in fuel starvation of the right engine. Contributing to the accident was the pilot’s incomplete…NTSB CEN12LA071Accident · Serious injuriesLimited investigationFinal reportJuve Richard G Zodiac CH601 HDS · Clinton, ARThe inadvertent opening of the canopy during takeoff due to the improperly repaired forward canopy latch mechanism, which did not fully secure the canopy.NTSB CEN12FA072Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Perryville, ARThe pilot's loss of control in flight.NTSB CEN12LA066Accident · Minor injuriesLimited investigationFinal reportPiaggio Aero Industries P180 · Flint, MIThe captain's failure to maintain directional control during landing with one engine inoperative. Contributing to the accident was an improperly installed clevis pin in the left engine power lever, the crew’s delay in accurately identifying their heading, and…NTSB WPR12CA043Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Baker, CAThe pilot's delayed decision to perform an aborted landing.NTSB CEN12LA074Accident · No injuriesLimited investigationFinal reportBeech S35 · Elkhart Lake, WIThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR12LA036Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woodburn, ORThe pilot’s failure to maintain ground clearance while maneuvering with an external load line.NTSB WPR12CA038Accident · No injuriesData collectionFinal reportCessna 172S · Phoenix, AZThe student pilot's inadequate directional control during takeoff.NTSB ERA12WA099Accident · 4 fatalForeign investigationCessna 210 · Cuiaba, BrazilOn November 12, 2011, about 2000 universal coordinated time, a Cessna 210N, Brazilian registration PT-VMG, was substantially damaged when it impacted terrain shortly after takeoff in Cuiaba Municipality, State of Mato Grosso, Brazil. The Brazilian…NTSB WPR12CA037Accident · No injuriesData collectionFinal reportCessna 180H · Snohomish, WAThe pilot's decision to land in a high, gusting, variable wind.NTSB ERA12WA092Accident · No injuriesForeign investigationPiper PA-25 · Meteropolitana, ChileOn November 11, 2011, at 1345 UTC, a Piper PA-25-260, Chilean registration CC-ABM, registered to and operated by Sociedad De Ttrabajos Aeros Aeropacifico LTDA as a personal flight experienced a partial loss of engine power on initial takeoff climb, in the…NTSB WPR12MA034Accident · 5 fatalMajor investigationFinal reportEurocopter EC 130 B4 · Pukoo, HIThe pilot's failure to maintain clearance from mountainous terrain while operating in marginal weather conditions, which resulted in the impact of the horizontal stabilizer and lower forward portion of the fenestron with ground and/or vegetation and led to…NTSB CEN12FA058Accident · 1 fatalField investigationFinal reportCessna 337G · Alamosa, COThe loss of power to the rear engine due to fuel starvation during takeoff, which resulted from the fuel selector valve being inadvertently moved to the “off” position, and resulted in the airplane’s inability to climb.NTSB CEN12CA079Accident · Minor injuriesData collectionFinal reportBeech 95-B55 (T42A) · College Station, TXThe total loss of engine power from both engines, which resulted from fuel exhaustion due to the pilot’s inadequate pre-flight preparation.NTSB WPR12CA033Accident · No injuriesData collectionFinal reportCasler Scott CX-4 · San Carlos, AZThe pilot's inadequate directional control during takeoff.NTSB WPR12LA032Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Williams, CAA total loss of engine power during takeoff initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12FA031Accident · 3 fatalField investigationFinal reportCessna 182Q · Lake Havasu City, AZThe pilot's continued cruise flight into cloudy conditions at night, which resulted in a loss of airplane control due to spatial disorientation.NTSB ANC12LA002Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Kwigillingok, AKThe pilot's failure to abort the takeoff when he realized the airplane could not attain sufficient takeoff and climb performance and his improper decision to depart from an airport where night operations were prohibited.NTSB WPR12LA027Accident · No injuriesLimited investigationFinal reportBeech A36 · Yucca Valley, CAA loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA12LA063Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · West Palm Beach, FLThe pilot’s failure to maintain airspeed during a low-altitude turn into gusty tailwind conditions, which resulted in a loss of translational lift and settling with power. Contributing to the accident was the pilot's lack of total flight experience.NTSB ERA12FA062Accident · 2 fatalField investigationFinal reportBeech D-45 · Williston, FLThe flight instructor's failure to maintain airspeed in changing wind conditions during a steep climb after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the flight instructor’s ostentatious display close to the ground.NTSB ERA12IA060Incident · No injuriesIncident investigationFinal reportCessna 550 · Key West, FLThe pilots’ failure to appropriately apply the landing gear wheel brakes after landing, to properly perform the hard brake pedal-no braking condition procedure following the reported brake failure and to apply the emergency brakes. The reason for the reported…NTSB ERA12LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Pompano Beach, FLThe separation of the throttle cable from its fitting, which resulted in an inability to control engine power. Contributing to the accident was the inadequate maintenance by the owner.NTSB ERA12FA057Accident · 1 fatalField investigationFinal reportEckenrode Carl J Vans RV-6 · Taylorsville, GAThe airplane's entry into an uncontrolled descent for reasons that could not be determined because postaccident examination of the airplane and the pilot’s medical history did not reveal any anomalies that would have precluded normal operation.NTSB CEN12CA051Accident · Minor injuriesData collectionFinal reportDowner Bellanca 14-19-2 · Borger, TXA total loss of engine power due to fuel starvation as a result of the pilot’s improper fuel management. Contributing to the accident was the pilot’s diverted attention with the broken fuel gauge knob.NTSB ERA12FA056Accident · Serious injuriesField investigationFinal reportGulfstream G150 · Key West, FLThe pilot in command's failure to follow the normal landing procedures (placing engines into reverse thrust first and then brake), his delayed decision to continue the landing or go-around, and the flight crew's failure to follow emergency procedures once a…NTSB WPR12CA025Accident · No injuriesData collectionFinal reportCessna 172K · Florence, MTThe pilot's failure to maintain clearance from a power line during a low-level flight along a river. Contributing to the accident was the pilot's decision to fly at a low altitude.NTSB ERA12CA054Accident · Serious injuriesData collectionFinal reportAeros Trike · Amherst, VAThe student pilot's inadequate aircraft control and improper airspeed while maneuvering to land, which resulted in a stall. Contributing to the accident was the pilot's lack of experience in the make and model of the accident aircraft.NTSB ANC12FA006Accident · 1 fatalField investigationFinal reportEurocopter AS 350 B2 · Iliamna, AKThe pilot's loss of control due to sudden medical impairment or incapacitation.NTSB ERA12FA052Accident · 2 fatalField investigationFinal reportInterplane S R O Skyboy · Miami, FLThe pilot’s failure to maintain control of the airplane while flying at low speed, which resulted in a subsequent aerodynamic stall, spin, and impact with terrain. Contributing to the outcome of the accident was the pilot’s decision to operate the airplane…NTSB ERA12CA053Accident · Serious injuriesData collectionFinal reportCessna 172F · Smoketown, PAThe pilot did not maintain a proper approach path, which resulted in a collision with a tree.NTSB CEN12FA043Accident · Serious injuriesField investigationFinal reportHawker Beechcraft 76 · Fort Worth, TXThe flight instructor's failure to maintain airspeed above the air minimum control airspeed (Vmca), which resulted in a loss of control and impact with terrain. Contributing to the accident was the instructor's failure to follow published procedures to…NTSB ERA12CA050Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · McAlpin, FLThe pilot's misjudgment of the airplane's distance from known transmission lines.NTSB CEN12FA037Accident · 1 fatalField investigationFinal reportCirrus Design SR22T · Carrollton, TXThe pilot's failure to adequately preflight the airplane prior to departure, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA12FA021Accident · 1 fatalField investigationFinal reportElkind Bruce Cozy MK IV · Lexington, NCThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA12FA018Accident · 1 fatalField investigationFinal reportBerger Michael A Waiex · Washington, GAThe in-flight failure of the aircraft’s Y-tail attachment structure during maneuvering flight due to overload. Contributing to the accident was, the kit manufacturer’s use of 14 CFR Part 23, Appendix A design guidelines intended for a conventional tail…NTSB ERA12CA019Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Manassas, VAThe pilot did not maintain adequate airspeed while turning to the downwind leg, which resulted in an aerodynamic stall and spin.NTSB WPR12LA015Accident · Minor injuriesLimited investigationFinal reportPiper PA46R · Paso Robles, CAA loss of engine power while maneuvering for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN12CA035Accident · Minor injuriesData collectionFinal reportHouts Avid Mark IV · Hibbing, MNThe improper installation of a hose clamp, which resulted in an oil line rupture and subsequent loss of engine oil pressure.NTSB ERA12LA045Accident · No injuriesLimited investigationFinal reportGraff Wilbur C Bearhawk · Woodrow, WVThe pilot’s delayed use of carburetor heat while operating in conditions conducive to carburetor icing.NTSB ERA12CA042Accident · Minor injuriesData collectionFinal reportMoyes Bailey Dragonfly · Massey, MDThe pilot did not maintain airspeed during approach to landing, which resulted in an aerodynamic stall.NTSB CEN12CA028Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Brookings, SDThe pilot's inadequate compensation for gusty wind conditions while landing.NTSB ERA12LA034Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Newnan, GAA total loss of engine power for undetermined reasons.NTSB ERA12LA033Accident · No injuriesLimited investigationFinal reportCessna R172K · Williamsburg, VAA total 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 ERA12FA030Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Danbury, CTThe pilot did not maintain clearance from a lighted tower during final approach in night visual conditions.NTSB ERA12CA043Accident · Minor injuriesData collectionFinal reportFehlner-Shelton Aerosport Scamp WTB1 · Grantham, NCThe pilot's inadequate clearance from unmarked power lines while on approach to land at a private airport.NTSB ERA12CA036Accident · Serious injuriesData collectionFinal reportCessna 172F · Atlanta, GAThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA12CA035Accident · Serious injuriesData collectionFinal reportAmerican Champion 7AC · Berkley, MAThe pilot did not maintain clearance from a tree during the final approach in solar glare conditions.