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 ANC23LA081Accident · Serious injuriesClass 4 · LimitedFinal reportPiper/Gerbi Charles R PA 18-150 · Juneau, AKThe student pilot’s failure to maintain altitude after the airplane encountered a downdraft while maneuvering over an area of hilly terrain.NTSB WPR23LA339Accident · No injuriesClass 4 · LimitedFinal reportEurocopter France AS350B2 · Silverton, WAThe pilot’s failure to maintain visual reference and altitude while maneuvering over a lake during dusk conditions, which resulted in the helicopter impacting water.NTSB WPR23LA334Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Prescott, AZThe pilot-in-command’s inadequate preflight planning for the high density altitude and relative humidity conditions and his failure to recognize the need to reject the takeoff, allowing the student pilot to execute an abnormally long takeoff roll and apply…NTSB WPR23LA322Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5B · Lone Pine, CAThe pilot's inability to maintain altitude after encountering a downdraft, which resulted in collision with terrain.NTSB WPR23FA302Accident · 3 fatalClass 3 · FieldFinal reportBell 407 · Cabazon, CAThe Skycrane flight crew’s decision to enter the Fire Traffic Area’s 7-nm NOCOM ring at an altitude significantly above their maximum cleared altitude, which resulted in their need for an aggressive descent into congested airspace and subsequent failure to…NTSB WPR23LA290Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 23 · Coolin, IDThe pilot’s failure to maintain clearance from trees after takeoff, during high density altitude weather conditions.NTSB ERA23FA317Accident · 1 fatalClass 3 · FieldFinal reportBell 206-L4 · Springfield, OHThe pilot’s failure to remain clear of powerlines during an agricultural spraying operation.NTSB CEN23LA336Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402B · Alta, IAThe airplane’s encounter with a dust devil, which resulted in a loss of lift, and subsequent collision with powerlines.NTSB CEN23LA328Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Hanlontown, IAThe pilot’s failure to maintain clearance from a cable during spray operations.NTSB CEN23LA324Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-402B · Clara City, MNThe pilot’s failure to maintain clearance from a transmission line during an aerial application flight.NTSB WPR23LA272Accident · No injuriesClass 3 · LimitedFinal reportMellinger B L III/Briebleb R Glasair III · Pahrump, NVA fuel leak due to damaged threads on a fuel line fitting, which resulted in an interruption of fuel flow and a total loss of engine power due to fuel starvation.NTSB CEN23LA279Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · Chapman, KSThe pilot’s failure to maintain clearance from the power line during an agricultural application pass.NTSB WPR23LA245Accident · No injuriesClass 4 · LimitedFinal reportSchleicher Alexander ASH 26 E · Williams, CAThe pilot’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in a collision with terrain.NTSB CEN23LA331Accident · Minor injuriesClass 4 · LimitedFinal reportDavid Brown/U Balldin/T Morgan Zenith Stol CH701 · Arnaudville, LAThe pilot’s failure to maintain airspeed resulting in exceeding the airplane’s critical angle of attack and an aerodynamic stall. The low altitude at which the flight was conducted contributed to the outcome.NTSB CEN23FA257Accident · 1 fatalClass 3 · FieldFinal reportAvid Magnum · Beaver Island, MIThe pilot’s failure to maintain clearance from the water while maneuvering in low visibility conditions due to smoke and haze.NTSB WPR23LA232Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Rochester, NVA broken fuel line fitting that resulted in a total loss of engine power due to fuel starvation.NTSB ERA23FA266Accident · 1 fatalClass 3 · FieldFinal reportWonder Michael S Harmon Rocket · Porter, NYThe pilot’s failure to maintain control of the airplane while initiating a low-altitude aerobatic maneuver, which resulted in impact with trees and terrain. Contributing to the accident was the pilot’s high-risk behavior.NTSB WPR23FA223Accident · 2 fatalClass 3 · FieldFinal reportCompagnie Daher TB 30 Epsilon · Apache Junction, AZThe pilot’s controlled flight into the mountainous terrain due to diminished depth perception as a result of the shadowing effect from the sun’s position. Contributing to the accident was the decision by all three pilots to fly low altitude around the…NTSB WPR23LA215Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Belfair, WAThe total loss of engine power due to the fatigue failure of the crankshaft accessory drive gear.NTSB WPR23FA208Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-31-325 · Tupelo, MSThe pilot's exceedance of the airplane's critical angle of attack while maneuvering after takeoff for reasons that could not be determined, which resulted in an aerodynamic stall and subsequent loss of control.NTSB CEN23FA220Accident · 1 fatalClass 3 · FieldFinal reportVans RV7 · Gibbon, NEThe pilot’s improper decision to fly the airplane into known adverse weather and icing conditions which resulted in a loss of control.NTSB CEN23LA228Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164 · Saffell, ARThe airplane’s encounter with a dust devil after takeoff, which resulted in a loss of lift, and a subsequent loss of control. Contributing to the accident was the presence of a dust devil in the airplane’s flight path.NTSB CEN23LA210Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · St. Anthony, NDThe pilot’s failure to maintain clearance from terrain while maneuvering at low attitude.NTSB CEN23LA212Accident · Minor injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Light, ARThe pilot exceeding the climb capability of the airplane during takeoff which led to it settling into the ground.NTSB WPR23LA204Accident · No injuriesClass 4 · LimitedFinal reportCessna 175A · Enterprise, UTThe pilot’s inability to maintain altitude during an initial climbout in mountainous terrain after encountering a suspected downdraft.NTSB CEN23LA303Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-G6 · Ulysses, KSThe pilot’s failure to maintain clearance from a cable during spray operations.NTSB ERA23LA245Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-25-260 · Hollywood, FLThe pilot’s improper banner pickup approach, which resulted in the banner tow hook contacting the airplane, and the subsequent overload separation of the right rudder control horn, resulting in a loss of airplane control.NTSB WPR23LA200Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B3 · San Diego, CAThe pilot’s failure to maintain altitude during a hover taxi due to distraction resulting from the unanticipated activation of strobing lights while using night vision googles.NTSB WPR23LA198Accident · Minor injuriesClass 3 · LimitedFinal reportSilvaire Luscombe 8A · Clovis, NMThe airplane’s uncontrollable descent and forced landing for reasons that could not be determined.NTSB WPR23LA193Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · American Falls, IDThe pilot’s inadvertent selection of the off position of the fuel tank selector inflight, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN23LA193Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32RT · DeKalb, ILThe pilot’s failure to maintain aircraft control during a go-around in gusting winds. Contributing was the presence of windshear.NTSB CEN23LA171Accident · No injuriesClass 4 · LimitedFinal reportKitfox IV · Gretna, NEThe pilot’s failure to maintain clearance from terrain during a turn immediately after takeoff.NTSB WPR23LA175Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P337H · Laurel, MTA partial loss of engine power to the rear engine resulting from cylinder detonation for undetermined reasons, which resulted in a forced landing and impact with terrain.NTSB WPR23LA183Accident · No injuriesClass 3 · LimitedFinal reportAero Vodochody L-39ZA · Barnhart, TXA total loss of engine power due to water-contaminated fuel from an undetermined source.NTSB WPR23LA145Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Elko, NVThe pilot’s failure to maintain sufficient altitude and airspeed in gusting tailwind conditions that resulted in an unrecoverable descent and impact with terrain.NTSB CEN23LA143Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Hillsboro, MOThe pilot’s failure to maintain clearance from trees during final approach to landing.NTSB ANC23FA031Accident · 2 fatalClass 3 · FieldFinal reportBell Helicopter Textron 407 · Nuevo, CAThe pilot’s decision to maneuver in a steep bank at a low altitude, which resulted in his failure to maintain clearance with terrain.NTSB WPR23FA137Accident · 1 fatalClass 3 · FieldFinal reportCessna 182S · Alcova, WYThe airplane’s encounter with low level wind shear associated with moderate turbulence, which resulted in a loss of airplane control.NTSB WPR23LA126Accident · Minor injuriesClass 4 · LimitedFinal reportTrendak Taurus · Strawberry Reservoir, UTThe pilot’s failure to maintain clearance from the snow-covered lake while flying at a low altitude.NTSB CEN23FA125Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Port O'Connor, TXThe pilot’s initiation of the visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of helicopter control. Contributing to the accident was the pilot’s flicker vertigo during the flight.NTSB WPR23LA105Accident · No injuriesClass 4 · LimitedFinal reportHughes 269C · Yakima, WAThe pilot's failure to see and avoid a powerline while flying at low altitude over a river.NTSB WPR23LA103Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Porterville, UTThe pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low altitude.NTSB WPR23LA099Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Rich County, UTThe pilot’s inability to maintain altitude following an encounter with turbulence and adverse wind conditions.NTSB CEN23FA084Accident · 4 fatalClass 3 · FieldFinal reportPiper PA46 · Yoakum, TXThe pilot’s spatial disorientation during a missed approach in instrument meteorological conditions, which led to an exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.NTSB ANC23LA012Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 208B · Kualapuu, HIThe pilot’s failure to maintain adequate altitude during a circling approach procedure in dark night visual meteorological conditions, which resulted in a collision with terrain.NTSB WPR23LA091Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · San Diego, CAThe flight instructor’s failure to maintain altitude while maneuvering to another runway after the engine cowling opened shortly after takeoff. Contributing to the accident was the failure of both the student pilot and flight instructor to conduct an adequate…NTSB ERA23FA108Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-301 · Dayton, VAThe pilot’s controlled flight into terrain while descending over mountainous terrain at night.NTSB CEN23LA086Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Fowlerton, TXThe pilot’s failure to maintain clearance with trees, which resulted in an uncontrollable spin due to tail rotor damage.NTSB WPR23LA082Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Watsonville, CAThe pilot’s failure to maintain clearance from powerlines during a go around.NTSB ERA23LA107Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-301T · Old Bridge, NJThe pilot’s failure to maintain adequate clearance from trees during the landing approach.