NTSB investigations
810 cases where NTSB found Descent/approach/glide path.
Cases per year
| 2008 | 55 |
|---|---|
| 2009 | 42 |
| 2010 | 44 |
| 2011 | 39 |
| 2012 | 56 |
| 2013 | 40 |
| 2014 | 37 |
| 2015 | 39 |
| 2016 | 57 |
| 2017 | 64 |
| 2018 | 46 |
| 2019 | 40 |
| 2020 | 40 |
| 2021 | 48 |
| 2022 | 49 |
| 2023 | 29 |
| 2024 | 38 |
| 2025 | 32 |
| 2026 | 15 |
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062040')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01062040')) 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 ERA26LA307Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Altoona, PAThe pilot’s descent below the glidepath and collision with trees during a missed approach.NTSB WPR26LA286Accident · Minor injuriesClass 4 · LimitedFinal reportInterstate S-1A · Blackfoot, IDThe pilot's failure to maintain the proper glidepath during the landing approach, which resulted in a touchdown prior to the runway threshold, impact of the main landing gear with the pavement edge.NTSB ERA26LA259Accident · Serious injuriesClass 4 · LimitedFinal reportMaule M-5-235C · Hickman, KYThe pilot’s failure to maintain a proper glide path, which resulted in a runway undershoot.NTSB WPR26LA246Accident · Serious injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Lake Elsinore, CAThe student pilot’s failure to maintain a proper glidepath, which resulted in a long landing and collision with a person on the ground.NTSB ERA26LA263Accident · Serious injuriesClass 4 · LimitedFinal reportRyan Navion A · Newport, NHThe pilot’s failure to attain an appropriate touchdown point, which resulted in a runway overrun.NTSB WPR26LA234Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Dixie, IDThe pilot's delayed decision to initiate a go-around and subsequent failure to maintain clearance from rising terrain.NTSB WPR26LA206Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 177 · Cascade, IDThe pilot’s improper approach, which resulted in a faster than normal touchdown and subsequent runway overrun.NTSB ERA26LA220Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Chesapeake, VAThe pilot’s improper decision to continue with an unstabilized approach, which resulted in a hard landing, loss of directional control, and collision with a runway marker light and sign.NTSB WPR26LA124Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210 · Upland, CAThe pilot’s improper approach, which resulted in a long landing, runway excursion, and a nose over.NTSB CEN26LA122Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Golden, MOThe pilot’s failure to establish stabilized approach that would have allowed the airplane to touch down with adequate runway remaining. Contributing to the accident was the pilot’s failure to execute a go-around.NTSB WPR26LA099Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada BHT407 · Libby, MTThe pilot's failure to maintain clearance from a light post during landing.NTSB WPR26LA095Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Alpine, WYThe pilot’s inadvertent descent while operating in flat light conditions which resulted in controlled flight into terrain.NTSB ERA26LA096Accident · No injuriesClass 4 · LimitedFinal reportAmerican General Acft AG5B · Fairfield, NJThe pilot’s failure to maintain an appropriate glide path during the landing approach in gusting wind conditions, resulting in an impact with trees prior to the runway.NTSB ERA26LA088Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Philippi, WVThe pilot’s failure to obtain the proper touchdown point, which resulted in a runway overrun.NTSB CEN26LA085Accident · Minor injuriesClass 4 · LimitedFinal reportQuad City Challenger · Greenbrier, ARThe non-certificated pilot's failure to maintain airplane control during the landing.NTSB WPR26LA039Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 77A · Rio Rancho, NMAn inadvertent hard landing in high wind conditions resulting in serious injury of one of the pilots.NTSB CEN26LA033Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182H · Lakeview, ARThe pilot’s failure to maintain a proper approach path during landing which resulted in a collision with terrain short of the runway. Contributing to the accident was the improper flap position during landing, and the pilot being fatigued.NTSB ERA26LA003Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · West Milford, NJThe pilot’s failure to adequate clearance from obstacles while maneuvering during the landing approach and the instructor pilot’s delayed remedial action, which resulted in the airplane contacting a tree and terrain.NTSB WPR26LA014Accident · No injuriesClass 4 · LimitedFinal reportMaye James A Just Aircraft Escapade · Flanigan, NVThe pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN26LA011Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Portage, WIThe student pilot’s failure to maintain proper airspeed and attitude for a short field landing. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA25LA363Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-300 · White Plains, NYThe pilot’s failure to maintain proper glidepath during a night visual approach, which resulted in a collision with the runway lighting system. Contributing to the outcome was the pilot’s momentary disorientation due to glare from the runway approach lighting…NTSB CEN25LA400Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200 · Rush City, MNThe pilot’s failure to properly monitor the airplane glide path which resulted in the inadvertent descent below the approach minimum descent altitude and the impact with trees.NTSB ERA25LA358Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Blue Ridge, GAThe pilot’s failure to obtain the proper touchdown point, which resulted in a runway overrun.NTSB ERA25LA355Accident · No injuriesClass 4 · LimitedFinal reportLamphere David A Wittman Buttercup · Monterey, VAThe pilot’s failure to attain a proper touchdown point while landing, which resulted in a runway overrun.NTSB WPR25LA275Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Hollister, CAThe pilot’s delayed go-around from an unstabilized approach that resulted in an impact with terrain.NTSB CEN25LA370Accident · No injuriesClass 4 · LimitedFinal reportBoeing E75 · Benton, KSThe pilot's failure to maintain clearance from a moving vehicle during an evasive maneuver from a perceived conflict with another airplane. Contributing to the accident was the pilot of the other airplane’s non-standard phraseology and inaccurate position…NTSB CEN25LA354Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Baldwin City, KSThe pilot’s decision to continue the night landing without runway lights which resulted in the runway overrun.NTSB ERA25LA328Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Montauk, NYThe pilot’s failure to verify the wind direction and maintain an appropriate approach speed, which resulted in a long landing and subsequent runway excursion.NTSB CEN25LA406Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-T34 · Beaman, IAThe pilot’s failure to maintain a proper glidepath during landing which resulted in a landing short of the runway.NTSB WPR25LA251Accident · No injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Kalispell, MTThe pilot’s unstable approach to the runway, which resulted in an aerodynamic stall at low altitude and impact with terrain.NTSB ERA25LA296Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-180A · Muskeget Island, MAThe pilot’s failure to obtain a proper touchdown point while attempting to land on a very short and rough turf runway, which resulted in a runway overrun and collision with vegetation and terrain.NTSB ANC25LA081Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Anchorage, AKThe pilot’s decision to continue an unstabilized approach, which resulted in a landing touchdown with insufficient runway remaining and a subsequent runway overrun and a collision with a fence.NTSB ERA25LA271Accident · No injuriesClass 4 · LimitedFinal reportRohrer Douglas D Vans RV-14A · Bowling Green, KYThe pilot’s failure to attain an appropriate touchdown point during landing, which resulted in a runway overrun and collision with a fence.NTSB CEN25LA257Accident · Minor injuriesClass 4 · LimitedFinal reportVan's RV-6 · New Richmond, WIThe pilot’s failure to maintain proper airspeed and altitude during the approach which resulted in a runway overshoot and subsequent landing in a lake. Contributing to the accident was the pilot’s delayed remedial action to abort the landing.NTSB CEN25LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Howard, WIThe pilot’s failure to maintain control of the airplane while on approach to land.NTSB WPR25LA202Accident · No injuriesClass 4 · LimitedFinal reportMooney M20K · Henderson, NVThe pilot’s failure to maintain directional control during a go-around, resulting in a collision with a runway sign.NTSB CEN25LA211Accident · No injuriesClass 4 · LimitedFinal reportCessna U206 · Falun, WIThe pilot experiencing the featureless terrain illusion during the approach which gave the perception that the airplane was at a higher altitude over the glassy water surface than it was, resulting in the airplane impacting the water.NTSB CEN25LA202Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26C · Hampshire, ILThe pilot’s failure to maintain a proper altitude during the approach, which resulted in overshooting the landing area, a runway excursion, and impact with terrain.NTSB ERA25LA224Accident · No injuriesClass 4 · LimitedFinal reportShoemaker Ronald R Pazmany PL-2 · Reading, PAThe pilot’s failure to maintain a proper descent rate, resulting in a hard landing short of the runway and collapse of the right main landing gear.NTSB WPR25FA145Accident · 2 fatalClass 3 · FieldFinal reportChampion 7ECA · Cottonwood, CAThe flight instructor’s delayed response to an improper landing approach and runway overshoot, which resulted in an impact with an airport perimeter fence and trees.NTSB WPR25LA144Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26B · Ontario, ORThe pilot's exceedance of the airplane's critical angle of attack during the final approach to land, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR25LA157Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Fullerton, CAThe pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun and collision with terrain.NTSB ERA25LA128Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Alton Bay, NHThe pilot’s failure to maintain an appropriate glide path during the landing approach, which resulted in in the airplane contacting a snowbank short of the runway.NTSB ERA25LA123Accident · No injuriesClass 4 · LimitedFinal reportCessna 172C · Argyle, NYThe mechanic’s incorrect installation of the oil temperature gauge probe in the oil filter adapter and failure to test run the engine for oil leaks after the installation, which resulted in a total loss of oil and the pilot’s decision to perform a…NTSB WPR25LA087Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL3 · Upland, CAThe pilot’s failure to maintain adequate separation during landing, which resulted in a runway collision with another airplane.NTSB ERA25LA118Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kennesaw, GAThe student pilot’s failure to maintain an appropriate glide path and the flight instructor’s inadequate monitoring of the landing approach, which resulted in the airplane contacting the ground short of the runway.NTSB ERA25LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Smyrna, TNThe pilot’s failure to maintain an appropriate approach path, resulting in the airplane contacting a tree during a landing approach at night.NTSB CEN25LA064Accident · Serious injuriesClass 4 · LimitedFinal reportCozy Cub · Parsons, KSThe pilot’s failure to maintain clearance from power lines while on final approach to land.NTSB CEN25LA045Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Crowley, LAThe pilot’s un-stabilized landing approach and high airspeed during the approach, that resulted in touchdown with insufficient runway remaining to stop the airplane.NTSB CEN25LA036Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Bridgeport, TXThe student pilot’s delayed go-around from an unstabilized approach and failure to attain/maintain control during the go-around that resulted in an impact with terrain.