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 WPR11CA396Accident · No injuriesData collectionFinal reportAviat A-1C-200 · Casper, WYThe pilot's failure to maintain directional control during landing.NTSB ERA11WA472Accident · 4 fatalForeign investigationAgusta AW139 · BrazilOn August 19, 2011, at 1948 coordinated universal time (16:48 local time), an Agusta, AW139, helicopter, Brazilian registration PT-SEK, impacted into the Atlantic Ocean, near an oil rig, identifier P-65, the helicopter sank in waters with a recorded floor…NTSB WPR11FA392Accident · 1 fatalField investigationFinal reportBriegleb BG-12B · Moore, IDThe pilot’s decision to perform a low pass over the runway in the opposite direction of his intended landing, and his subsequent failure to maintain airspeed and glider control during the reverse-course maneuver. Contributing to the accident was the effect of…NTSB WPR11FA390Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Forsyth, MTThe pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in a stall/mush, loss of control, and impact with terrain.NTSB ERA11LA501Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Monmouth, MEOperation of the airplane by a non-certificated pilot and his failure to maintain airplane control.NTSB ERA11FA462Accident · Serious injuriesField investigationFinal reportBeech B19 · Whitesburg, GAThe student pilot did not retract the wing flaps during a go-around, which decreased the airplane’s climb performance and resulted in an in-flight collision with trees.NTSB CEN11CA580Accident · No injuriesData collectionFinal reportCessna 172N · Winnsboro, LAThe pilot's failure to maintain aircraft control during takeoff with a gusting crosswind.NTSB ANC11CA082Accident · No injuriesData collectionFinal reportPiper PA-20 · Tyonek, AKThe student pilot’s decision to take off toward a hill with a gusting tailwind. Contributing was the pilot's premature rotation that prevented the airplane from climbing over the hill.NTSB WPR11LA388Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-602 · Pine Bluffs, WYThe pilot's failure to maintain clearance from power lines during an aerial application flight.NTSB WPR11CA387Accident · Serious injuriesData collectionFinal reportP&M GT450 · Teton Village, WYThe pilot's failure to maintain an adequate airspeed, which resulted in a stall mush to ground impact.NTSB ERA11LA459Accident · Serious injuriesLimited investigationFinal reportEvans Robert W SR Pegazair 100 · Maysville, NCThe student pilot's failure to maintain adequate airspeed during initial takeoff climb, which resulted in an aerodynamic stall.NTSB ERA11FA463Accident · 1 fatalField investigationFinal reportQuad City Ultralight Challenger II · Ransom Township, PAThe non-certificated pilot's failure to maintain aircraft control while maneuvering, which resulted in a collision with trees and terrain. Contributing to the accident was the pilot's lack of overall flight experience and lack of experience in the same make…NTSB ERA11FA458Accident · 1 fatalField investigationFinal reportCessna 310Q · Tupelo, MSThe pilot’s delayed reaction in performing the engine failure procedures and his failure to maintain adequate airspeed, which resulted in a loss of airplane control. Contributing to the accident was maintenance personnel’s improper torquing of the B-nut…NTSB CEN11LA596Accident · No injuriesLimited investigationFinal reportSuminski Walter M Jabiru SP · Columbia, ILSeparation of the right main wheel during landing rollout for undetermined reasons.NTSB ANC11CA081Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Valdez, AKThe pilot's failure to maintain the proper approach path, which resulted in a runway undershoot.NTSB WPR11LA386Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Hardin, MTThe loss of engine power during takeoff due to the fatigue failure of the turbine wheel blades, which resulted from inadequate maintenance and inspections.NTSB ERA11LA457Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Graham, NCThe individual's fuel mismanagement, which resulted in fuel exhaustion and a subsequent engine failure. Contributing the accident was the individual’s failure to maintain adequate airspeed following the engine failure, which resulted in an aerodynamic stall.NTSB ERA11CA460Accident · No injuriesData collectionFinal reportMooney M20R · West Chester, PAThe pilot did not maintain adequate airspeed during a go-around, which resulted in an aerodynamic stall.NTSB CEN11LA568Accident · Serious injuriesLimited investigationFinal reportQuad City Challenger · Granbury, TXThe leak in the plastic connectors in the fuel lines, which resulted in decreased engine power during the initial climb.NTSB CEN11CA631Accident · No injuriesData collectionFinal reportCessna A188 · Ord, NEThe pilot's loss of directional control during a crosswind takeoff.NTSB ANC11LA080Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Cape Yakataga, AKA collision into water during initial climb after takeoff for undetermined reasons.NTSB WPR11FA383Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Silver Bow, MTThe pilot's failure to maintain airplane control while maneuvering.NTSB ERA11LA454Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Hodgenville, KYThe pilot's inadequate takeoff performance planning, which resulted in collision with an obstacle during takeoff from a turf runway that was not long enough for the given conditions.NTSB WPR11LA380Accident · No injuriesLimited investigationFinal reportBeech B36TC · Lemoore, CAA loss of engine power during cruise flight due to maintenance personnel's failure to adequately torque the number 4 cylinder retaining nuts, which resulted in the in-flight separation of the cylinder.NTSB WPR11FA382Accident · 4 fatalField investigationFinal reportCessna P210N · Burley, IDThe pilot's failure to attain sufficient altitude and maintain aircraft control during a turn shortly after liftoff while operating at maximum gross weight, with a tailwind, and in high density altitude conditions.NTSB WPR11CA376Accident · No injuriesData collectionFinal reportCessna 172P · San Diego, CAThe student pilot's failure to maintain clearance from obstacles while taxiing.NTSB CEN11LA578Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1(PT17) · Fabens, TXThe pilot’s decision to continue the high density altitude takeoff with reduced engine power and his decision to initiate a turn back to the runway with insufficient airspeed, which resulted in an aerodynamic stall.NTSB CEN11LA575Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Sabetha, KSThe pilot's failure to maintain adequate airspeed, which resulted in a stall. Contributing to the accident was the pilot's lack of certification to act as a pilot and his lack of recent experience.NTSB CEN11CA576Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Stanberry, MOThe pilot’s failure to maintain directional control during takeoff.NTSB ERA11CA453Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · West Liberty, KYThe pilot's failure to obtain the proper touchdown point during landing, which resulted in a runway excursion.NTSB CEN11LA671Accident · Serious injuriesLimited investigationFinal reportFisher Michael E Hyster · Lake Jackson, TXThe improper maintenance of the throttle control cable, which resulted in the engine going to idle power after takeoff.NTSB CEN11LA598Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Edgeley, NDThe loss of engine power for reasons that could not be determined because postaccident examination of the airplane and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN11LA573Accident · 1 fatalLimited investigationFinal reportStevens R P/Mccright D W Vans RV-6 · Conroe, TXThe failure of the pilot of the RV-6 airplane to maintain clearance from the RV-8 airplane while practicing formation flight.NTSB CEN11LA571Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Uvalde, TXThe pilot’s failure to maintain airspeed while maneuvering to avoid power lines during a precautionary landing, which resulted an aerodynamic stall. Contributing to the accident was the fluctuating engine power for undetermined reasons and the pilot's…NTSB CEN11LA569Accident · 2 fatalLimited investigationFinal reportFairchild M-62 · Madrid, IAThe pilot's improper decision to conduct low-level flight along a river, which resulted in a collision with power lines.NTSB WPR11CA399Accident · No injuriesData collectionFinal reportRichmond Jim R CCK-1865 · Dubois, WYThe pilot's failure to maintain clearance from a wire during cruise flight.NTSB ERA11CA448Accident · No injuriesData collectionFinal reportRobinson R22 · Titusville, FLThe private pilot's incorrect manipulation of the engine mixture control which resulted in an inadvertent engine shutdown.NTSB ANC11CA078Accident · No injuriesData collectionFinal reportPiper PA-11 · Chenga Bay, AKThe pilot's improper decision to land on an unsuitable landing surface which resulted in a nose over.NTSB WPR11CA360Accident · No injuriesData collectionFinal reportAircraft Mfg & Design CH750 Stol · New Washoe City, NVThe pilot under instruction's control interference and the CFI's inadequate supervision of the flight.NTSB CEN11LA563Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Mansfield, SDThe loss of engine power due to debris in the engine air intake system.NTSB CEN11CA565Accident · No injuriesData collectionFinal reportWeatherly 201C · Bronson, IAThe pilot's failure to maintain clearance from terrain while maneuvering during an aerial application flight.NTSB ERA11CA445Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Charleston, SCThe pilot's decision to continue the approach and landing at a high airspeed, which resulted in an improper touchdown point and subsequent runway excursion.NTSB CEN11FA557Accident · 3 fatalField investigationFinal reportPiper PA-23 · Millersburg, OHThe pilot’s failure to maintain clearance with terrain during the landing approach in night conditions and fog. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB ERA11LA444Accident · Minor injuriesLimited investigationFinal reportHodges Samuel J RV-7A · Paducah, KYA partial loss of engine power during the initial climb for undetermined reasons.NTSB ERA11FA443Accident · 2 fatalField investigationFinal reportMaule M-7-235 · Warrenton, VAThe pilot's inadequate airspeed and excessive bank angle while maneuvering for landing, which resulted in an aerodynamic stall.NTSB ANC11CA074Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Coldfoot, AKThe pilot's inadequate directional control of the airplane during takeoff. Contributing to the accident was the pilot’s fatigue.NTSB CEN11FA572Accident · Serious injuriesField investigationFinal reportFerguson Fergy 1 · Falcon, COA loss of control for undetermined reasons.NTSB CEN11CA551Accident · Serious injuriesData collectionFinal reportQuicksilver Sprint II · Douglas, KSThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA11CA441Accident · No injuriesData collectionFinal reportCessna 172K · Sylacauga, ALA stuck exhaust-valve on the number one cylinder which resulted in a loss of engine power.NTSB CEN11LA552Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Amarillo, TXA loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.