NTSB investigations, 2018
261 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2008 | 333 |
|---|---|
| 2009 | 307 |
| 2010 | 268 |
| 2011 | 313 |
| 2012 | 320 |
| 2013 | 282 |
| 2014 | 311 |
| 2015 | 298 |
| 2016 | 284 |
| 2017 | 283 |
| 2018 | 261 |
| 2019 | 288 |
| 2020 | 262 |
| 2021 | 258 |
| 2022 | 244 |
| 2023 | 216 |
| 2024 | 203 |
| 2025 | 183 |
| 2026 | 96 |
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 year(c.\"eventDate\") = 2018
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2018 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN19LA050Accident · 1 fatalLimited investigationFinal reportCessna R172K · Chesaning, MIThe pilot's loss of airplane control for reasons that could not be determined based on the available information.NTSB ERA19RA077Accident · 5 fatalForeign investigationAgusta A109 · Santa Maria Coronango, State of Puebla, MexicoThe government of Mexico has notified the NTSB of an accident involving a AGUSTA A109S helicopter that occurred on December 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…NTSB ERA19LA078Accident · 1 fatalLimited investigationFinal reportBRM Aero Bristell S-LSA · Lakeland, FLThe student pilot's exceedance of the airplane's critical angle of attack during the initial climb, resulting in an aerodynamic stall from which the pilot did not recover.NTSB GAA19CA123Accident · Minor injuriesData collectionFinal reportCessna 172 · Center, TXThe pilot's exceedance of the airplane's critical angle of attack during landing in gusting crosswind conditions, which resulted in an aerodynamic stall.NTSB ERA19LA072Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA46 · Mayport, FLAn in-flight loss of control following an encounter with supercooled large droplet icing conditions, which ultimately resulted in an uncontrolled descent and subsequent inflight breakup. Also causal was the pilot’s failure to maintain an appropriate airspeed…NTSB ERA19FA071Accident · 4 fatalField investigationFinal reportCessna 560 · Atlanta, GAThe pilot's loss of airplane control due to spatial disorientation during initial climb in instrument meteorological conditions.NTSB WPR19FA042Accident · 1 fatalClass 2 · FieldFinal reportPiper PA-24-250 · Aberdeen, IDThe pilot's diverted attention during the takeoff climb due to a loss of engine power, which resulted in the airplane’s exceedance of the critical angle of attack and subsequent stall/spin.NTSB GAA19CA098Accident · No injuriesData collectionFinal reportCessna 170 · Riggins, IDThe pilot's improper preflight performance planning and his subsequent failure to attain sufficient speed for the airplane to climb with a tailwind.NTSB CEN19WA102Accident · 3 fatalForeign investigationCirrus SR22 · Beauberry, FranceThe government of France has notified the NTSB of an accident involving a Cirrus SR22 airplane that occurred on December 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…NTSB ERA19LA061Accident · Serious injuriesClass 3 · LimitedFinal reportCessna P210 · Myerstown, PAA total loss of engine power due to fuel starvation.NTSB CEN19WA040Accident · 4 fatalForeign investigationCessna U206 · Culiacan, Sinaloa, MexicoNTSB CEN19LA039Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Fargo, NDThe pilot's failure to lower the flaps during the approach and maintain sufficient airspeed while flying in instrument meteorological and icing conditions and the accumulation of ice on the wings’ leading edges, which resulted in the exceedance of the…NTSB CEN19FA036Accident · 3 fatalClass 3 · FieldFinal reportCessna 525 · Memphis, INThe pilot’s inability to regain airplane control after a left roll that began for reasons that could not be determined based on the available evidence.NTSB CEN19FA035Accident · 1 fatalField investigationFinal reportPiper PA 30 · Marion, INThe pilot's exceedance of the airplane's critical angle of attack following a loss of the left engine power shortly after takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the loss of left…NTSB GAA19CA099Accident · Minor injuriesData collectionFinal reportCirrus SR20 · Jasper, GAThe student pilot's exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall, and the flight instructor's delayed remedial action.NTSB WPR19LA029Accident · No injuriesClass 3 · LimitedFinal reportBKF Backcountry Supercub · Casper, WYThe seizure of two bearings in the reduction gearbox, resulting in the total loss of engine power. Contributing to the accident was a high descent rate which resulted in a hard landing.NTSB GAA19CA063Accident · No injuriesData collectionFinal reportRobinson R44 · Knox City, TXThe pilot's failure to maintain adequate airspeed with a tailwind, which resulted in the helicopter settling with power, and his subsequent incorrect collective application while attempting to recover, which resulted in a loss of helicopter control due to a…NTSB GAA19WA419Accident · 2 fatalForeign investigationSocata TB20 · Dinard Pleurtuit, FranceThe government of France has notified the NTSB of an accident involving a SOCATA TB20 airplane that occurred on November 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…NTSB ERA19LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Barnesville, GAThe student pilot’s failure to maintain airplane control during takeoff and the flight instructor’s delayed remedial action, which resulted in an off-runway landing and subsequent collision with trees.NTSB ERA19LA050Accident · Minor injuriesClass 3 · LimitedFinal reportUltralite Sro Stingsport · Clermont, FLAn inflight failure of the airplane’s horizontal stabilizer.NTSB ERA19FA049Accident · 1 fatalClass 2 · FieldFinal reportLancair Legacy RG · Gainesville, GAThe pilots’ failure to execute a go-around when the nighttime autopilot-coupled approach became unstable, which resulted in a loss of control and subsequent impact with terrain. Also causal was the flight instructor's inadequate supervision of the pilot and…NTSB CEN19FA029Accident · 2 fatalField investigationFinal reportBeech 55 · Liberal, KSThe pilot's improper decision to fly in an area where moderate icing conditions were forecasted in an airplane that was not certified for such conditions, and in the effort to get out of the icing conditions, his decision to fly below the minimum descent…NTSB CEN19FA028Accident · 2 fatalField investigationFinal reportNorth American P51 · Fredericksburg, TXThe pilot's decision to perform a low-level maneuver at an altitude where he was unable to recover the airplane before impacting terrain.NTSB ERA19LA043Accident · Serious injuriesClass 3 · LimitedFinal reportAero Commander 690 · Myrtle Beach, SCAn encounter with low-level windshear and turbulence during the landing approach, which resulted in a loss of airplane control.NTSB ERA19LA041Accident · Serious injuriesLimited investigationFinal reportPiper PA28R · Lake City, FLThe pilot's failure to attain adequate airspeed before attempting the takeoff with a tailwind, which resulted in the airplane being unable to sustain flight.NTSB WPR19FA022Accident · 4 fatalClass 2 · FieldFinal reportPiper PA28 · Guthrie Center, IAPilot incapacitation due to carbon monoxide poisoning as a result of an undetected crack in an engine exhaust muffler, which permitted entry of exhaust gasses into the cabin via the cabin heat system.NTSB ERA19FA039Accident · 1 fatalField investigationFinal reportCessna 310 · Walton, NYAn in-flight fire of undetermined origin. Contributing to the accident were the severe icing conditions encountered during the final minutes of the flight, which led to a loss of airplane control.NTSB ERA19WA040Accident · 1 fatalForeign investigationPiper PA23 · Nassau, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Piper PA23 airplane that occurred on November 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions…NTSB CEN19WA037Accident · 1 fatalForeign investigationRotorway Exec · Saint Pierre, St. Pierre & MiquelonNTSB ERA19LA037Accident · 1 fatalLimited investigationFinal reportCessna 150 · Woodstock, GAThe pilot's failure to maintain airspeed during the initial climb in gusting wind conditions, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's lack of recent flight experience.NTSB ERA19FA036Accident · 1 fatalField investigationFinal reportTitan Tornado 1 · Louisa, VAThe pilot's failure to maintain airspeed and the airplane's exceedance of its critical angle of attack, which resulted in an aerodynamic stall and spin at a low altitude.NTSB ANC19LA006Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's failure to maintain airplane control during the landing flare, which resulted in the wing striking the runway. Contributing to the accident was a partial loss of engine power, which resulted from fuel contamination.NTSB CEN19FA022Accident · 2 fatalField investigationFinal reportMustang II · Broomfield, COThe pilot's inability to maintain airplane control following an encounter with mountain wave turbulence.NTSB CEN19FA021Accident · 1 fatalField investigationFinal reportCessna 210 · Bradley, SDThe non-instrument-rated pilot's improper decision to conduct a flight in which instrument meteorological conditions existed along the route of flight, which resulted in spatial disorientation and a loss of airplane control.NTSB ERA19FA035Accident · 2 fatalField investigationFinal reportAerospatiale AS 355F2 · Beekmantown, NYThe pilot's failure to keep the helicopter clear of a utility pole while hovering with a tailwind, which resulted in a dynamic rollover into active power lines.NTSB ERA19FA034Accident · 2 fatalField investigationFinal reportAutogyro Cavalon · Sebring, FLThe pilot's improper decision to operate the gyroplane in an unairworthy condition, which resulted in the cyclic pitch control disconnecting in flight. Contributing was the pilot's inability to maintain control of the helicopter utilizing the published…NTSB CEN19FA018Accident · 1 fatalField investigationFinal reportEurocopter AS350 · Odanah, WIThe pilot's loss of helicopter control for undetermined reasons.NTSB ERA19LA028Accident · Serious injuriesLimited investigationFinal reportBeech V35 · Murfreesboro, TNThe pilot's failure to maintain airplane control while maneuvering at low altitude in gusting wind conditions.NTSB ENG19WA004Accident · 5 fatalForeign investigationAgusta Agusta AW169 · Leicester, United KingdomThe United Kingdom's Air Accidents Investigation Branch (AAIB) has notified the NTSB of an accident involving an Agusta AW169, which occurred on October 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB WPR19WA015Accident · 1 fatalForeign investigationBell UH -1H · Vermaaklikheid, South AfricaOn October 23, 2018, about 0745 Coordinated Universal time, a Bell UH-1H helicopter, ZS-HLP, impacted terrain during a firefighting mission near Vermaaklikheid, South Africa. The pilot sustained fatal injuries and the helicopter was substantially damaged in…NTSB WPR19LA013Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R44 · Kaneohe, HIThe pilot’s sudden incapacitation from an undiagnosed heart condition during flight, which resulted in a hard landing.NTSB ERA19FA023Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Woodbine, NJThe pilot's failure to maintain the proper airspeed during takeoff, which resulted in the exceedance of the airplane’s critical angle of attack and the airplane experiencing an aerodynamic stall.NTSB GAA19CA037Accident · No injuriesData collectionFinal reportZenith CH601 · Junction City, KSThe pilot's failure to secure the canopy latch before takeoff, which resulted in the canopy opening in flight and the subsequent loss of airplane control.NTSB DCA19WA015Incident · No injuriesForeign investigationBoeing 787 · Hong Kong, ChinaThe government of China has notified the NTSB of an accident involving a BOEING 787 airplane that occurred on October 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of China's investigation under the provisions of…NTSB CEN19FA009Accident · 1 fatalClass 2 · FieldFinal reportRobinson R22 · Fulton, MOA total loss of engine power due to carburetor icing, the pilot's delayed application of carburetor heat, and the pilot's delay in entering an autorotation following the loss of engine power, which resulted in a main rotor stall due to low rotor rpm and an…NTSB ERA19LA014Accident · Serious injuriesClass 3 · LimitedFinal reportHargrove Hummel Ultra Cruiser · Zephyrhills, FLThe pilot's failure to activate the airplane’s auxiliary fuel pump, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident were the impairing effects of the pilot’s medication on his performance.NTSB ERA19LA012Accident · 3 fatalLimited investigationFinal reportPiper PA34 · Westhampton Beach, NYThe instructor's decision to conduct and continue a visual flight rules flight into instrument meteorological conditions with a known flight instrument anomaly, which resulted in spatial disorientation, causing a loss of airplane control and subsequent…NTSB CEN19LA007Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman AA5 · Refugio, TXThe pilot’s improper inflight fuel management, which resulted in a total loss of engine power due to fuel starvation and the pilot’s failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack and an…NTSB CEN19FA004Accident · 2 fatalField investigationFinal reportPiper PA32RT · Poolville, TXThe pilot's loss of airplane control as a result of spatial disorientation and the exceedance of the structural capabilities of the airplane. Contributing to the accident was the pilot's limited experience in instrument conditions.NTSB ERA19TA005Accident · No injuriesFinal reportEnstrom F28 · Bridgeville, DEThe pilot's mismanagement of collective pitch control during takeoff from an area with numerous obstacles, which resulted in the helicopter entering a low rotor rpm state and a forced hard landing.