NTSB investigations
5,002 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2008 | 333 |
|---|---|
| 2009 | 307 |
| 2010 | 266 |
| 2011 | 313 |
| 2012 | 320 |
| 2013 | 282 |
| 2014 | 311 |
| 2015 | 298 |
| 2016 | 284 |
| 2017 | 283 |
| 2018 | 261 |
| 2019 | 287 |
| 2020 | 261 |
| 2021 | 254 |
| 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 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 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 ERA27LA008Accident · Minor injuriesLimited investigationInvestigation openZielke Ronald W Zenith 750 · Marysville, OHNTSB CEN27FA016Accident · 5 fatalClass 3 · FieldInvestigation openPiper PA 46-350P · Reedsburg, WINTSB WPR27FA015Accident · 1 fatalClass 3 · FieldInvestigation openBertling Courtney MXL-2 · Newberg, ORNTSB CEN26LA327Accident · Minor injuriesClass 3 · LimitedPreliminary reportHaberman Habercraft · Pelican Rapids, MNOn September 27, 2026, about 1720 central daylight time, a Haberman Habercraft airplane, N10516, was substantially damaged during an accident near Pelican Rapids, Minnesota. The pilot sustained a minor injury. The airplane was operated as a Title 14 Code of…NTSB CEN26FA325Accident · 1 fatalClass 3 · FieldPreliminary reportEXP PA-18 Replica · Buffalo, MNOn September 27, 2026, about 1608 central daylight time, an experimental PA-18 Replica airplane, N43LK, sustained substantial damage when it was involved in an accident near Buffalo, Minnesota. The pilot was fatally injured, and the pilot-rated passenger was…NTSB WPR26LA360Accident · No injuriesClass 4 · LimitedInvestigation openCessna A185F · Livingston, MTNTSB WPR26FA355Accident · 2 fatalClass 3 · FieldInvestigation openAeronca 7AC · Hesperia, CANTSB ERA26FA338Accident · 1 fatalClass 3 · FieldPreliminary reportReed Julian Estill RV-4 · Albertville, ALOn September 15, 2026, about 0620 central daylight time, an experimental amateur-built RV-4, N469TW, was substantially damaged when it was involved in an accident near Albertville, Alabama. The pilot was fatally injured. The airplane was operated as a Title…NTSB WPR26LA344Accident · Serious injuriesClass 4 · LimitedInvestigation openTaylorcraft BC12D · Nibbe, MTNTSB CEN26LA317Accident · Minor injuriesClass 4 · LimitedInvestigation openRobinson Helicopter R44 II · Natchez, MSNTSB ERA26FA329Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-28-181 · Ludlow, MAOn September 5, 2026, about 2105 eastern daylight time, a Piper PA-28-181, N7653F, was destroyed when it was involved in an accident near Ludlow, Massachusetts. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of…NTSB ERA26FA326Accident · 2 fatalClass 3 · FieldPreliminary reportMaclura Evolution · Tampa, FLOn September 3, 2026, about 0815 eastern daylight time, an experimental, amateur-built Evolution airplane, N305PV, was destroyed when it was involved in an accident near Tampa, Florida. The commercial pilot and passenger were fatally injured. The airplane was…NTSB WPR26LA322Accident · Serious injuriesClass 4 · LimitedInvestigation openKrugh Patrick M Steen Skybolt · Big Bear, CANTSB ERA26LA313Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Milton, FLThe flight instructor’s failure to maintain control of the helicopter during a low hover over a grass area, which resulted in left skid contact with the ground and a dynamic rollover to the left.NTSB CEN26LA299Accident · No injuriesClass 4 · LimitedInvestigation openCessna 150M · Greenwood, ILNTSB CEN26LA300Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T206H · Marble, COThe pilot's failure to maintain directional control during the final approach in variable and gusting wind conditions. Contributing to the accident were localized wind effects associated with mountainous terrain and with nearby convective activity.NTSB CEN26LA294Accident · Minor injuriesClass 4 · LimitedFinal reportPipistrel Taurus Electro G2.5 · Hempstead, TXThe pilot’s failure to properly stow the motor in preparation for approach and landing that resulted in a loss of airspeed and an inadvertent aerodynamic stall and spin.NTSB ERA26FA294Accident · 1 fatalClass 3 · FieldPreliminary reportBachem Fritz M Avid Mark IV · Arp, TXOn August 9, 2026, at about 1655 central daylight time, an experimental amateur-built Avid Mark IV, N77FB, was substantially damaged when it was involved in an accident near Arp, Texas. The private pilot was fatally injured. The airplane was operated as a…NTSB CEN26LA282Accident · 1 fatalClass 3 · LimitedPreliminary reportPzl-Bielsko B1-PW-5 · Briggs, TXOn August 6, 2026, about 1538 central daylight time, a PZL-Bielsko B1-PW-5 glider, N105WS, was substantially damaged when it was involved in an accident near Briggs, Texas. The pilot was fatally injured. The glider was operated as a Title 14 Code of Federal…NTSB CEN26FA280Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-24-250 · Bethany, MOOn August 4, 2026, about 1839 central daylight time, a Piper PA-24-250 airplane, N8422P, was destroyed when it was involved in an accident near Bethany, Missouri. The pilot received fatal injuries. The airplane was operated under Title 14 Code of Federal…NTSB CEN26FA275Accident · 1 fatalClass 3 · FieldPreliminary reportBeech E18S · Guymon, OKOn August 2, 2026, about 1608 central daylight time (CDT), a Beech E18S airplane, N210Q, was destroyed when it was involved in an accident near Guymon, Oklahoma. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN26LA274Accident · No injuriesClass 4 · LimitedFinal reportCessna A188B · Algona, IAThe pilot’s failure to maintain control during a turn, which resulted in an aerodynamic stall.NTSB WPR26LA267Accident · Minor injuriesClass 4 · LimitedInvestigation openRans S7 · Kemmerer, WYNTSB WPR26FA257Accident · 1 fatalClass 3 · FieldPreliminary reportLuscombe 8A · Canton, TXOn July 14, 2026, sometime between 1252 and 1356 CDT, a Luscombe 8A, N1164K, was substantially damaged when it crashed in a field near Canton, Texas. The pilot, who was the sole occupant, was fatally injured. The airplane was operated as a Title 14 Code of…NTSB CEN26LA254Accident · 1 fatalClass 3 · LimitedPreliminary reportTag Aviation PTY Titanium Explorer · Larkspur, COOn July 13, 2026, about 800 mountain daylight time, a Tag Aviation Pty Ltd Titanium Explorer gyrocopter, N665TE was substantially damaged when it was involved in an accident near Larkspur, Colorado. The pilot passed away in the hospital five days after the…NTSB ERA26FA269Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 182 · Piseco, NYOn July 12, 2026, about 1909 eastern daylight time, a Cessna 182J, N43TB, was destroyed when it was involved in an accident near Piseco, New York. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB CEN26FA247Accident · 1 fatalClass 3 · FieldPreliminary reportKaman Aerospace K-1200 · Silver Jack Reservoir, COOn July 12, 2026, about 1705 mountain daylight time, a Kaman Aerospace Corporation K-1200 (K-MAX) helicopter, N40HX, was substantially damaged when it was involved in an accident at Silver Jack Reservoir, Colorado. The pilot was fatally injured. The…NTSB ERA26LA272Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170B · Hartwell, GAThe pilot’s failure to compensate for the gusty and variable wind conditions, which resulted in a loss of control and collision with trees during takeoff.NTSB WPR26LA243Accident · No injuriesClass 4 · LimitedInvestigation openValerie Westedt Zenith Zodiac 650B · Peyton, CONTSB CEN26LA244Accident · Serious injuriesClass 4 · LimitedFinal reportCassutt Iiim · Odessa, TXThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which led to an aerodynamic stall and a loss of airplane control at too low of an altitude to recover. Contributing to the accident was the pilot’s lack of recent…NTSB CEN26LA245Accident · Serious injuriesClass 4 · LimitedFinal reportXag P150 MAX · Wolcott, INThe pilot’s failure to maintain control of the UAS during takeoff.NTSB GAA26WA241Accident · Minor injuriesClass 5 · ForeignCirrus SR22 · Neropolis, BrazilNTSB ERA26FA252Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA24 · Hazen, NDOn June 28, 2026, about 1317 central daylight time, a Piper PA-24-250, N6852P, was destroyed when it was involved in an accident near Hazen, North Dakota. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB CEN26LA238Accident · 1 fatalClass 3 · LimitedPreliminary reportAirborne Windsports PTY Edge XT-912-L · Winona, MNOn June 25, 2026, about 2000 central daylight time, an Airborne Windsports Pty Ltd Edge Xt-912-L weight-shift-control light sport aircraft, N912CV was substantially damaged when it was involved in an accident at Winona Municipal Airport (ONA) Winona,…NTSB GAA26WA239Accident · 1 fatalClass 5 · ForeignSupermarine Spitfire · Muluckine, AustraliaNTSB CEN26LA234Accident · Serious injuriesClass 3 · LimitedPreliminary reportBell 47G-2 · Troy, MOOn June 22, 2026, about 1840 central daylight time, a Bell 47G-2 helicopter, N65520, was substantially damaged when it was involved in an accident near Troy, Missouri. The pilot sustained serious injuries. The helicopter was operated as a Title 14 Code of…NTSB WPR26FA223Accident · 2 fatalClass 3 · FieldPreliminary reportComp Air CA6-WB · Nicholasville, KYOn June 20, 2026, about 0846 eastern daylight time, an experimental amateur-built Comp Air CA6-WB, N82BT, was destroyed when it was involved in an accident near Nicholasville, Kentucky. The pilot and passenger were fatally injured. The airplane was operated…NTSB ERA26FA241Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 177RG · Morrison, TNOn June 17, 2026, about 1215 central daylight time, a Cessna 177RG, N7637V, was substantially damaged when it was involved in an accident near Morrison, Tennessee. The pilot and pilot-rated passenger were fatally injured. The airplane was operated as a Title…NTSB CEN26FA224Accident · 12 fatalClass 2 · FieldPreliminary reportPacific Aerospace 750XL · Butler, MOOn June 14, 2026, about 1125 central daylight time, a Pacific Aerospace Limited 750XL airplane, N221BN, was destroyed when it was involved in an accident near Butler, Missouri. The pilot and 11 passengers sustained fatal injuries. The airplane was operated as…NTSB CEN26FA222Accident · 1 fatalClass 3 · FieldPreliminary reportCirrus Design SR20 · Wheelers Mill, OHOn June 11, 2026, about 1030 eastern daylight time, a Cirrus SR20 airplane, N858SD, was destroyed when it was involved in an accident near Wheelers Mill, Ohio. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB ANC26LA052Accident · Serious injuriesClass 4 · LimitedInvestigation openTimothy G Tarris Early Bird Jenny · Lamar, CONTSB ERA26LA236Accident · Minor injuriesClass 4 · LimitedFinal reportCub Crafters CC19-215 · Plymouth, NHThe pilot’s failure to maintain control of the airplane during an aborted landing attempt which resulted in an aerodynamic stall.NTSB ERA26FA230Accident · Serious injuriesClass 3 · FieldPreliminary reportCessna 150 · Kissimmee, FLOn June 6, 2026, about 1458 eastern daylight time, a Cessna 150L, N156KA, was substantially damaged when it was involved in an accident near Kissimmee Gateway Airport (ISM), Kissimmee, Florida. The commercial pilot and student pilot were seriously injured.…NTSB WPR26LA212Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna P210N · Santa Teresa, NMOn June 5, 2026, about 1130 mountain daylight time, a Cessna P210N airplane, N54CC, was substantially damaged when it was involved in an accident at Dona Ana County International Jetport Airport (DNA), Santa Teresa, New Mexico. The pilot and 2 passengers were…NTSB ERA26LA240Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-108 · Westminster, MDThe pilot’s failure to maintain airplane control during takeoff, which resulted in a runway excursion and collision with terrain.NTSB CEN26LA217Accident · No injuriesClass 3 · LimitedPreliminary reportAutogyro Cavalon · Coffeyville, KSOn June 2, 2026, at 0837 central daylight time, an AutoGyro Cavalon gyroplane, N113CX, was substantially damaged when it was involved in an accident near Coffeyville, Kansas. The pilot was not injured. The gyroplane was operated as a Title 14 Code of Federal…NTSB WPR26LA214Accident · Serious injuriesClass 3 · LimitedPreliminary reportMooney M20J · Albuquerque, NMOn May 31, 2026, at 1515 mountain daylight time, a Mooney M20J, N555ED, sustained substantial damage when it was involved in an accident near Albuquerque, New Mexico. The pilot was seriously injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN26LA209Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Jonesboro, ARThe student pilot's failure to maintain adequate airspeed, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot’s decision to practice slow flight maneuvers at an…NTSB ERA26FA214Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-25-235 · Saratoga Springs, NYOn May 26, 2026, about 1347 eastern daylight time, a Piper PA-25-235 airplane, N8656L, was substantially damaged when it was involved in an accident near Saratoga Springs, New York. The pilot was fatally injured. The airplane was operated as a Title 14 Code…NTSB WPR26LA201Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican AA1 · Cowley, WYThe pilot's improper landing flare and subsequent loss of directional control during landing.