NTSB investigations, NE
16 cases where NTSB found Terrain.
Cases per year
| 2008 | 4 |
|---|---|
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2022 | 1 |
| 2023 | 1 |
Where
Latest cases
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030210'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '030210')) 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 CEN23LA357Accident · No injuriesClass 4 · LimitedFinal reportPiper PA25 · Hartington, NEThe pilot’s misperception of the rising terrain resulting in a collision with crops and terrain.NTSB CEN22LA384Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Kearney, NEThe pilot’s inadequate in-flight planning that resulted in a loss of engine power due to fuel exhaustion.NTSB CEN19LA240Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Blair, NEThe failure of the lower actuator bearing support bracket, which resulted in the misalignment of the clutch actuator, the loss of belt tension on the main rotor drive system, and the subsequent forced landing on sloped terrain.NTSB GAA19CA160Accident · No injuriesData collectionFinal reportPiper PA18 · Rushville, NEThe partial loss of engine power due to the accumulation of carburetor ice, which resulted in a forced landing on rough terrain.NTSB CEN18LA199Accident · Serious injuriesLimited investigationFinal reportAeronca 58B · Tekamah, NEThe partial loss of engine power due to the formation of carburetor ice. Contributing to the accident was the pilot's failure to use carburetor heat and his decision to continue flight with reduced engine power rather than landing the airplane on suitable…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 CEN16FA005Accident · 1 fatalField investigationFinal reportBeech P35 · Chadron, NEThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into rising terrain during cruise flight.NTSB CEN15LA405Accident · No injuriesLimited investigationFinal reportPiper PA-36-375 · Elmwood, NEThe pilot’s decision to take off with the airplane near its maximum gross weight from a runway that did not have sufficient length for the airplane to achieve a normal takeoff and positive climb rate after liftoff.NTSB CEN15LA271Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Foster, NEThe total loss of engine power during a low-level aerial application flight due to fuel exhaustion following the pilot’s inadequate preflight inspection that led to his assumption that sufficient fuel was on board for the flight based on his reliance on a…NTSB CEN14CA348Accident · Minor injuriesData collectionFinal reportZach Vans RV-6A · Wayne, NEThe pilot became distracted and landed short of the runway. Contributing to the accident was the hole in the ground.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 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 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 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.