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 WPR10LA127Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Los Banos, CAA partial loss of engine power due to a failure of the throttle interconnect hardware, which resulted in a hard landing.NTSB WPR10LA126Accident · Serious injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58A · Escalon, CAA loss of engine power during cruise flight due to the fatigue failure of the pneumatic fuel-to-governor control line. Also causal was the inadequate installation of the pneumatic line by maintenance personnel, and the pilot’s decision to continue flight with…NTSB ERA10LA127Accident · No injuriesLimited investigationFinal reportCessna 150G · St. Augustine, FLA loss of engine power due to fuel exhaustion caused by the failure of the right wing fuel tank sending unit gasket, which resulted in a forced landing.NTSB ERA10CA125Accident · No injuriesData collectionFinal reportBeech A36 · Argyle, NYThe pilot's decision to land downwind on the contaminated runway, resulting in the airplane overrunning the runway.NTSB WPR10LA119Accident · Minor injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · La Quinta, CAA loss of engine power during cruise flight due to water contamination in the fuel.NTSB CEN10FA108Accident · 2 fatalField investigationFinal reportSmith Aerostar 601P · Sugar Grove, ILThe pilot's spatial disorientation and subsequent failure to maintain airplane control.NTSB WPR10LA118Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Reno, NVA total loss of engine power during cruise due to oil starvation as a result of foreign material blockage of the oil pickup tube.NTSB CEN10FA107Accident · 2 fatalField investigationFinal reportCostruzioni Aeronautiche Tecna P2002 · Waxahachie, TXA loss of aircraft control while maneuvering for undetermined reasons.NTSB ANC10CA015Accident · No injuriesData collectionFinal reportCessna 172H · Nightmute, AKThe pilot's failure to maintain control of the airplane in a strong gusting wind, and his decision to taxi for takeoff in such conditions.NTSB ANC10FA014Accident · 2 fatalField investigationFinal reportBeech 1900C · Sand Point, AKAn in-flight loss of control for an undetermined reason, which resulted in an uncontrolled descent.NTSB DCA10WA025Accident · No injuriesForeign investigationBoeing 747 · Luxembourg, LuxembourgOn January 21, 2010, a Cargolux Airlines, Boeing 747-400F, registration LX-OCV, struck the top of a maintenance van that was on the runway during CAT IIIB conditions at Luxembourg-Findel International Airport, Luxembourg. The airplane landed safely with minor…NTSB CEN10CA106Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Cherokee, IAThe pilot misjudged his altitude while on short final approach.NTSB ANC10LA013Accident · No injuriesLimited investigationFinal reportCessna 172M · Bethel, AKThe pilot's failure to maintain directional control of the airplane during takeoff.NTSB ERA10FA115Accident · 2 fatalField investigationFinal reportBeech B-60 · Madison, ALThe pilot's failure to divert to the nearest suitable airport following a total loss of power in the right engine during cruise flight. Contributing to the accident was the total loss of power in the right engine due to separation of its No. 2 cylinder as a…NTSB CEN10FA097Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B-60 · Elyria, OHThe pilot's failure to maintain adequate airspeed during the instrument approach, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA10WA116Accident · 3 fatalForeign investigationPiper PA-32-300 · Bimini, Bahamas, BahamasOn January 17, 2010, at approximately 1545 eastern standard time, a Piper PA-32-300, N4219R, crashed approximately 500 yards northwest of the Bimini Bay Resort, North Bimini, Bahamas. The flight departed Lynden Pindling International Airport, Nassau, Bahamas…NTSB CEN10LA103Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Cedar Rapids, IAThe pilot's failure to maintain aircraft control while flying an instrument approach. Contributing to the accident was the pilot's lack of experience in actual instrument conditions.NTSB CEN10LA099Accident · 2 fatalLimited investigationFinal reportBuckeye DM · Sublette, KSThe failure of both pilots to see and avoid the other aircraft, which resulted in a midair collision while maneuvering at low altitude.NTSB CEN10FA101Accident · 2 fatalField investigationFinal reportCessna 172 · Holland, MIThe pilot's decision to take off in known instrument meteorological conditions without instrument currency or recent instrument experience, which led to spatial disorientation resulting in an inadvertent spin. Contributing to the accident was the pilot's lack…NTSB CEN10CA104Accident · No injuriesData collectionFinal reportCirrus SR22 · Fredericksburg, TXThe pilot's failure to maintain directional control during landing, and his failure to properly execute a go-around.NTSB ERA10LA120Accident · 2 fatalLimited investigationFinal reportSteele Samuel D RV-4 · Picayune, MSThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin. Contributing to the accident was the overweight and aft-center-of-gravity condition of the airplane at takeoff.NTSB ERA10LA119Accident · 1 fatalLimited investigationFinal reportQuad City Challenger · Palmetto, FLThe non-certificated pilot's failure to maintain airspeed which resulted in an inadvertent stall and subsequent impact with the ground. Contributing to the accident was his impairment due to the prescription narcotic medication he was taking.NTSB ERA10CA114Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Collegedale, TNThe pilot’s failure to maintain directional control during the initial climb after takeoff in dark light conditions.NTSB ERA10LA113Accident · 1 fatalLimited investigationFinal reportFoster John Glasair III · Oxford, CTThe pilot's failure to maintain a proper approach path during visual conditions at dusk, which resulted in an in-flight collision with power lines.NTSB CEN10CA094Accident · Minor injuriesData collectionFinal reportEngineering & Research Ercoupe 415-CD · New London, WIThe pilot's decision to land with a tailwind on the snow- and ice-covered runway.NTSB WPR10LA104Accident · 2 fatalLimited investigationFinal reportAirborne Streak 2 · Lake Isabella, CAThe pilot’s performance of prohibited aerobatic flight maneuvers that exceeded the structural limits of the airplane, resulting in an in-flight breakup.NTSB WPR10LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Apple Valley, CAThe pilot's loss of directional control during the landing roll and the check airman’s delayed remedial response.NTSB ERA10CA109Accident · Serious injuriesData collectionFinal reportSchweizer 269C-1 · Grantsville, MDThe pilot's loss of aircraft control after encountering turbulence over a mountain range. Contributing to the accident was the pilot's failure to obtain an Airmet for turbulence along the route of flight prior to departure and while enroute.NTSB CEN10MA088Accident · 2 fatalMajor investigationFinal reportGates Learjet 35A · Prospect Heights, ILA loss of control for undetermined reasons.NTSB CEN10CA092Accident · Minor injuriesData collectionFinal reportCessna 150L · Brownstown, ILA total loss of engine power due to fuel exhaustion as a result of the student pilot becoming lost/disoriented in flight.NTSB CEN10CA091Accident · Minor injuriesData collectionFinal reportGrumman American AA-5B · Santa Fe, NMThe restricted elevator control movement for undetermined reasons.NTSB ERA10LA105Accident · 1 fatalLimited investigationFinal reportCessna 172S · Greenbush, METhe pilot's improper decision to attempt a transoceanic flight in turbulent, icing conditions, with an overweight airplane that was not approved for moderate turbulence and not equipped with deicing systems. Contributing to the accident was the pilot's…NTSB ERA10LA104Accident · No injuriesLimited investigationFinal reportCessna 150G · Doylestown, PAA partial loss of engine power due to carburetor icing.NTSB ANC10LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Willow, AKThe pilot’s failure to ensure that the airplane’s fuel selector valve was on before takeoff, resulting in a loss of engine power due to fuel starvation, and his subsequent decision to attempt a low altitude turn towards the departure airport, resulting in an…NTSB ERA10LA102Accident · 1 fatalLimited investigationFinal reportDavis Michael J Longez · Dexter, KYThe loss of engine power due to the chaffing and grounding of the single magneto's ignition lead.NTSB CEN10CA081Accident · Minor injuriesData collectionFinal reportCessna 182P · Bowie, TXA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to properly secure the right wing fuel cap and monitor the available fuel supply.NTSB WPR10CA089Accident · No injuriesData collectionFinal reportCessna 172M · Albion, IDThe pilot's failure to maintain clearance from mountainous terrain while maneuvering in gusting winds.NTSB ERA10LA101Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · St. Petersburg, FLA loss of engine power for undetermined reasons.NTSB WPR10LA092Accident · No injuriesLimited investigationFinal reportCessna 402C · Moab, UTThe pilot's decision to depart on a snow covered runway, which resulted in a loss of control and encounter with terrain. Contributing to the accident was the airport manager's failure to adhere to the Airport Certification Manual and close the runway due to…NTSB ERA10LA098Accident · Serious injuriesLimited investigationFinal reportCzech Aircraft Works Sportcruiser · Suffolk, VAThe pilot's inadequate recovery from a stall and inadvertent spin. Contributing to the accident was the improperly marked airspeed indicator and the airplane manufacturer's improper airspeed information. Also contributing was the instructor's inadequate…NTSB WPR10CA088Accident · No injuriesData collectionFinal reportAviat A1-A · West Jordon, UTThe pilot's failure to maintain directional control of the airplane during the landing roll in gusting wind conditions.NTSB WPR10LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Corona, CAA loss of engine power for undetermined reasons.NTSB WPR10LA083Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · San Jose, CAA total loss of engine power due to water contamination in the fuel system as a result of the pilot's inadequate preflight inspection.NTSB WPR10LA082Accident · Minor injuriesLimited investigationFinal reportEADS Socata TBM 700 · Truckee, CAThe pilot’s failure to maintain an adequate airspeed and clearance from terrain during an attempted go-around. Contributing to the accident was the pilot's decision to land on a partially obscured runway.NTSB ERA10WA312Accident · 5 fatalForeign investigationBeech 58 · Guarico, VenezuelaOn December 13, 2009, about 2040 UTC, a Beech 58, of Venezuelan registration, YV2473, registered to and operated by Aeronaves Baron, C.A., impacted terrain during takeoff from the Mata de Juajua Airport (SVCS), near Estatdo Guárico, Venezuela. Visual…NTSB CEN10WA073Accident · 1 fatalClass 5 · ForeignCirrus SR20 · Oberbarnim, GermanyOn December 10, 2009, at 1625 coordinated universal time, a Cirrus SR20, German registered D-EYAT, was destroyed when it impacted forested terrain near Oberbarnim, Germany. Instrument meteorological conditions prevailed at the time of the accident. The pilot…NTSB WPR10WA080Accident · 1 fatalForeign investigationBell 206 · Dorrigo, Australia, AustraliaOn December 9, 2009, at 1225 universal coordinated time a Bell 206 L-1, VH-MJO, operated by Commercial Helicopters Pty Ltd. collided with the terrain during takeoff near Dorrigo, Australia. The flight was for the purpose of performing an aerial survey. The…NTSB WPR10LA076Accident · Serious injuriesLimited investigationFinal reportBeech 35-33 · Lehi, UTThe loss of engine power during cruise flight for undetermined reasons.NTSB WPR10LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Fresno, CAA total loss of engine power for undetermined reasons.NTSB ERA10FA091Accident · 4 fatalField investigationFinal reportCessna 172S · Kissimmee, FLThe pilot's decision to depart under special VFR flight at night when instrument meteorological conditions prevailed at the departure airport and along the route of flight and his continued VFR flight into instrument meteorological conditions, which resulted…