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 MIA00LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Hickory, NCThe certified flight instructor (CFI) failure to maintain directional control on rough terrain on takeoff. This resulted in the airplane veering to the left, colliding with bushes after the airplane became airborne, and subsequent in-flight collision with…NTSB MIA00LA046Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Pikeville, NCThe inadequate supervision of the private-rated pilot by the certified flight instructor for allowing the airplane to impact terrain during a simulated forced landing procedure to an open field.NTSB MIA00LA039Accident · Minor injuriesLimited investigationFinal reportPitts S1C · Creedmore, NCThe pilot's failure to select the reserve position of the fuel tank resulting in loss of engine power due to fuel starvation and a nose over during a forced landing.NTSB MIA00LA031Accident · No injuriesLimited investigationFinal reportCessna 175-235 · Mint Hill, NCThe PIC's improper preflight fuel planning and preparation and the PIC's improper en route fuel consumption calculations resulting in a total loss of engine power due to fuel exhaustion and damage to the aircraft during the subsequent forced landing.NTSB MIA00LA022Accident · No injuriesLimited investigationFinal reportCessna 150M · Jacksonville, NCThe flight instructor's improper supervision of the student pilot during preflight and improper fuel management ensuring there was sufficient fuel for the planned flight. This resulted in a total loss of engine power due to fuel exhaustion.NTSB MIA00LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Raleigh, NCThe pilot's failure to maintain directional control on landing rollout for undetermined reasons. This resulted in the airplane veering off the runway and colliding with an airport sign.NTSB ATL00LA001Accident · No injuriesLimited investigationFinal reportCessna 305C · Morganton, NCThe pilot's inadequate compensation for a tailwind which resulted in the loss of control.NTSB MIA00LA013Accident · No injuriesLimited investigationFinal reportBritish Aerospace HS 125-700A · Fayetteville, NCThe overstress failure of the lugs of the cylinder head of the left main landing gear jack for undetermined reasons. Also, inability of the flight crew to extend the left main landing gear.NTSB MIA99LA231Accident · Serious injuriesLimited investigationFinal reportAlson g. Siler CH-701 · Mount Pleasant, NCThe failure of the pilot to apply sufficient right rudder input during the go-around following a bounced landing and his failure to maintain runway alignment resulting in the in-flight collision with trees 100-150 yards to the left of the runway.NTSB MIA99FA215Accident · 2 fatalField investigationFinal reportCessna 150F · Maple, NCthe pilot's failure to follow the aircraft's operating checklist and retract the wing flaps for takeoff as specified, as well as the pilot's failure to maintain airspeed (Vso) on initial takeoff climb, which resulted in an inadvertent stall, a spin, and…NTSB MIA99LA211Accident · No injuriesLimited investigationFinal reportMooney M-20R · Stoneville, NCthe pilot's failure to maintain airspeed, and adequately compensate for torque and P-factor, resulting in the loss of directional control, collision with hangars, and substantial damage to the aircraft during the attempted go around/recovery from a landing.NTSB MIA99LA248Accident · No injuriesLimited investigationFinal reportDouglas DC3C-S4C4G · Charlotte, NCthe pilot-in-command did not use the check list which resulted in the right main landing gear collapsing.NTSB ATL99LA111Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Asheboro, NCThe pilot's failure to maintain flying speed that resulted in a stall and the subsequent collision with trees.NTSB MIA99LA192Accident · No injuriesLimited investigationFinal reportCessna 182Q · Rock Springs, NC**This report was modified on 2/24/2016. Refer to the public docket for this accident for additional information.** Inadequate preflight by the commercial pilot/CFI receiving instruction resulting in an in-flight loss of engine power due to fuel exhaustion.NTSB MIA99LA191Accident · No injuriesLimited investigationFinal reportMooney M20F · Liberty, NCImproper inspection of the muffler assembly resulting in erosion going undetected and the rupture of the muffler and shroud while in cruise flight. The condition caused melting of portions of the air induction system, loss of engine power, and the pilot's…NTSB MIA99LA190Accident · No injuriesLimited investigationFinal reportBeech A23 · Pinehurst, NCThe flight crew's improper fuel management resulting in engine loss of power due to fuel starvation and damage to the airplane due to collision with trees in the subsequent forced landing.NTSB MIA99FA180Accident · 4 fatalField investigationFinal reportCessna 421C · Charlotte, NCThe failure of the pilot to shutdown the right engine and feather the propeller after a reported loss of power in the engine shortly after takeoff resulting in the airplane descending, colliding with trees and then the ground.NTSB MIA99LA178Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Charlotte, NCThe pilot misjudged the flare during the landing.NTSB MIA99LA163Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Chapel Hill, NCThe failure of the pilot to maintain airspeed resulting in the airplane stalling and entering a spin. Contributing to the accident was the pilot's impairment by marijuana.NTSB ATL99LA093Accident · No injuriesLimited investigationFinal reportRobert W. Ferrell Titan Tornado II · Ashboro, NCThe loss of engine power for undetermined reasons. Factors were weather conditions favorable for the formation of carburetor ice.NTSB ATL99LA092Accident · Minor injuriesLimited investigationFinal reportMurray R. Gardner FLY Baby · Mount Olive, NCA fatigue failure of the flywire bracket that resulted in the inflight separation of the left wing.NTSB ATL99LA086Accident · No injuriesLimited investigationFinal reportBeech BE-100 · Hickory, NCThe failure of the landing gear actuator due to the improper installation of the lower thrust bearing by maintenance personnel.NTSB ATL99LA082Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Southern Pines, NCA failure of the left main landing gear retraction assembly as a result of the disconnection of the left main landing gear strap bracket assembly from the main gear spring attachment bracket due to the missing nut. A factor was the ditch.NTSB MIA99FA150Accident · 1 fatalField investigationFinal reportCessna 172 · Fontana, NCthe pilot continued visual flight into know weather conditions which resulted in reduced visibility, and the subsequent in-flight collision with rising terrain. Factors in this accidents were clouds and low ceiling in the accident area.NTSB MIA99LA149Accident · 2 fatalLimited investigationFinal reportR.O. and D.O Hewitt Kitfox IV-1200 · Kannapolis, NCThe failure of the pilot-in-command to maintain airspeed and the inadvertent stall resulting in the uncontrolled descent with terrain. A factor in the accident was the impairment of the pilot by drugs (tetrahydrocannabinol).NTSB ATL99LA077Accident · Serious injuriesLimited investigationFinal reportBeech 23-B24R · Boone, NCThe pilots failure to obtain/maintain proper climb rate during initial climbout. This resulted in the collision with the mountain/hilly terrain.NTSB ATL99LA075Accident · No injuriesLimited investigationFinal reportBeech 36 · Williamston, NCThe pilot's inadequate evaluation of winds that resulted in the loss of directional control during an attempted takeoff with a tailwind. A factor was the tailwind condition.NTSB MIA99LA139Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Apex, NCthe pilot's failure to maintain control of the airplane resulting in the airplane drifting, and subsequently impacting with trees.NTSB ATL99LA068Accident · Minor injuriesLimited investigationFinal reportVans RV-6A · Cedar Creek, NCThe soft runway surface.NTSB ATL99LA064Accident · No injuriesLimited investigationFinal reportCessna 172B · Mt. Airy, NCThe pilot's failure to maintain proper airspeed during landing and his failure to attain a proper touchdown point on the runway.NTSB ATL99LA065Accident · No injuriesLimited investigationFinal reportCessna 206 · Fayetteville, NCThe pilot's failure to maintain directional control during landing. A factor was the crosswind.NTSB ATL99LA056Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bunn Level, NCThe loss of engine power for undetermined reasons. Factors were an electrical system malfunction for undetermined reasons and the dark night conditions.NTSB MIA99LA098Accident · Minor injuriesLimited investigationFinal reportPiper PA-60-601P · Statesville, NCthe pilot's failure to attain the proper touchdown point on the runway. Factors in this accident were excessive approach speed, rain, and a wet runway.NTSB MIA99LA094Accident · No injuriesLimited investigationFinal reportCessna 182J · Franklin, NCThe failure of the pilot to maintain directional control of the airplane on final approach resulting in the in-flight collision with trees and the ground.NTSB MIA99LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, NCThe student pilots failure to maintain directional control during an attempted touch and go landing. This resulted in the airplane veering off the left side of the runway, and subsequent on-ground collision with a ditch and nosed over inverted..NTSB ATL99LA049Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-80 · Raleigh, NCThe flight encountered clear air turbulence while descending through 17,000 feet mean sea level (MSL).NTSB MIA99LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-210T · Washington, NCLoss of engine power for undetermined reasons on initial takeoff climb resulting in a forced landing and in-flight collision with trees and terrain.NTSB ATL99FA045Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Brevard, NCThe pilot's inadequate inflight planning that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB ATL99LA027Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, NCThe failure of the #2 exhaust valve that resulted in the total loss of engine power. A factor is the lack of suitable emergency landing terrain.NTSB MIA99LA040Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Star, NCThe failure of the pilot to use proper short-field landing procedure, resulting in an extended flare and touchdown by the nose wheel and right main wheel simultaneously, and the subsequent loss of directional control and collision with trees.NTSB ATL99FA020Accident · Serious injuriesField investigationFinal reportCessna 172N · Concord, NCThe pilot's improper in-flight decision and his failure to maintain clearance during approach that resulted in collision with utility lines. Related factors were dark night, trees and low ceilings.NTSB ATL99LA018Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hickory, NCThe pilot's failure to properly recover from a bounced landing.NTSB ATL99LA012Accident · No injuriesLimited investigationFinal reportAeroSport WS-15-2 · Parkton, NCThe collapse of the carburetor heat box hose which starved the carburetor of air resulting in a partial loss of power, forced landing and nose over. Factors were the weeds and stocky stubble in the forced landing zone.NTSB ATL99FA136Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Robbinsville, NC"This case was changed from ATL05FA014." The pilot's improper in-flight decision to continue VFR flight into IMC, which resulted in an in-flight encounter with weather and controlled flight into terrain. Factors were the pilot's inadequate preflight planning…NTSB MIA99LA017Accident · No injuriesLimited investigationFinal reportReinhold Revolution Mini 500 · Hickory, NCThe seizure of the rear piston in the cylinder barrel resulting in total loss of engine power and an autorotation which resulted in main rotor contact with the tail boom while touching down on unsuitable terrain.NTSB ATL98LA132Accident · No injuriesLimited investigationFinal reportCessna 172P · Farmville, NCThe pilot's failure to maintain directional control of the aircraft and his improper use of the brakes, which led to the aircraft departing the left side of the runway. Contributing factors were the wet runway and the vehicle.NTSB MIA98LA256Accident · No injuriesLimited investigationFinal reportCessna 152 · Reidsville, NCThe pilot's delay in the initiation of a go-around, and his failure to maintain obstacle (tree) clearance.NTSB MIA98LA249Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Burlington, NCThe pilot's failure to abort the takeoff after recognizing that the airplane was slow to accelerate during the takeoff roll, and his not obtaining/maintaining clearance with the wire during the forced landing. Contributing factors were carburetor icing…NTSB ATL98LA125Accident · Serious injuriesLimited investigationFinal reportHopkins Buckeye Industries Dream Machine 582 · Franklin, NCThe non-certificated pilot's inadequate judgement of the required climb rate, and his failure to attain clearance from obstacles.NTSB MIA98LA235Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Kill Devil Hill, NCFailure of the number one cylinder exhaust valve resulting in loss of engine power and a forced landing on unsuitable terrain at which time the aircraft nosed over.