NTSB investigations, NC
261 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\" = 'NC' 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" = 'NC' 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 GAA17CA028Accident · Minor injuriesData collectionFinal reportNewkirk Thomas Ray Vans RV 6 · Garland, NCThe pilot's improper landing flare, which resulted in a bounced landing on the grass runway.NTSB GAA16CA494Accident · No injuriesData collectionFinal reportBeech B23 · Raleigh, NCThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB ERA16CA302Accident · No injuriesData collectionFinal reportBeech B200 · Burnsville, NCA collision with a bush during landing.NTSB GAA16CA383Accident · No injuriesData collectionFinal reportAeronca 7AC · Lenoir, NCThe pilot's encounter with instrument meteorological conditions, which resulted in an emergency descent through fog, a runway overrun on a wet grass runway, and a collision with a ditch and vegetation. Contributing to the accident was the pilot's failure to…NTSB ERA16LA209Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M 18A · Brunswick, NCThe failure of the right wing due to a fatigue fracture of the right outboard wing forward spar lower fitting. Contributing to the accident was the routine operation of the airplane over its certificated maximum gross weight and the operator's improper or…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 ERA16LA162Accident · Minor injuriesClass 3 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2008 · Burgaw, NCThe pilot’s failure to activate the airplane’s alternator, which resulted in an eventual loss of electrical power to the engine’s fuel pumps, fuel starvation, and a total loss of engine power. Contributing was the pilot’s use of an incomplete checklist.NTSB GAA16CA183Accident · Minor injuriesData collectionFinal reportPiper PA22 · Pantego, NCA loss of directional control during the takeoff roll in gusting wind conditions, which resulted in a runway excursion, a nose over, and an impact with terrain. Contributing to the accident was the pilot's decision to takeoff in gusting crosswind conditions.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 ERA16FA108Accident · 1 fatalField investigationFinal reportBeech A36 · Marshville, NCThe pilot's improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the severity of the pilot's injuries was his failure to have a properly secured shoulder harness at the time of the accident.NTSB ERA16LA085Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Concord, NCThe pilot’s inadequate management of the airplane’s automated systems, which resulted in a loss of control during an instrument approach and necessitated his subsequent deployment of the airplane’s parachute system.NTSB GAA16CA099Accident · No injuriesData collectionFinal reportDavis Michael J MD Special · Wallace, NCThe pilot's improper fuel planning, which resulted in fuel exhaustion.NTSB GAA16CA082Accident · No injuriesData collectionFinal reportAeronca 7BCM · Reidsville, NCThe pilot's loss of pitch control while maneuvering at low altitude, which resulted in a collision with terrain, a left main landing gear collapse, and runway excursion.NTSB ERA16LA067Accident · Serious injuriesLimited investigationFinal reportGolden Circle Air T Bird II · Lenoir, NCThe pilot’s failure to maintain airspeed and a coordinated turn in the traffic pattern, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall and spin. Contributing to the accident was the pilot’s failure to…NTSB ERA16LA059Accident · No injuriesLimited investigationFinal reportPacific Aerospace 750XL · Raeford, NCThe pilot's failure to obtain the proper touchdown point and speed during a precautionary landing with the engine shut down. Contributing to the accident was an erroneous engine torque indication, which led the pilot to shut the engine down, for reasons that…NTSB ERA16LA045Accident · Serious injuriesLimited investigationFinal reportPhantom Aeronautics Phantom X 1 · Monroe, NCThe partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any preimpact anomalies that would have precluded normal operation.NTSB ERA16LA041Accident · No injuriesLimited investigationFinal reportWoodrow Larry W Sonex · Morganton, NCThe pilot/owner’s inadequate maintenance inspection following a propeller strike, which resulted in the subsequent in-flight propeller separation due to propagation of fatigue cracks in the crankshaft.NTSB ERA16LA040Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Jefferson, NCA total loss of engine power for reasons that could not be determined during a postaccident test run of the engine.NTSB ERA16CA011Accident · No injuriesData collectionFinal reportPiper PA-32RT-300T · Salisbury, NCThe pilot's inadvertent switching of the fuel selector to the "off" position on final approach, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA15CA272Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Sanford, NCThe student pilots failure to maintain a climb after takeoff, which resulted in an impact with terrain.NTSB ERA15FA340Accident · 3 fatalField investigationFinal reportBeech A36 · Kernersville, NCThe pilot's loss of airplane control due to spatial disorientation, which resulted in an aerodynamic stall/spin. Contributing to the accident was deficient Federal Aviation Administration air traffic control training on recognition and handling of…NTSB ERA15LA343Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC-6 · Louisburg, NCThe propeller’s movement to the beta position during landing for reasons that could not be determined during postaccident examination and testing, which resulted in an attempted go-around and subsequent loss of airplane control.NTSB ERA15FA335Accident · 2 fatalField investigationFinal reportCooper Michael C RV 8A · Advance, NCThe pilots' failure to maintain airplane control during a low-altitude maneuver.NTSB ERA15CA321Accident · Serious injuriesData collectionFinal reportQuicksilver MXL II Sport · Pittsboro, NCThe pilot's failure to open the fuel shutoff valve during the preflight examination of the airplane which resulted in a total loss of engine power during initial climb after takeoff due to fuel starvation.NTSB ERA15CA320Accident · Minor injuriesData collectionFinal reportSanderson Herbert H SHA Glasair · Bladenboro, NCThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a ditch.NTSB GAA15CA212Accident · Minor injuriesData collectionFinal reportMain Air Rapier · Reidsville, NCThe student pilot landed with variable wind conditions, which resulted in an in-flight loss of control and subsequent impact with terrain.NTSB ERA15LA281Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A188B · Albertson, NCThe pilot’s failure to maintain clearance from wires during takeoff due to his impairment from alcohol use.NTSB GAA15CA192Accident · No injuriesData collectionFinal reportCessna R172K · Fairfield, NCThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and impact with terrain.NTSB GAA15CA190Accident · No injuriesData collectionFinal reportPiper PA 32-300 · Greensboro, NCThe pilot's decision to continue the approach after realizing the intended parameters were not attainable, resulting in a runway over-shoot, a loss of control on the ground and the consequent collision with trees.NTSB GAA15CA185Accident · No injuriesData collectionFinal reportBarron Starduster SA 300 · Whiteville, NCThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion and a collision with terrain.NTSB ERA15FA245Accident · 1 fatalField investigationFinal reportCzech Sport Piper Sport · Holly Ridge, NCThe pilot’s failure to maintain airplane control after the cockpit canopy opened during initial climb. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.NTSB ERA15LA231Accident · 1 fatalLimited investigationFinal reportBeech A36 · Siler City, NCThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall.NTSB GAA15CA115Accident · Minor injuriesData collectionFinal reportSmiley James E RAG Wing RW-6 · Mocksville, NCThe pilot's loss of directional control during takeoff, which resulted in a runway excursion and impact with a building.NTSB GAA15CA098Accident · No injuriesData collectionFinal reportSchweizer SGS 1 26B · Mocksville, NCThe glider pilot over-ran the runway and impacted a structure after encountering a strong updraft on short final.NTSB GAA15CA072Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA40 · Fuquay-Varina, NCThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a runway overrun.NTSB GAA15CA017Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Greensboro, NCThe pilot's failure to maintain directional/pitch control during final approach, resulting in a collision with terrain.NTSB ERA15CA154Accident · No injuriesData collectionFinal reportBeech 58 · Monroe, NCThe pilot's failure to maintain a proper glidepath and failure to perform a go-around once a safe landing could not accomplished, which resulted in a landing area overshoot and runway excursion.NTSB ERA15FA128Accident · 1 fatalField investigationFinal reportPiper PA28 · Greensboro, NCA total loss of engine power after takeoff due to fuel starvation as a result of excessive wear of the fuel selector valve. Also causal was the owner/operator and maintenance personnel's inadequate maintenance, and inadequate postmaintenance inspection.NTSB ERA15LA092Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Long View, NCThe improper installation of the lower rear crankshaft counterweight snap rings by unknown maintenance personnel, which resulted in the separation of the counterweight and a subsequent total loss of engine power during initial climb.NTSB ERA15FA023Accident · 1 fatalField investigationFinal reportBeech D95 · Bahama, NCThe pilots' failure to maintain adequate airspeed during climb, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the flight instructor's decision to conduct a…NTSB ERA14LA411Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Creedmoor, NCThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s impairment due to alcohol ingestion.NTSB ERA14CA373Accident · Minor injuriesData collectionFinal reportPiper PA-46-350P · Statesville, NCThe pilot's failure to maintain a proper glide path and airspeed on final approach, which resulted in a long landing and runway excursion.NTSB ERA14LA361Accident · No injuriesLimited investigationFinal reportHiller UH 12E · Wadesboro, NCA partial loss of engine power due to the failure of the No. 2 engine accessory gearbox bearing for reasons that could not be determined based on the available information.NTSB ERA14CA349Accident · No injuriesData collectionFinal reportPekola James W Ridge Runner III · Andrews, NCThe pilot's failure to open the fuel tank valves during the preflight examination of the airplane, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA14CA335Accident · No injuriesData collectionFinal reportAlexander Schleicher K 7 · Mocksville, NCThe pilot's decision to install an additional cushion to elevate his passenger and his failure to insure the cushion would not interfere with the control stick movement resulting in limited movement of the elevator in flight and collision with a fence during…NTSB ERA14LA338Accident · Serious injuriesLimited investigationFinal reportLawson Ronald S Explorer · East Bend, NCA total loss of engine power likely due to a failure of a rotary valve shaft seal and the pilot’s failure to detect and diagnose the impending failure during the preflight inspection.NTSB ERA14FA256Accident · 1 fatalField investigationFinal reportStolp Starduster SA-300 · Newton, NCThe pilot’s failure to recover from an intentional spin. Contributing to the accident was the pilot’s lack of adequate spin entry and recovery training.NTSB ERA14CA270Accident · No injuriesData collectionFinal reportWonder Michael S Harmon Rocket · Winston Salem, NCThe pilot's failure to maintain directional control during landing in a gusty crosswind which resulted in a runway excursion and collision with terrain.NTSB ERA14CA233Accident · Minor injuriesData collectionFinal reportPiper PA 28-180 · Indian Trail, NCThe pilot's improper flap retraction during a short field takeoff, which resulted in the aircraft experiencing an aerodynamic stall and impact with trees.