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 GAA19CA262Accident · No injuriesData collectionFinal reportCub Crafters Carbon CUB EX · Grand Junction, COThe pilot's failure to maintain clearance from power lines during low-level maneuvering through a canyon.NTSB ERA19FA163Accident · 2 fatalClass 2 · FieldFinal reportGuimbal Cabri · Kent Island, MDThe noninstrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in an inadvertent descent into the water. Contributing to the accident was the pilot's decision to conduct the flight at a low altitude without…NTSB ERA19LA157Accident · Serious injuriesClass 3 · LimitedFinal reportBarrows Bearhawk LSA · Holly Springs, NCThe pilot's failure to maintain clearance from powerlines during the visual approach.NTSB CEN19LA123Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R66 · St Jacob, ILThe pilot's in-flight collision with an unmarked wire during an aerial application flight; the wire lacked contrast with the surrounding environment.NTSB GAA19CA216Accident · No injuriesData collectionFinal reportBell 47G · Donna, TXThe pilot's failure to maintain altitude during an agricultural application flight.NTSB CEN19TA112Accident · Minor injuriesClass 3Final reportPiper PA28 · Aberdeen, MSThe pilot's failure to maintain directional control of the airplane during landing, which resulted in a collision with a fence and impact with terrain during the attempted aborted landing.NTSB CEN19FA095Accident · 2 fatalClass 2 · FieldFinal reportBell 407 · Galliano, LAThe pilot's loss of control during cruise flight as a result of spatial disorientation while operating the helicopter in close proximity to terrain in marginal meteorological conditions.NTSB WPR19FA091Accident · 1 fatalClass 2 · FieldFinal reportBell UH1B · Forks, WAA total loss of engine power due to the failure of the gas generator sealing disk as a result of the operator’s exceedance of the sealing disk life limits at too low an altitude for the pilot to accomplish a successful autorotation which resulted in the…NTSB ERA19FA118Accident · 1 fatalClass 3 · FieldFinal reportHughes 369 · Talking Rock, GAA fatigue failure of the overrunning clutch subassembly due to abnormal bending loads due to cracks on the center engine mount, which resulted in an inflight loss of power. Contributing to the accident was the helicopter's low altitude and airspeed when the…NTSB ERA19FA112Accident · 1 fatalClass 3 · FieldFinal reportPiper PA25 · Fort Lauderdale, FLThe pilot’s failure to maintain proper altitude and clearance while maneuvering during a banner tow flight, which resulted in an in-flight collision with a 19-story building in a heavily congested area. Contributing to the accident were the easterly wind…NTSB ERA19FA106Accident · 1 fatalClass 2 · FieldFinal reportStol UC-1 · Winter Haven, FLA total loss of left engine power for reasons that could not be determined, and the instructor's failure to maintain airspeed while maneuvering for a forced landing, which resulted in a loss of control. Contributing to the accident was the instructor's…NTSB CEN19LA086Accident · No injuriesLimited investigationFinal reportBeech 65 · Colby, KSThe pilot’s failure to properly secure the crew hatch door before takeoff, which resulted in his distraction and his failure to maintain airplane control and airspeed.NTSB GAA19CA141Accident · No injuriesData collectionFinal reportRobinson R22 · Clearwater, FLThe flight instructor's failure to maintain sufficient altitude over uneven terrain during a hover taxi, which resulted in ground contact and a subsequent dynamic rollover.NTSB WPR19FA080Accident · 2 fatalClass 2 · FieldFinal reportCessna 172 · Desert Hot Springs, CAThe pilot's inadequate and/or improper preparation for the flight in which he selected an altitude too low to assure terrain clearance and resulted in an impact with terrain in turbulent downdraft conditions.NTSB CEN19FA072Accident · 3 fatalClass 1 · FieldFinal reportBell 407 · Zaleski, OHThe NTSB determines that the probable cause of this accident was Survival Flight's inadequate management of safety, which normalized pilots' and operations control specialists' noncompliance with risk analysis procedures and resulted in the initiation of the…NTSB WPR19TA061Accident · Serious injuriesClass 3Final reportBell 206 · Yuma, AZThe pilot's failure to maintain clearance from power transmission wires while flying at low altitude in nighttime conditions.NTSB CEN19LA068Accident · No injuriesLimited investigationFinal reportAerospatiale AS350 · Ponca City, OKThe pilot's failure to maintain altitude during the hover operation while his view was obstructed due to the fogged-over windshield.NTSB CEN19TA075Accident · Minor injuriesFinal reportMBB BK117 · Strum, WIThe pilot's failure to maintain clearance from the fire truck.NTSB CEN19LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Abilene, TXThe pilot's failure to see and avoid a cell tower wire during a pipeline patrol flight. Contributing to the accident was the pilot's distraction due to writing down observations about the pipeline while flying.NTSB ERA19FA070Accident · 3 fatalField investigationFinal reportPiper PA28 · Blairsville, GAThe pilot's failure to maintain clearance from trees during a visual approach for landing in night visual meteorological conditions. Contributing to the accident was the pilot's lack of recent experience flying at night.NTSB ERA19FA059Accident · 1 fatalField investigationFinal reportCessna 210 · Apalachicola, FLThe pilot's controlled flight into terrain as a result of his spatial disorientation during departure in dark nighttime conditions.NTSB GAA19CA078Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Americus, GAThe pilot's failure to see and avoid a power line during an agricultural application flight.NTSB WPR19TA037Accident · Minor injuriesClass 3Final reportScottish Series 100 MDL 101 · Lake Pleasant, AZImpact with a lake for undetermined reasons.NTSB CEN19FA029Accident · 2 fatalField investigationFinal reportBeech 55 · Liberal, KSThe pilot's improper decision to fly in an area where moderate icing conditions were forecasted in an airplane that was not certified for such conditions, and in the effort to get out of the icing conditions, his decision to fly below the minimum descent…NTSB CEN19FA024Accident · 3 fatalField investigationFinal reportBell 206 · Uvalde, TXThe pilot's controlled flight into terrain during night visual meteorological conditions. Contributing to the accident was the pilot improper decision to inhibit the helicopter's terrain warning systems and flight at low altitude.NTSB ERA19LA028Accident · Serious injuriesLimited investigationFinal reportBeech V35 · Murfreesboro, TNThe pilot's failure to maintain airplane control while maneuvering at low altitude in gusting wind conditions.NTSB CEN19CA017Accident · No injuriesData collectionFinal reportPiper PA28R · Hobbs, NMThe pilot's incorrect altimeter setting during the night visual approach, which resulted in a controlled flight into terrain.NTSB CEN18FA387Accident · 1 fatalField investigationFinal reportBeech 200 · Oscoda, MIThe pilot's descent below minimum descent altitude during the nonprecision instrument approach for reasons that could not be determined based on the available information.NTSB GAA18CA573Accident · No injuriesData collectionFinal reportHiller UH 12E · Frankfort, KSThe ground crewmember's improper grabbing of the hovering helicopter's skid during an external load hook-up, which resulted in the helicopter descending and the main rotors striking ground equipment.NTSB WPR18LA263Accident · Serious injuriesClass 3 · LimitedFinal reportCessna A185 · Bullhead City, AZThe pilot’s diverted attention during takeoff initial climb, which resulted in a collision with rising terrain.NTSB WPR18FA261Accident · 2 fatalClass 3 · FieldFinal reportGruber Beelzabub · Rochester, WAThe pilot’s failure to maintain clearance from a tree while maneuvering at a low altitude.NTSB GAA18CA533Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12 · Cut Bank, MTThe pilot’s failure to see and avoid power wires while maneuvering at low altitude. Contributing to the accident was the pilot’s inability to determine the airplane’s altitude due to sun glare.NTSB CEN18LA365Accident · Serious injuriesLimited investigationFinal reportMD Helicopters MD-369 · Orchard Lake, MIThe pilot's failure to maintain helicopter control and terrain clearance while in a hover after performing an evasive maneuver to avoid wildlife.NTSB CEN18FA368Accident · 1 fatalField investigationFinal reportPiper PA32RT · St Ignace, MIThe pilot's failure to maintain sufficient altitude after takeoff in dark night conditions which resulted in a collision with the water.NTSB WPR18FA245Accident · 1 fatalClass 2 · FieldFinal reportCessna P210 · Prescott, AZThe pilot's misjudgment of distance and altitude from the runway and his subsequent failure to maintain an approach path that provided clearance from the terrain due to a visual illusion in dark night conditions.NTSB CEN18FA358Accident · 4 fatalField investigationFinal reportBeech B60 · Fort Walton Beach, FLThe pilot's controlled flight into terrain after misidentifying the destination airport during a period of restricted visibility due to weather.NTSB WPR18FA237Accident · 2 fatalClass 3 · FieldFinal reportChampion 7KCAB · Descanso, CAThe pilot's decision to enter a spin without sufficient altitude to recover. Also causal to the accident was the pilot's inadequate preflight weight and balance calculations, which placed the airplane outside the normal and acrobatic category flight envelope,…NTSB WPR18LA227Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182 · Salmon, IDThe pilot’s inadvertent encounter with downdraft conditions, which resulted in a loss of altitude, and the pilot’s subsequent decision to conduct a precautionary landing into a stand of trees.NTSB GAA18CA512Accident · No injuriesClass 4 · Data collectionFinal reportBell 206 · Battle Mountain, NVThe pilot's failure to maintain the proper altitude and airspeed while flying in a canyon in gusting wind conditions.NTSB WPR18LA241Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Afton, WYThe pilot’s failure to maintain terrain clearance after an encounter with a downdraft while maneuvering in a valley with a high-density altitude, which resulted in impact with trees and terrain.NTSB GAA18CA483Accident · No injuriesData collectionFinal reportRobinson R22 · Ocean City, NJThe flight instructor's decision to conduct hover practice at a lower altitude than recommended and his delayed remedial action during recovery from an unstable hover, which resulted in a dynamic rollover.NTSB CEN18LA316Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Wiley, COThe pilot's failure to maintain proper clearance from the sprinkler guy-wire, which resulted in the airplane’s collision with the wire during a visual approach to landing.NTSB GAA18CA502Accident · No injuriesData collectionFinal reportWSK PZL Mielec M-18A · Dansville, NYThe pilot’s failure to maintain clearance from crops during an agricultural application flight.NTSB CEN18LA303Accident · Minor injuriesLimited investigationFinal reportBuchanan Kitfox IV · Loma, COThe pilot's improper decision to conduct a low-altitude flight over a river and his inadequate monitoring of the environment, which resulted in a collision with a cableway.NTSB ERA18LA204Accident · Serious injuriesLimited investigationFinal reportProgressive Aerodyne Searey · Haverhill, NHThe pilot's failure to maintain clearance from trees while maneuvering the airplane at a very low altitude in a confined area while attempting to land on a river.NTSB CEN18FA297Accident · 1 fatalField investigationFinal reportAeronca 7AC · Alexandria, MNThe pilot's intentional low-altitude flight, which resulted in an impact with power lines.NTSB WPR18FA200Accident · 1 fatalField investigationFinal reportDe Havilland DH112 Venom · Sheboygan, WIThe airplane's encounter with wake turbulence from the lead airplane in the formation flight, which resulted in a compressor stall and the airplane's subsequent inability to climb.NTSB GAA18CA561Accident · No injuriesData collectionFinal reportApollo Fox · Chateaugay, NYThe pilot’s failure to maintain clearance from trees during a go-around.NTSB CEN18FA267Accident · 2 fatalField investigationFinal reportKolb Twinstar · La Porte, TXThe pilot's failure to maintain airspeed during a visual approach for landing, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall at an altitude too low for recovery.NTSB CEN18FA263Accident · 1 fatalField investigationFinal reportAir Tractor AT-602 · Wheatley, ARThe pilot's failure to maintain clearance from terrain for reasons that could not be determined based on the available evidence.