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 ERA12FA008Accident · 1 fatalField investigationFinal reportAviat A-1 · Moyock, NCThe operation of the airplane by a non-certificated pilot, and his failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.NTSB ERA11FA504Accident · 1 fatalField investigationFinal reportHutchinson Kenneth A Velocity RG · Sanford, NCThe pilot/owner's intentional flight of his airplane with known mechanical discrepancies (frozen turbocharger waste gate), which resulted in a partial loss of engine power and subsequent collision with trees and terrain shortly after takeoff. Contributing to…NTSB ERA11CA485Accident · Minor injuriesData collectionFinal reportHaines Joseph E SHA-GLASAIR · Beaufort, NCThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB ERA11LA459Accident · Serious injuriesLimited investigationFinal reportEvans Robert W SR Pegazair 100 · Maysville, NCThe student pilot's failure to maintain adequate airspeed during initial takeoff climb, which resulted in an aerodynamic stall.NTSB ERA11LA457Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Graham, NCThe individual's fuel mismanagement, which resulted in fuel exhaustion and a subsequent engine failure. Contributing the accident was the individual’s failure to maintain adequate airspeed following the engine failure, which resulted in an aerodynamic stall.NTSB ERA11FA426Accident · 1 fatalField investigationFinal reportTaylorcraft BL-65 · Winterville, NCA loss of airplane control for undetermined reasons as the autopsy was unable to reveal any definitive conditions that would have led to the loss of control.NTSB ERA11FA412Accident · 2 fatalField investigationFinal reportCessna 182S · Erwin, NCThe pilot’s loss of control due to spatial disorientation while maneuvering in dark night conditions.NTSB ERA11CA364Accident · Minor injuriesData collectionFinal reportHelio H-295 · Brasstown, NCThe pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA11LA359Accident · Serious injuriesLimited investigationFinal reportNavion Navion B · Red Oak, NCThe pilot's inadvertent movement of the fuel tank selector handle to the off position, resulting in a total loss of engine power due to fuel starvation.NTSB ERA11CA355Accident · No injuriesData collectionFinal reportDotson William P Sngl Seat Hawk Arrow · Carthage, NCA partial loss of engine power due to the pilot’s improper installation of the engine’s No. 1 cylinder spark plugs.NTSB ERA11LA342Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA-5A · Linden, NCA partial loss of engine power during initial climb for undetermined reasons.NTSB ERA11FA312Accident · 4 fatalField investigationFinal reportBeech 58 · Murphy, NCAn in-flight fire that mostly likely occurred in the right front cockpit area behind the instrument panel and below the glare shield; the origin of the fire could not be determined because of the extensive fire damage.NTSB ERA11FA285Accident · 2 fatalField investigationFinal reportHebert Peter J Lancair Legacy · Richlands, NCThe pilot's improper in-flight fuel management, which resulted in a loss of engine power due to fuel starvation.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 ERA11CA181Accident · Minor injuriesData collectionFinal reportCessna 172K · Ocracoke, NCThe pilot’s inadequate flare and failure to regain control of the airplane while attempting to recover from bounced landing.NTSB ERA11CA174Accident · Serious injuriesData collectionFinal reportPiper J3C-65 · Maysvile, NCThe pilot-rated passenger’s loss of directional control during takeoff and the pilot’s delayed remedial action, which resulted in a runway excursion and collision with trees.NTSB ERA11CA129Accident · Serious injuriesData collectionFinal reportKolb Kolb Mark III · Rutherfordton, NCThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude resulting in a stall/spin and ground impact.NTSB ERA11LA023Accident · Serious injuriesLimited investigationFinal reportBobo Christopher J Loehle 5151 · Southern Pines, NCThe reported fluttering of the wings in flight and the pilot's subsequent in-flight loss of control for undetermined reasons.NTSB ERA10LA423Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Eastover, NCThe uncommanded retraction of the nose gear for undetermined reasons and the pilot's improper decision to continue the takeoff after the propeller began to contact the ground.NTSB ERA10LA424Accident · No injuriesLimited investigationFinal reportW.H. Hunnicutt Hobo · Fletcher, NCA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to select an adequate forced landing site.NTSB ERA10LA374Accident · Serious injuriesLimited investigationFinal reportMulloy Charles Zodiac 601XL · Enochville, NCLoss of engine power due to fuel contamination, and the pilot’s inadequate preflight of the fuel system.NTSB ERA10LA370Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · New Bern, NCInadequate quality control at the fuel servo overhaul facility, which resulted in contamination of the fuel servo and a subsequent loss of engine power due to fuel starvation.NTSB ERA10FA356Accident · 1 fatalField investigationFinal reportCirrus SR20 · Chapel Hill, NCThe pilot's improper recovery from a bounced landing and subsequent improper go-around procedure, which resulted in a loss of directional control, runway excursion, and collision with a tree.NTSB ERA10LA349Accident · No injuriesLimited investigationFinal reportBeech F33A · Mooresville, NCA loss of engine power for undetermined reasons.NTSB ERA10CA343Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Burnsville, NCThe pilot's failure to maintain a proper visual glideslope during final approach.NTSB ERA10LA323Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Asheville, NCThe pilot's failure to maintain forward airspeed, which resulted in a settling with power encounter.NTSB ERA10LA302Accident · 1 fatalLimited investigationFinal reportBeech 60 · Edenton, NCThe flight instructor’s initiation of a simulated single engine scenario at or below the airplane’s minimum single engine control speed, resulting in a loss of airplane control. Contributing to the accident was the flight instructor’s failure to set full…NTSB ERA10CA274Accident · No injuriesData collectionFinal reportCessna T210N · Fuquay-Varina, NCThe pilot's improper decision to land with a tailwind resulting in an overrun.NTSB ERA10CA217Accident · No injuriesData collectionFinal reportMason Aventura II · Greensboro, NCThe pilot's inadequate compensation for a wind gust during the landing approach, which resulted in a loss of directional control.NTSB ERA10CA168Accident · No injuriesData collectionFinal reportAeronca 7AC · Roanoke Rapids, NCThe pilot’s failure to maintain directional control during a crosswind landing/rollout.NTSB ERA10LA146Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Carthage, NCA total loss of engine power during the initial climb after takeoff for undetermined reasons.NTSB ERA10LA077Accident · No injuriesLimited investigationFinal reportCessna 170B · Durham, NCThe total loss of engine power in flight and a fire in the engine compartment for undetermined reasons.NTSB ERA10CA072Accident · Serious injuriesData collectionFinal reportAirframes Unlimited Coyote · Indian Trail, NCA loss of engine power due to carburetor icing.NTSB ERA10LA047Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Fairview, NCA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight fuel planning.NTSB ERA10LA007Accident · 1 fatalLimited investigationFinal reportCase Richard L VAN RV-6 · Magnolia, NCThe pilot's continued visual flight into instrument meterological conditions and his subsequent failure to maintain aircraft control. Contributing to the accident was the pilot's inadequate preflight evaluation of the weather.NTSB ERA09LA483Accident · 2 fatalLimited investigationFinal reportBeech C24R · Sylva, NCThe pilot's failure to maintain an adequate airspeed during an aborted landing, which resulted in an aerodynamic stall.NTSB ERA09CA461Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Rockingham, NCThe pilot's failure to maintain directional control on landing roll out.NTSB ERA09LA454Accident · 1 fatalLimited investigationFinal reportPongracz John M Nieuport 1 · Brasstown, NCThe pilot’s failure to maintain adequate airspeed during climb after takeoff, resulting in an inadvertent stall.NTSB ERA09CA395Accident · Minor injuriesData collectionFinal reportPiper PA-28-235 · Rutherford, NCThe pilot's failure to maintain adequate airspeed while performing a go-around which resulted in a stall.NTSB ERA09LA394Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Hertford, NCThe in-flight collision with terrain for undetermined reasons.NTSB ERA09LA356Accident · 1 fatalLimited investigationFinal reportChris Mitchell Titan Tornado · Chadbourn, NCThe pilot’s failure to maintain aircraft control during initial climb following a loss of engine power. The reason for the power loss was not determined.NTSB ERA09IA331Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Elkin, NCA total loss of engine power due to the failure of the No. 2 piston as a result of a fatigue crack of undetermined origin.NTSB ERA09LA329Accident · 2 fatalLimited investigationFinal reportSorenson Lightning · Brevard, NCBoth pilots failure to maintain adequate airspeed while maneuvering after a loss of engine power for undetermined reasons, which resulted in an aerodynamic stall.NTSB ERA09LA293Accident · Serious injuriesLimited investigationFinal reportGossard Ronald F Kitfox IV · Camden, NCA loss of engine power due to an in-flight separation of the engine muffler exhaust pipe and resulting impingement of hot exhaust gases on the carburetor.NTSB ERA09LA271Accident · No injuriesLimited investigationFinal reportCessna 177 · Kinston, NCA partial loss of engine power due to the failure of the No. 1 cylinder exhaust valve for undetermined reasons.NTSB ERA09LA182Accident · 1 fatalLimited investigationFinal reportMoore Glenn Moronca · Burgaw, NCA partial loss of engine power due to fuel contamination as a result of the pilot's operation of the airplane with a deteriorated fuel tank.NTSB ERA09LA150Accident · 1 fatalLimited investigationFinal reportQuicksilver MXL II Sport · Ellenboro, NCThe pilot's failure to maintain control of the airplane during climbout. Contributing to the accident was the pilot’s lack of experience in the make and model of the airplane.NTSB ERA09LA139Accident · 1 fatalLimited investigationFinal reportHughes OH-6A · Monroe, NCThe pilot-rated-passenger’s failure to maintain clearance from a known wire hazard during low-level maneuvering. Contributing to the accident was the pilot-in-command’s inadequate monitoring of the flight.NTSB ERA09LA106Accident · 1 fatalLimited investigationFinal reportReamer RV7A · Wadesboro, NCThe pilot's failure to maintain adequate airspeed while on approach for a precautionary landing, which resulted in an aerodynamic stall.NTSB ERA09LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · New Bern, NCA loss of engine power for undetermined reasons.