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 WPR11CA408Accident · No injuriesData collectionFinal reportCessna 140 · Kent, WAThe student pilot's inadvertent application of the brakes during the landing roll, which resulted in the airplane nosing over.Aug 27, 2011 · N2719N · Substantial damageNTSB ERA11CA474Accident · Minor injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe student pilot's landing at an unapproved location, which resulted in a ground fire from the engine exhaust.Aug 27, 2011 · N2093U · Substantial damageNTSB CEN11CA600Accident · No injuriesData collectionFinal reportCessna 182C · Grand Marais, MNThe pilot's delayed decision to land the airplane when he realized the airplane's performance was insufficient to clear approaching terrain during the initial climb after takeoff. Contributing to the accident was the pilot's inadequate preflight planning.Aug 27, 2011 · N9011T · Substantial damageNTSB ERA11LA473Accident · Minor injuriesLimited investigationFinal reportWoolston Glenn E Zenith 701 Stol · Carlton, NYThe pilot’s lack of recognition that the engine was being supplied fuel from only the right tank with the fuel selector in the both position, which resulted in the total loss of engine power due to fuel starvation. Contributing to the accident was the…Aug 26, 2011 · N246CV · Substantial damageNTSB CEN11LA605Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18 Dromader · Freeport, ILThe pilot's decision to operate the airplane with a known defect in the elevator control system that led to his inability to control the airplane during the initial climb.Aug 26, 2011 · N7070L · Substantial damageNTSB CEN11FA599Accident · 4 fatalClass 1 · FieldFinal reportEurocopter AS-350-B2 · Mosby, MOThe pilot's failure to confirm that the helicopter had adequate fuel on board to complete the mission before making the first departure, his improper decision to continue the mission and make a second departure after he became aware of a critically low fuel…Aug 26, 2011 · N352LN · Substantial damageNTSB CEN11CA662Accident · No injuriesData collectionFinal reportPiper PA-30 · Saguache, COThe pilot's failure to maintain airplane control during the aborted takeoff.Aug 26, 2011 · N75BA · Substantial damageNTSB CEN11CA627Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Batesville, TXThe pilot’s inadequate preflight inspection that failed to ensure all tie-down clamps were removed prior to takeoff, which resulted in the helicopter’s dynamic rollover.Aug 26, 2011 · N99FJ · Substantial damageNTSB CEN11CA620Accident · No injuriesData collectionFinal reportCessna T210M · Kremmling, COThe pilot's failure to maintain aircraft control during the landing.Aug 26, 2011 · N761NX · Substantial damageNTSB CEN11LA595Accident · No injuriesLimited investigationFinal reportCessna 140 · Monmouth, ILThe pilot's loss of airplane control during the landing roll.Aug 25, 2011 · N72688 · Substantial damageNTSB CEN11FA597Accident · 1 fatalField investigationFinal reportNichols Lancair 235 · Heath, OHThe pilot's failure to obtain adequate familiarization with the accident airplane type before the accident flight, which resulted in his failure to maintain airplane control during takeoff.Aug 25, 2011 · N777BN · DestroyedNTSB ANC11CA086Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Beluga Lake, AKThe pilot's decision to takeoff with an unfavorable wind which resulted in a loss of directional control, and collision with terrain.Aug 25, 2011 · N8491Y · Substantial damageNTSB ANC11CA085Accident · No injuriesData collectionFinal reportMaule M-5-210C · Tok, AKThe pilot's failure to go-around soon enough to preclude the necessity of a forced landing due to the airplane's inability to outclimb ascending terrain.Aug 24, 2011 · N62019 · Substantial damageNTSB WPR11FA404Accident · Serious injuriesField investigationFinal reportCessna 150G · Cavanaugh Bay, IDThe pilot’s failure to maintain adequate airspeed during an attempt to execute a go-around with a tailwind condition, which resulted in an aerodynamic stall and spin.Aug 23, 2011 · N2870S · Substantial damageNTSB WPR11FA403Accident · No injuriesField investigationFinal reportBeech A23-24 · Palo Alto, CAThe student’s and flight instructor’s mismanagement of the fuel supply, resulting in a total loss of engine power due to fuel starvation.Aug 23, 2011 · N5779V · Substantial damageNTSB CEN11LA593Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-400 · Monango, NDThe pilot did not maintain adequate separation from a tree during the aerial-application flight.Aug 23, 2011 · N23720 · Substantial damageNTSB WPR11CA402Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Emmett, IDThe pilot's failure to maintain directional control during landing.Aug 22, 2011 · N4376Z · Substantial damageNTSB CEN11LA558Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Alpine, TXThe pilot’s improper flare which resulted in a hard landing. Contributing to the accident was the pilot’s improper decision to fly the airplane with a known mechanical deficiency.Aug 22, 2011 · N8076J · Substantial damageNTSB CEN11CA589Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Matthews, MOThe pilot's failure to maintain control of the airplane during takeoff.Aug 22, 2011 · N113AA · Substantial damageNTSB WPR11LA400Accident · No injuriesLimited investigationFinal reportCessna 182Q · Alton, UTThe pilot’s failure to abort the takeoff in a timely manner, which resulted in insufficient altitude to clear obstructions.Aug 21, 2011 · N79ES · Substantial damageNTSB WPR11FA407Accident · No injuriesField investigationFinal reportCirrus Design SR22 · Fall City, WAThe pilot's inadequate approach planning and failure to achieve the proper touchdown point, which resulted in a runway overrun.Aug 21, 2011 · N675DH · Substantial damageNTSB WPR11FA395Accident · 1 fatalField investigationFinal reportMaule M-7-235C · Brookings, ORThe pilot’s improper decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in a collision with trees while on approach for landing.Aug 21, 2011 · N199BF · Substantial damageNTSB WPR11CA406Accident · No injuriesData collectionFinal reportCessna A185F · Polson, MTThe pilot's failure to maintain directional control during landing.Aug 21, 2011 · N61609 · Substantial damageNTSB WPR11CA398Accident · Minor injuriesData collectionFinal reportBell 47G-4 · Los Banos, CAThe pilot's failure to maintain clearance from the power poles while maneuvering during low-altitude operations.Aug 21, 2011 · N948DS · Substantial damageNTSB CEN11LA606Accident · 1 fatalLimited investigationFinal reportBoeing A75N1(PT17) · Mt. Clemens, MIThe wing walker’s decision to release his grip of the airplane during an attempted aerial transfer from airplane to helicopter before both aircraft achieved the proper relative positioning for the transfer.Aug 21, 2011 · N49739 · 2 aircraft · No damageNTSB CEN11LA588Accident · Minor injuriesLimited investigationFinal reportHendryx Steve/Wiley Ross Super Rebel · La Porte City, IAThe improper assembly of the aileron cable by the airplane builder.Aug 21, 2011 · N540AF · Substantial damageNTSB CEN11LA585Accident · 1 fatalLimited investigationFinal reportAero Commander Callair A-9B · Marshall, MIThe towplane pilot's loss of control during an aerotow operation due to the glider pilot's inability to maintain a proper position behind the towplane while encountering turbulence on initial climb.Aug 21, 2011 · N7638V · Substantial damageNTSB CEN11CA590Accident · No injuriesData collectionFinal reportRans Designs S-7LS · Joplin, MOThe pilot's failure to maintain aircraft control during the landing.Aug 21, 2011 · N544RS · Substantial damageNTSB CEN11CA586Accident · Minor injuriesData collectionFinal reportCessna TU206G · Shawno, WIThe pilot's loss of control on final approach, while maneuvering to avoid birds.Aug 21, 2011 · N12TL · Substantial damageNTSB WPR11CA446Accident · No injuriesData collectionFinal reportCessna 182A · Prescott, AZThe pilot's failure to maintain directional control while taxiing.Aug 20, 2011 · N3723D · Substantial damageNTSB ERA11FA468Accident · 1 fatalField investigationFinal reportMitchell David N Lancair IV P · Hammonton, NJThe Lancair pilot's failure to see and avoid the aerobatic airplane. Contributing to the accident was the Lancair pilot's inadequate use of collision avoidance strategies while inbound to an area of known potential aerobatic activity.Aug 20, 2011 · N71DM · 2 aircraft · Substantial damageNTSB ERA11FA467Accident · 2 fatalField investigationFinal reportCessna 172M · Titusville, PAThe flight instructor's improper decision to attempt a visual descent into instrument meteorological conditions while approaching the destination airport, which resulted in an in-flight collision with trees and terrain.Aug 20, 2011 · N13126 · Substantial damageNTSB ERA11CA478Accident · No injuriesData collectionFinal reportCano Dave Avid Flyer Mkiv · Smithville, TNThe pilot's failure to maintain directional control during the takeoff roll due to his distraction by an open door.Aug 20, 2011 · N52CH · Substantial damageNTSB ERA11CA477Accident · No injuriesData collectionFinal reportPitts Special · Bessemer, ALThe pilot's failure to maintain directional control during the landing roll.Aug 20, 2011 · N2997G · Substantial damageNTSB CEN11LA591Accident · Minor injuriesLimited investigationFinal reportAmerican Autogyro Sparrowhawk · Delaware, OHThe noncertificated pilot did not maintain adequate airspeed and aircraft control during initial climb.Aug 20, 2011 · N2631B · Substantial damageNTSB CEN11LA582Accident · 1 fatalLimited investigationFinal reportVertical Unlimited 12 · Kansas City, MOThe pilot's impairment during an aerobatic airshow performance for reasons that could not be determined based on available information, which resulted in an in-flight loss of airplane control.Aug 20, 2011 · N2BJ · Substantial damageNTSB ANC11CA083Accident · No injuriesData collectionFinal reportCessna 180A · Igiugig, AKThe pilot's decision to take off in a variable wind, resulting in a shallow climb and collision with terrain.Aug 20, 2011 · N26CZ · Substantial damageNTSB WPR11CA397Accident · Minor injuriesData collectionFinal reportCessna 170B · Jefferson, ORThe pilot's failure to maintain clearance from power transmission lines during the landing approach into the sun.Aug 19, 2011 · N2789D · Substantial damageNTSB WPR11CA396Accident · No injuriesData collectionFinal reportAviat A-1C-200 · Casper, WYThe pilot's failure to maintain directional control during landing.Aug 19, 2011 · N53WY · Substantial damageNTSB ERA11WA472Accident · 4 fatalForeign investigationAgusta AW139 · BrazilOn August 19, 2011, at 1948 coordinated universal time (16:48 local time), an Agusta, AW139, helicopter, Brazilian registration PT-SEK, impacted into the Atlantic Ocean, near an oil rig, identifier P-65, the helicopter sank in waters with a recorded floor…Aug 19, 2011 · PR-SEK · Substantial damageNTSB WPR11LA416Accident · 1 fatalLimited investigationFinal reportLuscombe 8 · Lincoln, CAThe passenger's accidental fall while turning the propeller by hand to start the engine.Aug 18, 2011 · N45725 · No damageNTSB WPR11LA405Accident · No injuriesLimited investigationFinal reportJuneau Stol CH-701 · Snohomish, WAThe pilot's improper landing flare, which resulted in a stall and a hard landing.Aug 18, 2011 · N701BZ · Substantial damageNTSB WPR11FA392Accident · 1 fatalField investigationFinal reportBriegleb BG-12B · Moore, IDThe pilot’s decision to perform a low pass over the runway in the opposite direction of his intended landing, and his subsequent failure to maintain airspeed and glider control during the reverse-course maneuver. Contributing to the accident was the effect of…Aug 18, 2011 · N559Y · Substantial damageNTSB WPR11FA390Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Forsyth, MTThe pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in a stall/mush, loss of control, and impact with terrain.Aug 18, 2011 · N7666D · Substantial damageNTSB ERA11LA501Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Monmouth, MEOperation of the airplane by a non-certificated pilot and his failure to maintain airplane control.Aug 18, 2011 · N5048Z · Substantial damageNTSB ERA11FA462Accident · Serious injuriesField investigationFinal reportBeech B19 · Whitesburg, GAThe student pilot did not retract the wing flaps during a go-around, which decreased the airplane’s climb performance and resulted in an in-flight collision with trees.Aug 18, 2011 · N281G · Substantial damageNTSB CEN11CA580Accident · No injuriesData collectionFinal reportCessna 172N · Winnsboro, LAThe pilot's failure to maintain aircraft control during takeoff with a gusting crosswind.Aug 18, 2011 · N3209E · Substantial damageNTSB ANC11CA082Accident · No injuriesData collectionFinal reportPiper PA-20 · Tyonek, AKThe student pilot’s decision to take off toward a hill with a gusting tailwind. Contributing was the pilot's premature rotation that prevented the airplane from climbing over the hill.Aug 18, 2011 · N7763K · Substantial damageNTSB WPR11LA487Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Fortuna, CAThe unexpected engine start during hand propping, which resulted in a serious injury. Contributing to the accident was the lack of communication between the pilot and the individual hand propping the engine.Aug 17, 2011 · N3453K · No damageNTSB WPR11LA388Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-602 · Pine Bluffs, WYThe pilot's failure to maintain clearance from power lines during an aerial application flight.Aug 17, 2011 · N8518Y · Substantial damage