NTSB investigations
70 cases where NTSB found Understanding/comprehension.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 5 |
| 2013 | 6 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 4 |
| 2017 | 5 |
| 2018 | 3 |
| 2019 | 1 |
| 2020 | 3 |
| 2021 | 10 |
| 2022 | 4 |
| 2023 | 8 |
| 2024 | 5 |
| 2025 | 3 |
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\", '02041515')) 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", '02041515')) 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 WPR26LA071Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Lake Elsinore, CAThe pilot’s intentional deployment of the airframe parachute system due to task-saturation in instrument meteorological conditions.NTSB ANC25LA043Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Snohomish, WAThe pilot’s decision to continue the landing attempt with insufficient runway remaining, which resulted in a runway overrun and collision with a fence.NTSB ANC25LA024Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot's failure to maintain an appropriate airspeed during the landing approach, which resulted in exceedance of the critical angle of attack and an aerodynamic stall, during gusting wind conditions.NTSB ANC24FA102Accident · 1 fatalClass 3 · FieldFinal reportCessna 206 · Chalkyitsik, AKA loss of engine power due to water-contaminated fuel as a result of the pilot’s inadequate preflight inspection. Contributing to the accident was the operator’s failure to ensure replacement filters were available for use during refueling operations.NTSB ANC24LA079Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Palmer, AKThe pilot's failure to follow the operator’s procedure manual and attempted to land at a remote landing zone in high wind conditions. Contributing factor was the pilot’s decision to not conduct a fly over of the landing site to determine wind condition which…NTSB CEN24FA243Accident · 2 fatalClass 3 · FieldFinal reportWaco YKC · Selden, KSThe pilot's inadvertent visual flight into instrument meteorological conditions, which had not been forecast at the time of departure, and which resulted in a loss of control due to spatial disorientation.NTSB ERA24LA230Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Hope Mills, NCA loss of engine performance due to carbon fouling of three spark plugs that, when combined with the airplane’s high gross weight condition, resulted in a collision with trees and terrain.NTSB ANC24LA016Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Hana, HIThe pilot’s failure to ensure the passenger’s gear was properly secured before departure.NTSB ERA24LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Miami, FLThe business jet flight crew’s failure to appropriately position their airplane to mitigate the impact of their extended duration, high-power engine run, and their failure to adequately communicate these factors to air traffic control, which resulted in the…NTSB WPR23LA315Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Marysville, CAThe flight instructor’s failure to monitor the airplane’s speed during a high-speed taxi, resulting in a runway excursion.NTSB ERA23LA299Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Richmond, VAThe pilot’s delay in performing a go-around after a likely encounter with low-level wind shear, resulting in a hard landing. Contributing to the accident were the pilot’s failure to recognize the severity of the actual and forecasted weather near the airport…NTSB ANC23FA045Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-300 · Old Harbor, AKThe pilot’s failure to maintain clearance from rising terrain. Contributing to the accident was the pilot’s delayed decision to turn away from the terrain.NTSB ANC23FA031Accident · 2 fatalClass 3 · FieldFinal reportBell Helicopter Textron 407 · Nuevo, CAThe pilot’s decision to maneuver in a steep bank at a low altitude, which resulted in his failure to maintain clearance with terrain.NTSB ERA23LA135Accident · 1 fatalClass 2 · LimitedFinal reportBombardier BD-100-1A10 · Windsor Locks, CTThe flight crew’s failure to remove the right side pitot probe cover before flight, their decision to depart with a No-Go advisory message following an aborted takeoff, and their selection of the incorrect non-normal checklist in flight, which resulted in an…NTSB DCA23LA192IncidentClass 4 · LimitedFinal reportLearjet 60 · Boston, MAThe Hop-a-Jet flight crew taking off without a takeoff clearance which resulted in a conflict with a JetBlue flight that had been cleared to land on an intersecting runway.NTSB WPR23FA110Accident · 2 fatalClass 3 · FieldFinal reportWillman Loren LOREN'S Aircam · Grass Valley, CAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall/spin at an altitude too low for recovery.NTSB CEN23FA045Accident · No injuriesClass 3 · FieldFinal reportCirrus Design SF50 · Mount Comfort, INThe uncommanded activation of the CAPS autopilot mode due to corrosion of the system’s electrical components. Contributing to the accident was the pilot’s failure to identify the CAPS autopilot mode and promptly follow the procedures in the airplane flight…NTSB WPR22FA266Accident · 2 fatalClass 3 · FieldFinal reportHolland Mike RV9A · Tryon, NEThe non-instrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, exceedance of the airplane’s design limitations, and in-flight breakup of the airplane…NTSB ERA22FA318Accident · 4 fatalClass 3 · FieldFinal reportPiper PA-46-350P · North Las Vegas, NVThe low-wing airplane pilot’s failure to ensure that the airplane was aligned with the correct runway, which resulted in a collision with the high-wing airplane on final approach. Contributing to the accident was the controller’s failure to provide timely and…NTSB CEN22LA181Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172M · Manhattan, KSThe pilot’s failure to use carburetor heat during the approach and his unsuitable flight profile for an upsloping runway, which resulted in a partial loss of engine power and an impact with terrain during an attempted go-around.NTSB WPR22FA053Accident · 1 fatalClass 3 · FieldFinal reportRussell W Dyer Vortex · Lakeport, CAThe pilot’s loss of control for reasons that could not be determined and the delayed remedial action to recover from the power pushover event.NTSB WPR22LA031Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Covelo, CAA passenger’s unsecured object departed the cabin resulted in a collision with the tail rotor drive shaft.NTSB CEN22LA010Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24 · Loveland, COThe pilot’s failure to recognize the degraded engine power and abort the takeoff in a timely manner.NTSB ERA22LA006Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Williston, FLThe pilot’s failure to maintain clearance from terrain on approach which resulted in controlled flight into trees. Contributing to the accident was the flight instructor’s inadequate supervision of the approach path, the dark night conditions and the landing…NTSB CEN21LA388Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Iron Mountain, MIThe mechanics’ failure to follow procedures for high-thrust operations at the nontowered airport, which resulted in jet blast damage to an airplane taxiing nearby.NTSB ANC21FA065Accident · 2 fatalClass 3 · FieldFinal reportCessna 172P · Eagle River, AKAn inflight collision with terrain under unknown circumstances. Contributing to the delayed rescue response was the failure of the emergency locator transmitter (ELT) to activate as designed, and the mechanic’s failure to ensure the correct ELT was installed…NTSB CEN21FA304Accident · 1 fatalClass 3 · FieldFinal reportFocke-Wulf FWP-149D · Killeen, TXThe total loss of engine power due to a fatigue failure of a crankshaft counterweight mounting lobe, which resulted in a counterweight separation and catastrophic secondary damage to the engine drivetrain. Contributing to the accident was the mislabeled…NTSB CEN21FA238Accident · 2 fatalClass 3 · FieldFinal reportLancair Evolution · McDermott, OHThe pilot’s failure to recognize and avoid airframe icing conditions, which resulted in a loss of airplane performance and a subsequent loss of control and in-flight break-up.NTSB CEN21LA216Accident · No injuriesClass 3 · LimitedFinal reportAerospatiale AS350 B2 Ecureuil · Yukon, OKThe pilot receiving instruction’s untimely and unidentified inadvertent activation of the hydraulic cut-off switch, which turned off the hydraulic system while the helicopter was at slow airspeed followed by a rapid power increase, which resulted in a loss of…NTSB WPR21LA110Accident · No injuriesClass 3 · LimitedFinal reportDassault FALCON900EX · San Diego, CAThe flight crew’s operation of the airplane outside of the manufacturer’s specified weight and balance limitations and with an improper trim setting, which resulted in the airplane’s inability to rotate during the attempted takeoff. Contributing to the…NTSB CEN21LA051Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Denver, COThe student pilot’s failure to maintain control of the airplane during landing with a gusting crosswind and his failure to go around and relinquish control of the airplane when directed by the instructor pilot.NTSB CEN21LA057Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus SR22 · Tishomingo, OKThe pilot’s improper adjustment of the engine mixture control, which resulted in a total loss of engine power. Contributing to the accident was a disconnected oil temperature connector, which was likely damaged during maintenance before the accident flight…NTSB CEN20CA335Accident · Serious injuriesClass 4 · Data collectionFinal reportCirrus SR22 · Lafayette, INThe pilot's failure to monitor aircraft control, which resulted in a loss of control when a passenger inadvertently moved the control stick, and the pilot and other passenger's decision to unbuckle their restraints inflight.NTSB WPR20LA024Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Ogden, UTThe flight instructor’s failure to raise the landing gear using the alternate system, which resulted in a reduced climb rate and impact with an obstacle. Contributing to the accident was the flight instructor’s lack of understanding of the backup landing gear…NTSB GAA19CA067Accident · No injuriesData collectionFinal reportJabiru J230-SP · Center, TXThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA18LA117Accident · No injuriesClass 3 · LimitedFinal reportStanley Lancair · Sebring, FLThe failure of ground personnel to obtain permission from airport management to conduct engine test runs; adequately monitor the area behind the B737 for traffic; and install barricades to prevent access behind the running airplane, which resulted in the…NTSB CEN18LA087Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Loveland, COThe airplane pilot’s failure to see and avoid the helicopter while in the traffic pattern, which resulted in a midair collision between the two aircraft. Contributing to the accident was the airplane pilot’s misunderstanding of the helicopter pilot’s…NTSB CEN18FA023Accident · 2 fatalField investigationFinal reportBeech V35B · Alva, OKThe flight instructor's and pilot's failure to recognize that a high descent rate had developed on short final, likely due to their distraction by an open engine cowling, and the unexpected strong pitch-down force during flap extension due to the installation…NTSB WPR17LA159Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Van Nuys, CAAn improper repair of the right magneto's tachometer and governor signal wire, which failed during cruise flight and initiated a simultaneous malfunction of both the engine tachometer and governor control system, which resulted in erroneous and contradictory…NTSB ERA17LA229Accident · Serious injuriesLimited investigationFinal reportAviat A-1C-180 · Dillwyn, VAThe pilot's selection of a grass airstrip that was of insufficient length for landing, and his exceedance of the airplane's critical angle of attack during the go-around, which resulted in an aerodynamic stall.NTSB WPR17FA074Accident · 1 fatalField investigationFinal reportQuicksilver MXL II · Hesperia, CAThe pilot's failure to identify and correct his construction error of a critical structural component, which resulted in a loss of airplane control during takeoff. Contributing to the accident was the pilot's impairment due to his combined use of multiple…NTSB OPS17IA014IncidentClass 3 · IncidentFinal reportEmbraer S A ERJ 170-200 LR · San Francisco, CAThe local controller's issuance of a landing clearance for runway 28L to the ERJ170, and the subsequent issuance of line up and wait instructions to the A320 for runway 28L, resulting in a runway incursion.NTSB ANC17LA008Accident · No injuriesLimited investigationFinal reportAirborne Extreme SQ-12 · Palmer, AKThe fuel injector manufacturer's inappropriate guidance to use a 5-ampere circuit breaker in place of the required 10-ampere circuit breaker on the fuel injector circuit, which resulted in the circuit breaker opening, a loss of electrical power to the…NTSB ANC17LA007Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bethel, AKThe mechanic's failure to install a whistle slot in the engine breather tube, which resulted in a frozen tube, displacement of the crankshaft oil seal, a loss of oil, and smoke in the cockpit, which led to a forced landing.NTSB WPR16LA090Accident · No injuriesLimited investigationFinal reportCessna 172L · McNeil Island, WAThe student pilot's fuel mismanagement, which led to fuel starvation and a total loss of engine power during cruise flight. Contributing to the accident was his failure to follow the appropriate engine start, before takeoff, and emergency checklists.NTSB ERA16LA085Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Concord, NCThe pilot’s inadequate management of the airplane’s automated systems, which resulted in a loss of control during an instrument approach and necessitated his subsequent deployment of the airplane’s parachute system.NTSB ERA15LA219Accident · 1 fatalLimited investigationFinal reportRainbow Aerotrike · Chesnee, SCThe pilot’s failure to maintain lateral or bank control during takeoff, which resulted in collision with, and subsequent suspension from, a tree. Contributing to the pilot’s fatal injuries was his attempt to jump out of the trike to a nearby tree limb.NTSB CEN15LA069Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Fort Collins, COThe student pilot’s failure to comprehend the significance of the wake turbulence that a preceding helicopter would generate during departure, which resulted in a loss of airplane control during landing. Contributing to the accident was the lack of Federal…NTSB ERA14LA193Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Louisa, VAThe pilot's decision to continue operation of the airplane with known mechanical issues (fluctuating oil pressure and metal in the oil filter), which was the result of undertorqued cylinder through bolts. Contributing to the accident was the mechanic's…NTSB CEN13FA415Accident · 1 fatalField investigationFinal reportBell UH-1H · Dove Creek, COPilot-induced oscillations caused by the loss of hydraulic assist of the flight controls due to an excessive loss of hydraulic fluid during a critical phase of flight, which resulted in ground impact. Contributing to the accident was an inadequate analysis of…