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 ERA13FA372Accident · 2 fatalField investigationFinal reportAeronca 7AC · Taunton, MAThe pilot/owner’s inadequate preflight inspection and inadequate pretakeoff check of the flight controls, which resulted in a takeoff with the rudder gust lock installed. Contributing to the accident was the pilot-rated passenger’s failure to detect that the…NTSB ERA13CA378Accident · Minor injuriesData collectionFinal reportCessna 172R · Shelter Island, NYThe pilot did not attain the proper touchdown point on the runway, which resulted in a runway excursion.NTSB ERA13CA375Accident · Minor injuriesData collectionFinal reportMark C Pauls RV-7A · Cortland, NYA partial loss of engine power during go-around due to incorrect maintenance of the fuel system by the pilot/builder.NTSB CEN13CA515Accident · Minor injuriesData collectionFinal reportGrumman American Avn. AA-1B · Valparaiso, INThe pilot's improper recovery from a bounced landing.NTSB CEN13CA508Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Faribault, MNThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB WPR13LA385Accident · Minor injuriesLimited investigationFinal reportRobert Golding Tbirdii · Bakersfield, CAThe failure of the two pilots to adequately planflight, particularly regarding their roles and responsibilities, which resulted in their failure to maintain sufficient altitude to clear power lines during a low pass.NTSB WPR13FA386Accident · Serious injuriesField investigationFinal reportPiper PA 28 · Tehachapi, CAThe pilot's failure to conduct predeparture airplane performance planning for a departure from a high density altitude location, which resulted in his selection of a flightpath toward rising terrain that the airplane was not capable of outclimbing.NTSB CEN13LA503Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Concord, WIThe pilot's failure to properly plan for a maximum performance takeoff by not fully addressing the elevated density altitude or the nonstandard runway surface conditions and his failure to properly configure the airplane's flap setting for the accident…NTSB CEN13LA502Accident · Minor injuriesLimited investigationFinal reportAnderas Tiger Moth R80 · New Franken, WIThe loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ANC13LA085Accident · No injuriesLimited investigationFinal reportCessna U206F · Tokotna, AKA total loss of engine power due to the failure of the crankshaft, which resulted from a mechanic’s application of insufficient torque on the cylinder through bolts.NTSB ANC13FA084Accident · 2 fatalField investigationFinal reportCessna 150L · Anchorage, AKA loss of engine power due to fuel starvation as a result of a low fuel state and a nose-high attitude during a go-around, which unported the fuel tank feed line, and the pilot's decision to make a low-altitude turn back to the airport, which resulted in an…NTSB ANC13CA083Accident · Minor injuriesData collectionFinal reportPiper PA-18A · Talkeetna, AKThe pilot's failure to maintain directional control during takeoff.NTSB CEN13LA504Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Walnut Ridge, ARThe pilot's failure to properly set the engine power for takeoff, which resulted in the airplane subsequently settling into terrain.NTSB CEN13CA501Accident · No injuriesData collectionFinal reportMcdonnell Douglas Heli 369FF · Reese, MIThe failure of the temporary hoist holding the powerline wire which resulted in a brief loss of control and main rotor blade impacts with the tower.NTSB ANC13LA081Accident · Minor injuriesLimited investigationFinal reportCessna 180J · Palmer, AKThe pilot’s failure to maintain adequate airspeed during initial climb after takeoff, which resulted in a subsequent aerodynamic stall. Contributing to the accident was the pilot’s decision to take off with a slight tailwind.NTSB ERA13LA370Accident · No injuriesLimited investigationFinal reportBeech C23 · Bingham, METhe pilot's inadequate preflight planning, which resulted in his attempt to take off from a short, turf runway in high-density altitude conditions under which the airplane was unable to attain a positive climb rate to clear trees.NTSB CEN13LA497Accident · No injuriesLimited investigationFinal reportPerth Amboy Bird BK · Zanesville, OHThe pilot’s loss of directional control during landing.NTSB WPR13FA380Accident · 1 fatalField investigationFinal reportNelson KR-2 · Cataldo, IDThe pilot’s decision to intentionally enter a spin in the airplane, which had unknown spin characteristics due to the engine modification, from which he was unable to recover.NTSB CEN13FA496Accident · 2 fatalField investigationFinal reportMooney M20J · Kansas City, MOThe pilot's improper decision to attempt continued flight after a momentary loss of engine power with usable runway remaining. Contributing to the accident were the pilot's premature retraction of the landing gear, the loss of engine power due to fuel system…NTSB ERA13LA366Accident · No injuriesLimited investigationFinal reportInterstate S-1B1 · Lititz, PAThe pilot’s failure to control the airplane’s pitch attitude, which resulted in an aerodynamic stall during the initial takeoff climb. Contributing to the accident was the pilot’s failure to set the trim in accordance with the pretakeoff checklist and the…NTSB WPR13FA376Accident · 2 fatalField investigationFinal reportUrban Air Sro Samba XXL · Carson City, NVThe pilot's failure to maintain adequate airspeed while maneuvering, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin. Contributing to the accident was the improper location of the parachute…NTSB ERA13LA364Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Indian Trail, NCThe pilot's improper preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR13CA373Accident · Minor injuriesData collectionFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Las Vegas, NVThe pilot's failure to maintain aircraft control during the initial climb following an aborted landing. Contributing to the accident was the pilot's inaccurate fuel planning which resulted in a low fuel state and subsequent precautionary off airport landing.NTSB ANC13CA080Accident · Minor injuriesData collectionFinal reportCessna U206 · Sleetmute, AKThe total loss of engine power due to fuel starvation and the pilot's inadequate preflight inspection.NTSB WPR13FA370Accident · 2 fatalField investigationFinal reportChampion 7GCAA · Paradise, CAThe pilot's failure to maintain airplane control during low-altitude maneuvering after encountering an updraft.NTSB CEN13CA489Accident · No injuriesData collectionFinal reportBeech 58P · Peoria, ILThe pilot did not attain the proper touchdown point during landing, which resulted in a runway excursion and impact with a perimeter fence.NTSB ANC13LA079Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Paxson, AKThe partial loss of engine power due to a loose throttle cable clamp.NTSB WPR13FA368Accident · 1 fatalField investigationFinal reportBeech E35 · West Yellowstone, MTThe pilot's failure to maintain airplane control while aligning the airplane with the runway for landing, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's…NTSB ERA13CA362Accident · No injuriesData collectionFinal reportPiper PA-28R-180 · Fredericksburg, VAThe pilot’s inadequate pre-flight and in-flight planning and his failure to obtain a weather briefing at his intermediate stops, resulting in a missed approach at his destination and subsequent fuel exhaustion. The pilot’s fatigue due to lack of sleep may…NTSB CEN13LA484Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Larchwood, IAA complete loss of engine power during an agricultural application flight for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation.NTSB ANC13CA078Accident · No injuriesData collectionFinal reportPiper PA-18-150 · McCarthy, AKThe pilot's loss of directional control during takeoff.NTSB ERA13LA361Accident · No injuriesLimited investigationFinal reportBryant Frederick M Rans S-12 · Vienna, MDThe student pilot’s inadequate control of the airplane, which resulted in an aerodynamic stall and subsequent impact with water.NTSB ERA13LA360Accident · Minor injuriesLimited investigationFinal reportQuest Kodiak 100 · Westport, MAA failure to achieve a positive climb rate after takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.NTSB ERA13CA369Accident · No injuriesData collectionFinal reportMaule M-5-210C · Verona, NYThe pilot’s delay in applying power after a bounced landing, resulting in collision with terrain during a go-around.NTSB CEN13FA476Accident · 2 fatalField investigationFinal reportBeechcraft F33A · Ennis, TXThe loss of engine power for reasons that could not be determined during postaccident examinations due to postcrash fire damage.NTSB WPR13LA366Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Overgaard, AZThe partial loss of engine power during takeoff due to the separation of the exhaust baffling, which resulted in a partial blockage of airflow. Contributing to the accident was inadequate maintenance of the exhaust system.NTSB CEN13CA510Accident · No injuriesData collectionFinal reportErcoupe 415-C · Mackinac Island, MIThe pilot's failure to maintain aircraft control while on final approach.NTSB CEN13CA475Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Poteau, OKThe pilot’s application of excessive left rudder during the takeoff roll, resulting in a loss of directional control, his failure to correct the excursion with opposite rudder, and his failure to abort the takeoff in a timely manner.NTSB ERA13FA358Accident · 4 fatalField investigationFinal reportRockwell International 690B · East Haven, CTThe pilot's failure to maintain airspeed while banking aggressively in and out of clouds for landing in gusty tailwind conditions, which resulted in an aerodynamic stall and uncontrolled descent.NTSB CEN13LA486Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Dumas, ARThe pilot's failure to maintain directional control of the airplane during landing.NTSB ANC13TA076Accident · No injuriesFinal reportBell UH-1B · Tok, AKThe failure of the tail rotor crosshead bearing, which resulted in a loss of tail rotor control.NTSB ANC13CA075Accident · No injuriesData collectionFinal reportCessna 185D · North Pole, AKThe malfunction of the right main wheel brake during taxi due to a faulty O-ring in the right brake pedal master cylinder.NTSB CEN13CA474Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Clare, MIThe flight instructor's failure to adequately monitor the landing approach, his delayed corrective action and his failure to maintain directional control that resulted in the airplane's collision with a ditch adjacent to the runway. The student pilot's…NTSB ERA13CA354Accident · No injuriesData collectionFinal reportStetson Norman B Challenger II · Orange, MAThe pilot’s failure to maintain airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of total flight experience in the accident airplane make and model.NTSB CEN13LA463Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Vinton, IAThe pilot's operation of the helicopter at high gross weight and high density altitude while still in ground effect, which reduced the efficiency of the rotor system and the amount of lift produced, which resulted in a collision with terrain. Contributing to…NTSB ANC13LA074Accident · No injuriesClass 3 · LimitedFinal reportHughes 500D · Delta Junction, AKA total loss of engine power for undetermined reasons, which necessitated an emergency hovering autorotation, during which the helicopter impacted trees and terrain.NTSB WPR13LA360Accident · No injuriesLimited investigationFinal reportVersteeg Helicycle · Richland, WAThe pilot’s failure to maintain helicycle control during hover due to an inadvertent control input.NTSB CEN13LA462Accident · No injuriesLimited investigationFinal reportEmbraer S A EMB-505 · Eden Prairie, MNThe flight crew's failure to execute a go-around during a non-stabilized approach, which resulted in a runway overrun.NTSB CEN13FA465Accident · 1 fatalField investigationFinal reportAir Tractor AT-400 · Balko, OKThe pilot's failure maintain clearance from a meteorological tower while en route at a low altitude. Contributing to the accident was the sun's glare.NTSB CEN13CA469Accident · No injuriesData collectionFinal reportCessna 182T · Mackinac Island, MIThe pilot's delayed response to abort the takeoff, which resulted in an excursion and collision with a fence. Contributing to the accident was the pilot's failure to check the pitot tube for debris during preflight.