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 WPR11FA268Accident · 1 fatalField investigationFinal reportTrusty Thorp T-18 · Tehachapi, CAThe pilot’s failure to maintain clearance from mountainous terrain during cruise flight, which resulted from his impairment or incapacitation due to multiple medical conditions and sedating medication.NTSB WPR11CA250Accident · Serious injuriesData collectionFinal reportSchweizer 269C · Las Vegas, NVThe pilot's failure to maintain adequate clearance from terrain while attempting a transition from hovering flight to forward flight over a mesa in windy, downdraft conditions.NTSB WPR11FA242Accident · 4 fatalField investigationFinal reportCessna 172R · Wendover, UTThe pilot did not maintain adequate airspeed during the downwind turn resulting in an aerodynamic stall, in-flight loss of control, and spin. Contributing to the accident was the pilot’s inadequate preflight planning and exceedance of the approved weight and…NTSB ERA11FA321Accident · 4 fatalField investigationFinal reportBeech V35 · Ellijay, GAThe pilot’s failure to maintain adequate clearance from terrain while maneuvering in a mountainous area.NTSB CEN11FA359Accident · Minor injuriesField investigationFinal reportEurocopter AS 350 B2 · Fort Worth, TXThe pilot’s loss of control due to his not maintaining adequate airspeed and altitude during a simulated hydraulic flight control failure. Contributing to the accident was the flight instructor’s inadequate supervision and delayed remedial response.NTSB WPR11LA233Accident · Serious injuriesLimited investigationFinal reportPalmer RV6A · Cody, WYThe pilot’s failure to maintain sufficient altitude to avoid rising terrain. Contributing to the accident was the pilot’s visual illusion and disorientation due to the flat light conditions.NTSB WPR11FA230Accident · 1 fatalField investigationFinal reportCameron Lancair Legacy · Pioneer, CAThe pilot’s continued flight into instrument meteorological conditions at an insufficient altitude to clear terrain.NTSB CEN11FA337Accident · 1 fatalField investigationFinal reportBell OH-58C · New Athens, ILThe pilot’s failure to attain sufficient altitude to clear terrain while maneuvering.NTSB CEN11CA325Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Golden, COThe pilot’s decision to operate the helicopter at a high density altitude near terrain, which resulted in a settling with power condition.NTSB CEN11LA323Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-402A · Arriba, COThe pilot’s controlled flight into terrain for undetermined reasons.NTSB CEN11LA317Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · New Columbia, ILThe pilot's failure to maintain adequate clearance from the wheat crop during takeoff.NTSB CEN11LA316Accident · 1 fatalLimited investigationFinal reportNorris Dominator · Blue Springs, NEThe pilot's failure to maintain clearance from power lines.NTSB ERA11CA260Accident · Minor injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Belhaven, NCThe pilot's failure to maintain adequate clearance above crops while performing an aerial application flight.NTSB CEN11FA299Accident · 2 fatalField investigationFinal reportClaus Rodney L Christen Eagle II · San Angelo, TXThe pilot did not maintain sufficient altitude to recover from a low-level aerobatic maneuver.NTSB WPR11LA190Accident · Minor injuriesLimited investigationFinal reportBell 47G · Torrance, CAThe pilot did not maintain adequate altitude during takeoff, which resulted in ground contact and a dynamic rollover.NTSB WPR11LA181Accident · Serious injuriesLimited investigationFinal reportCessna A188 · Palouse, WAThe pilot did not maintain adequate clearance from obstacles during a low-level aerial application maneuver.NTSB WPR11LA179Accident · Serious injuriesLimited investigationFinal reportEagle DW1 · Newman, CAThe pilot’s inadequate visual lookout and failure to maintain clearance from a vehicle during a low-altitude operation.NTSB ERA11FA219Accident · 2 fatalField investigationFinal reportBeech 58 · Greensboro, NCThe pilot’s spatial disorientation due to a somatogravic illusion while conducting a missed approach in instrument meteorological conditions, which resulted in the airplane’s descent into objects and terrain.NTSB ERA11FA218Accident · 2 fatalField investigationFinal reportCessna 310R · Pikeville, KYThe pilot's flight below the published minimum descent altitude in instrument meteorological conditions, which resulted in a collision with trees and the ground. Contributing to the accident was the pilot's use of nighttime cold medication at doses above…NTSB CEN11FA263Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Fredricktown, MOThe pilot's decision to attempt to maintain visual flight by descending below an area of deteriorating forecast weather to an altitude that did not provide adequate terrain clearance.NTSB CEN11FA253Accident · 3 fatalField investigationFinal reportPiper PA46-350P · Monroe, MIThe pilot's demonstration of poor judgment by attempting a high-speed pass several feet above the runway and his subsequent failure to maintain clearance from the runway.NTSB ANC11CA021Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chicken Lake, AKThe pilot's failure to maintain adequate clearance from terrain.NTSB ERA11FA214Accident · 1 fatalField investigationFinal reportAerostar S A YAK-52 · Palm Coast, FLThe pilot’s failure to recover from the nose-low descent during an aerobatic maneuver.NTSB ERA11CA180Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R44 II · Weston, FLThe pilot's failure to maintain adequate altitude and physical alertness which resulted in an in-flight collision with the water. Contributing to the accident was the pilot's fatigue.NTSB WPR11FA145Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Phoenix, AZThe pilot and flight instructor's failure to adequately monitor the flight task and environment while maneuvering to maintain sufficient altitude with rising terrain in dark night conditions and the flight instructor's improper decision to practice in an area…NTSB WPR11FA117Accident · Serious injuriesField investigationFinal reportCessna 172 · Glendora, CAThe flight crew's failure to maintain adequate terrain clearance while maneuvering in downdraft conditions over mountains.NTSB WPR11FA116Accident · 3 fatalField investigationFinal reportCessna 182K · Adrian, ORThe non-instrument-rated pilot did not maintain sufficient altitude to clear mountainous terrain while in cruise flight in the dark.NTSB CEN11CA154Accident · Serious injuriesData collectionFinal reportPowerchute Airwolf 912ULS · Alexandria, INThe pilot's failure to maintain clearance with trees during an initial climb following an aborted landing.NTSB ERA11FA101Accident · 2 fatalField investigationFinal reportCessna 172H · Weyers Cave, VAThe inherent limitations of the see-and-avoid concept, which made it difficult for the helicopter pilot to see the airplane before the collision. Contributing to the accident was the airplane pilot’s non-standard entry to the airport traffic pattern, which,…NTSB CEN11FA110Accident · 2 fatalField investigationFinal reportBeech B60 · Edwards, COControlled flight into terrain, while on an instrument approach in instrument meteorological conditions, for undetermined reasons.NTSB ERA11FA085Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 40 · Pearlington, MSThe pilot’s controlled flight into terrain likely due to spatial disorientation, while flying over sparsely lighted terrain at night.NTSB ERA11CA082Accident · Serious injuriesData collectionFinal reportBell 206L-3 · Canal Point, FLThe pilot's failure to maintain clearance from the ground while maneuvering at a low altitude. Contributing to the accident was the pilot’s fatigue.NTSB WPR11FA073Accident · Serious injuriesField investigationFinal reportCessna T210M · Ogden, UTThe pilot did not maintain clearance from obstacles after descending below the published approach decision height when visibility was less than published approach minimums due to heavy ground fog and he did not execute a missed approach after failing to…NTSB ERA11FA070Accident · 3 fatalField investigationFinal reportPiper PA 46-350P · Destin, FLControlled flight into water due to the pilot's improper descent below the published minimum descent altitude.NTSB WPR11FA061Accident · 1 fatalField investigationFinal reportAmerican Champion 8GCBC · Bremerton, WAThe pilot did not maintain clearance from terrain for undetermined reasons. Contributing to the accident were the pilot’s use of oxycodone and his severe coronary artery disease.NTSB WPR11LA048Accident · Serious injuriesLimited investigationFinal reportMD Helicopter 369D · Salem, ORThe pilot’s failure to maintain clearance between the longline and trees, which resulted in the longline snagging a tree and then recoiling into the main rotor blades and a subsequent loss of helicopter control.NTSB ERA11CA059Accident · No injuriesData collectionFinal reportHiller-Rogerson Helicopter UH12E · Madison, FLThe pilot's encounter with a settling with power condition while he was performing slow, low-level, out-of- ground-effect flight maneuvers.NTSB WPR11FA047Accident · 1 fatalField investigationFinal reportBeech C35 · Enterprise, ORThe noninstrumented pilot’s inadequate weather planning, which resulted in his failure to maintain visual flight while maneuvering under low ceilings in rainy and foggy conditions and his subsequent failure to maintain clearance from mountainous terrain.NTSB WPR11CA041Accident · No injuriesData collectionFinal reportAviat A-1B · Heber City, UTThe pilot's failure to maintain clearance from the ground during low-level maneuvering in mountainous/hilly terrain.NTSB WPR11CA036Accident · Minor injuriesData collectionFinal reportAerostar Acft Corp Of Texas M20E · Seligman, AZThe pilot's failure to maintain clearance from terrain while maneuvering. Contributing to the accident was the pilot's inadequate preflight and in-flight planning.NTSB WPR11CA011Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe student pilot's failure to maintain an adequate drift control and skid clearance from the ground and the CFI's inadequate supervision while hovering, resulting in dynamic rollover.NTSB CEN11CA010Accident · Minor injuriesData collectionFinal reportMartin Curtis Zenair CH701 SP · Lonsdale, MNThe pilot's failure to maintain clearance from a power line while on approach to land.NTSB WPR11FA005Accident · 2 fatalField investigationFinal reportCessna 172 · Panguitch, UTThe pilot's decision to conduct a low-level flight into a canyon in windy conditions at a high density altitude, which resulted in a collision with trees and terrain.NTSB WPR10FA459Accident · 2 fatalField investigationFinal reportCessna T210N · Coeur d'Alene, IDThe pilot’s continued flight into instrument meteorological conditions and failure to maintain clearance with mountainous terrain while maneuvering in an area of low cloud ceilings.NTSB ANC10CA093Accident · Minor injuriesData collectionFinal reportCessna T310R · Nome, AKThe pilot's failure to maintain clearance from terrain during a special VFR approach, resulting in a collision with terrain.NTSB ANC10CA089Accident · No injuriesData collectionFinal reportCessna 150M · Bethel, AKThe pilot's failure to maintain altitude/clearance during a night approach, resulting in a collision with terrain short of the runway.NTSB WPR10CA439Accident · Serious injuriesData collectionFinal reportAyres S2R-G10 · Ligurta, AZThe pilot's failure to maintain clearance from rising terrain. Contributing to the accident was the pilot's decision to orient the application tracks so that they did not provide the maximum possible clearance from the rising terrain, and, the predawn…NTSB WPR10FA435Accident · 1 fatalField investigationFinal reportRemos Remos G-3/600 · Tucson, AZThe pilot's failure to maintain airplane control while maneuvering at a low altitude.NTSB CEN10CA507Accident · No injuriesData collectionFinal reportLet L-23 Super Blanik · Socorro, NMA loss of lift that resulted in an off-airport landing.NTSB WPR10LA427Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Sequim, WAThe pilot’s failure to maintain the proper approach path and his delayed corrective actions, which resulted in an undershoot. Contributing to the accident was the pilot's distraction from other aircraft in the area.