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 CEN13CA189Accident · No injuriesData collectionFinal reportCessna 140 · El Reno, OKThe pilot's failure to maintain control during takeoff. Contributing to the accident was the check pilot's delayed remedial action.Mar 11, 2013 · N90047 · Substantial damageNTSB WPR13CA142Accident · Minor injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · San Jose, CAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the pilot’s failure to adequately latch the canopy before takeoff.Mar 10, 2013 · N811EV · Substantial damageNTSB WPR13FA141Accident · 1 fatalField investigationFinal reportMaule M5 · Woodinville, WAThe pilot's failure to maintain adequate airspeed following a total loss of engine power due to fuel contamination, which resulted in a stall/spin and subsequent impact with terrain.Mar 9, 2013 · N17PR · Substantial damageNTSB ERA13CA161Accident · Minor injuriesData collectionFinal reportRainbow Aircraft PTY Cobra · Camden, SCThe pilot's failure to maintain airplane control during the approach to land.Mar 9, 2013 · N78DK · Substantial damageNTSB DCA13CA065Accident · No injuriesData collectionFinal reportBoeing 757-232 · Atlanta, GAthe pilot's failure to maintain correct airspeed and pitch attitude at touchdown.Mar 8, 2013 · N698DL · Substantial damageNTSB CEN13LA191Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Beech Grove, ARThe pilot’s failure to maintain control of the airplane during the takeoff roll.Mar 8, 2013 · N6902K · Substantial damageNTSB ANC13FA030Accident · 2 fatalField investigationFinal reportBeech 1900C · Aleknagik, AKThe flight crew's failure to maintain terrain clearance, which resulted in controlled flight into terrain in instrument meteorological conditions. Contributing to the accident were the flight crew's failure to correctly read back and interpret clearance…Mar 8, 2013 · N116AX · DestroyedNTSB ANC13CA031Accident · Minor injuriesData collectionFinal reportNelson Larry L WAG Aero 2+2 · Chickaloon, AKThe pilot's delayed decision to abort the landing.Mar 8, 2013 · N86LN · Substantial damageNTSB CEN13LA188Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Olathe, KSThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.Mar 7, 2013 · N715BB · Substantial damageNTSB ERA13CA155Accident · No injuriesData collectionFinal reportEngineering & Research Ercoupe 415-C · Newnan, GAThe pilot's failure to maintain proper visual lookout during taxi operations, which resulted in a collision with a parked airplane.Mar 5, 2013 · N87172 · Substantial damageNTSB ANC13CA028Accident · No injuriesData collectionFinal reportCessna 185B · Flat, AKThe pilot's inadequate compensation for gusting, variable wind conditions during initial climb after takeoff.Mar 5, 2013 · N2550Z · Substantial damageNTSB WPR13CA140Accident · Minor injuriesData collectionFinal reportWeston SEA-ERA · Bellevue, WAThe pilot’s failure to maintain control during takeoff on choppy water conditions.Mar 4, 2013 · N226SE · Substantial damageNTSB ERA13CA154Accident · No injuriesData collectionFinal reportCessna 172P · Bardstown, KYThe student pilot’s improper flare during a crosswind landing, which resulted in a hard landing.Mar 4, 2013 · N89847 · Substantial damageNTSB CEN13LA186Accident · 1 fatalLimited investigationFinal reportFisher Michael E Celebrity · Terrell, TXThe pilot’s exceedance of the airplane’s design stress limits while performing aerobatic maneuvers.Mar 4, 2013 · N70785 · DestroyedNTSB ANC13FA027Accident · 3 fatalField investigationFinal reportCessna 182B · Nikolai, AKThe pilot’s failure to maintain adequate airspeed while maneuvering inside a box canyon and the airplane’s subsequent aerodynamic stall, which resulted in an in-flight collision with mountainous terrain. Contributing to the accident was the pilot’s visual…Mar 4, 2013 · N2343G · Substantial damageNTSB WPR13FA138Accident · 1 fatalField investigationFinal reportCessna 172M · Saratoga, WYThe pilot’s decision to attempt flight into approaching adverse weather, which led to his low-level flight, encounter with mountain obscuration and moderate turbulence, and his subsequent loss of airplane control. Contributing to the severity of the pilot’s…Mar 3, 2013 · N5129R · Substantial damageNTSB CEN13FA183Accident · 4 fatalField investigationFinal reportMooney M20E · Angel Fire, NMThe pilot's loss of control while flying in a turbulent mountain-wave environment. Contributing to the accident was the pilot's overconfidence in his ability to safely pilot the airplane in gusting wind conditions and his lack of experience operating in…Mar 3, 2013 · N3484X · Substantial damageNTSB WPR13LA137Accident · 1 fatalLimited investigationFinal reportHughes 369HS · Latangai Island, Papua New GuineaThe failure of both the pilot and the fish master of the vessel to adequately monitor their environment, which resulted in a collision.Mar 2, 2013 · N471M · Substantial damageNTSB WPR13CA139Accident · No injuriesData collectionFinal reportCessna 172F · Nampa, IDThe failure of the pilot of another airplane, who was taxiing with no intent for flight, to maintain proper visual lookout.Mar 2, 2013 · N8713U · Substantial damageNTSB WPR13CA136Accident · Serious injuriesData collectionFinal reportBuckeye Dream Machine · Tracy, CAThe pilot’s failure to see and avoid power lines during a climb.Mar 2, 2013 · N7193K · Substantial damageNTSB ERA13LA151Accident · No injuriesLimited investigationFinal reportCessna 150 · Naples, METhe student pilot’s improper decision to land on a frozen lake.Mar 2, 2013 · N3438J · Substantial damageNTSB CEN13CA185Accident · Minor injuriesData collectionFinal reportPiper PA22 · Baraga, MIThe pilot’s failure to maintain directional control during taxi.Mar 2, 2013 · N2238A · Substantial damageNTSB ERA13CA150Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Brunswick, GAThe pilot's failure to maintain directional control while landing in a strong, gusting crosswind.Feb 28, 2013 · N135CD · Substantial damageNTSB ANC13LA026Accident · Serious injuriesLimited investigationFinal reportIsaak Paul G Isaak Super CUB · Sterling, AKThe pilot’s failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.Feb 28, 2013 · N130Z · Substantial damageNTSB ERA13LA148Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Sanford, NCThe installation of an incorrect length of cotter pin on the throttle linkage clevis pin by maintenance personnel at an undetermined time, which resulted in the pin coming loose and the loss of throttle control.Feb 27, 2013 · N1953H · Substantial damageNTSB CEN13LA179Accident · 1 fatalLimited investigationFinal reportCessna 150M · Deming, NMThe pilot's physical incapacitation, including loss of vision, which led to a loss of control and the subsequent in-flight breakup of the airplane.Feb 27, 2013 · N9172U · Substantial damageNTSB WPR13LA135Accident · Serious injuriesLimited investigationFinal reportSummit II · Quartzsite, AZThe noncertificated pilot’s failure to maintain aircraft control after encountering shifting wind, which resulted in collision with a windsock.Feb 25, 2013 · N8028X · Substantial damageNTSB ERA13FA144Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Lutz, FLThe noninstrument-rated pilot’s decision to attempt a visual flight rules flight in instrument meteorological conditions, which resulted in spatial disorientation and a loss of aircraft control. Contributing to the accident was the pilot’s lack of instrument…Feb 24, 2013 · N2895U · DestroyedNTSB ERA13CA163Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Greenbrier, ALThe pilot’s failure to maintain adequate clearance from trees.Feb 24, 2013 · N7310N · Substantial damageNTSB ERA13CA147Accident · Serious injuriesData collectionFinal reportEmbraer ERJ 190-100 IGW · Tunica, MSThe cabin attendant's failure to follow published guidance and checklists before and during landing.Feb 24, 2013 · N164HQ · No damageNTSB CEN13CA176Accident · No injuriesData collectionFinal reportCessna 172A · Vineland, MNThe pilot’s decision to attempt a touch-and-go landing on a narrow, ice-covered road with snow banks on each side.Feb 24, 2013 · N76NG · Substantial damageNTSB ERA13CA182Accident · No injuriesData collectionFinal reportPiper PA-46-310P · Venice, FLThe pilot’s failure to secure the airplane before moving the propeller to assist the engine start.Feb 23, 2013 · C-GNEW · Substantial damageNTSB WPR13CA133Accident · No injuriesData collectionFinal reportLuscombe 8A · Lebanon, ORThe pilot’s failure to compensate for a crosswind during initial climb, which resulted in a loss of control.Feb 22, 2013 · N1192K · Substantial damageNTSB CEN13FA174Accident · 2 fatalField investigationFinal reportEurocopter AS 350 B2 · Oklahoma City, OKThe loss of engine power due to engine ice ingestion during initial climb after takeoff in dark night light conditions. Contributing to the accident were the lack of an installed engine air inlet cover while the helicopter was parked outside, exposed to…Feb 22, 2013 · N917EM · Substantial damageNTSB ERA13MA139Accident · 5 fatalMajor investigationFinal reportBeech 390 · Thomson, GAThe pilot's failure to follow airplane flight manual procedures for an antiskid failure in flight and his failure to immediately retract the lift dump after he elected to attempt a go-around on the runway. Contributing to the accident were the pilot's lack of…Feb 21, 2013 · N777VG · DestroyedNTSB ERA13CA142Accident · Minor injuriesData collectionFinal reportDombroski Frank Vans RV-10 · Lake Placid, NYThe pilot's improper in-flight planning and decision making, which resulted in attempted visual flight in night instrument meteorological conditions and subsequent impact with terrain.Feb 21, 2013 · N10FD · Substantial damageNTSB CEN13IA177Incident · No injuriesIncident investigationFinal reportTTX Air Lancair · Indianapolis, INThe pilots' failure to verify landing gear extension before landing.Feb 21, 2013 · N613TX · Minor damageNTSB CEN13FA172Accident · 1 fatalField investigationFinal reportMaule MXT-7-180 · Parkers Parairie, MNThe pilot’s failure to transfer fuel from the auxiliary fuel tanks to the main fuel tanks in a timely manner, which resulted in fuel starvation to the engine.Feb 21, 2013 · N9229Y · Substantial damageNTSB ERA13CA141Accident · No injuriesData collectionFinal reportCessna 180 · Halifax, NCThe pilot's decision to land in gusty crosswind conditions, which resulted in a loss of airplane directional control during the landing roll.Feb 20, 2013 · N9411C · Substantial damageNTSB WPR13CA130Accident · No injuriesData collectionFinal reportCessna 152 · Kelso, WAThe student pilot's inadequate landing flare and lack of remedial actions, which resulted in a hard bounced landing.Feb 19, 2013 · N89956 · Substantial damageNTSB WPR13GA128Accident · 1 fatalFinal reportBell 206B · Eureka, NVThe pilot’s failure to maintain clearance from a wire while maneuvering during low-altitude operations. Contributing to the accident was task- and/or work-related fatigue.Feb 18, 2013 · N20620 · Substantial damageNTSB WPR13CA126Accident · No injuriesData collectionFinal reportBellanca 7ECA · Santa Paula, CAThe pilot's failure to maintain directional control during the landing roll.Feb 18, 2013 · N50380 · Substantial damageNTSB ERA13CA146Accident · No injuriesData collectionFinal reportCessna 172P · Valparaiso, FLThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions.Feb 18, 2013 · N98598 · Substantial damageNTSB ERA13CA137Accident · Minor injuriesData collectionFinal reportCessna 172N · Okeechobee, FLThe pilot’s failure to maintain directional control during takeoff.Feb 18, 2013 · N6249D · Substantial damageNTSB ANC13FA024Accident · Serious injuriesField investigationFinal reportCessna 170B · Skwentna, AKThe pilot’s failure to maintain airspeed during a departure turn, resulting in an aerodynamic stall and collision with terrain.Feb 18, 2013 · N2814C · Substantial damageNTSB ERA13LA136Accident · 1 fatalLimited investigationFinal reportQuicksilver MX2 · Poplarville, MSThe noncertificated pilot’s decision to make the flight and his failure to maintain clearance from trees while maneuvering at a low altitude.Feb 17, 2013 · UNREG · Substantial damageNTSB ERA13CA140Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Livingston, TNThe student pilot’s failure to maintain directional control during the landing roll.Feb 17, 2013 · N43077 · Substantial damageNTSB CEN13LA170Accident · No injuriesLimited investigationFinal reportCessna 195 · Austin, TXThe pilot's use of an excessive taxi speed, which resulted in the airplane overrunning the end of the unlit taxiway after the failure of the right wing landing light.Feb 17, 2013 · N4426C · Substantial damageNTSB CEN13LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Akron, COThe pilot’s physical impairment due to alcohol intoxication, which resulted in an aerodynamic stall during landing.Feb 17, 2013 · N6199E · DestroyedNTSB CEN13CA175Accident · Minor injuriesData collectionFinal reportCessna 177 · Elcho, WIThe pilot's inadequate preflight and in-flight fuel management, which led to a total loss of engine power due to fuel exhaustion.Feb 17, 2013 · N30227 · Substantial damage