NTSB investigations, NC
146 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 9 |
| 1984 | 4 |
| 1985 | 7 |
| 1986 | 6 |
| 1987 | 2 |
| 1988 | 6 |
| 1989 | 6 |
| 1990 | 7 |
| 1991 | 6 |
| 1992 | 11 |
| 1993 | 5 |
| 1994 | 9 |
| 1995 | 5 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 2 |
| 1999 | 5 |
| 2000 | 7 |
| 2001 | 5 |
| 2002 | 4 |
| 2003 | 8 |
| 2004 | 4 |
| 2005 | 4 |
| 2006 | 8 |
| 2007 | 5 |
Where
Open the mapLatest cases
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250) 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 MIA08CA008Accident · No injuriesData collectionFinal reportGlobe GC-1B · Edenton, NCThe pilot's failure to maintain airspeed while on final approach resulting in an inadvertent stall.NTSB MIA07CA151Accident · No injuriesData collectionFinal reportSchleicher ASW-24E · Morganton, NCThe failure of the pilot to maintain airspeed while turning base to final resulting in the left wing contacting the ground.NTSB NYC07FA126Accident · 3 fatalField investigationFinal reportColumbia Aircraft Mfg LC42-550FG · Burnsville, NCThe pilot's improper recovery from a bounced landing resulting in a loss of directional control and subsequent impact with several parked airplanes.NTSB ATL07LA073Accident · 1 fatalLimited investigationFinal reportCulver, Aurther L. Seawind 3000 · Yanceyville, NCThe pilot's failure to maintain clearance/altitude while operating in instrument meteorological conditions (IMC). Contributing to the accident was the pilot's lack of an instrument rating, his improper decision to operate in IMC, a low cloud ceiling, and…NTSB ATL07CA061Accident · Serious injuriesData collectionFinal reportHarrison Robert J. Longez · Morganton, NCThe pilot's failure to maintain an adequate airspeed that resulted in an inadvertent stall, and subsequent inflight collision with trees and the ground.NTSB NYC07FA052Accident · 4 fatalField investigationFinal reportCessna TR182 · Charlotte, NCThe pilot's spatial disorientation, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was instrument meteorological conditions.NTSB ATL07LA025Accident · 2 fatalLimited investigationFinal reportFagan Rans S-6S · Taylorsville, NCThe pilots failure to maintain airspeed while maneuvering resulting in an inadvertent stall, uncontrolled decent, collision with the ground, and a post crash fire.NTSB NYC07FA037Accident · 1 fatalField investigationFinal reportCirrus SR22 · Huntersville, NCThe pilot's failure to maintain aircraft control. Contributing to the accident was the night instrument meteorological conditions.NTSB ATL07CA017Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA 20-C1 · Raleigh, NCThe pilot's failure to maintain airspeed during a go-around, which resulted in a inadvertent stall.NTSB ATL07FA013Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Statesville, NCThe pilot's failure to maintain airspeed while maneuvering with a low ceiling in instrument flight conditions, resulting in an inadvertent stall, and collision with trees and the ground. Factors in the accident were the pilot's failure to follow the published…NTSB ATL07FA010Accident · 2 fatalField investigationFinal reportCessna 182T · Rocky Mount, NCThe pilot's failure to maintain aircraft control.NTSB ATL07CA007Accident · No injuriesData collectionFinal reportCessna 188B · Belhaven, NCThe pilot's failure to compensate for wind conditions and maintain adequate airspeed, which resulted in an inadvertent stall and subsequent in-flight collision with terrain.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 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 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.NTSB ATL05CA088Accident · No injuriesData collectionFinal reportCessna 172 · Raleigh, NCThe pilot's failure to maintain adequate obstacle clearance during initial climb, which resulted in an in-flight collision with treesNTSB ATL05LA017Accident · Serious injuriesLimited investigationFinal reportDavid Nielson Ison Hi-Max 1700 · Hendersonville, NCThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin and subsequent in-flight collision with terrain.NTSB ATL04LA158Accident · 1 fatalLimited investigationFinal reportPitts S-1 · Durham, NCThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin and subsequent in-flight collision with terrain.NTSB ATL04FA107Accident · 2 fatalField investigationFinal reportMooney M20M · Cary, NCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with trees. Factors were low ceilings and fog.NTSB ATL04LA072Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Indian Trail, NCThe pilot's attempted lift off without adequate airspeed resulting in a stall/mush and collision with trees while transitioning from an aborted landing to takeoff climb. A factor was the crosswind condition.NTSB ATL04FA056Accident · 1 fatalField investigationFinal reportCessna 206H · Sanford, NCThe pilot's loss of control of the airplane during takeoff initial climb due to spatial disorientation, which resulted in an inflight collision with trees and the ground. Factors were the dark night, fog, and low ceilings.NTSB ATL04LA033Accident · Minor injuriesLimited investigationFinal reportBartholomew Firestar · Waxhaw, NCThe pilot's failure to maintain airspeed while maneuvering on final approach resulting in an inadvertent stall and in-flight collision with trees and the ground.NTSB ATL04LA030Accident · No injuriesLimited investigationFinal reportThocker Vans RV-4 · Liberty, NCThe pilot's failure to maintain airspeed on initial takeoff climb resulting in an in-flight loss of control, inadvertent stall, and collision with the runway.NTSB ATL04LA015Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Hickory, NCThe pilot's failure to maintain airspeed which resulted in a stall.NTSB ATL03LA129Accident · Serious injuriesLimited investigationFinal reportWilliam Allen MONI-1 · Timberlake, NCThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent collision with the ground.NTSB ATL03FA104Accident · 3 fatalField investigationFinal reportPiper PA-44-180 · Battleboro, NCThe certified flight instructor's (CFI) failure to maintain flying speed that resulted in a stall/spin and the uncontrolled collision with the ground.NTSB ATL03FA052Accident · 5 fatalField investigationFinal reportBeech BE-36A · Mount Airy, NCThe pilots failure to maintain control of the aircraft due to spatial disorientation. A factor was low clouds.NTSB DCA03MA022Accident · 21 fatalClass 1 · MajorFinal reportBeech 1900D · Charlotte, NCthe airplane's loss of pitch control during take-off. The loss of pitch control resulted from the incorrect rigging of the elevator system compounded by the airplane's aft center of gravity, which was substaintially aft of the certified aft limit.…NTSB ATL02FA171Accident · 2 fatalField investigationFinal reportMooney M20R · Burnsville, NCThe pilot's failure to maintain airspeed during final approach, which resulted in an inadvertent stall and uncontrolled descent into trees and terrain. Factors were wind gusts and terrain-induced turbulence.NTSB ATL02LA168Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Mocksville, NCThe pilot's failure to maintain airspeed during the takeoff and initial climb which resulted in an inadvertent stall and the subsequent collision with trees.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 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 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 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 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 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.NTSB MIA01FA060Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Bethel, NCthe pilot's failure to maintain control of the airplane due to spatial disorientation, which resulted in an in-flight collision with power lines and the subsequent impact with terrain. A factor in this accident was: the pilot's lack of recent instrument…NTSB MIA01FA043Accident · 1 fatalField investigationFinal reportPiper PA-31-325 · Belvidere, NCThe pilot's failure to maintain airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions resulting in the airplane entering a descending turn and crashing into terrain.NTSB MIA01LA026Accident · 1 fatalLimited investigationFinal reportJ and J Tukan · Hayesville, NCThe ultralight pilot's in-flight loss of control for unknown reasons resulting in an in-flight collision with the terrain.NTSB ATL00LA070Accident · 2 fatalLimited investigationFinal reportLeslie Briggs Glasair III · Smithfield, NCThe pilot's failure to maintain flying speed during an emergency landing which lead to an inadvertent stall/spin. A factor was the pilot's failure to secure the cockpit canopy prior to takeoff.NTSB MIA00LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Chapel Hill, NCThe failure of the CFI to delay his landing until the approaching line of thunderstorms passed, causing the flight to encounter severely gusting wind conditions resulting in the loss of altitude control and collision with the terrain.NTSB MIA00FA141Accident · 2 fatalField investigationFinal reportNorth American SNJ-5 · Elk Park, NCThe inflight loss of control for undetermined reasons resulting in the airplane colliding with mountainous terrain during the uncontrolled descent.NTSB MIA00LA089Accident · No injuriesLimited investigationFinal reportBeech 76 · Salisbury, NCThe flight instructors inadequate supervision of a dual student who attempted a go around using one engine which resulted in loss of control and impact with the ground.NTSB MIA00LA065Accident · 1 fatalLimited investigationFinal reportSlater P-51 · Hampstead, NCThe pilots failure to maintain airspeed (VSO) while maneuve ring on a turn to crosswind resulting in an inadvertent stall/spin, and subsequent in-flight collision with trees and terrain.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 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 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).