NTSB investigations, NE
95 cases where the sequence of events included Collision with terr/obj (non-CFIT).
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.\"eventStateOrRegion\" = 'NE' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' 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."eventStateOrRegion" = 'NE' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' 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 CEN17LA181Accident · 1 fatalLimited investigationFinal reportAS+ AC 4 · Blair, NEThe pilot's loss of control due to his diverted attention as he attempted to close the canopy that opened during initial climb.NTSB GAA17CA127Accident · No injuriesData collectionFinal reportVaughan Gerald R Side Winder TD · McCook, NEThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB GAA16CA470Accident · No injuriesData collectionFinal reportCessna 182 · Diller, NEThe pilot's failure to go around after overshooting his intended touchdown point, which resulted in impact with farm equipment and terrain during an aborted landing attempt.NTSB CEN16LA291Accident · 1 fatalLimited investigationFinal reportAir Tractor AT602 · David City, NEThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN16FA282Accident · 2 fatalField investigationFinal reportBeech 95 B55 (T42A) · Leshara, NEThe pilot's loss of airplane control during a practice stall maneuver, which resulted in a spin that continued to ground impact.NTSB CEN16LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA 18-150 · Cozad, NEAn in-flight loss of control for reasons that could not be determined because examination of the wreckage did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.NTSB CEN16FA130Accident · 1 fatalField investigationFinal reportAeronca 7AC · Ellsworth, NEThe pilot's impairment due to carbon monoxide poisoning from a known cracked engine exhaust muffler, which resulted in a loss of aircraft control. Contributing to the accident was the pilot's decision to continue flying the airplane without properly repairing…NTSB CEN16FA073Accident · 1 fatalField investigationFinal reportCessna 172N · Wayne, NEThe noninstrument-rated pilot's improper decision to continue visual flight into instrument meteorological conditions, which resulted in a collision with terrain.NTSB GAA15CA266Accident · Minor injuriesData collectionFinal reportSchweizer G 164B · Paxton, NEThe pilot's failure to maintain adequate distance from a power line during low altitude flight operations, which resulted in an impact with the power line, and subsequent impact with the ground.NTSB CEN15LA389Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT 502B · Monroe, NELoss of propeller thrust for reasons that could not be determined, since examination of the airplane's engine, propeller, and associated accessories revealed no anomalies.NTSB CEN15LA343Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Hartington, NEThe pilot’s decision to use an excessive, unapproved flap setting for takeoff, which significantly increased the induced drag and resulted in an aerodynamic stall when the airplane flew out of ground effect.NTSB CEN14CA395Accident · No injuriesData collectionFinal reportCessna A188B · Milford, NEThe pilot's improper engine mixture setting which reduced available engine power, and his inadvertent retraction of flaps which resulted in an impact with crops and terrain.NTSB CEN14LA131Accident · No injuriesLimited investigationFinal reportCessna R182 · Eustis, NEA catastrophic engine failure, which was initiated by the failure of the No. 5 connecting rod cap.NTSB CEN14CA063Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Burwell, NEAn inadvertent collision with a deer during landing.NTSB CEN13CA530Accident · No injuriesData collectionFinal reportAeronca 7EC · Plattsmouth, NEThe pilot's loss of control during takeoff.NTSB CEN13FA429Accident · No injuriesField investigationFinal reportPiper PA-28R-201T · Holdrege, NEThe loss of engine power during takeoff due to the activation of the primer diverter valve.NTSB CEN13LA371Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Campbell, NEThe pilot's decision to continue with the takeoff roll despite the airplane's difficulty becoming airborne The high-density altitude likely contributed to the airplane's reduced performance.NTSB CEN13LA171Accident · No injuriesLimited investigationFinal reportPiper PA46 · Grand Island, NEThe pilot's failure to maintain airplane control after engine start.NTSB CEN13FA130Accident · 4 fatalField investigationFinal reportRaytheon 58 · Maxwell, NEThe pilot’s inadvertent encounter with severe icing conditions, which resulted in structural icing and the subsequent loss of airplane control.NTSB CEN13FA081Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Blair, NEThe pilot's loss of control due to physical incapacitation.NTSB CEN13FA045Accident · 1 fatalField investigationFinal reportCessna 150F · Gothenburg, NEThe student pilot’s failure to maintain adequate airspeed on final approach, which resulted in an inadvertent aerodynamic stall and subsequent impact with terrain.NTSB CEN12CA666Accident · Serious injuriesData collectionFinal reportBarche Destiny XLT · Springfield, NEThe pilot’s decision to continue the takeoff when the chute oscillations were initially detected.NTSB CEN12CA403Accident · No injuriesData collectionFinal reportAyres S2R-G10 · Minden, NEThe pilot’s failure to maintain clearance from the wake turbulence from a previous pass.NTSB CEN12LA302Accident · Serious injuriesLimited investigationFinal reportTroyer Kitfox 3 · Elm Creek, NEThe pilot’s failure to verify the amount of oil in the injection oil reservoir before takeoff, which resulted in an insufficient fuel/oil ratio and subsequent loss of engine power.NTSB CEN12CA285Accident · Minor injuriesData collectionFinal reportChampion 7GCBC · Genoa, NEThe pilot’s loss of directional control of the airplane during an aborted landing. Contributing to the accident was the pilot’s improper flare.NTSB CEN12FA210Accident · 1 fatalField investigationFinal reportBeech E-55 · Broken Bow, NEThe pilot’s failure to maintain airspeed and subsequent loss of airplane control during a single-engine landing approach. Contributing to the accident was the pilot's improper fuel management during cruise flight, which resulted in an initial loss of power in…NTSB CEN12CA148Accident · No injuriesData collectionFinal reportPiper PA-18 · Thedford, NEThe pilot did not maintain directional control during landing, which resulted in a runway excursion.NTSB CEN11FA616Accident · 2 fatalField investigationFinal reportLarson Ken W Christen EAGLE-II · Seward, NEThe pilot’s inadvertent pulling of the mixture control lever on takeoff, which shut down the engine.NTSB CEN11CA631Accident · No injuriesData collectionFinal reportCessna A188 · Ord, NEThe pilot's loss of directional control during a crosswind takeoff.NTSB CEN11CA526Accident · No injuriesData collectionFinal reportPiper PA-36-375 · Cambridge, NEThe pilot's failure to reset the engine's mixture control lever to the full rich position prior to takeoff.NTSB CEN11LA316Accident · 1 fatalLimited investigationFinal reportNorris Dominator · Blue Springs, NEThe pilot's failure to maintain clearance from power lines.NTSB CEN11FA079Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Norfolk, NEThe pilot’s decision to continue the flight into instrumental meteorological conditions which resulted in a collision with a tree.NTSB CEN10CA539Accident · No injuriesData collectionFinal reportCessna A185F · Rushville, NEThe pilot's failure to maintain directional control of the airplane during takeoff. Contributing to the accident was the loss of visual reference due to the sun glare.NTSB CEN10CA544Accident · No injuriesData collectionFinal reportPiper PA22 · Atkinson, NEThe pilot's failure to maintain directional control while landing with a crosswind.NTSB CEN10LA463Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-802A · Lindsay, NEThe loss of airplane control for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation and evidence was insufficient to definitively establish whether the…NTSB CEN10CA013Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Bingham, NEThe pilot's impairment due to alcohol consumption and failure to maintain aircraft control.NTSB CEN09LA574Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Kimball, NEA loss of engine power due to improper installation of an oil line fitting resulting in oil depletion.NTSB CEN09LA350Accident · 1 fatalLimited investigationFinal reportPeterson Allen L Dragonfly II · Arthur, NEThe pilot's continued visual flight into instrument meteorological conditions. Contributing to the accident was the pilot's impairment due to the use of a over-the-counter medication with sedative effects and spatial disorientation.NTSB CEN09LA190Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A · Wood Lake, NEThe pilot's failure to maintain adequate airspeed during the initial climb, which resulted in an aerodynamic stall.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 DFW08CA188Accident · No injuriesData collectionFinal reportBell 47G-3B · Mullen, NEThe plot's distraction with the chemical load resulting the failure to maintain control of the helicopter. A factor was no suitable terrain for landing.NTSB DEN08FA100Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau EA 300/L · Gothenburg, NEThe pilot's failure to maintain aircraft control after encountering instrument meteorological conditions. Contributing to the accident were the pilot's recent usage of Marihuana, his impaired judgement and decision making, and the low visibility weather…NTSB DFW08CA120Accident · No injuriesData collectionFinal reportHughes 269A · Lincoln, NEThe pilot's failure to properly execute a steep approach, which resulted in a tail strike and a loss of control.NTSB CHI08CA089Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Scribner, NEThe inadequate compensation for wind conditions and the directional control not obtained/maintained by the pilot during landing. A contributing factor was the crosswind.NTSB CHI08IA065Incident · No injuriesIncident investigationFinal reportBoeing 737-2H4 · Lincoln, NEThe improper installation of the swivel valve fittings by the operator's mechanic leading to the total loss of both hydraulic systems. Contributing to the incident were the swivel valves leaking and the total failure of the hydraulic system.