NTSB investigations
1,311 cases where NTSB found Altitude.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062012')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01062012')) 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 ANC14FA062Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Big Lake, AKThe pilot's impairment due to alcohol consumption, which resulted in his failure to maintain clearance from trees.NTSB CEN14FA414Accident · 2 fatalField investigationFinal reportPiper PA 28R-201 · Steamboat Springs, COThe pilot’s inability to maintain a climb while attempting to cross over a mountain pass in high-density altitude conditions that degraded the airplane’s climb performance. Contributing to the accident was the pilot’s decision to attempt the flight in…NTSB CEN14CA409Accident · Minor injuriesData collectionFinal reportGlasflugel H 301 B Libelle · Brenham, TXThe pilot's attempt to maneuver away from power lines during a forced landing, which resulted in a collision with a tree and a fence.NTSB WPR14LA322Accident · 1 fatalLimited investigationFinal reportSchweizer G 164B · Tulelake, CAThe pilot's failure to maintain clearance from power lines while maneuvering during low-altitude operations.NTSB CEN14CA403Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Allen, NEThe pilot did not ensure sufficient obstacle clearance for potential wind conditions, which resulted in his loss of control of the helicopter.NTSB ERA14CA366Accident · Minor injuriesData collectionFinal reportCessna 150M · Waterloo, NYThe pilot's failure to maintain adequate clearance from obstructions while on approach to the runway.NTSB ERA14FA359Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Clayton, GAThe pilot’s decision to begin a flight with fog and low clouds present at the airport, which resulted in an encounter with instrument meteorological conditions immediately after takeoff and a controlled flight into terrain.NTSB WPR14FA302Accident · 2 fatalField investigationFinal reportCessna 172K · Littlefield, AZThe pilot's failure to maintain airplane control when the airplane encountered high gusting wind while conducting low altitude flight in a narrow canyon, which resulted in an inflight collision with terrain.NTSB WPR14FA303Accident · 4 fatalField investigationFinal reportCessna 182L · Sedona, AZThe pilot’s failure to maintain adequate airspeed and his exceedance the airplane’s critical angle-of attack while maneuvering through a canyon in high-density altitude conditions at low altitude, which resulted in an aerodynamic stall.NTSB ERA14LA347Accident · Serious injuriesLimited investigationFinal reportColt Balloons 160A · Clinton, MAThe pilot's inadequate preflight and inflight planning and improper landing site selection and approach path, which resulted in the balloon contacting powerlines during landing. Contributing to the accident was the Federal Aviation Administration's inadequate…NTSB WPR14CA296Accident · Serious injuriesData collectionFinal reportBell 47G 2A · Merced, CAThe pilot's failure to adequately monitor the environment to maintain clearance from the power pole guide wire during low level maneuvering.NTSB CEN14CA382Accident · Serious injuriesData collectionFinal reportGremminger Greg Magni M 16 · Cape Girardeau, MOThe pilot's failure to maintain sufficient altitude while maneuvering which led to a collision with power lines.NTSB WPR14CA292Accident · Serious injuriesData collectionFinal reportJonker Sailplanes JS1-C · Truckee, CAThe pilot's failure to maintain aircraft control in gusting wind conditions while on final approach to the runway.NTSB WPR14FA282Accident · 3 fatalField investigationFinal reportPiper PA 28R-180 · Lake Elsinore, CAThe pilot's failure to maintain airplane control when the landing gear unintentionally extended while maneuvering at low altitude and airspeed, which increased the airplane’s drag and decreased its ability to climb over the rising terrain.NTSB CEN14FA339Accident · 2 fatalField investigationFinal reportNorth American/Aero Classics P 51D · Durango, COThe pilot's failure to compensate for the high-performance airplane's tendency to enter a torque roll during the initial climb, which resulted in the airplane entering a torque roll and the subsequent loss of control at too low of an altitude to recover.…NTSB WPR14CA279Accident · Serious injuriesData collectionFinal reportWiley Kitfox IV · Sprague, WAThe pilot's failure to maintain adequate clearance from powerlines during the landing approach resulting in a collision.NTSB CEN14LA379Accident · 1 fatalLimited investigationFinal reportKolb Mark III · Jonesville, LAThe noncertificated pilot's failure to maintain clearance from trees.NTSB WPR14LA271Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Big Creek, IDThe pilot’s execution of a traffic pattern that did not put the airplane in position for a normal final approach and the pilot’s decision to continue the landing attempt instead of initiating a go-around, which resulted in the airplane exceeding its critical…NTSB CEN14LA326Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS350B · Mayhill, NMThe pilot's failure to maintain helicopter control while performing a go-around in strong, gusting wind conditions. Contributing to the accident was the pilot's decision to initiate the flight in strong, gusting wind conditions.NTSB CEN14LA309Accident · No injuriesLimited investigationFinal reportSchumacher Challenger II · St. Joesph, ILThe total loss of engine power due to a lack of lubrication following the in-flight failure of the mechanical oil injection pump. Contributing to the accident was the temporary obscuration of the pilot's forward visibility due to sun glare during the forced…NTSB CEN14CA314Accident · Minor injuriesData collectionFinal reportAir Tractor AT 402B · Newport, ARThe pilot misjudged his altitude which resulted in the airplane contacting a wire during the low altitude aerial application maneuver.NTSB WPR14FA262Accident · 2 fatalField investigationFinal reportMooney M20B · Page, AZThe pilot’s failure to maintain adequate clearance from terrain while maneuvering in a canyon in high-density altitude conditions.NTSB WPR14CA255Accident · No injuriesData collectionFinal reportCosmos Phase II Phase II 582 · Caldwell, IDThe pilot's failure to monitor the environment and to maintain sufficient altitude to clear power lines during low altitude flight.NTSB WPR14FA252Accident · 1 fatalField investigationFinal reportCessna 175 · Moab, UTThe pilot’s decision to approach rising mountainous terrain at too low an altitude to clear it and his subsequent attempt to climb, which exceeded the airplane’s critical angle-of-attack and resulted in a stall/spin.NTSB ERA14FA288Accident · 1 fatalField investigationFinal reportPiper PA-46-500TP · White Plains, NYThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation (somatogravic illusion). Contributing to the accident was the pilot's self-induced pressure to depart and his decision to depart in low-ceiling and…NTSB CEN14LA298Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Oneida, ARThe pilot’s inadequate fuel management, which resulted in a total loss of engine power at low altitude due to fuel exhaustion and a forced landing in a muddy field and subsequent nose-over.NTSB CEN14CA283Accident · No injuriesData collectionFinal reportAyres S2R T34 · Wilmont, ARPilot's failure to verify the amount of chemical load on the airplane prior to takeoff which resulted in the airplane being heavier than expected. Contributing to the accident was loading crew not following the pilot's instructions.NTSB WPR14LA230Accident · 1 fatalLimited investigationFinal reportCessna 172M · Laytonville, CAThe pilot’s impairment due to alcohol ingestion, which resulted in his failure to maintain clearance from trees during a low-altitude flyby.NTSB WPR14CA216Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · San Manuel, AZThe pilot's failure to maintain an adequate obstacle clearance altitude from phone wires while performing low-level operations.NTSB CEN14LA418Accident · 1 fatalLimited investigationFinal reportTexas Helicopter OH 13H/M74A · Little Falls, MNThe pilot's failure to maintain clearance from a tree at the edge of a field that he was spraying.NTSB WPR14FA203Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Santa Paula, CAThe pilot's failure to maintain clearance from power lines while flying at a low altitude.NTSB WPR14CA204Accident · No injuriesData collectionFinal reportCessna 150C · Wellington, NVThe pilot's failure to maintain aircraft control while departing from a wet runway.NTSB WPR14LA198Accident · No injuriesLimited investigationFinal reportRockwell International S 2R · Medicine Lake, MTThe pilot’s failure to maintain airplane control and sufficient altitude to clear terrain during a low-altitude maneuver.NTSB ERA14CA239Accident · Serious injuriesData collectionFinal reportTaylorcraft BC 65 · Summerville, GAThe pilot's selection of an inadequate altitude during low level maneuvering, which resulted in an in-flight collision with trees.NTSB ERA14FA231Accident · 3 fatalField investigationFinal reportEagle C-7 · Ruther Glen, VAThe pilot’s inadequate approach and his failure to maintain clearance from power lines, which resulted in a subsequent fire.NTSB ERA14CA238Accident · Serious injuriesData collectionFinal reportNorth American AT6 - C · Roxbury, NYThe pilot's failure to maintain adequate obstacle clearance, which resulted in the inflight collision with a power line.NTSB WPR14FA183Accident · 2 fatalField investigationFinal reportCessna 150 - F · Santa Clara, UTThe flight instructor’s failure to arrest the airplane’s descent and maintain clearance from mountainous terrain while maneuvering at a low altitude.NTSB CEN14FA230Accident · No injuriesField investigationFinal reportPiper PA 25-235 · Northglenn, COThe pilot's decision to operate the banner-tow flight below the minimum safe altitude specified by federal regulation, which likely limited his ability to recover from a potential loss of airspeed due to a gusting wind condition. Also causal was the pilot’s…NTSB WPR14FA182Accident · 1 fatalField investigationFinal reportBoeing E75 · Fairfield, CAThe pilot's failure to maintain clearance from the runway during a low-level aerobatic maneuver due to his impairment by an over-the-counter antihistamine. Contributing to the severity of the pilot's injuries were the pilot's lack of fire protective clothing,…NTSB ERA14CA220Accident · Serious injuriesData collectionFinal reportSchleicher ASW 20 · Monroe, GAThe pilot's improper selection of an off-airport landing site and his subsequent failure to maintain clearance from trees during an off airport landing.NTSB WPR14LA177Accident · Serious injuriesLimited investigationFinal reportAirplane Factory Ltd The Sling · Daggett, CAThe pilots’ failure to maintain clearance from terrain while operating in dark night, visual meteorological conditions. Contributing to the accident was the pilots’ failure to enable the aural terrain warning system.NTSB CEN14FA224Accident · 4 fatalField investigationFinal reportPiper PA 32R-300 · Highmore, SDThe pilot's decision to continue the flight into known deteriorating weather conditions at a low altitude and his subsequent failure to remain clear of an unlit wind turbine. Contributing to the accident was the inoperative obstruction light on the wind…NTSB ERA14CA229Accident · No injuriesData collectionFinal reportGingras Michel Aventura II · Punta Gorda, FLThe pilot's failure to maintain clearance from the water while operating at a low altitude.NTSB CEN14LA222Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Cleburne, TXThe student pilot's failure to maintain tail rotor clearance from terrain while transitioning to a hover taxi and the instructor pilot's inadequate remedial action to prevent the impending tail rotor contact.NTSB ERA14CA209Accident · No injuriesData collectionFinal reportCessna T206H · Gilford, NHThe pilot misjudged the float equipped airplane's altitude while maneuvering above the surface of a lake, which resulted in a float inadvertently contacting the water. Contributing to the accident were the glassy water conditions and pilot's lack of recent…NTSB WPR14FA158Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Green River, UTA loss of engine power due to fuel contamination while maneuvering at a low altitude and the pilot's inadequate preflight inspection, which failed to detect the contamination.NTSB ERA14CA175Accident · Minor injuriesData collectionFinal reportBeech S35 · Marathon, FLThe pilot's distraction in the cockpit while on a visual approach over water during a dark night resulting in the airplane descending until impact with the water.NTSB CEN14CA170Accident · No injuriesData collectionFinal reportDonald G Stokes Challenger II · Crockett, TXThe pilot's failure to maintain control of the airplane, resulting in a hard landing.NTSB ERA14LA158Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Elizabethton, TNThe pilot’s delayed decision to maneuver around rising terrain, which resulted in a collision with trees and terrain. Contributing to the accident was the pilot’s failure to calculate the performance requirements needed to climb over mountainous terrain…NTSB WPR14CA138Accident · Minor injuriesData collectionFinal reportDG Flugzeugbau DG 1000S · Wrightwood, CAThe pilot's inadequate in-flight planning/decision to maneuver the glider where the lift was not sufficient to maintain flight, resulting in an off airport landing.