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 ERA20CA291Accident · No injuriesClass 4 · Data collectionFinal reportTeam Rocket F1 Rocket · Finelyville, PAThe pilot's misjudgment of the airplane’s speed and altitude during the landing approach, and his failure to attain the proper touchdown point during landing, which resulted in a runway overrun. Contributing to the accident were his access to a limited set of…NTSB WPR20CA273Accident · No injuriesClass 4 · Data collectionFinal reportSchweizer SGS233 · Warner Springs, CAThe pilot's inability to maintain altitude due to a loss of thermal lift, which resulted in an off-airport landing.NTSB CEN20CA387Accident · Serious injuriesClass 4 · Data collectionFinal reportPowrachute Airwolf · Casco, MIThe pilot's decision to takeoff towards known obstacles which resulted in an impact with a power line.NTSB CEN20CA335Accident · Serious injuriesClass 4 · Data collectionFinal reportCirrus SR22 · Lafayette, INThe pilot's failure to monitor aircraft control, which resulted in a loss of control when a passenger inadvertently moved the control stick, and the pilot and other passenger's decision to unbuckle their restraints inflight.NTSB WPR20CA261Accident · Serious injuriesClass 4 · Data collectionFinal reportAviat A1 · Kernville, CAThe pilot's failure to maintain clearance from trees during a go-around, which resulted in an impact with terrain.NTSB WPR20CA262Accident · Serious injuriesClass 4 · Data collectionFinal reportHead AX8 88 · Jackson, WYThe balloon pilot’s inability to maintain altitude during un-forecasted weather, which resulted in a hard landing.NTSB WPR20LA244Accident · 2 fatalClass 3 · LimitedFinal reportAmerican Eurocopter AS350 · Pioche, NVThe pilot’s failure to maintain altitude from terrain and subsequent loss of helicopter control due to entanglement of the external load cable with the tail rotor.NTSB CEN20CA312Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT 602 · Tiro, OHThe pilot's failure to maintain clearance while attempting to fly under power lines during an aerial application pass.NTSB CEN20CA311Accident · Minor injuriesClass 4 · Data collectionFinal reportAir Tractor AT 401 · Burlington, COThe pilot’s failure to maintain clearance from guy-wires during low-altitude agricultural operations.NTSB WPR20CA218Accident · No injuriesClass 4 · Data collectionFinal reportRans S6 · Richland, WAThe pilot's inability to arrest a descent rate or maintain altitude after encountering a downdraft while maneuvering at low altitude near mountainous terrain that resulted in a hard landing.NTSB WPR20LA216Accident · 1 fatalClass 3 · LimitedFinal reportSchleicher ASW27 · Ely, NVThe pilot’s loss of glider control while maneuvering near a mountain ridge in downdrafts and dry microbursts at an altitude that precluded recovery.NTSB CEN20LA272Accident · 1 fatalClass 3 · LimitedFinal reportGolden Circle Air T-Bird · Grosse Ile, MIThe noncertificated pilot’s failure to maintain clearance from trees while maneuvering at low altitude in gusting wind conditions. Contributing to the accident was the pilot’s lack of flight experience.NTSB CEN20LA278Accident · 1 fatalClass 3 · LimitedFinal reportGrumman G164 · Springfield, COThe pilot’s loss of visibility in the cockpit due to foam created by the chemicals loaded in the hopper, which resulted in collision with terrain. Contributing to the accident was the combining of chemicals known to produce foam and the pilot’s failure to…NTSB CEN20LA282Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Venice, LAA partial loss of engine power for reasons that could not be determined based on available evidence.NTSB ANC20CA066Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA22 · Tyonek, AKThe pilot's decision to land at an unimproved airstrip with limited go-around capabilities, his improper landing flare and aborted landing, and his subsequent failure to attain sufficient altitude to clear vegetation during an attempted go-around.NTSB WPR20CA197Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Pioche, NVThe pilot’s decision to fly at low level over mountainous terrain and his inability to recover when the helicopter encountered a downdraft that resulted in a collision with terrain.NTSB CEN20CA230Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R22 · El Campo, TXThe pilot's failure to maintain adequate clearance from the rice vegetation, which resulted in the helicopter's impact with terrain.NTSB CEN20CA221Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT502 · Hiawatha, KSThe pilot’s decision to attempt the takeoff with a tailwind in high density altitude conditions.NTSB CEN20LA214Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172 · New Washington, INA high velocity descent and impact with terrain for undetermined reasons.NTSB WPR20LA169Accident · 3 fatalClass 3 · LimitedFinal reportCessna 175 · Redlands, CAThe noncertificated pilot’s visual flight rules flight into instrument meteorological conditions and subsequent impact with terrain.NTSB ANC20CA052Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT802 · Unalakleet, AKThe pilot's failure to maintain terrain clearance during the departure, which resulted in a collision with terrain..NTSB WPR20CA162Accident · No injuriesClass 4 · Data collectionFinal reportBell 206 · Elko, NVThe pilot's failure to maintain helicopter control in gusting wind that resulted in a loss in altitude and subsequent collision with a fence.NTSB ANC20CA054Accident · No injuriesClass 4 · Data collectionFinal reportCessna 120 · Gulkana, AKThe pilot's failure to maintain proper airspeed during final approach to landing, and his subsequent failure to attain sufficient altitude to clear trees during an attempted go-around.NTSB WPR20CA153Accident · Minor injuriesClass 4 · Data collectionFinal reportAyres S 2R · Artois, CAThe pilot's failure to maintain clearance from power lines during a go-around.NTSB CEN20LA179Accident · 1 fatalClass 3 · LimitedFinal reportCessna P210 · Burlington, WIThe pilot did not maintain a safe altitude during the visual approach, and subsequently lost control which resulted an impact with trees and terrain.NTSB ERA20CA184Accident · No injuriesClass 4 · Data collectionFinal reportBell OH-58C · Livingston, NYThe pilot's failure to maintain obstacle clearance while maneuvering at low altitude at night, which resulted in the helicopter striking a tree.NTSB ERA20LA177Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA34 · Pembroke Pines, FLA total loss of power in the right engine for reasons that could not be determined based on available information. Contributing to the accident was the flight instructor’s decision to turn 180° before securing the right engine, which resulted in a loss of…NTSB WPR20CA151Accident · No injuriesClass 4 · Data collectionFinal reportLet L 33 Solo · Arlington, WAThe loss of lift while on final approach which resulted in a hard off-airport landing.NTSB ERA20CA178Accident · Minor injuriesClass 4 · Data collectionFinal reportSchempp Hirth Ventus 2CT · Stuarts Draft, VAA loss of thermal lift during a motor glider flight, which resulted in an off-airport landing. Contributing to the accident was the pilot's delayed attempted engine start.NTSB WPR20LA141Accident · 1 fatalClass 3 · LimitedFinal reportBellanca 8GCBC · Byron, CAThe tow airplane pilot’s loss of control resulting from the glider pilot’s failure to maintain a proper altitude behind the tow airplane, which caused the tail of the tow airplane to be lifted upward and the tow airplane to pitch nose down while at a low…NTSB CEN20LA168Accident · 1 fatalClass 3 · LimitedFinal reportYakovlev YAK 52 · Palmyra, ILA loss of control during a low-altitude aerobatic maneuver.NTSB WPR20CA127Accident · No injuriesData collectionFinal reportFLIGHTstar 2 · Oakdale, CAThe noncertificated pilot’s decision to take off through a large helicopter’s rotor wash, which resulted in his inability to gain altitude during takeoff.NTSB WPR20CA125Accident · Minor injuriesData collectionFinal reportCessna 172 · Yakima, WAThe pilot's failure to attain sufficient altitude during a go-around, which resulted in impact with hilly terrain.NTSB ERA20CA151Accident · No injuriesData collectionFinal reportPipistrel Sinus · Townsend, TNThe motor glider's encounter with atmospheric lift conditions that were not sufficient to maintain flight, which necessitated a forced landing and resulted in impact with vegetation. Contributing to the accident was the pilot's delayed decision to restart the…NTSB WPR20LA122Accident · No injuriesClass 3 · LimitedFinal reportBuckman Bucks Special · Prescott, WADiminished engine performance due to carburetor icing conditions and multiple mechanical anomalies that did not allow for the airplane to attain adequate airspeed during takeoff from a planted field and failure to maintain clearance from obstructions.…NTSB ANC20CA041Accident · No injuriesData collectionFinal reportPiper PA 18A · Chickaloon, AKThe pilot's selection of unsuitable terrain for landing, which necessitated a go-around, and her subsequent failure to maintain clearance from rising mountainous terrain.NTSB CEN20CA144Accident · No injuriesData collectionFinal reportRobinson R22 · Seymour, TXThe pilot's failure to maintain clearance from a tree while maneuvering at low altitude.NTSB CEN20LA442Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Sterling City, TXThe pilot’s failure to maintain clearance from power lines during an aerial application flight.NTSB ERA20CA128Accident · Minor injuriesData collectionFinal reportStolp Starduster Acroduster II SA750 · Senoia, GAThe pilot's failure to see and avoid trees while maneuvering at low altitude, which resulted in a loss of airplane control.NTSB CEN20CA111Accident · Minor injuriesData collectionFinal reportCessna P206 · Hill City, MNThe pilot's failure to maintain the proper altitude and airspeed during the approach and his delayed addition of power to go around and the flight instructor’s delayed remedial action, which resulted in a nose-over after landing on the closed snow-covered…NTSB ANC20CA029Accident · Minor injuriesClass 4 · Data collectionFinal reportChampion 7GCAA · Sterling, AKThe pilot's failure to maintain altitude/clearance during approach, which resulted in the airplane impacting an area of deep snow. A factor associated with the accident was flat light conditions.NTSB CEN20LA109Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Dumas, ARThe pilot’s failure to maintain clearance from a power line pole during a low-level aerial application flight, which resulted in impact with the bracket and a subsequent forced landing.NTSB ANC20CA023Accident · Minor injuriesClass 4 · Data collectionFinal reportRobinson R44 · Talkeetna, AKThe pilot's failure to maintain adequate clearance from snow covered terrain during an en route descent in flat light conditions, which resulted in controlled flight into terrain.NTSB CEN20CA085Accident · No injuriesData collectionFinal reportRobinson R44 · Marfa, TXThe pilot's failure to maintain clearance from a fence during low-altitude maneuvering.NTSB WPR20FA086Accident · 2 fatalClass 3 · FieldFinal reportCessna 140 · Sonora, CAThe pilot’s failure to maintain clearance from trees during approach for landing.NTSB ANC20CA018Accident · No injuriesData collectionFinal reportCessna 172 · Palmer, AKThe pilot's failure to maintain clearance from snow-covered terrain while maneuvering at low altitude.NTSB WPR20FA067Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Jacksonville, TXThe pilot’s failure to maintain clearance from guy wires associated with a tower while maneuvering at low altitude.NTSB ERA20LA094Accident · Serious injuriesClass 3 · LimitedFinal reportAirborne America AX9-140 · Homestead, FLThe pilot's decision to operate the balloon at low altitude near obstructions, structures, and powerlines, which resulted in the balloon contacting powerlines. Contributing to the accident was the Federal Aviation Administration's inadequate oversight of…NTSB WPR20FA063Accident · 4 fatalClass 3 · FieldFinal reportCessna TR182 · Billings, MTThe pilot’s failure to maintain clearance due to poor decision making in selecting an unsafe altitude during cruise flight.NTSB WPR20FA049Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Goodyear, AZThe pilot’s failure to maintain clearance from power lines due to his impairment from cannabis.