NTSB investigations, NC
25 cases where NTSB found Altitude.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2011 | 3 |
| 2013 | 4 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 4 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2022 | 2 |
| 2024 | 1 |
| 2026 | 1 |
Where
Open the mapLatest 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\" = 'NC' 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\", '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."eventStateOrRegion" = 'NC' 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", '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 ERA26LA138Accident · Minor injuriesClass 4 · LimitedFinal reportGlasflugel Kestrel · Little Switzerland, NCA loss of thermal lift during a glider flight, which resulted in a collision with trees during a landing approach to a diversionary airport.NTSB ERA24LA321Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Pisgah Forest, NCThe pilot’s failure to maintain proper altitude and airspeed on final approach, resulting in a runway excursion and substantial damage to the airplane.NTSB ERA22LA356Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182C · Holly Ridge, NCThe pilot’s failure to maintain clearance of powerlines on final approach.NTSB ERA22LA274Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Brevard, NCThe pilot’s failure to maintain altitude while maneuvering the airplane at a low altitude, which resulted in impact with trees and terrain.NTSB ERA21LA322Accident · No injuriesClass 3 · LimitedFinal reportDiamond DA42 · Hiddenite, NCThe flight instructor’s inability to stop the descent following a practice emergency descent for reasons that could not be determined.NTSB ERA19LA157Accident · Serious injuriesClass 3 · LimitedFinal reportBarrows Bearhawk LSA · Holly Springs, NCThe pilot's failure to maintain clearance from powerlines during the visual approach.NTSB ERA18FA180Accident · 1 fatalField investigationFinal reportCessna 150J · Manteo, NCA loss of control due to the banner tow rope becoming entangled with the left horizontal stabilizer in crosswind conditions.NTSB ERA17MA316Accident · 4 fatalClass 2 · MajorFinal reportEurocopter Deutschland MBB BK 117 · Hertford, NCA failure of the rear bearing in the No. 2 engine, which (1) created multiple and likely unexpected and confusing cockpit indications, resulting in the pilot's improper diagnosis and subsequent erroneous shutdown of the No. 1 engine, and (2) the resulting…NTSB ERA17LA102Accident · Serious injuriesClass 3 · LimitedFinal reportShell John Super SIX · Morganton, NCA loss of engine power and impact with trees and terrain for reasons that could not be determined based on the available information.NTSB ERA16LA301Accident · Minor injuriesLimited investigationFinal reportMeans Rober C Rotorway Exec · Iron Station, NCThe pilot’s failure to maintain adequate clearance from the ground while hovering, which resulted in separation of the forward section of the right skid tube with counterweight attached, a sudden center of gravity (CG) shift outside the normal operating…NTSB ERA16FA169Accident · 1 fatalField investigationFinal reportPiper PA32 · Boone, NCThe pilot's delayed decision to conduct a go-around following an unstabilized landing approach and his subsequent failure to maintain clearance from trees near the end of the runway.NTSB GAA16CA173Accident · Minor injuriesData collectionFinal reportBeech F35 · Long Island, NCThe pilot's decision to maneuver at low altitude, which resulted in a collision with power lines and substantial damage to the vertical stabilizer.NTSB GAA16CA160Accident · Minor injuriesData collectionFinal reportRobinson R44 · Oak Island, NCThe student pilot's failure to maintain a stabilized hover, resulting in a loss of control and an impact with terrain.NTSB ERA15FA351Accident · 1 fatalField investigationFinal reportCessna 172 · Riegelwood, NCThe noncertificated pilot’s failure to maintain adequate clearance from terrain for reasons that could not be determined based on the available evidence.NTSB ERA14CA126Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Ventus 2B · Burnsville, NCThe pilot's improper use of the spoilers, which resulted in an uncontrolled descent and subsequent impact with trees.NTSB ERA13CA245Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1-23H-15 · Yadkinville, NCThe pilot's improper altitude management while maneuvering for an off-airport landing, which resulted in a collision with trees.NTSB ERA13CA272Accident · No injuriesData collectionFinal reportPdps Pzl-Bielsko SZD-55-1 · Henderson, NCA loss of aerodynamic lift that resulted in a forced landing to unsuitable terrain.NTSB ERA13LA238Accident · No injuriesLimited investigationFinal reportSteele Ralph Bruce Steen Skybolt · Windsor, NCThe pilot's decision to initiate an aerobatic maneuver with insufficient altitude to recover before ground impact.NTSB ERA13LA113Accident · 1 fatalLimited investigationFinal reportPiper PA-34-200T · Manteo, NCThe pilot's attempted visual flight in instrument meteorological conditions while maneuvering at a low altitude in the traffic pattern, which resulted in spatial disorientation and impact with the water. Contributing was the pilot's lack of experience flying…NTSB ERA12CA043Accident · Minor injuriesData collectionFinal reportFehlner-Shelton Aerosport Scamp WTB1 · Grantham, NCThe pilot's inadequate clearance from unmarked power lines while on approach to land at a private airport.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 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 ERA10CA011Accident · No injuriesData collectionFinal reportRemos Remos G-3/ · Sims, NCThe pilot's failure to maintain altitude, resulting in controlled flight into water.NTSB ERA09CA134Accident · Serious injuriesData collectionFinal reportPiper PA-32R-300 · Manteo, NCThe pilot's failure to follow the missed approach procedure while landing with a low ceiling.NTSB NYC08CA097Accident · Minor injuriesData collectionFinal reportChristen Industries Eagle II · Boone, NCThe pilot's failure to maintain clearance/altitude while on the final leg of the traffic pattern. Contributing to the accident were the proximity of the trees to the threshold, and the lack of a displaced threshold.