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 ATL06CA125Accident · No injuriesData collectionFinal reportBrown Floyd L Christen Eagle II · Topsail Beach, NCThe in-flight separation of the engine and propeller from the airframe for undetermined reasons, which resulted in the airplane's uncontrolled impact with water.NTSB ATL06LA121Accident · Minor injuriesLimited investigationFinal reportKirkpatrick Rans S-6 · Roseboro, NCThe pilot's failure to maintain ground clearance while maneuvering for a forced landing following loss of engine power.NTSB ATL06CA120Accident · No injuriesData collectionFinal reportCessna 150L · Bunn, NCThe pilot's improper preflight inspection resulting in a total loss of engine power due to water ingestion, a forced landing to none suitable soft ground, and a nose over.NTSB ATL06LA111Accident · 1 fatalLimited investigationFinal reportCanadair F86 · Hickory, NCThe pilot's improper assembly of the airplanes brakes, exceeding the authorized gross weight of the airplane at takeoff, and the pilot's failure to abort the takeoff in sufficient time to avoid an on-ground collision with fixed objects. A factor in the…NTSB ATL06LA103Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Gold Hill, NCThe pilot's failure to maintain airspeed while doing a go around, which resulted in an inadvertent stall, loss of control and in-flight collision with the ground. A factor was the pilot's lack of recent experience in the airplane.NTSB ATL06CA100Accident · Serious injuriesData collectionFinal reportNickel Acro II · Hertford, NCThe certified flight instructor and commercial pilot receiving instruction failure to maintain a visual look out, resulting in a wire strike on final approach, and collapse of the main landing gear on touchdown.NTSB ATL06CA098Accident · No injuriesData collectionFinal reportMooney M20M · Burnsville, NCThe pilot's failure to achieve the proper touch down point on landing resulting in a runway over run and collision with an embankment.NTSB ATL06LA094Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Wilkesboro, NCThe pilot's improper fuel consumption calculations and improper in-flight planning/decision which resulted in a total loss of engine power due to fuel exhaustion, a forced landing, and collision with terrain.NTSB ATL06CA095Accident · No injuriesData collectionFinal reportFantasy Air Allegro 2000 · Sanford, NCThe student pilot's improper flare, and inadequate recovery from a bounced landing.NTSB ATL06CA092Accident · No injuriesData collectionFinal reportCessna 150M · Shelby, NCThe student pilot's improper preflight inspection and his failure to refuel the airplane resulting in fuel exhaustion and subsequent loss of engine power.NTSB ATL06CA091Accident · Serious injuriesData collectionFinal reportKearn Breezy · Dover, NCThe pilot's failure to ensure the airplane contained adequate fuel for the flight resulting in a loss of engine power due to fuel exhaustion.NTSB ATL06CA089Accident · Minor injuriesData collectionFinal reportMooney M20M · Banner Elk, NCThe pilot's failure to attain the proper touchdown point during landing.NTSB ATL06CA087Accident · Minor injuriesData collectionFinal reportBeech B36TC · Brevard, NCThe pilot's failure to attain the proper touchdown point during landing.NTSB ATL06LA085Accident · No injuriesLimited investigationFinal reportHughes 269A · Concord, NCThe loss of engine power for undetermined reasons while maneuvering, resulting in a forced landing to uneven terrain and a roll over.NTSB ATL06CA073Accident · No injuriesData collectionFinal reportRobinson R44 Raven II · Rocky Point, NCThe pilot's inadequate visual lookout during a precautionary landing which resulted in an in-flight collision with a transmission wire.NTSB ATL06IA071Incident · No injuriesIncident investigationFinal reportBeech C90A · Raleigh, NCThe inadequate manufacturing process, which resulted in a windshield fire and subsequent emergency landing.NTSB ATL06CA064Accident · Minor injuriesData collectionFinal reportCessna L-19 · Kenly, NCThe pilot's continued operation of the airplane with known deficiencies (tail wheel steering) which resulted in loss of directional control during the takeoff roll, and a ground loop.NTSB ATL06CA063Accident · No injuriesData collectionFinal reportCessna 0-1A · Kenansville, NCThe pilot's failure to maintain directional control which resulted in an ground loop, and subsequent collision with ground.NTSB ATL06CA062Accident · No injuriesData collectionFinal reportCessna C-172S · Sanford, NCThe pilot's improper landing flare which resulted in a hard landing.NTSB ATL06IA054Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Asheville, NCThe improper installation of the pilot's windshield by company maintenance personnel, which resulted in flame and smoke in the cockpit, and subsequent emergency landing.NTSB ATL06LA052Accident · Minor injuriesLimited investigationFinal reportE Newton Newton RV-6A · Mooresville, NCThe collapse of the nose landing gear for undetermined reasons, which resulted in a nose over.NTSB ATL06CA046Accident · No injuriesData collectionFinal reportCessna 172L · Long Island, NCThe student pilot's failure to achieve the proper touch down point on landing resulting in an overrun, on-ground collision with a ditch, and subsequent nose over. A factor in the accident was the inadequate supervision of the student pilot by the flight…NTSB ATL06LA041Accident · No injuriesLimited investigationFinal reportCessna 500 · Burnsville, NCThe pilot's misjudged distance/altitude that led to an undershoot and the pilot's failure to attain the proper touchdown point.NTSB ATL06CA040Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Burlington, NCThe pilot's misjudgment of altitude/distance which resulted in an undershoot of the runway and subsequent impact with the runway collapsing the main landing gear.NTSB ATL06FA029Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Sylva, NCThe pilot's continued VFR flight into IMC conditions resulting in a collision with mountainous terrain.NTSB ATL06LA027Accident · No injuriesLimited investigationFinal reportPiper PA32-300 · Maiden, NCThe total loss of engine power due to the failure of the No. 5 main bearing due to overheating for undetermined reasons.NTSB ATL06CA047Accident · No injuriesData collectionFinal reportCessna 172 P · Wilmington, NCThe student pilot's improper landing flare which resulted in a hard landing.NTSB ATL06CA020Accident · No injuriesData collectionFinal reportCessna 152 · Sanford, NCThe student pilot's failure to maintain directional control on landing roll out, resulting in the airplane going off the left side of the runway, colliding with a ditch, and nosing over inverted.NTSB ATL06CA016Accident · Minor injuriesData collectionFinal reportCessna 177 · New Bern, NCThe pilot's failure to activate the carburetor heat during approach resulting in a total loss of engine power due to carburetor ice.NTSB ATL06CA015Accident · Minor injuriesData collectionFinal reportPiper PA-32-260 · Bryson City, NCThe loss of engine power due to carburetor icing, and the pilot's failure to use carburetor heat.NTSB ATL06CA018Accident · No injuriesData collectionFinal reportCessna 152 · Durham, NCThe pilot's improper flare on landing flare touchdown resulting in a hard landing and collapse of the nose gear.NTSB ATL06LA007Accident · 1 fatalLimited investigationFinal reportNorth American AT-6D · Mocksville, NCThe pilot's improper fuel management resulting in a total loss of engine power due to fuel starvation and an in-flight collision with trees and the ground.NTSB ATL06CA005Accident · No injuriesData collectionFinal reportCessna 150M · Morgantown, NCThe student pilot's improper recovery from a bounced landing,resulting in a loss of directional control and nose over.NTSB ATL06CA001Accident · Minor injuriesData collectionFinal reportBeech D-95A · Greensboro, NCThe pilot mistakenly shut down the operating engine when the passenger interfered with the rudder pedals as he attempted to identify the inoperative engine.NTSB ATL05CA160Accident · No injuriesData collectionFinal reportCessna 182T · Wilmington, NCThe pilot's improper flare which resulted in a hard landing, and the collapse of the nose gear.NTSB ATL05LA154Accident · 2 fatalLimited investigationFinal reportSamson Seawind 3000 · Wrightsville Bh, NCThe pilot's improper preflight decision to attempt night VFR flight into IMC, which resulted in an inflight encounter with weather and the pilot's subsequent loss of control of the airplane due to spatial disorientation.NTSB ATL05CA150Accident · No injuriesData collectionFinal reportMaule M4-210C · OCRACOKE iSLAND, NCThe pilot's inadequate compensation for winds and his failure to maintain directional control during a crosswind landing, which resulted in an on-ground collision with trees. A factor was the crosswind condition.NTSB ATL05CA146Accident · No injuriesData collectionFinal reportPiper 22 · Archdale, NCThe pilot's failure to maintain directional control during landing roll, which resulted in a nose over.NTSB ATL05LA140Accident · 2 fatalLimited investigationFinal reportAllegro 2000 · Supply, NCThe instructor pilot's failure to maintain airspeed for unknown reasons, resulting in an aerodynamic stall and subsequent collision with the ground.NTSB ATL05CA138Accident · Minor injuriesData collectionFinal reportBeech C24R · Lumberton, NCThe pilot's improper/inadequate evaluation of the weather, which resulted into flight into a thunderstorm.NTSB ATL05CA134Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH2000 · Winston-Salem, NCThe student pilot's misjudged flare and his improper recovery from a bounced landing resulting in a stall and hard landing.NTSB ATL05CA166Accident · No injuriesData collectionFinal reportBeech 35 · Carthage, NCThe pilot's excessive braking resulting in a loss of control and subsequent impact with gully. A related factor was the tailwind.NTSB DCA05MA083Accident · Serious injuriesMajor investigationFinal reportBoeing 767-232 · Raleigh-Durham, NCAn inadvertent in-flight encounter with clear air turbulence.NTSB ATL05FA128Accident · 1 fatalField investigationFinal reportCessna 172N · Penrose, NCA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to use the full length of the runway for takeoff, and the inadvertent stall.NTSB ATL05CA120Accident · No injuriesData collectionFinal reportGrumman American AA-1B · Durham, NCThe pilot's failure to maintain directional control. Factors were soft and wet terrain.NTSB ATL05LA117Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Mocksville, NCThe loss of engine power due to fuel system contamination. A factor was trees.NTSB ATL05IA116Incident · Minor injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Greensboro, NCThe inadequate assembly of the nose landing gear selector valve by a parts supplier, which resulted in internal seal damage and a hydraulic leak that led to the collapse of the nose landing gear. A factor was the insufficient information provided by the…NTSB ATL05LA111Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Yadkinville, NCThe pilots failure to maintain adequate clearance from object and inadequate visual look-out while maneuvering resulted in an in-flight collision with power lines.NTSB ATL05CA093Accident · No injuriesData collectionFinal reportAllegro 2000 · Leasburg, NCThe pilot's inadequate recovery from a bounced landing, resulting in a hard landing, and the subsequent on ground collision with trees.NTSB ATL05CA090Accident · No injuriesData collectionFinal reportCessna 172R · Louisburg, NCThe pilot's failure to maintain adequate airspeed, which resulted in a stall and subsequent loss of control and collision with the ground.