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 ERA12FA565Accident · 2 fatalField investigationFinal reportYakovlev YAK 52 · Brownsboro, ALThe pilot's loss of control while performing a low-level aerobatic maneuver, which resulted in collision with terrain.NTSB WPR12FA420Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Strawberry, AZThe flight instructor's and the evaluator's failure to divert at an appropriate time during cruise flight, which resulted in the airplane's inability to maintain a sufficient altitude to clear rising terrain. Contributing to the accident was the flight…NTSB CEN12FA639Accident · 2 fatalField investigationFinal reportMooney M20J · Teddys Peak, COThe pilot's decision to continue flight into deteriorating weather conditions, including fog and mountain obscuration, and his failure to maintain clearance with known rising terrain along the route of flight, which resulted in controlled flight into terrain.NTSB CEN12LA615Accident · 1 fatalLimited investigationFinal reportGoodyear F2G · Valley City, NDThe pilot’s decision to initiate the aerobatic maneuver at an altitude that did not allow for full recovery of the airplane before ground impact.NTSB WPR12LA371Accident · Serious injuriesLimited investigationFinal reportArrow Falcon Exporters OH58 · Escalon, CAThe pilot’s failure to maintain clearance from trees during a low-altitude agricultural application, which resulted in a loss of control and impact with the ground.NTSB ERA12FA527Accident · 1 fatalField investigationFinal reportBell 407 · Abingdon, VAThe pilot's improper decision to make a low-level departure over water in dark night conditions without lights, which resulted in controlled flight into the water. Contributing to the accident was the pilot's likely spatial disorientation due to a vestibular…NTSB WPR12LA359Accident · Serious injuriesLimited investigationFinal reportFechtner KR-2 · Tehachapi, CAThe pilot's failure to maintain control of the airplane during the approach to the airport.NTSB CEN12CA546Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · Hanley Falls, MNThe pilot’s failure to maintain clearance from a guy wire during an agricultural application pass.NTSB WPR12FA349Accident · 1 fatalField investigationFinal reportCessna P210N · Santa Monica, CAThe pilot's failure to maintain altitude during a return to the airport following an unspecified emergency; the nature of the emergency could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would…NTSB WPR12CA351Accident · Minor injuriesData collectionFinal reportRobinson R22 · Monticello, UTThe pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude, which resulted in the helicopter settling and subsequently colliding with the ground. Contributing to the accident was that the pilot had insufficient altitude to…NTSB CEN12FA517Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Imperial, NEThe pilot’s failure to maintain adequate clearance from rising terrain while flying toward the rising sun, which interfered with his ability to see the terrain.NTSB ERA12CA495Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Alexander, NYThe pilot's inadequate visual lookout and failure to maintain altitude during aerial application, which resulted in controlled flight into terrain.NTSB ANC12FA083Accident · 1 fatalField investigationFinal reportPiper PA-32-301 · Hoonah, AKThe pilot's failure to maintain clearance from trees and terrain while in cruise flight in marginal visual meteorological conditions.NTSB CEN12LA490Accident · Serious injuriesLimited investigationFinal reportSmith Applebay Zuni II · Gregory, MIThe glider pilot’s failure to maintain sufficient altitude and airspeed while turning to the base leg of the traffic pattern, which resulted in a stall/spin and impact with trees and terrain.NTSB CEN12CA464Accident · Serious injuriesData collectionFinal reportBertram William J Bertram 2000 · Shiocton, WIThe pilot’s distraction with taking photographs, which resulted in his failure to maintain sufficient altitude to avoid the guy wire.NTSB CEN12LA453Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402B · Britt, IAThe pilot’s failure to maintain clearance from power transmission lines during an agricultural application operation. Contributing to the accident was the pilot’s distracted attention due to personal cell phone use during flight operations.NTSB ERA12LA455Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Hilltown, PAThe improper decision of the flight instructor receiving instruction to attempt a course reversal rather than land straight ahead following a simulated low-level rope break, and the inadequate remedial action of the flight instructor-in-command for allowing…NTSB WPR12LA301Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Cheyenne, WYThe pilot's failure to maintain clearance with a power line. Contributing to the accident was the sun's glare.NTSB ANC12CA067Accident · No injuriesData collectionFinal reportCessna 207A · Kotlik, AKThe pilot's failure to maintain altitude/clearance from terrain during cruise flight at low altitude, which resulted in an in-flight collision with water. A contributing factor was the pilot’s diverted attention to adjust the engine power.NTSB ERA12LA429Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Tallahassee, FLThe pilot’s failure to maintain awareness of the helicopter’s altitude while attempting to troubleshoot the clutch actuator warning light, which resulted in an inadvertent descent and impact with water. Contributing to the accident was the pilot's possible…NTSB WPR12FA282Accident · 4 fatalField investigationFinal reportAerospatiale AS350B · Camp Verde, AZThe pilot's improper decision to fly at a low altitude through a river canyon, contrary to voluntary guidance within the Special Conservation Area, which led to collision with a cable. Contributing to the pilot’s decision were his cognitive and psychomotor…NTSB ERA12FA423Accident · 1 fatalField investigationFinal reportPiper PA-31P · Dalton, GAThe pilot’s failure to maintain airplane control following loss of power in the right engine for reasons that could not be determined because of fire and impact damage. Contributing to the accident was the pilot’s delayed feathering of the right propeller…NTSB ERA12CA413Accident · Minor injuriesData collectionFinal reportMooney M10 · Hurlock, MDThe pilot's failure to see and avoid power lines during final approach to landing.NTSB WPR12FA274Accident · 4 fatalField investigationFinal reportCessna 172 · Veneta, ORThe pilot’s failure to maintain adequate airspeed and altitude to clear trees during the initial climb after takeoff.NTSB WPR12LA265Accident · Serious injuriesLimited investigationFinal reportRoetman Ryland K JR Eagle · Rexburg, IDA loss of engine oil pressure, which led to the subsequent uncommanded loss of thrust and decrease in the propeller rpm during a low-level aerobatic maneuver.NTSB WPR12LA259Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 II · East Wenatchee, WAThe pilot’s failure to adequately monitor the environment and maintain clearance from the power lines while maneuvering at low altitude.NTSB WPR12CA209Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Sula, MTThe pilot's inability to maintain clearance from terrain while operating in a downdraft over mountainous terrain.NTSB ERA12LA386Accident · 1 fatalLimited investigationFinal reportBowen Christopher W Dogbee · Wrens, GAThe pilot’s loss of control during a low-altitude maneuver for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot’s decision…NTSB CEN12CA347Accident · Serious injuriesData collectionFinal reportCameron Balloons Z-90 · Sellersburg, INThe balloon pilot’s failure to maintain clearance from power lines.NTSB WPR12GA243Accident · 2 fatalFinal reportLockheed P2V-7 · Modena, UTThe flight crew's misjudgment of terrain clearance while maneuvering for an aerial application run, which resulted in controlled flight into terrain. Contributing to the accident was the flight crew's failure to follow the lead airplane's track and to…NTSB CEN12LA318Accident · Serious injuriesLimited investigationFinal reportAeros Ltd/Skyranger Skyranger II · Saline, MIThe pilot did not maintain proper control of the airplane while maneuvering at low altitude, which resulted in an aerodynamic stall.NTSB CEN12CA319Accident · Serious injuriesData collectionFinal reportHughes 369HS · Delavan, MNThe pilot’s failure to maintain clearance with power lines during an aerial application flight.NTSB CEN12CA313Accident · Serious injuriesData collectionFinal reportAyres S2R-R1340 · Clear Lake, SDThe pilot's failure to perform a detailed observation of the power lines before beginning the aerial application work, which resulted in an inadvertent collision with the two lower wires.NTSB WPR12LA220Accident · 1 fatalLimited investigationFinal reportGrumman G 164D · Nicolaus, CAThe pilot’s failure to maintain airplane control during a low-altitude maneuver.NTSB ERA12FA345Accident · 1 fatalField investigationFinal reportShepard Jimmy D JR Pitts S1D · Port Richey, FLThe pilot's decision to conduct aerobatic flight at a low altitude, which resulted in a collision with the water.NTSB WPR12LA205Accident · Serious injuriesLimited investigationFinal reportInfinity 2000 · Hurricane, UTThe pilot's decision to fly at a low altitude in a canyon, which resulted in insufficient altitude to recover from an encounter with terrain-induced turbulence.NTSB ERA12CA320Accident · Minor injuriesData collectionFinal reportCessna 172F · Cambridge, NYThe pilot’s loss of airplane control during a takeoff in variable crosswind conditions.NTSB ERA12CA304Accident · Serious injuriesData collectionFinal reportBell 206B · Hershey, PAThe pilot's diverted attention while performing aerial application at low altitude, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s failure to adjust the control friction to the position he was accustomed.NTSB CEN12LA248Accident · Minor injuriesLimited investigationFinal reportAerostar International Raven S49A · Janesville, WIThe pilot’s failure to maintain clearance from the powerlines while landing.NTSB WPR12LA160Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Kent, WAThe pilot’s failure to maintain airplane control while maneuvering in the traffic pattern, which resulted in a collision with trees.NTSB WPR12LA149Accident · Serious injuriesLimited investigationFinal reportPowrachute Sky Rascal · Indio, CAThe operation of an airplane by a non-certificated pilot. Contributing to the accident was the non-certificated pilot's failure to maintain clearance from powerlines during initial climb in gusty wind conditions.NTSB ANC12CA029Accident · No injuriesData collectionFinal reportCessna 180 · Palmer, AKThe pilot’s failure to maintain adequate clearance from terrain during low-level maneuvering.NTSB WPR12FA136Accident · 2 fatalField investigationFinal reportCessna 150L · Goble, ORThe flight instructor's decision to continue flight into the area of reduced visibility and the pilots’ subsequent failure to maintain clearance from the hilly terrain while operating in an area of low ceilings, rain, and fog.NTSB WPR12LA126Accident · No injuriesLimited investigationFinal reportQuicksilver MX Sprint II · Willits, CAThe student pilot did not maintain an adequate approach/glide path and altitude, which resulted in a runway undershoot and subsequent collision with trees. Contributing to the accident was the student pilot's lack of flight experience.NTSB WPR12FA123Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Brockton, MTThe pilot’s failure to maintain adequate airspeed and airplane control while maneuvering at a low altitude, which resulted in a stall and subsequent impact with terrain.NTSB CEN12FA174Accident · 2 fatalField investigationFinal reportHemp Timothy Legacy 2000 · Belen, NMThe pilot’s failure to maintain clearance from power lines while maneuvering after takeoff. Contributing to the accident was the pilot’s decision to operate the airplane during the hours of darkness when he had a restriction for daytime flight only due to…NTSB WPR12FA105Accident · 3 fatalField investigationFinal reportCessna 172S · North Bend, WAThe pilot's physical impairment due to alcohol, which adversely affected his ability to operate the airplane and to maintain clearance from mountainous terrain while operating in dark night conditions.NTSB CEN12FA158Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Osborn, MOThe pilot’s decision to conduct low-level passes above a residence and his failure to maintain sufficient altitude.NTSB WPR12CA102Accident · Minor injuriesData collectionFinal reportPiper PA-18-135 · Concrete, WAThe pilot did not attain and maintain sufficient altitude to clear terrain while maneuvering.NTSB WPR12FA098Accident · 2 fatalField investigationFinal reportCessna 210 · Morgan, UTThe non-instrument-rated pilot’s poor planning and continued visual flight rules flight into instrument meteorological conditions and failure to maintain clearance from mountainous terrain.