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 WPR11LA369Accident · No injuriesLimited investigationFinal reportCessna 140 · Wilkeson, WAA partial loss of engine power during takeoff due to water contamination in the fuel system.NTSB CEN11LA549Accident · No injuriesLimited investigationFinal reportAerosport Ikarus C42E · East Troy, WIThe flight instrctor's delayed remedial action during landing. Contributing to the accident was the student pilot’s loss of directional control when he became distracted with the open door.NTSB CEN11LA546Accident · 2 fatalLimited investigationFinal reportReinboldt Richard A Challenger II · Reedsburg, WIThe pilot did not maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB WPR11LA366Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Hazelton, IDPartial loss of engine power for undetermined reasons.NTSB WPR11FA367Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Camas, WAThe pilot's failure to maintain control of the airplane while maneuvering in the traffic pattern.NTSB ERA11LA438Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · St. Petersburg, FLThe pilot's improper rotation during takeoff, resulting in a stall and subsequent collision with the ground.NTSB WPR11LA371Accident · No injuriesLimited investigationFinal reportCarpenter Kolb Twinstar III · Republic, WAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR11LA359Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Emmett, IDA total loss of engine power due to carburetor icing because the pilot did not use carburetor heat.NTSB ERA11LA437Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Egg Harbor Township, NJThe pilot’s failure to maintain adequate airspeed while maneuvering near the ground, which resulted in an aerodynamic stall.NTSB ERA11FA435Accident · 1 fatalField investigationFinal reportRans S18 · Fayetteville, TNThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin. Contributing to the accident was the pilot's lack of recent flight experience.NTSB CEN11CA540Accident · Serious injuriesData collectionFinal reportBell 47G-2 · Charles City, IAThe pilot's failure to refuel the helicopter which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR11CA365Accident · No injuriesData collectionFinal reportCessna 162 · Rawlings, WYThe pilot's decision to attempt a takeoff at a density altitude that was outside the performance envelope of the airplane. Also causal was the flight's likely encounter with a sudden tailwind gust.NTSB ERA11FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-28-140The non-instrumented rated pilot’s flight into instrument meteorological conditions for undetermined reasons, resulting in an in-flight loss of control, uncontrolled descent, and collision with the water.NTSB CEN11LA542Accident · No injuriesLimited investigationFinal reportT&T Falcon LS · Lee's Summit, MOA binding condition in the left rudder cable which resulted in a loss of directional control during landing.NTSB CEN11LA536Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13 · Stoughton, WIThe pilot’s improper preflight planning and his failure to gain proper airspeed during takeoff from a grass airstrip resulting in a stall, the loss of control, and subsequent impact with the trees. Contributing to the accident was the pilot operating the…NTSB CEN11CA535Accident · No injuriesData collectionFinal reportTexas Helicopter OH-13H/M74A · Joice, IAThe pilot's failure to maintain clearance from the wire.NTSB WPR11CA358Accident · No injuriesData collectionFinal reportMcdonald Lynn B Avid Flyer Mark IV · Yamhill, ORThe pilot’s loss of directional control during landing rollout due to an unlocked tail wheel that was caused by a degradation of the tailwheel assembly mounting angle.NTSB ERA11LA434Accident · Minor injuriesLimited investigationFinal reportNord Stampe SV4C · Rhinebeck, NYA total loss of engine power for undetermined reasons.NTSB ERA11FA431Accident · 1 fatalField investigationFinal reportBeech G35 · Byron, GAThe pilot’s sustained flight at airspeeds in excess of the airplane's never exceed speed during a steep descent, which resulted in a subsequent in-flight structural failure due to overstress.NTSB CEN11CA533Accident · No injuriesData collectionFinal reportGarlick Helicopters OH-58C · Rushford, MNThe pilot's diverted attention, which resulted in the failure to maintain clearance from the power line.NTSB CEN11CA532Accident · No injuriesData collectionFinal reportAlon A-2A · Rolfe, IAThe pilot's decision to execute a precautionary landing to unsuitable terrain.NTSB WPR11LA361Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Perris, CAThe pilot’s failure to maintain airplane control and the resulting encounter with an aerodynamic stall. Also causal were the pilot’s inadequate preflight planning and preflight inspection, his failure to ensure the pitch trim was positioned correctly for…NTSB WPR11CA355Accident · No injuriesData collectionFinal reportCessna 170A · Mulino, ORThe certified flight instructor's inadequate oversight of his student, and delayed recovery efforts following the student's loss of directional control during landing rollout.NTSB ERA11CA430Accident · No injuriesData collectionFinal reportCessna 182 · Dandrige, TNThe loss of engine power due to fuel exhaustion as a result of poor planning.NTSB CEN11LA541Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Hettinger, NDInternal failure of the engine for undetermined reasons.NTSB CEN11LA529Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Opelousas, LAThe loss of engine power due to fuel contamination.NTSB CEN11FA528Accident · 2 fatalField investigationFinal reportWright B Flyer Wright B Flyer · Springfield, OHThe flight crew’s failure to maintain airplane control following a partial loss of engine thrust during cruise flight. Contributing to the accident was the failed weld as a result of incomplete welding on the left propeller shaft, which led to the partial…NTSB ANC11FA071Accident · 4 fatalField investigationFinal reportCessna U206G · Talkeetna, AKThe inadequate visual lookout and failure to see and avoid by the pilots of both airplanes while maneuvering to land, which resulted in a midair collision. Contributing to the accident was the lack of standardized, unequivocal procedures concerning common…NTSB WPR11CA353Accident · No injuriesData collectionFinal reportSloan Roger D Vans RV7A · Sheridan, WYThe pilot's failure to maintain aircraft control during takeoff due to cockpit distractions.NTSB ERA11LA427Accident · 1 fatalLimited investigationFinal reportTL Ultralight Sro Sting S3 · Sarasota, FLThe inability of the pilot-in-command (PIC) to recover from an inadvertent spin following a stall demonstration for reasons that could not be determined because aircraft and engine examinations did not reveal any anomalies that would have precluded recovery…NTSB CEN11LA539Accident · Serious injuriesLimited investigationFinal reportHurley Richard A Cavalier SA102.5 · Salem, IAThe partial loss of engine power due to the formation of carburetor ice.NTSB ERA11FA426Accident · 1 fatalField investigationFinal reportTaylorcraft BL-65 · Winterville, NCA loss of airplane control for undetermined reasons as the autopsy was unable to reveal any definitive conditions that would have led to the loss of control.NTSB CEN11CA545Accident · No injuriesData collectionFinal reportAyres S2R-G6 · Forest City, IAThe pilot's inadequate visual lookout during an aerial application run, which resulted in an in-flight collision with a windmill.NTSB CEN11CA524Accident · Minor injuriesData collectionFinal reportTexas Helicopter OH-13H/M74A · Creston, ILThe pilot's failure to maintain adequate skid clearance from the helicopter cart during landing, resulting in a dynamic rollover.NTSB WPR11LA364Accident · No injuriesLimited investigationFinal reportNicholson 2000 · Sedona, AZThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA11CA425Accident · Serious injuriesData collectionFinal reportPiper PA-24-250 · Sidney, NYThe pilot's inadequate fuel planning and management, which resulted in fuel starvation and a total loss of engine power during final approach.NTSB CEN11CA525Accident · No injuriesData collectionFinal reportBell 47G-2A · Nicolett, MNThe pilot's failure to maintain control of the helicopter while maneuvering during an aerial application flight.NTSB ERA11CA423Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Quinton, VAThe pilot's inadequate preflight planning and fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN11FA508Accident · 1 fatalField investigationFinal reportBeech A36 · Williston, NDThe pilot's improper fuel management, which resulted in fuel starvation and a partial loss of engine power while maneuvering at a low altitude.NTSB WPR11LA356Accident · No injuriesLimited investigationFinal reportSikorsky S-55B · Brewster, WAThe pilot did not maintain main rotor rpm while hovering in gusting wind conditions.NTSB WPR11FA350Accident · 1 fatalField investigationFinal reportSikorsky S-55B · Chelan, WAThe pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude.NTSB CEN11LA514Accident · No injuriesLimited investigationFinal reportEvens RV4 · Monroe City, MOA total loss of engine power for undetermined reasons.NTSB CEN11LA512Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Anderson, INThe fatigue failure of the propeller governor speeder spring, which resulted in the pilot’s inability to control engine output power.NTSB CEN11FA507Accident · 1 fatalField investigationFinal reportSikorsky UH-34D · Wilton, IAThe inadequate performance planning by the pilot that resulted in reduced climb capability while transitioning to an out-of-ground effect hover with a left pedal turn.NTSB CEN11FA505Accident · 2 fatalField investigationFinal reportPiper J3L-65 · Van Dyne, WIThe pilot’s inability to maintain airplane control while maneuvering for reasons that could not be determined from the available evidence.NTSB ANC11LA068Accident · No injuriesLimited investigationFinal reportCessna 185 · Kenai, AKThe loss of engine power for an undetermined reason, resulting in the ditching and sinking of the airplane in ocean waters.NTSB WPR11LA370Accident · No injuriesLimited investigationFinal reportPiper J5A · Biddle, MTFailure of the left main landing gear strut during the landing roll due to a preexisting crack.NTSB WPR11CA347Accident · No injuriesData collectionFinal reportCessna 182B · Sandy, ORThe pilot's failure to maintain adequate clearance between the airplane and ground obstacles.NTSB ERA11LA418Accident · No injuriesLimited investigationFinal reportFloyd Joseph B RV6 · Hartford, KYA loss of engine power due to fuel contamination as a result of the pilot/owner's inadequate maintenance of the airplane's fuel system, which resulted in blockage of the fuel lines and filters.NTSB ERA11CA419Accident · No injuriesData collectionFinal reportCessna 177 · Americus, GAThe CFI and pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.