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 SEA08CA163Accident · Minor injuriesData collectionFinal reportLet Blanik L-13 · Arlington, WAThe pilot's failure to maintain clearance from a tree while making an off-field landing in a glider. Contributing to the accident was the pilot's inadequate compensation for the gusting winds.NTSB MIA08CA145Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Greensburg, KYThe pilot's failure to maintain clearance from trees while maneuvering. Contributing to the accident was the low altitude maneuvers.NTSB DFW08CA191Accident · No injuriesData collectionFinal reportCessna T210M · Van Horn, TXThe pilot's failure to maintain altitude due to his diverted attention. Contributing to the accident was complications manually extending the landing gear.NTSB LAX08CA229Accident · No injuriesData collectionFinal reportBell 47G-3B-1 · Shafter, CAThe pilot's failure to maintain adequate altitude while maneuvering. Contributing factors were the failure of the helicopter's lights during the night flight and the effect of that failure on the pilot's visual perception.NTSB DFW08CA182Accident · No injuriesData collectionFinal reportAyres S2R · Baton Rouge, LAThe pilot's failure to maintain clearance from the transmission wire.NTSB LAX08CA223Accident · Minor injuriesData collectionFinal reportGrumman Acft Eng G-164B · Patterson, CAThe pilot's failure to maintain clearance from obstacles while maneuvering.NTSB LAX08CA219Accident · No injuriesData collectionFinal reportTallent, Chris M. Putts Special · Sumter, SCthe pilot's failure to maintain the proper glideslope and clearance from obstacles. Contributing to the accident was the pilot's limited experience in the airplane type.NTSB DEN08LA119Accident · 1 fatalLimited investigationFinal reportShannon Kevin RV-8 · Valera, TXThe pilot's failure to maintain adequate airspeed during a forced landing, which led to an aerodynamic stall, following a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's mismanagement of fuel and the low altitude at…NTSB CHI08CA176Accident · No injuriesData collectionFinal reportAero Commander S2R · Clontarf, MNThe pilot's failure to maintain clearance from the power transmission lines. Contributing to the accident was the power transmission lines.NTSB CHI08CA177Accident · No injuriesData collectionFinal reportRobinson R44 II · Ottawa, ILThe pilot's failure to maintain clearance from the power transmission lines. Contributing to the accident was the unmarked power transmission lines.NTSB DEN08LA120Accident · Serious injuriesLimited investigationFinal reportChomo EAA Biplane B1 · Schuyler, NEThe pilot's failure to maintain clearance from the wire due to his diverted attention resulting in in-flight collision with the wire. Contributing to the accident was the pilot's failure to locate an emergency landing site.NTSB SEA08LA158Accident · 1 fatalLimited investigationFinal reportMauck RV-6A · Sierraville, CAThe pilot's failure to maintain clearance with trees and terrain while maneuvering Contributing to the accident was the reduced visibility in the area due to smoke.NTSB LAX08CA188Accident · Minor injuriesData collectionFinal reportPiper PA-36-375 · Lodi, CAThe pilot's inadequate in-flight decision to continue the flight into an area of obscured visibility and his failure to maintain clearance above obstacles.NTSB SEA08CA151Accident · No injuriesData collectionFinal reportCessna T182T · Point Roberts, WAThe pilot's failure to maintain clearance from trees during a go-around. Contributing to the accident were the pilot inadvertently allowing the airplane to porpoise during the landing flare, and the presence of a tailwind.NTSB CEN09CA108Accident · Minor injuriesData collectionFinal reportPowrachute Pegasus · Sunrise Beach, TXThe pilot's failure to maintain altitude/clearance from a powerline while maneuvering. A contributing factor was the powerline.NTSB NYC08CA219Accident · Serious injuriesData collectionFinal reportHeldeberg Design Blue Heron Marathon · Avon, METhe pilot's improper decision to takeoff from an area that was not a designated runway, and his failure to maintain clearance of trees.NTSB LAX08CA178Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Cedar Valley, UTThe pilot's failure to maintain terrain clearance while maneuvering. A contributing factor was the high density altitude.NTSB MIA08CA137Accident · No injuriesData collectionFinal reportAir Tractor AT-402B · Muscle Shoals, ALThe pilot's failure to maintain clearance from utility wires during low altitude maneuvers.NTSB MIA08FA115Accident · 3 fatalField investigationFinal reportCessna T206H · Cedar Key, FLThe pilot’s failure to maintain clearance from the water during a dark night approach to a coastal airport.NTSB CHI08CA186Accident · No injuriesData collectionFinal reportNaval Aircraft Factory N3N-3 · Luckey, OHThe pilot not maintaining clearance from the high vegetation during the off airport landing. Contributing to the accident was the high vegetation.NTSB NYC08CA200Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Wildwood, NJThe pilot's failure to maintain clearance from trees during approach. Contributing to the accident were the dark night conditions.NTSB SEA08CA143Accident · Minor injuriesData collectionFinal reportCessna 150M · Cove, ORThe pilot's failure to maintain clearance with terrain during a go-around.NTSB CHI08CA139Accident · No injuriesData collectionFinal reportCessna 172N · Blue Ash, OHThe separation of the throttle cable from the linkage during the approach to land and the altitude/clearance not being available to the pilot during the forced landing. Contributing to the accident was the electrical wires the airplane impacted.NTSB LAX08CA150Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Rockport, CAThe pilot's performance of VFR flight into IMC, resulting in failure to maintain terrain clearance. Contributing to the accident was the fog.NTSB DEN08CA087Accident · No injuriesData collectionFinal reportCessna 172H · Brookshire, TXThe pilot's decision to duck under marked transmission lines and his failure to maintain clearance from the fence. Contributing to the accident was the marked transmission lines.NTSB CHI08CA127Accident · Minor injuriesData collectionFinal reportCessna 140 · Burlington, WIA loss of engine power for undetermined reasons. Contributing to the accident was the low altitude at the time of the loss of engine power.NTSB DEN08CA089Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164C · De Witt, ARThe pilot's improper decision to attempt to close the canopy in flight, and his diverted attention resulting in the airplane impacting the terrain. Contributing to the accident was the excessively worn canopy latch.NTSB DEN08CA084Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Mountain Grove, MOthe pilot's failure to maintain clearance with the power line.NTSB CHI08LA124Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · New Lisbon, WIThe pilot's failure to maintain adequate altitude during a course reversal at the completion of an agricultural spray run.NTSB LAX08CA125Accident · Minor injuriesData collectionFinal reportGrumman AA-5A · Atlanta, IDThe pilot's failure to attain and maintain an adequate airspeed during the takeoff to clear trees during the initial climb. Contributing factors were the soft and rough nature of the short runway surface.NTSB SEA08LA120Accident · 2 fatalLimited investigationFinal reportYakovlev Yak 52 · Vancouver, WAThe pilot's failure to maintain an airspeed sufficient to avoid a stall during a low altitude aerobatic maneuver. Contributing to the accident was the low altitude at which the pilot initiated the maneuver.NTSB LAX08CA126Accident · Serious injuriesData collectionFinal reportRobinson R22 Beta II · Prescott, AZThe instructor's inadequate supervision and delayed remedial action that resulted in ground contact and a rollover.NTSB SEA08CA113Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Waitsburg, WAThe pilot's failure to maintain clearance from the terrain while maneuvering at low altitude. Contributing to the accident was the rising terrain.NTSB DFW08LA108Accident · Serious injuriesLimited investigationFinal reportWoods Challenger II · Corning, ARThe pilot's failure to maintain clearance from transmission lines. A contributing factor was the low altitude selected by the pilot.NTSB DFW08CA104Accident · Serious injuriesData collectionFinal reportAir Tractor AT-602 · Paragould, ARThe pilot's failure to maintain clearance from electrical wires while maneuvering. Contributing to the accident were binding of the elevator control, inadvertent stall and trees.NTSB CHI08CA112Accident · No injuriesData collectionFinal reportPierson RV-6 · Newark, ILThe partial loss of engine power due to the fracture of the number 4 exhaust valve, and the pilot's decision to shut-down the engine without sufficient altitude to ensure a safe glide path to the runway. Contributing to the accident was the barbed wire fence…NTSB DEN08LA081Accident · Minor injuriesLimited investigationFinal reportEnstrom F28C · Mosby, MOA loss of engine power for reasons undetermined, and the pilot's decision to discontinue the autorotation when he thought engine power had been restored. Contributing to the accident were the low altitude and excessive airspeed.NTSB DEN08LA077Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Angleton, TXThe pilot's inadequate visual lookout and his failure to maintain clearance from the tranmission lines. A factor in this accident was the unmarked transmission wires.NTSB SEA08FA108Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Big Bear City, CAThe pilot's failure to maintain altitude/clearance from mountainous terrain. Contributing to the accident were the mountainous terrain, the dark night condition, the turbulent wind condition, and the low clouds.NTSB CHI08CA103Accident · No injuriesData collectionFinal reportKoleno Titan T-51 · Geneva, OHThe failure of the propeller pitch control mechanism during approach. Contributing to the accident were the inability of the pilot to maintain airspeed and altitude, and the unsuitable terrain.NTSB MIA08CA084Accident · No injuriesData collectionFinal reportGrumman American AA5B · Marlboro, MAThe pilot's inadequate compensation for wind gusts while on final approach.NTSB LAX08CA085Accident · No injuriesData collectionFinal reportAyres S2R-600 · Blythe, CAThe pilot's failure to maintain terrain clearance. Contributing factors were the dusk light condition and the pressure the pilot felt to accomplish the flight.NTSB LAX08CA082Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164B · Colfax, WAThe pilot's inadequate compensation for the wind conditions, failure to attain and maintain an adequate airspeed that resulted in a stall mush, and, the subsequent failure to maintain terrain and obstacle clearance during the takeoff initial climb.…NTSB LAX08CA091Accident · No injuriesData collectionFinal reportBeech F90 · Idaho Falls, IDthe pilot's misjudged distance and airspeed that led to a failure to attain the proper touchdown point and a runway overrun. Contributing factors were the snow and muddy conditions off the runway.NTSB MIA08FA080Accident · 2 fatalField investigationFinal reportCessna 182B · Wildwood, FLThe noninstrument rated pilot's failure to maintain terrain clearance at night in marginal visual flight conditions. Contributing to the accident was the dark night, and low cloud ceilings.NTSB SEA08CA091Accident · No injuriesData collectionFinal reportBell 206B · Oxnard, CAThe pilot's failure to maintain clearance with terrain during an aerial application.NTSB DFW08FA078Accident · 1 fatalField investigationFinal reportCessna 172M · Gun Barrel City, TXThe pilot's failure to avoid the transmission line. A contributing factor was the pilot's decision to perform a low-level maneuver.NTSB NYC08CA128Accident · No injuriesData collectionFinal reportPiper PA 32-300 · Apopka, FLThe pilot's failure to maintain clearance/altitude while on the final leg of the approach.NTSB DEN08FA059Accident · 2 fatalField investigationFinal reportCessna 414A · Benton, KSThe pilot's failure to maintain clearance from the trees. Contributing to the accident was the pilot's flight into known adverse weather conditions and the low clouds and visibility.NTSB SEA08CA081Accident · Minor injuriesData collectionFinal reportSteven Hardie AIR CAM · Duncan Mills, CAThe pilot's failure to maintain clearance with power lines while maneuvering at a low altitude. Contributing factors included the pilot's decision to fly at low altitude and the sun glare condition.