NTSB investigations, 2020
441 cases where NTSB found Environmental issues.
Cases per year
| 2008 | 933 |
|---|---|
| 2009 | 669 |
| 2010 | 591 |
| 2011 | 564 |
| 2012 | 566 |
| 2013 | 507 |
| 2014 | 612 |
| 2015 | 568 |
| 2016 | 665 |
| 2017 | 700 |
| 2018 | 663 |
| 2019 | 613 |
| 2020 | 441 |
| 2021 | 463 |
| 2022 | 428 |
| 2023 | 437 |
| 2024 | 426 |
| 2025 | 312 |
| 2026 | 149 |
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\") = 2020
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03'))
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") = 2020 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03')) 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 ANC21LA010Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172R · Hope, AKThe pilot’s selection of unsuitable terrain for landing. A factor was the certified flight instructor’s selection of unsuitable terrain for landing.NTSB ERA21LA094Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Stowe, PAThe pilot's loss of directional control while landing in a gusty crosswind, which resulted in a runway excursion and subsequent impact with terrain.NTSB CEN21LA101Accident · No injuriesClass 3 · LimitedFinal reportBeech 65-A80-8800 · Alexandria, MNThe pilot’s decision to attempt takeoff with frost covering the airplane and rotating below the published rotation speed, which led to exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB ERA21LA089Accident · Serious injuriesClass 4 · LimitedFinal reportGlasflugel Club Libelle 205 · Bunn, NCThe pilot's failure to maintain adequate clearance from trees during an off-airport landing.NTSB ERA21LA088Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Cleveland, GAA total loss of engine power due to carburetor icing.NTSB WPR21LA074Accident · Minor injuriesClass 4 · LimitedFinal reportAerostar International S-60A · Peoria, AZThe pilot’s encounter with an updraft which resulted in a loss of aircraft control and subsequent collision with powerlines.NTSB DCA21LA058Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A320-232 · Houston, TXan encounter with forecasted convective turbulence during approach.NTSB ERA21LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Culpeper, VAThe pilot’s decision to land the airplane in crosswind conditions that exceeded the airplane’s maximum demonstrated crosswind velocity.NTSB ERA21LA085Accident · 1 fatalClass 3 · LimitedFinal reportCessna 210L · Midway, GAThe pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pressure to complete the flight to work in an emergency room.NTSB CEN21LA095Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Morris, ILThe pilot's inadequate pedal application during liftoff with a tailwind, which resulted in a loss of yaw control and a subsequent impact with terrain.NTSB CEN21LA097Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Albion, NEThe pilot’s failure to maintain directional control during the landing with a tailwind.NTSB ERA21LA080Accident · 1 fatalClass 3 · LimitedFinal reportSocata TB10 · Pembroke Pines, FLThe pilot’s failure to use carburetor heat in environmental conditions favorable for serious carburetor ice during a prolonged wait with the engine at a low power setting before takeoff, which resulted in a partial loss of engine power due to carburetor ice.…NTSB ERA21LA077Accident · No injuriesClass 3 · LimitedFinal reportEmbraer EMB-500 · Jacksonville, FLThe flight crew’s failure to apply maximum braking immediately upon touchdown, which resulted in a runway excursion. Contributing to the accident were 1) the slightly excessive approach airspeed and 2) the flight crew’s decision to land on a wet runway during…NTSB CEN21LA089Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA28 · Bossier City, LAThe student pilot’s decision to conduct a flight during night instrument meteorological conditions and his loss of airplane control due to spatial disorientation. Contributing to the accident was the student pilot’s use of an amphetamine and his attention…NTSB CEN21LA086Accident · No injuriesClass 4 · LimitedFinal reportEclipse EA 500 · Leadville, COThe pilot’s failure to maintain proper control of the airplane, which led to an unstabilized approach and a long landing on a runway contaminated with ice and patchy packed snow resulting in a runway excursion.NTSB ERA21LA070Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA24 · Nashville, TNThe pilot’s failure to use carburetor heat during the approach, which resulted in a loss of engine power due to carburetor icing.NTSB ERA21LA079Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Nantucket, MAThe pilot's failure to maintain adequate clearance from obstacles during the attempted go around following an approach to landing in sun glare.NTSB ERA21LA074Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Dexter, METhe pilot’s loss of directional control while landing, which resulted in an encounter with snow and subsequent nose over.NTSB CEN21LA085Accident · Serious injuriesClass 4 · LimitedFinal reportLuscombe 8 · Manvel, TXThe pilot’s failure to maintain clearance from power lines during his attempted landing and his loss of situational awareness that led to him to misidentify a pipeline field for the landing airpark.NTSB WPR21LA067Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Dillon, MTThe student pilot’s exceedance of the airplane’s critical angle attack during an attempted go-around, which resulted in an aerodynamic stall.NTSB ERA21LA065Incident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Leesburg, VAThe pilot’s loss of directional control during landing in crosswind conditions. Contributing to the loss of control was the significantly underinflated nose landing gear tire.NTSB CEN21LA075Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA32 · Windom, MNThe pilot’s spatial disorientation shortly after takeoff into night instrument meteorological conditions, which resulted in loss of airplane control and subsequent impact with terrain.NTSB CEN21LA077Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Marietta, TXThe pilot’s failure to see and avoid a transmission wire during takeoff.NTSB ANC21LA008Accident · No injuriesClass 4 · LimitedFinal reportPiper PA18 · Juneau, AKThe solo student pilot’s failure to maintain directional control during taxi in strong crosswind conditions, which resulted in a loss of control and subsequent impact with a ditch.NTSB CEN21LA071Accident · No injuriesClass 3 · LimitedFinal reportCessna 551 · Lufkin, TXThe pilot’s decision to land on a runway that did not provide enough length to stop the airplane given the wet surface conditions, resulting in a runway excursion.NTSB CEN21LA079Accident · No injuriesClass 4 · LimitedFinal reportHutson Star-Lite · San Antonio, TXThe pilot’s decision to land on a soft terrain which resulted in the failure of the nose landing gear.NTSB CEN21LA072Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Elton, LAThe loss of engine power, which resulted in a forced landing on unsuitable terrain. The reason for the loss of engine power could not be determined based on available evidence.NTSB ERA21LA060Accident · No injuriesClass 4 · LimitedFinal reportChampion 7EC · Northhampton, NYThe pilot’s loss of airplane control during an off-airport landing on soft sand, which resulted in a nose over.NTSB CEN21LA068Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · French Lick, INThe pilot’s improper in-flight decision making which resulted in a total loss of engine power due to fuel starvation.NTSB ERA21LA057Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Sanford, NCThe pilot's loss of directional control during takeoff in crosswind conditions, which resulted in a runway excursion and impact with terrain.NTSB CEN21LA111Accident · No injuriesClass 4 · LimitedFinal reportCessna T182T · Hollister, MOThe pilot’s failure to maintain proper airspeed control during an instrument approach in instrument meteorological conditions, which led to a bounced landing, collapsing the nose landing gear, and resulting in substantial damage.NTSB ERA21LA056Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Atlanta, GAThe Cessna pilot’s failure to tune his radio to the common traffic advisory frequency, which resulted in a lack of awareness of the other aircraft operating at the airport. Contributing to the accident was the Cessna pilot’s lack of understanding of the…NTSB ERA21LA054Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Greenville, SCA partial loss of engine power due to the pilot’s delayed application of carburetor heat, which resulted in carburetor icing.NTSB ERA21LA053Accident · 1 fatalClass 3 · LimitedFinal reportBeech V35 · Deltaville, VAAn uncontrolled descent and impact with terrain following an in-flight collision with seagulls.NTSB CEN21LA087Accident · No injuriesClass 4 · LimitedFinal reportPiper PA12 · Gilliam, LAThe non-instrument rated pilot’s encounter with poor weather conditions resulting in his performing a precautionary landing to a cornfield and subsequently nosing over.NTSB ERA21LA050Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Cynthiana, KYThe pilot’s failure to maintain proper glide path during a visual approach that was conducted at night, resulting in a collision with trees and terrain.NTSB ERA21LA045Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Manville, NJThe pilot's failure to maintain directional control while landing in a gusty crosswind, which resulted in a runway excursion and noseover.NTSB ERA21LA047Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL3 · Greenville, NCThe airplane’s collision with a bird during initial climb, which resulted in a forced landing.NTSB CEN21LA074Accident · No injuriesClass 4 · LimitedFinal reportZlin Savage Cub-S · Francis, OKThe pilot’s selection of unsuitable terrain for the landing, which resulted in a nose over when the airplane encountered soft sand during the landing roll.NTSB WPR21LA056Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Howe, IDThe pilot’s failure to maintain clearance from mountainous terrain after an encounter with a downdraft, which resulted in a collision with terrain.NTSB ERA21LA048Accident · No injuriesClass 4 · LimitedFinal reportVans RV4 · Milton, FLThe pilot's failure to maintain directional control during a crosswind landing.NTSB WPR21LA051Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MX7 · Moab, UTThe pilot's failure to maintain airplane control during takeoff from an unimproved airstrip, which resulted in a nose-over.NTSB WPR21FA048Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Los Angeles, CAMaintenance personnel’s failure to properly secure the throttle control hardware during recent maintenance, which resulted in its disconnection and a subsequent loss of engine power on approach for landing.NTSB CEN21LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Salem, INThe pilot’s failure to avoid an obstacle during his approach to land.NTSB CEN21LA055Accident · 2 fatalClass 3 · LimitedFinal reportCessna 182R · Rockwall, TXThe pilot’s decision to continue an unstabilized approach and his delayed go-around decision, which resulted in the airplane’s impact with power lines and the ground. Contributing to the accident was the inaccurate wind direction reporting as a result of a…NTSB WPR21FA045Accident · 2 fatalClass 3 · FieldFinal reportCessna 177 · Langley, WAThe flight instructor’s failure to maintain airspeed, which resulted in an aerodynamic stall and subsequent loss of control while attempting to conduct an emergency landing. Contributing to the accident was a total loss of engine power as a result of…NTSB WPR21LA042Accident · Minor injuriesClass 4 · LimitedFinal reportDiamond DA40 · Mesa, AZThe pilot’s failure to maintain clearance with a vehicle while taxiing.NTSB ERA21LA041Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20C · Laconia, NHThe pilot’s failure to maintain adequate clearance from trees during an approach in sun glare and hazy conditions.NTSB CEN21LA058Accident · No injuriesClass 4 · LimitedFinal reportTemco GC-1B · Waukegan, ILThe pilot’s failure to maintain directional control during takeoff with a crosswind that resulted in a ground loop and impact with terrain.NTSB CEN21LA044Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-22-135 · Dunn Center, NDThe noninstrument-rated pilot’s decision to depart into instrument meteorological conditions, which resulted in a loss of control.