NTSB investigations, NC
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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' 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' 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 MIA02LA123Accident · Serious injuriesLimited investigationFinal reportCessna CE-182-A · Siler City, NCThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB MIA02LA118Accident · No injuriesLimited investigationFinal reportCessna 150D · Louisburg, NCthe failure of the pilot-in-command to follow emergency procedures after smelling smoke that resulted in an electrical fire, damage to the airplane, and a forced landing.NTSB ATL02LA129Accident · Minor injuriesLimited investigationFinal reportEames Acro Sport · Burlington, NCA total loss of engine power due to fuel starvation. This resulted in a forced landing and subsequent hard landing while maneuvering around trees.NTSB MIA02LA116Accident · No injuriesLimited investigationFinal reportNavion Nav4 · Raleigh, NCthe pilot's inadequate preflight planning, improper fuel consumption calculations, and selection of the auxiliary fuel tank for landing, which resulted in a loss of engine power due to fuel starvation, and forced landing in trees. A factor in this accident…NTSB ATL02LA125Accident · No injuriesLimited investigationFinal reportRotorway Exec 162F · Concord, NCThe pilot's improper use of cyclic while attempting a hover resulting in dynamic rollover.NTSB ATL02LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenville, NCThe pilot's improper preflight planning and fuel management resulting in fuel exhaustion, and the total loss of engine power. The airplane nosed over during a forced landing to a cotton field.NTSB MIA02LA112Accident · No injuriesLimited investigationFinal reportCessna 172S · Kill Devil Hill, NCthe pilot's failure to maintain control of the airplane after an attempted aborted landing, and while braking during the landing roll, which resulted in the airplane departing the end of the runway and impacting with a ditch.NTSB MIA02LA107Accident · Serious injuriesLimited investigationFinal reportCessna P206 · Manteo, NCa total loss of engine power due to the failure of a connecting rod bolt because of fatigue, resulting in damage to the airplane during the subsequent ditching.NTSB ATL02LA132Accident · No injuriesLimited investigationFinal reportCessna 182 · Saint Pauls, NCThe pilots improper flare, during an attempted landing.NTSB ATL02LA114Accident · No injuriesLimited investigationFinal reportBeech 23 · Greensboro, NCThe loss of engine power for undetermined reasons, A factor was the pilot's intentional ground loop during a forced landing.NTSB ATL02FA091Accident · 2 fatalField investigationFinal reportBeech BE-35 · Warsaw, NCThe pilot's physical impairment due to the use of marijuana. The pilot's diminished judgment to continue flight into known instrument flight conditions that resulted in an in-flight loss of control, failure of the right wing due to overstress separation, and…NTSB ATL02LA081Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Smithfield, NCThe pilot's inadequate in-flight planning that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB ATL02FA077Accident · 1 fatalField investigationFinal reportBeech E35 · Blowing Rock, NCThe pilot's continued VFR flight in to known IMC, which resulted in an in-flight collision with trees in mountainous terrain. A factor was low ceiling.NTSB MIA02FA075Accident · Serious injuriesField investigationFinal reportMcDonnell Douglas MD-11 · Charlotte, NCThe failure of the aircraft operator to comply with, in a timely manner, on the No. 2 engine, Boeing Alert Service Bulletin MD11-71A086, resulting in the integrated drive generator feeder cable chaffing through a fire warning loop and failure of the fire…NTSB ATL02FA069Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Apex, NCThe pilot experienced spatial disorientation that resulted in the loss of control and the overload failure of the airframe. A factor was low visibility and ceilings.NTSB MIA02FA067Accident · 1 fatalField investigationFinal reportPiper PA32R-300 · Broadway, NCThe pilot's inadequate visual lookout and his failure to maintain obstacle clearance.NTSB ATL02LA050Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Blowing Rock, NCThe pilot's in-flight decision to continue flight into an area with high winds that resulted in an in-flight encounter with a downdraft and subsequent loss of control of the airplane and collision with terrain.NTSB ATL02LA039Accident · No injuriesLimited investigationFinal reportCessna 172M · Sanford, NCThe pilots failure to maintain directional control during landing roll that resulted in a collision with an airport sign. Factors were wet runway surface and wind gust.NTSB MIA02FA044Accident · 3 fatalField investigationFinal reportPiper PA-46-350P · Raleigh, NCthe pilot's failure to maintain control of the airplane, due to spatial disorientation, while performing a missed approach, resulting in an uncontrolled descent, and subsequent impact with a tree and a house. Factors in this accident were dark night, fog,…NTSB ATL02LA016Accident · Minor injuriesLimited investigationFinal reportWhitty, Philip J. Mustang II · Hampstead, NCA loss of engine power for undetermined reasons, which resulted in a forced landing and subsequent nose over during landing roll. A factor was the soft, unsuitable terrain.NTSB MIA02LA038Accident · No injuriesLimited investigationFinal reportByrd KR-2S · Linden, NCThe pilot's failure to correct a condition where visual contact with the terrain was lost due to sunshine glare, resulting in collision with a tree during final approach for landing.NTSB MIA02LA033Accident · Minor injuriesLimited investigationFinal reportVernon D. Pitts RV-4 · Burgaw, NCThe loss of engine power for undetermined reasons.NTSB MIA02LA021Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Southern Pines, NCThe dislodging of the front crankshaft oil seal for undetermined reasons resulting in loss of engine oil, loss of engine power, and collision with a tree and then the ground during a forced landing.NTSB ATL02FA010Accident · 1 fatalField investigationFinal reportCessna 310Q · Winston Salem, NCImproper installation of the elevator trim tab control rod by maintenance personnel which allowed the control rod to disconnect and jam in the full up position (elevator full down) while in-flight. This resulted in a loss of directional control and subsequent…NTSB ATL02FA003Accident · 2 fatalField investigationFinal reportBell 206B · N. Wilkesboro, NCThe pilot's failure to maintain visual lookout and clearance above obstacles, which resulted in a collision with power lines and subsequent loss of control and collision with terrain.NTSB ATL02LA001Accident · No injuriesLimited investigationFinal reportCessna 172 · Goldsboro, NCThe student pilot's failure to maintain directional control during a touch-and-go landing.NTSB ATL02LA006Accident · No injuriesLimited investigationFinal reportBeech BE-55-T42A · Raleigh, NCThe pilot's improper flare, and improper recovery from a bounced landing.NTSB MIA02LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, NCThe improper flare by the pilot-in-command resulting in a hard landing and subsequent collapse of the nose landing gear due to overload.NTSB ATL01FA109Accident · 1 fatalField investigationFinal reportCessna T-210F · Hendersonville, NCThe pilot's failure to follow the air traffic controllers verbal instructions pertaining to heading and minimum safe vectoring altitude while being vectored for an ILS approach to his destination airport. This resulted in an in-flight collision with trees and…NTSB ATL01LA103Accident · Serious injuriesLimited investigationFinal reportNorth American P51-D · Lincolnton, NCA cooling system failure, that resulted in a total loss of coolant and the subsequent loss of engine power. A factor was the lack of suitable terrain for an emergency landing.NTSB MIA01LA219Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Wilgrove, NCThe failure of maintenance personal to properly reconnect the throttle-cable-to carburetor attachment, resulting in a throttle cable disconnection while in the landing pattern, and collision with trees. A factor in the accident was the failure of the pilot to…NTSB MIA01LA213Accident · Serious injuriesLimited investigationFinal reportAvid Mk-4 · Salisbury, NC, An aileron control system failure during climb due to an improper welded installation by the aircraft homebuilder, resulting in an inflight loss of lateral control, and an inflight collision with the terrain during an uncontrolled descent and landing.NTSB MIA01LA209Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Statesville, NCThe pilot's attempted takeoff with a tail wind and his failure to maintain directional control of the airplane during takeoff resulting in the airplane veering to the left and colliding with trees.NTSB MIA01LA205Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-402A · Whitakers, NCthe pilot's failure to maintain an adequate visual lookout and the proper clearance from obstacles while conducting aerial applications, which resulted in an inflight collision with a power utility pole.NTSB ATL01LA088Accident · Serious injuriesLimited investigationFinal reportW. E. Simmons Max Air Drifter ARV 582 · Collington, NCThe internal seizing of the engine assembly that resulted in a total loss of engine power during climb out.NTSB MIA01FA193Accident · 1 fatalField investigationFinal reportPiper PA-46-350P · Black Mountain, NCThe pilot's continued VFR flight into IMC conditions resulting in the airplane colliding with mountainous terrain.NTSB MIA01LA185Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Mooresville, NCthe pilot's improper fuel consumption calculations, inadequate preflight planning, and failure to refuel the airplane before takeoff, which resulted in a loss of engine power due to fuel exhaustion, and a forced landing in trees.NTSB ATL01LA070Accident · No injuriesLimited investigationFinal reportHughes 369A · Wadesboro, NCThe pilot's inadequate pre-flight planning which resulted in fuel exhaustion and the subsequent loss of engine power. A factor was rough and uneven terrain.NTSB MIA01LA172Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Garner, NCThe pilot's failure to maintain altitude clearance above the terrain while maneuvering, resulting in a collision with the terrain, and subsequent rollover.NTSB MIA01FA165Accident · 1 fatalField investigationFinal reportCessna 150L · Manteo, NCThe pilot's failure to maintain airspeed while maneuvering after releasing a banner resulting in an inadvertent stall and subsequent in-flight collision with terrain.NTSB MIA01LA160Accident · No injuriesLimited investigationFinal reportCessna 182S · Corolla, NCThe pilots failure to maintain directional control during landing flare and touchdown resulting in the airplane touching down on the left side of the runway and the left wing contacting trees.NTSB MIA01LA155Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Kill Devil Hill, NCThe loss of engine power due to fuel starvation for undetermined reasons resulting in the forced landing and subsequent on-ground collision with a sand dune with a resulting nose over. A factor in the accident was the unsuitable terrain encountered during the…NTSB MIA01FA151Accident · 3 fatalField investigationFinal reportMooney M-20J · Monroe, NCThe pilot in command’s failure to maintain airspeed while maneuvering to avoid objects, resulting in a stall/mush and collision with the terrain during uncontrolled descent. Contributing to the accident was the improper approach to land and his failure to…NTSB MIA01LA149Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Greensboro, NCthe pilot's failure to maintain airspeed during takeoff/initial climb, which resulted in an inadvertent stall, an uncontrolled descent, and collision with trees.NTSB MIA01LA136Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Wilmington, NCA total loss of engine power due to the failure of maintenance to properly secure the fuel selector cover, resulting in the pilot inadvertently selecting "off" instead of "left" tank, and the subsequent forced landing to uneven terrain.NTSB MIA01LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chapel Hill, NCThe loss of engine power for undetermined reasons during takeoff, resulting in an inflight collision with trees during the subsequent emergency landing. A factor in the accident was the lack of suitable terrain to conduct an emergency landing.NTSB MIA01LA123Accident · No injuriesLimited investigationFinal reportCessna A185F · Fayetteville, NCThe pilot's failure to maintain directional control of the airplane after encounter wind gusts during landing roll resulting in the airplane ground looping to the left and the right wing, right horizontal stabilizer, and right elevator contacting the runway…NTSB MIA01LA116Accident · No injuriesLimited investigationFinal reportCessna 170B · Penrose, NCfailure of the pilot to maintain directional control of the aircraft during the landing rollout while landing in a crosswind which resulted in a ground swerve and substantial damage to the aircraft.NTSB MIA01LA115Accident · Minor injuriesLimited investigationFinal reportJerome Wells KR-2 · Nashville, NCthe pilot's improper preflight inspection, which resulted in his operating an aircraft with contaminated fuel that resulted in a loss of engine power and and a forced landing to a field and damage to the aircraft during the forced landing.NTSB ATL01LA046Accident · 1 fatalLimited investigationFinal reportJacques J. Mistrot Skybolt · Smithfield, NCThe pilot's failure to maintain control of the airplane during climb out that resulted in the in-flight collision with the ground. A factor was the physical impairment.