NTSB investigations

19,008 cases where NTSB found Personnel issues.

Cases, newest first

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\", '02'))
  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.

NTSB ERA13FA209Accident · 2 fatalField investigationFinal reportCessna 210E · Williamsburg, VAThe pilot’s failure to maintain airplane control during a base-to-final turn with a gusting wind and potential turbulence/wind shear, which resulted in an aerodynamic stall and collision with terrain.Apr 19, 2013 · N111BK · Substantial damageNTSB WPR13CA258Accident · No injuriesData collectionFinal reportCessna P210N · Corvallis, ORThe pilot's inadvertent selection and activation of the landing gear handle rather than the flap handle during the landing roll. Contributing to the accident was the pilot's decision to alter the configuration of the airplane before exiting the runway.Apr 18, 2013 · N711BG · Substantial damageNTSB WPR13CA200Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Rexburg, IDThe pilot's failure to maintain airplane control during landing in gusting wind conditions, and the airplane’s subsequent collision with a fence during the go-around attempt.Apr 18, 2013 · N741R · Substantial damageNTSB ERA13CA208Accident · No injuriesData collectionFinal reportCessna 140 · Lancaster, SCThe pilot’s decision to land with a tailwind and his failure to turn off the carburetor heat during a go-around, which resulted in degraded engine performance and the airplane’s subsequent collision with trees at the end of the runway.Apr 18, 2013 · N76688 · Substantial damageNTSB ERA13CA206Accident · Minor injuriesData collectionFinal reportPoole Robert C JR Van's · Salisbury, NCThe pilot's improper landing flare, which resulted in a hard landing, and his subsequent decision to exit the paved runway onto the soft terrain.Apr 17, 2013 · N439RP · Substantial damageNTSB ERA13CA207Accident · No injuriesData collectionFinal reportCessna A185F · Palatka, FLThe pilot’s failure to retract the landing gear after takeoff from a runway, and his subsequent water landing with the wheels extended.Apr 16, 2013 · N812F · Substantial damageNTSB CEN13CA230Accident · No injuriesData collectionFinal reportWing Harold Kitfox II · Blaine, MNThe pilot's improper touchdown and subsequent failure to maintain control of the airplane during the landing roll. Contributing to the accident was the pilot’s lack of experience in tailwheel-equipped airplanes.Apr 16, 2013 · N389HW · Substantial damageNTSB WPR13FA201Accident · 2 fatalField investigationFinal reportCessna 182D · Wellington, NVThe pilot’s failure to maintain clearance from mountainous terrain during a night, visual descent to the destination airport, which resulted in controlled flight into terrain.Apr 15, 2013 · N9078X · DestroyedNTSB WPR13CA193Accident · No injuriesData collectionFinal reportCessna 210B · Caldwell, IDThe pilot’s failure to lower the landing gear, which resulted in a gear-up hard landing.Apr 15, 2013 · N9685X · Substantial damageNTSB CEN13LA229Accident · Minor injuriesLimited investigationFinal reportBeech N35 · Warren, ARThe fatigue failure of the engine crankshaft due to oversized crankcase saddle bores, which resulted from maintenance personnel improperly resizing the saddle bores during engine maintenance.Apr 15, 2013 · N9414Y · Substantial damageNTSB CEN13CA302Accident · Serious injuriesData collectionFinal reportJans Robert Falcon XP · Diboll, TXThe pilot did not properly secure a sand bag in the airplane's rear seat causing its flight controls to become jammed and resulting in the airplane's inability to avoid a collision with power lines.Apr 15, 2013 · N86FB · DestroyedNTSB WPR13LA191Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Mesquite, NVSeparation of the propeller from the engine during initial climb due to the incorrect torque applied to the propeller hub nut during maintenance.Apr 14, 2013 · N87114 · Substantial damageNTSB ERA13FA201Accident · 1 fatalField investigationFinal reportSchoonover John D KIT FOX IV 1200 · St. Lucie, FLThe pilot’s failure to maintain adequate airspeed during the turn to final, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot’s combined use of two sedating…Apr 14, 2013 · N117S · Substantial damageNTSB CEN13LA231Accident · No injuriesLimited investigationFinal reportNeedham Stoddard-Hamilton TD · Bloomington, INThe improper installation of a rudder control cable connector and its subsequent separation from the bellcrank, which resulted in the loss of directional control during takeoff.Apr 14, 2013 · N95RL · Substantial damageNTSB CEN13LA227Accident · Serious injuriesLimited investigationFinal reportQuad City Ultralight Acft Challenger I · Winnie, TXThe noncertificated pilot’s failure to maintain airplane control during takeoff due to his fixation on the instrument panel.Apr 14, 2013 · N171DP · Substantial damageNTSB CEN13CA303Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Livingston, TXThe pilot's delay to not perform a go-around when he lost sight of the runway while on final approach to land at night. Contributing to the accident was the obscuration (tall grass) of the runway edge lights.Apr 14, 2013 · N6784F · Substantial damageNTSB WPR13LA190Accident · Serious injuriesLimited investigationFinal reportBeech 35-B33 · San Manuel, AZA loss of engine power due to fuel starvation during the landing approach. Contributing to the accident was the pilot’s failure to follow the emergency checklist and switch tanks. Contributing to the severity of the pilot's injuries was the lack of a shoulder…Apr 13, 2013 · N6841Q · Substantial damageNTSB ERA13CA202Accident · Minor injuriesData collectionFinal reportCessna 172N · Summersville, WVThe pilot's failure to maintain directional control of the airplane while landing, which resulted in a runway excursion.Apr 13, 2013 · N6136F · Substantial damageNTSB CEN13LA228Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Buffalo, SDThe pilot’s failure to maintain adequate main rotor rpm while maneuvering at a low altitude in gusting wind conditions, which resulted in an emergency landing on uneven terrain.Apr 13, 2013 · N424DP · Substantial damageNTSB CEN13CA226Accident · No injuriesData collectionFinal reportEdward W Gray Lancair 360 · Alexandria, LAThe pilot's failure to attain the proper touchdown point, and his decision to continue the landing, which resulted in a runway excursion.Apr 13, 2013 · N77ZG · Substantial damageNTSB WPR13TA198Accident · No injuriesFinal reportBell OH-58C · Phoenix, AZThe pilot receiving instruction's delay in adding power during a recovery from a practice autorotation.Apr 12, 2013 · N119FT · Substantial damageNTSB WPR13LA188Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Ocean Shores, WAThe pilots’ loss of helicopter control during the approach to landing.Apr 12, 2013 · N442FG · Substantial damageNTSB WPR13CA218Accident · No injuriesData collectionFinal reportSchleicher ASW-27 · Middletown, CAThe glider’s encounter with atmospheric lift conditions not sufficient to maintain flight, which resulted in a forced landing on rough terrain.Apr 12, 2013 · N503CW · Substantial damageNTSB ERA13CA310Accident · No injuriesData collectionFinal reportSchleicher Alexander ASH 26 E · Tullahoma, TNThe pilot's improper use of wing spoilers during approach resulting in an altitude loss and collision with a tree.Apr 12, 2013 · N26EL · Substantial damageNTSB ERA13LA199Accident · Minor injuriesLimited investigationFinal reportMaxfly Inc/Mckay WM Searey · Polk City, FLThe improper installation of incorrect attachment hardware by maintenance personnel during an undocumented repair, which resulted in an in-flight structural failure and subsequent loss of aircraft control. Contributing to the accident was the covering of the…Apr 11, 2013 · N914WM · Substantial damageNTSB ERA13LA198Accident · No injuriesLimited investigationFinal reportFranke Russell J Searey · Polk City, FLAn inadvertent encounter with the water wake from a larger amphibious airplane before takeoff and the pilot's subsequent inadequate preflight inspection of the airplane during which he failed to note damage caused by the wake encounter.Apr 11, 2013 · N92319 · Substantial damageNTSB WPR13LA186Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Silver Peak, NVThe pilot’s incapacitation due to sleeping pills, which led to the airplane impacting terrain in an autopilot-controlled descent following a loss of engine power due to fuel exhaustion.Apr 10, 2013 · N205KT · Substantial damageNTSB WPR13CA192Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Moose Creek Ranger Station, IDThe pilot's use of excessive braking after landing with a tailwind and after an extended touchdown to avoid deer on the runway.Apr 9, 2013 · N3505P · Substantial damageNTSB ERA13CA200Accident · No injuriesData collectionFinal reportCessna 152 · Columbus, GAThe student pilot's improper recovery from a bounced landing.Apr 8, 2013 · N46803 · Substantial damageNTSB CEN13CA222Accident · Minor injuriesData collectionFinal reportCessna 172 · Manvel, TXThe pilot’s failure to maintain airplane control while taking off in gusting wind conditions.Apr 8, 2013 · N7825T · Substantial damageNTSB WPR13CA199Accident · No injuriesData collectionFinal reportCessna A185E · Cottonwood, IDThe pilot’s failure to see and avoid an object on the grass airstrip during the takeoff.Apr 7, 2013 · N2303Y · Substantial damageNTSB ERA13LA194Accident · No injuriesLimited investigationFinal reportCessna 172M · New Castle, VAThe pilot's failure to abort the takeoff after recognizing that the airplane was not accelerating properly, which led to an aerodynamic stall. The reason for the lack of acceleration could not be determined because postaccident examinations did not reveal any…Apr 7, 2013 · N92804 · Substantial damageNTSB CEN13FA221Accident · 2 fatalField investigationFinal reportMooney M20J · Collinsville, OKThe pilot’s loss of control of the airplane for reasons that could not be determined because an examination of the airplane did not find an abnormality that would have precluded normal operations.Apr 7, 2013 · N57672 · DestroyedNTSB WPR13FA183Accident · 1 fatalField investigationFinal reportCessna 182C · Circle, MTThe pilot’s failure to maintain airplane control as a result of spatial disorientation. Contributing to the accident was the pilot’s decision to continue flight into low visibility conditions.Apr 6, 2013 · N8721T · DestroyedNTSB WPR13CA228Accident · No injuriesData collectionFinal reportSocata TBM 700 · Sandy Valley, NVThe pilot's failure to extend the landing gear, which resulted in a gear-up landing.Apr 6, 2013 · N751J · Substantial damageNTSB DCA13FA071Accident · No injuriesField investigationFinal reportAirbus 321 · Las Vegas, NVthe captain's improper recovery from a bounced landing which resulted in a tailstrike.Apr 5, 2013 · N560UW · Substantial damageNTSB WPR13LA180Accident · No injuriesLimited investigationFinal reportCessna 172 · Phoenix, AZThe student pilot's excessive directional control inputs during the takeoff roll and the flight instructor's delayed and ineffective corrective actions, which resulted in the loss of airplane control.Apr 4, 2013 · N2166K · Substantial damageNTSB ERA13LA187Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLA partial loss of engine power due to the failure of the No. 3 exhaust valve. Contributing to the accident was the airplane operator’s failure to follow the engine manufacturer’s recommended engine overhaul intervals.Apr 4, 2013 · N6141Q · Substantial damageNTSB WPR13CA179Accident · No injuriesData collectionFinal reportAeronca 7CCM · Caldwell, IDThe pilot's loss of directional control after an encounter with a wind gust during takeoff.Apr 3, 2013 · N4687E · Substantial damageNTSB ERA13FA186Accident · 2 fatalField investigationFinal reportRobinson R44 · Miami, FLThe mechanic's failure to properly secure the pitch link hardware of one main rotor blade to the rotating swash plate, which resulted in the pitch link separating in flight and the pilot's subsequent loss of control. Contributing to the accident was the…Apr 3, 2013 · N3101H · DestroyedNTSB WPR13LA178Accident · Serious injuriesLimited investigationFinal reportMD Helicopter 369A · Darby, MTThe pilot's failure to arrest the landing descent due to his incorrect use of the throttle, which resulted in a hard landing.Apr 2, 2013 · N369HW · Substantial damageNTSB WPR13CA173Accident · No injuriesData collectionFinal reportCessna 150 · Brush Praire, WAThe pilot's failure to maintain directional control during the landing flare.Apr 1, 2013 · N4342U · Substantial damageNTSB ERA13LA188Accident · No injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLThe disconnection of the nose landing gear actuator, which resulted in the subsequent collapse of the nose landing gear. Contributing to the accident was the repair station’s inadequate maintenance, postmaintenance inspection process, and oversight of the…Apr 1, 2013 · VQ-TIN · Substantial damageNTSB CEN13FA217Accident · 2 fatalField investigationFinal reportMooney M20E · Guymon, OKThe noninstrument-rated pilot's encounter with instrument meteorological conditions, which resulted in spatial disorientation and his subsequent loss of airplane control. Contributing to the accident was the pilot's decision to take off in deteriorating…Apr 1, 2013 · N9330M · DestroyedNTSB ERA13FA184Accident · 2 fatalField investigationFinal reportLancair LC42 - 550FG · Winston-Salem, NCThe pilot's failure to detect multiple indications and cues in the cockpit of the steady loss of engine oil pressure, which resulted in a catastrophic engine failure over terrain unsuitable for landing. Also causal was the loss of internal engine lubrication…Mar 31, 2013 · N6506L · DestroyedNTSB CEN13FA219Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Castle Rock, COThe pilot's loss of airplane control while maneuvering between two convective storms that likely produced low-level windshear. Contributing to the accident was the pilot's relatively low overall flight experience and low night flight experience, which…Mar 31, 2013 · N55093 · Substantial damageNTSB ANC13GA036Accident · 3 fatalClass 1Final reportEurocopter AS350 · Talkeetna, AKThe pilot's decision to continue flight under visual flight rules into deteriorating weather conditions, which resulted in the pilot's spatial disorientation and loss of control. Also causal was the Alaska Department of Public Safety's punitive culture and…Mar 31, 2013 · N911AA · DestroyedNTSB WPR13LA174Accident · No injuriesLimited investigationFinal reportVans RV12 · Waldport, ORThe pilot’s improper flare, which resulted in a hard landing.Mar 30, 2013 · N572LS · Substantial damageNTSB WPR13CA172Accident · No injuriesData collectionFinal reportWaco YMF-3 · Thermal, CAThe pilot’s failure to maintain directional control while landing in a gusting crosswind.Mar 30, 2013 · N14080 · Substantial damageNTSB ERA13CA223Accident · No injuriesData collectionFinal reportPiper J3L-65 · Daytona Beach, FLThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion. Contributing to the accident was the pilot’s improper decision to land with a tailwind.Mar 30, 2013 · N35252 · Substantial damage