NTSB investigations
794 cases where the sequence of events included Low altitude operation/event.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '220' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '220' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 SEA08LA200Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Napavine, WAThe pilot's decision to make a low-altitude pass, and his failure to maintain clearance from all structures while maneuvering.NTSB MIA08CA170Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · Satartia, MSThe pilot's inadequate visual lookout resulting in the in-flight collision with a 40-foot-tall antenna.NTSB MIA08LA167Accident · 1 fatalLimited investigationFinal reportAyres S2R-T15 · Morton, MSThe pilot’s failure to maintain clearance from trees during low altitude maneuvering.NTSB CHI08CA252Accident · No injuriesData collectionFinal reportHiller UH-12E · Cokato, MNThe pilot did not visually identify and maintain clearance with the power lines, and the pilot's inability to maintain control of the helicopter once it contacted the power lines. Factors associated with the accident were the low altitude operations being…NTSB LAX08FA267Accident · 1 fatalField investigationFinal reportCessna TR182 · Sahuarita, AZThe pilot’s failure to maintain clearance from mountainous terrain while maneuvering at low altitude for undetermined reasons.NTSB NYC08CA279Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Tunica, MSThe pilot's failure to maintain clearance from the power lines during low-altitude maneuvers.NTSB LAX08LA266Accident · 1 fatalLimited investigationFinal reportBowman Titan Tornado II · Needles, CAThe pilot's failure to maintain clearance from a vehicle during a low-altitude flight over a highway.NTSB CHI08CA243Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Cosmos, MNThe pilot's failure to maintain clearance from the guide wire while maneuvering on an aerial application flight. Contributing to the accident was the presence of the guide wire.NTSB SEA08FA174Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Monticello, UTThe pilot's failure to maintain clearance from terrain while maneuvering. Contributing to the accident was the low altitude.NTSB MIA08LA161Accident · 1 fatalLimited investigationFinal reportGT Ultralights Airborne Edge X · Franklin, METhe pilot's improper decision to perform low-altitude maneuvers and his failure to maintain clearance from the surface of the bay. Contributing to the accident was the pilot's impairment due to alcohol.NTSB NYC08LA263Accident · 1 fatalLimited investigationFinal reportOsborne Challenger II · Fairdealing, KYThe pilot's failure to maintain adequate airspeed while climbing into rising terrain at low altitude, which resulted in an aerodynamic stall and uncontrolled descent.NTSB SEA08CA168Accident · Minor injuriesData collectionFinal reportWSL PZL Mielec · Caldwell, IDThe pilot failed to maintain clearance from a power line while maneuvering. Contributing to the accident was a vehicle.NTSB CHI08CA220Accident · Minor injuriesData collectionFinal reportAir Tractor AT-401 · Lake View, IAThe pilot not obtaining/maintaining altitude/clearance from the power line while performing an aerial application maneuver.NTSB DFW08LA197Accident · 1 fatalLimited investigationFinal reportMarshall James J Cozy MK IV · Midlothian, TXThe pilot's failure to maintain clearance from the wall of the rock quarry.NTSB CHI08CA212Accident · No injuriesData collectionFinal reportAyres S2R-T34 · Clinton, ILThe inadequate in-flight planning/decision making and the altitude/clearance not maintained by the pilot during the aerial application. A contributing factor was the guy wire.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 DEN08FA122Accident · 2 fatalField investigationFinal reportHughes 269B · Salesville, ARThe pilot's failure to maintain clearance from the crossing transmission line.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 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 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 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 SEA08FA146Accident · 2 fatalField investigationFinal reportCessna 172R · Monticello, UTThe in-flight collision with mountainous terrain for undetermined reasons. *This report was modified on December 10, 2009.NTSB DFW08LA143Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Wheatley, ARThe pilot's failure to maintain airspeed, resulting in an inadvertent low-altitude aerodynamic stall.NTSB SEA08LA128Accident · Serious injuriesLimited investigationFinal reportMoravan Zlin 50LX · Modesto, CAThe pilot failed to maintain clearance from terrain during a low-altitude maneuver at an airshow. Contributing to the accident was the task overload in the increased frequency congestion.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 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 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 CHI08LA101Accident · 2 fatalLimited investigationFinal reportCessna 172K · Roseglen, NDThe pilot failed to maintain obstacle clearance from the TV antenna during a low altitude maneuver. Contributing factors were the antenna, the night conditions, and pilot impairment due to alcohol.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 SEA08CA091Accident · No injuriesData collectionFinal reportBell 206B · Oxnard, CAThe pilot's failure to maintain clearance with terrain during an aerial application.NTSB NYC08WA131Accident · 10 fatalForeign investigationBell 412EP · Santa Cruz, PeruNTSB 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.NTSB CHI08LA080Accident · 1 fatalLimited investigationFinal reportCessna 140 · Grand Meadow, MNThe pilot's continued visual flight into an area of known instrument meteorological conditions in an airplane not equipped for instrument flight, and his failure to maintain control of the airplane while maneuvering at low altitude.NTSB CHI08CA079Accident · No injuriesData collectionFinal reportCessna 172RG · Litchfield, ILThe pilot's intentional low altitude flight and his failure to maintain clearance from the static wire. Contributing to the accident were the static wire, the partial loss of engine power due to propeller vibration, and the muddy field in which the forced…NTSB MIA08FA052Accident · 1 fatalField investigationFinal reportKaylor J E/Strahlmann R L RV-4 · Elkin, NCThe pilot's decision to attempt an aerobatic maneuver in close proximity to the ground.NTSB SEA08LA070Accident · 1 fatalLimited investigationFinal reportKidd Chris Harmon ROC · Maricopa, CAThe pilot's failure to maintain an adequate terrain clearance altitude while maneuvering in mountainous, hilly terrain. Contributing to the accident were hilly terrain, a low ceiling and gusty winds.NTSB LAX08CA054Accident · No injuriesData collectionFinal reportBell OH-58A · Brawley, CAThe pilot's failure to maintain clearance from obstacles. A factor in the accident was the dark night conditions.NTSB SEA08LA058Accident · 1 fatalLimited investigationFinal reportCorsario MK-5 · Perris, CAThe pilot's failure to maintain clearance from terrain while maneuvering.