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 ERA12FA326Accident · 1 fatalField investigationFinal reportGutierrez Pablino Hummel Bird · DeFuniak Springs, FLThe pilot's failure to maintain airplane control due to the airplane’s exceedence of its maximum gross weight and center of gravity’s most rearward limit and his lack of familiarity with the airplane make and model, which resulted in an aerodynamic stall and…May 9, 2012 · N9001N · Substantial damageNTSB CEN12LA282Accident · No injuriesLimited investigationFinal reportBell 206B-III · Flora, INThe pilot allowed the helicopter to settle with power.May 9, 2012 · N1069Z · Substantial damageNTSB CEN12CA295Accident · Minor injuriesData collectionFinal reportFlight Design Ctls · Moorhead, MNThe failure to maintain adequate airspeed for the wind conditions during landing, which resulted in a loss of airplane control.May 9, 2012 · N9922P · Substantial damageNTSB CEN12CA285Accident · Minor injuriesData collectionFinal reportChampion 7GCBC · Genoa, NEThe pilot’s loss of directional control of the airplane during an aborted landing. Contributing to the accident was the pilot’s improper flare.May 9, 2012 · N1880G · Substantial damageNTSB WPR12LA198Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Hanksville, UTThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude in high density altitude conditions, which resulted in the airplane’s inability to climb or maintain clearance from terrain.May 8, 2012 · N28WF · Substantial damageNTSB WPR12CA194Accident · No injuriesData collectionFinal reportCessna 207A · Grangeville, IDThe pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a loss of airplane control.May 8, 2012 · N207YH · Substantial damageNTSB ERA12CA323Accident · No injuriesData collectionFinal reportBeech A36 · Paducah, KYThe pilot’s failure to properly secure the airplane before turning the propeller by hand.May 8, 2012 · N1819L · Substantial damageNTSB CEN12CA280Accident · No injuriesData collectionFinal reportCessna A188 · Sterling, ILThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's runway selection based on the wind conditions.May 8, 2012 · N3557Q · Substantial damageNTSB WPR12CA204Accident · No injuriesData collectionFinal reportCessna 172P · Spokane, WAThe student pilot's improper landing flare and inadequate recovery from a bounced landing.May 7, 2012 · N54036 · Substantial damageNTSB ERA12CA325Accident · Minor injuriesData collectionFinal reportCessna 172R · Culebra, PRThe pilot's failure to remove the flight control lock before takeoff.May 7, 2012 · N24461 · Substantial damageNTSB CEN12CA301Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · El Campo, TXThe pilot's decision to rotate early, the airplane’s subsequent inability to climb, and the pilot’s delayed decision to abort the takeoff.May 7, 2012 · N5016P · Substantial damageNTSB WPR12CA215Accident · No injuriesData collectionFinal reportMaule M-7-260 · Brigham City, UTThe pilot’s failure to maintain directional control while landing with a gusting crosswind.May 6, 2012 · N7ZF · Substantial damageNTSB ERA12CA322Accident · No injuriesData collectionFinal reportCessna 182N · Newport, VTThe pilot’s failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall and hard landing.May 6, 2012 · N9217G · Substantial damageNTSB ERA12CA321Accident · Serious injuriesData collectionFinal reportEiriavion PIK 20D · Eagleville, TNThe glider’s encounter with atmospheric lift conditions not sufficient to maintain flight, which resulted in an aerodynamic stall.May 6, 2012 · N39RB · Substantial damageNTSB CEN12CA279Accident · No injuriesData collectionFinal reportBalloon Works Firefly 7-15 · Hallsville, MOThe pilot’s failure to maintain clearance from power lines during landing.May 6, 2012 · N9079S · Substantial damageNTSB WPR12CA210Accident · No injuriesData collectionFinal reportPiper PA-28RT-201T · Mariposa, CAThe pilot's delay in aborting the takeoff, which resulted in a runway overrun.May 5, 2012 · N2195X · Substantial damageNTSB WPR12CA196Accident · No injuriesData collectionFinal reportCessna 195 · Heber-Overgaard, AZThe pilot's loss of directional control during takeoff roll upon encountering a wind gust.May 5, 2012 · N3442V · Substantial damageNTSB ERA12FA319Accident · 1 fatalField investigationFinal reportCessna 177B · Honesdale, PAThe pilot pitching the airplane to an excessive nose-up attitude during an aborted landing, which resulted in increased induced drag, diminished airspeed, and an aerodynamic stall/spin. Contributing to the accident was the pilot’s use of a sedating…May 5, 2012 · N34539 · Substantial damageNTSB ERA12CA351Accident · No injuriesData collectionFinal reportCubCrafters CC11-160 · Umatilla, FLThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.May 5, 2012 · N3711T · Substantial damageNTSB ERA12CA320Accident · Minor injuriesData collectionFinal reportCessna 172F · Cambridge, NYThe pilot’s loss of airplane control during a takeoff in variable crosswind conditions.May 5, 2012 · N5551R · Substantial damageNTSB CEN12CA281Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Houston, TXThe pilot’s improper recovery from a bounced landing.May 5, 2012 · N919LA · Substantial damageNTSB WPR12CA234Accident · No injuriesData collectionFinal reportMurphy Rebel · Hayden Lake, IDThe pilots’ failure to position the landing gear for landing on the water, which resulted in a nose-over.May 3, 2012 · N1076D · Substantial damageNTSB CEN12FA271Accident · 2 fatalField investigationFinal reportBeech S35 · Lake in the Hills, ILThe pilot's excessive bank angle while on approach to land, which resulted in an inadvertent aerodynamic stall and spin.May 3, 2012 · N176Q · Substantial damageNTSB CEN12CA278Accident · No injuriesData collectionFinal reportGalloway/Ward RV-4 · Redwood Falls, MNThe pilot’s failure to maintain control of the airplane during takeoff in gusty wind conditions.May 3, 2012 · N102GW · Substantial damageNTSB CEN12CA274Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Cedar Bluffs, NEThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.May 3, 2012 · N3166W · Substantial damageNTSB ANC12CA036Accident · No injuriesData collectionFinal reportShort Bros. & Harland SC7 Series 3 · Chefornak, AKThe pilot's misidentification of a nearby snow-covered road as the snow-covered runway in flat light conditions.May 3, 2012 · N1906 · Substantial damageNTSB WPR12FA191Accident · Serious injuriesField investigationFinal reportHughes 269C · Phoenix, AZA loss of tail rotor drive due to a fatigue failure of the main transmission pinion, which resulted in a loss of directional control during cruise flight.May 2, 2012 · N380TL · Substantial damageNTSB ERA12LA315Accident · No injuriesLimited investigationFinal reportBerry Dean Glasair I · Columbus, GAThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a runway sign. Contributing to the accident was the pilot’s lack of experience in the airplane make and model, resulting in and his…May 2, 2012 · N540GZ · Substantial damageNTSB CEN12LA267Accident · Minor injuriesLimited investigationFinal reportBell 206B · Valley Falls, KSThe pilot’s inadequate compensation for the wind conditions during a hover maneuver, which resulted in a loss of tail rotor effectiveness.May 2, 2012 · N85RB · Substantial damageNTSB CEN12CA277Accident · No injuriesData collectionFinal reportCessna 152 · San Antonio, TXThe student pilot's misjudgment of the landing flare, which resulted in a hard/bounced landing and subsequent impact with the runway.May 1, 2012 · N94500 · Substantial damageNTSB CEN12CA263Accident · No injuriesData collectionFinal reportCampbell David Legacy · Durango, COThe pilot’s improper flare and subsequent aerodynamic stall, which resulted in a hard landing.May 1, 2012 · N12KX · Substantial damageNTSB ERA12CA313Accident · No injuriesData collectionFinal reportArion Lightning LS-1 · Ghent, NYThe pilot's loss of directional control during takeoff, which resulted in a runway excursion.Apr 30, 2012 · N782MD · Substantial damageNTSB ANC12CA034Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe student pilot did not maintain sufficient airspeed during a steep turn after takeoff, which resulted in an aerodynamic stall.Apr 30, 2012 · N8976D · Substantial damageNTSB WPR12CA192Accident · No injuriesData collectionFinal reportCessna 195B · Sacramento, CAThe pilot’s failure to maintain directional control during the landing roll while landing with a gusting wind.Apr 29, 2012 · N2194C · Substantial damageNTSB ERA12LA309Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Pilot Mountain, NCThe pilot's failure to abort the takeoff in a timely manner. Contributing to the accident was the airplane’s reduced takeoff performance.Apr 29, 2012 · N5769D · Substantial damageNTSB ERA12CA311Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Eaton, NYThe pilot's improper approach to landing, which resulted in the airplane touching down short of the runway.Apr 29, 2012 · N82398 · Substantial damageNTSB ERA12CA310Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Burlington, NCThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.Apr 29, 2012 · N91250 · Substantial damageNTSB CEN12CA269Accident · No injuriesData collectionFinal reportEurocopter AS 350 B2 · Hugo, OKThe pilot’s inadequate collective control inputs while performing a hovering autorotation, which resulted in a hard landing. Contributing to the accident was the check airman's delayed remedial action.Apr 29, 2012 · N406EM · Substantial damageNTSB WPR12LA189Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Beckwourth, CAThe pilot’s failure to maintain sufficient airspeed during initial climb, which resulted in a loss of airplane control.Apr 28, 2012 · N2559U · Substantial damageNTSB WPR12LA188Accident · No injuriesLimited investigationFinal reportHawker Beech V35B · Coalinga, CAThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.Apr 28, 2012 · N2841W · Substantial damageNTSB ERA12LA314Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake Wales, FLThe student pilot’s decision to depart from an intersection with insufficient runway remaining for takeoff, which resulted in a rejected takeoff and subsequent runway excursion.Apr 28, 2012 · N746RA · Substantial damageNTSB ERA12LA307Accident · No injuriesLimited investigationFinal reportRice Leo B Kitfox Series 5 · Port Canaveral, FLImpingement of the elevator control by foreign objects (clamp, glove) left in the flight control path by the pilot/owner or maintenance personnel.Apr 28, 2012 · N77LR · Substantial damageNTSB WPR12LA185Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Cloverdale, CAThe pilot’s improper fuel management, which resulted in a loss of engine power during climb due to fuel starvation.Apr 27, 2012 · N80SV · Substantial damageNTSB WPR12CA187Accident · No injuriesData collectionFinal reportGlass Roy L RV-6 · Coolidge, AZThe pilot’s loss of directional control during landing.Apr 27, 2012 · N164RG · Substantial damageNTSB ERA12LA306Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Fowler's Bluff, FLThe pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.Apr 27, 2012 · N6564X · Substantial damageNTSB ERA12LA305Accident · Serious injuriesLimited investigationFinal reportAviat A-1B · Sylacauga, ALThe pilot's attempt to take off with the carburetor heat in the hot position, which limited the airplane’s performance, and the pilot's subsequent failure to maintain adequate airspeed, which resulted in an aerodynamic stall.Apr 27, 2012 · N388AS · Substantial damageNTSB ERA12FA303Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Anderson, SCThe pilot's failure to maintain control of the airplane during the aborted landing, which resulted in an aerodynamic stall and impact with terrain.Apr 27, 2012 · N154CK · Substantial damageNTSB ERA12CA304Accident · Serious injuriesData collectionFinal reportBell 206B · Hershey, PAThe pilot's diverted attention while performing aerial application at low altitude, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s failure to adjust the control friction to the position he was accustomed.Apr 27, 2012 · N16EP · Substantial damageNTSB WPR12LA444Accident · No injuriesLimited investigationFinal reportCessna 172S · Glendale, AZThe pilot's inadequate flare and compensation for gusting wind conditions, which resulted in a bounced landing.Apr 26, 2012 · N320ME · Substantial damageNTSB CEN12LA258Accident · Minor injuriesLimited investigationFinal reportBell 206B · Amarillo, TXThe pilot's failure to maintain helicopter control during landing in gusty wind conditions associated with a thunderstorm, which resulted in a loss of tail rotor effectiveness.Apr 26, 2012 · N2068X · Substantial damage