NTSB investigations, 2013
71 cases where NTSB found Experience/knowledge.
Cases per year
| 2008 | 87 |
|---|---|
| 2009 | 79 |
| 2010 | 77 |
| 2011 | 78 |
| 2012 | 89 |
| 2013 | 71 |
| 2014 | 66 |
| 2015 | 64 |
| 2016 | 62 |
| 2017 | 60 |
| 2018 | 54 |
| 2019 | 60 |
| 2020 | 35 |
| 2021 | 38 |
| 2022 | 45 |
| 2023 | 47 |
| 2024 | 46 |
| 2025 | 21 |
| 2026 | 12 |
Where
Latest 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 year(c.\"eventDate\") = 2013
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0203'))
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 year(c."eventDate") = 2013 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0203')) 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 ERA14FA077Accident · 2 fatalField investigationFinal reportPiper PA-30 · Biglerville, PAThe noninstrument-rated pilot's spatial disorientation after inadvertently encountering instrument meteorological conditions at night and his subsequent loss of airplane control.NTSB WPR14CA075Accident · Serious injuriesData collectionFinal reportCessna 152 · St. Ignatius, MTThe non-certificated pilot's failure to maintain a stabilized approach for landing that resulted in a long landing and subsequent runway overrun.NTSB CEN14LA091Accident · Serious injuriesLimited investigationFinal reportQuicksilver Unknown · Palestine, TXThe noncertificated pilot’s failure to maintain airspeed, which resulted in an inadvertent stall during landing.NTSB WPR14CA070Accident · No injuriesData collectionFinal reportBellanca 7ECA · San Jose, CAThe flight instructor's failure to correct for the student pilot's loss of aircraft control in a timely manner during takeoff. Contributing to the accident was the instructor's inability to see the taxiway sign from the rear seat.NTSB ERA14FA068Accident · 3 fatalField investigationFinal reportCessna 310R · Jacksonville, FLThe pilot’s failure to maintain airplane control during a missed approach in night instrument meteorological conditions due to spatial disorientation and a lack of instrument proficiency.NTSB CEN14LA079Accident · Serious injuriesLimited investigationFinal reportThompson William A Sparrow II · Jeromesville, OHThe student pilot's in-flight loss of control while attempting to return to the runway following a loss of engine power. The cause of the loss of engine power could not be determined because the postaccident examination did not reveal any anomalies.NTSB ANC14CA010Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Soldotna, AKThe operation of the airplane by the uncertificated student pilot, his failure to recognize conditions conducive to structural icing, and subsequent decision to depart in conditions conducive to structural icing, resulting in a severe icing encounter and…NTSB ERA14FA045Accident · 4 fatalField investigationFinal reportLearjet 35 · Fort Lauderdale, FLThe pilot's failure to maintain control of the airplane following an inflight deployment of the left engine thrust reverser. Contributing to the accident was the flight crew's failure to perform the appropriate emergency procedures, the copilot's lack of…NTSB CEN14FA051Accident · 2 fatalField investigationFinal reportCessna T310R · Junction, TXThe noninstrument-rated private pilot's decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in the loss of airplane control. Contributing to the accident was the pilot’s failure to obtain a weather…NTSB CEN14FA047Accident · 3 fatalField investigationFinal reportBeechcraft B36TC · Amarillo, TXThe noninstrument-rated pilot’s improper decision to fly a night instrument approach in instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane during an attempted missed approach.NTSB CEN14LA036Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Superior, WIThe failure of the pilot who was flying the trail airplane to maintain separation from the lead airplane. Contributing to the accident was the inadequate pilot training for formation skydiving operations.NTSB ERA14FA027Accident · 1 fatalField investigationFinal reportCessna 172R · Nashville, TNThe noninstrument-rated pilot’s continued visual flight into night instrument flight rules conditions, which resulted in a collision with the runway during an attempted approach to land. Contributing to the accident was the pilot’s mental state, his…NTSB WPR14CA026Accident · No injuriesData collectionFinal reportCessna T210 - H · Lodi, CAThe student pilot's inadequate flare and failure to maintain directional control during landing.NTSB ERA14CA017Accident · Serious injuriesData collectionFinal reportBeech A36 · Burnsville, NCThe pilot's failure to achieve a proper touchdown point during landing, which resulted in a runway excursion.NTSB CEN14FA014Accident · 2 fatalField investigationFinal reportPiper PA 32R-301 · Huntsville, ARThe noninstrument-rated pilot’s continued flight into an area of known rain with reduced visibility and his failure to maintain airplane control while maneuvering the airplane after entering these conditions.NTSB ERA14CA031Accident · Serious injuriesData collectionFinal reportSchweizer SGS 1 26E · Eighty Four, PAThe pilot's failure to maintain proper airspeed and glide path, which resulted in an overshoot, a hard landing, and a subsequent collision with terrain. Contributing to the accident was the pilot's lack of total experience in make and model.NTSB ERA14FA002Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Tifton, GAThe noninstrument-rated pilot’s improper decision to continue visual flight rules flight into known instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB CEN14LA008Accident · No injuriesLimited investigationFinal reportEmbraer-Empresa Brasileira De EMB-500 · Wichita, KSThe pilot’s improper brake application during landing, which resulted in a loss of directional control.NTSB ERA14LA006Accident · 4 fatalLimited investigationFinal reportCessna 340A · Hampton Roads, VAThe pilot’s failure to maintain airplane control due to spatial disorientation in low-visibility conditions while maneuvering during a missed approach. Contributing to the accident was the pilot’s ineffective use of the onboard GPS equipment.NTSB ERA13FA412Accident · Serious injuriesField investigationFinal reportJoseph Bender Mustang II · Smoketown, PAThe pilot/owner/builder's failure to abort the takeoff and his subsequent failure to maintain airplane control. Contributing to the accident were the pilot's total lack of experience in the accident airplane and his lack of flying experience in the 3 1/2…NTSB WPR13FA393Accident · 1 fatalField investigationFinal reportStuart Vortex · Scappoose, ORThe student pilot's unintentional takeoff followed by his failure to maintain control of the gyroplane during the landing approach. Contributing to the accident was the student pilot’s lack of both flight training and flight experience and his lack of a solo…NTSB ERA13FA385Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Danville, VAThe student pilot's failure to maintain control and climb the airplane during a go-around maneuver. Contributing to the accident was the flight instructor's failure to provide adequate oversight of the student pilot by ensuring that the cockpit was free of…NTSB CEN13LA523Accident · No injuriesLimited investigationFinal reportBell-Transworld Helicopter Cor 47G-2 · Wichita Falls, TXThe delayed remedial action by the flight instructor during a simulated autorotation, which resulted in a hard landing.NTSB CEN13LA506Accident · Serious injuriesLimited investigationFinal reportBuckeye Breeze · Franklin, ILThe failure of both pilots, one of whom was noncertificated, to maintain adequate visual lookout while maneuvering to land, which resulted in a midair collision. Contributing to the accident was the pilots’ inadequate communication about their intended…NTSB CEN13CA515Accident · Minor injuriesData collectionFinal reportGrumman American Avn. AA-1B · Valparaiso, INThe pilot's improper recovery from a bounced landing.NTSB ERA13LA361Accident · No injuriesLimited investigationFinal reportBryant Frederick M Rans S-12 · Vienna, MDThe student pilot’s inadequate control of the airplane, which resulted in an aerodynamic stall and subsequent impact with water.NTSB CEN13CA475Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Poteau, OKThe pilot’s application of excessive left rudder during the takeoff roll, resulting in a loss of directional control, his failure to correct the excursion with opposite rudder, and his failure to abort the takeoff in a timely manner.NTSB ERA13CA354Accident · No injuriesData collectionFinal reportStetson Norman B Challenger II · Orange, MAThe pilot’s failure to maintain airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of total flight experience in the accident airplane make and model.NTSB CEN13LA459Accident · No injuriesLimited investigationFinal reportCessna 180H · Greencastle, INThe pilot's excessive application of the right brake during the landing, which resulted in a runway excursion.NTSB ERA13LA347Accident · Serious injuriesLimited investigationFinal reportDurfee Fred Quicksilver MXL · Lexington, TNThe student pilot/builder’s failure to maintain airspeed following a loss of engine power, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the student pilot/builder’s…NTSB CEN13LA428Accident · 1 fatalLimited investigationFinal reportCooper, David W. Challenger II · Mill Creek, INThe noncertificated pilot's improper fuel planning, which led to fuel exhaustion and a loss of engine power. Contributing to the accident was the pilot's failure to obtain adequate instruction or an endorsement to solo in the accident airplane model, which…NTSB ERA13FA325Accident · Serious injuriesField investigationFinal reportBeech 23 · Laurel, MDThe pilot's inadequate preflight preparation of the airplane, which resulted in a total loss of engine power during takeoff and his decision to operate the unairworthy airplane.NTSB CEN13LA418Accident · No injuriesLimited investigationFinal reportMarino Benoist Type XIV · Duluth, MNThe pilot's failure to maintain control of the seaplane during its initial flight test. Contributing to the accident was the pilot's overall lack of flight experience in the seaplane.NTSB CEN13CA430Accident · Minor injuriesData collectionFinal reportAlvarez Marvin R Rans S-6S · Schertz, TXThe noncertificated pilot's operation of the airplane, which resulted in impact with terrain.NTSB DCA13MA120Accident · 3 fatalClass 1 · MajorFinal reportBoeing 777-200ER · San Francisco, CAThe flight crew's mismanagement of the airplane's descent during the visual approach, the pilot flying's unintended deactivation of automatic airspeed control, the flight crew's inadequate monitoring of airspeed, and the flight crew's delayed execution of a…NTSB CEN13LA401Accident · 1 fatalLimited investigationFinal reportJDT 1600R · Chesaning, MIThe failure of the propeller reduction gearbox and the pilot’s subsequent failure to maintain adequate airspeed, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall and spin. Contributing to the accident were…NTSB ERA13CA315Accident · Minor injuriesData collectionFinal reportBeech A23-19 · Easton, PAThe pilot's improper touchdown point during landing, which resulted in a runway overrun. Contributing to the accident was the pilot’s decision to land with a tailwind condition and his lack of recent experience.NTSB WPR13CA361Accident · Minor injuriesData collectionFinal reportBuckeye Dream Machine · Fruitland, WAThe operation of a powered parachute by a non-certificated pilot, and the pilot's failure to maintain aircraft control during takeoff, which resulted in a collision with a vehicle.NTSB ERA13LA308Accident · Serious injuriesLimited investigationFinal reportHiller UH-12A · Florence, ALThe student pilot’s failure to maintain control of the helicopter while landing, which resulted in a tail rotor ground strike and collision with terrain.NTSB WPR13FA289Accident · 1 fatalField investigationFinal reportCessna P337H · San Luis Obispo, CALoss of engine power from the rear engine for reasons that could not be determined because of the postimpact thermal damage to the engine. Contributing to the accident were the pilot's decision to continue flight with a known deficiency, his failure to abort…NTSB CEN13FA364Accident · 4 fatalField investigationFinal reportCessna 172M · Waterford, MIThe pilot's failure to retract the wing flaps before attempting to take off, due to his lack of familiarity with the airplane make and model, which prevented the airplane from maintaining adequate altitude for takeoff.NTSB CEN13LA342Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Morrilton, ARThe flight instructor's inadequate training and oversight of the student pilot, which resulted in the noncertificated student pilot's loss of control during landing.NTSB CEN13CA334Accident · No injuriesData collectionFinal reportBeech C24R · Peyton, COThe pilot’s failure to maintain proper pitch control during takeoff.NTSB CEN13FA326Accident · 1 fatalField investigationFinal reportHawker Beechcraft B200GT · Baker, LAThe pilot’s failure to maintain adequate airspeed during departure, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s lack of specific knowledge of the airplane’s avionics.NTSB CEN13CA292Accident · No injuriesData collectionFinal reportCessna 162 · Erie, COThe pilot’s total lack of experience in aircraft make/model, and his failure to maintain directional control during landing. Contributing to the accident was the operator’s lack of oversight is allowing the airplane to be rented to the pilot.NTSB ERA13CA250Accident · Minor injuriesData collectionFinal reportThomas David W Rans S-12 XL · Cleveland, GAThe pilot's failure to maintain airspeed while maneuvering after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of overall recent flight experience and lack of experience in make and model.NTSB WPR13FA234Accident · 1 fatalField investigationFinal reportCessna 421C · Floriston, CAThe pilot's failure to maintain airplane control during descent while operating in instrument meteorological conditions.NTSB WPR13LA215Accident · No injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58A+ · Somerton, AZThe pilot's failure to maintain aircraft control while maneuvering at a low altitude in dark night conditions, which resulted in collision with terrain. Contributing to the accident was the pilot's fatigue due to his working at a time when he normally would…NTSB ERA13FA227Accident · 2 fatalField investigationFinal reportNewgent, Barry S6S · Suffolk, VAThe pilot's failure to maintain airspeed while turning from the downwind to the base leg of the traffic pattern, which resulted in a subsequent aerodynamic stall, spin, and impact with terrain. Contributing to the accident were the pilot's lack of currency…NTSB ERA13FA219Accident · 1 fatalField investigationFinal reportDaniels Dominator · Valkaria, FLThe pilot’s failure to maintain adequate power and airspeed, which resulted in a loss of control, abrupt descent, and impact with terrain. Contributing to the accident was the pilot’s failure to obtain adequate experience in the gyroplane before making the…