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 ERA11FA443Accident · 2 fatalField investigationFinal reportMaule M-7-235 · Warrenton, VAThe pilot's inadequate airspeed and excessive bank angle while maneuvering for landing, which resulted in an aerodynamic stall.Aug 7, 2011 · N747GL · Substantial damageNTSB ANC11CA074Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Coldfoot, AKThe pilot's inadequate directional control of the airplane during takeoff. Contributing to the accident was the pilot’s fatigue.Aug 7, 2011 · N762LA · Substantial damageNTSB WPR11LA373Accident · No injuriesLimited investigationFinal reportRotorway Exec · Chino Hills, CAA total loss of engine power due to fuel exhaustion as a result of both the owner's and the pilot's failure to determine or monitor the remaining fuel quantity during the flight. Contributing to the accident was the manufacturer's lack of fuel consumption…Aug 6, 2011 · N162CT · Substantial damageNTSB ERA11LA461Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Elizabethtown, NCThe improper securing of a “B” nut on the power turbine control (Py) line by unknown maintenance personnel, which resulted in a total loss of engine power. Contributing to the accident was the pilot's failure to use the manual fuel override switch.Aug 6, 2011 · N469CC · Substantial damageNTSB ERA11CA442Accident · No injuriesData collectionFinal reportDidier Siffer Arion Lightning · Farmingdale, NYThe pilot's failure to maintain directional control while landing in a strong quartering crosswind.Aug 6, 2011 · N723AD · Substantial damageNTSB CEN11CA551Accident · Serious injuriesData collectionFinal reportQuicksilver Sprint II · Douglas, KSThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Aug 6, 2011 · N403BP · Substantial damageNTSB ERA11CA440Accident · Minor injuriesData collectionFinal reportNelsen Lynn H Lightning · Frostproof, FLThe pilot's premature rotation during takeoff.Aug 5, 2011 · N13LN · Substantial damageNTSB CEN11CA608Accident · Minor injuriesData collectionFinal reportAyres S2R-G10 · Hot Springs, ARThe pilot's improper decision not to fully jettison the entire load of water when he realized the airplane was not climbing after takeoff.Aug 5, 2011 · N22592 · Substantial damageNTSB CEN11CA560Accident · No injuriesData collectionFinal reportCessna 182S · Los Cruces, NMThe pilot's loss of aircraft control due to insufficient aircraft performance during takeoff, with a heavy gross weight and a high density altitude.Aug 5, 2011 · N493JL · Substantial damageNTSB CEN11CA550Accident · Serious injuriesData collectionFinal reportAttaway Robert H RV6A · Colorado Springs, COThe pilot's failure to maintain control while landing.Aug 5, 2011 · N675RE · Substantial damageNTSB CEN11CA548Accident · Minor injuriesData collectionFinal reportPiper PA-18A · Sherman, TXThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Aug 5, 2011 · N150CW · Substantial damageNTSB CEN11LA549Accident · No injuriesLimited investigationFinal reportAerosport Ikarus C42E · East Troy, WIThe flight instrctor's delayed remedial action during landing. Contributing to the accident was the student pilot’s loss of directional control when he became distracted with the open door.Aug 4, 2011 · N577JP · Substantial damageNTSB CEN11LA546Accident · 2 fatalLimited investigationFinal reportReinboldt Richard A Challenger II · Reedsburg, WIThe pilot did not maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.Aug 4, 2011 · N340BR · Substantial damageNTSB WPR11FA367Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Camas, WAThe pilot's failure to maintain control of the airplane while maneuvering in the traffic pattern.Aug 3, 2011 · N6297P · Substantial damageNTSB ERA11LA438Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · St. Petersburg, FLThe pilot's improper rotation during takeoff, resulting in a stall and subsequent collision with the ground.Aug 3, 2011 · N8314Y · Substantial damageNTSB CEN11CA570Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Minot, NDThe pilot's failure to maintain directional control during the crosswind landing, resulting in a ground loop.Aug 3, 2011 · N8764S · Substantial damageNTSB ANC11TA079Accident · No injuriesFinal reportDehavilland DHC-2 MK. I(L20A) · Northway, AKThe pilot's failure to identify unsuitable terrain for landing and subsequent contact with a dirt mound, resulting in the separation of the tailwheel from the airframe.Aug 3, 2011 · N723DR · Substantial damageNTSB WPR11LA371Accident · No injuriesLimited investigationFinal reportCarpenter Kolb Twinstar III · Republic, WAThe pilot's failure to maintain directional control during the landing roll.Aug 2, 2011 · N3135J · Substantial damageNTSB WPR11LA362Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Syracuse, UTThe failure of the maintenance technicians who installed the engine to properly tighten the fuel injection servo to a spider supply line, which caused a loss of engine power due to fuel starvation.Aug 2, 2011 · N235GW · Substantial damageNTSB WPR11LA359Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Emmett, IDA total loss of engine power due to carburetor icing because the pilot did not use carburetor heat.Aug 2, 2011 · N6399B · Substantial damageNTSB ERA11LA437Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Egg Harbor Township, NJThe pilot’s failure to maintain adequate airspeed while maneuvering near the ground, which resulted in an aerodynamic stall.Aug 2, 2011 · N87020 · Substantial damageNTSB ERA11FA435Accident · 1 fatalField investigationFinal reportRans S18 · Fayetteville, TNThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin. Contributing to the accident was the pilot's lack of recent flight experience.Aug 2, 2011 · UNREG · Substantial damageNTSB CEN11CA540Accident · Serious injuriesData collectionFinal reportBell 47G-2 · Charles City, IAThe pilot's failure to refuel the helicopter which resulted in a loss of engine power due to fuel exhaustion.Aug 2, 2011 · N4771N · Substantial damageNTSB WPR11CA365Accident · No injuriesData collectionFinal reportCessna 162 · Rawlings, WYThe pilot's decision to attempt a takeoff at a density altitude that was outside the performance envelope of the airplane. Also causal was the flight's likely encounter with a sudden tailwind gust.Aug 1, 2011 · N7024V · Substantial damageNTSB ERA11FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-28-140The non-instrumented rated pilot’s flight into instrument meteorological conditions for undetermined reasons, resulting in an in-flight loss of control, uncontrolled descent, and collision with the water.Aug 1, 2011 · N4533R · Substantial damageNTSB CEN11LA536Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13 · Stoughton, WIThe pilot’s improper preflight planning and his failure to gain proper airspeed during takeoff from a grass airstrip resulting in a stall, the loss of control, and subsequent impact with the trees. Contributing to the accident was the pilot operating the…Aug 1, 2011 · N74260 · Substantial damageNTSB CEN11FA531Accident · 1 fatalField investigationFinal reportEdwards Douglas L SKY Ranger · Wautoma, WIThe pilot’s failure to maintain proper airspeed and attitude control of the airplane in the turn, which resulted in an aerodynamic stall.Aug 1, 2011 · N7501Y · Substantial damageNTSB CEN11CA535Accident · No injuriesData collectionFinal reportTexas Helicopter OH-13H/M74A · Joice, IAThe pilot's failure to maintain clearance from the wire.Aug 1, 2011 · N51857 · Substantial damageNTSB WPR11CA394Accident · No injuriesData collectionFinal reportBell 47G · Porterville, CAThe pilot's decision to takeoff in a tailwind condition, and his subsequent failure to attain sufficient lift during the takeoff.Jul 31, 2011 · N6260C · Substantial damageNTSB ERA11FA431Accident · 1 fatalField investigationFinal reportBeech G35 · Byron, GAThe pilot’s sustained flight at airspeeds in excess of the airplane's never exceed speed during a steep descent, which resulted in a subsequent in-flight structural failure due to overstress.Jul 31, 2011 · N156RP · Substantial damageNTSB CEN11FA537Accident · 1 fatalField investigationFinal reportMorrison E-RACER · Big Rock, ILThe pilot's failure to maintain airplane control after experiencing excessive engine cylinder head temperatures during the initial flight test of the experimental amateur-built airplane.Jul 31, 2011 · N345JM · DestroyedNTSB CEN11CA533Accident · No injuriesData collectionFinal reportGarlick Helicopters OH-58C · Rushford, MNThe pilot's diverted attention, which resulted in the failure to maintain clearance from the power line.Jul 31, 2011 · N82855 · Substantial damageNTSB CEN11CA532Accident · No injuriesData collectionFinal reportAlon A-2A · Rolfe, IAThe pilot's decision to execute a precautionary landing to unsuitable terrain.Jul 31, 2011 · N5647F · Substantial damageNTSB WPR11LA361Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Perris, CAThe pilot’s failure to maintain airplane control and the resulting encounter with an aerodynamic stall. Also causal were the pilot’s inadequate preflight planning and preflight inspection, his failure to ensure the pitch trim was positioned correctly for…Jul 30, 2011 · N6718X · Substantial damageNTSB WPR11FA354Accident · 2 fatalField investigationFinal reportCirrus SR20 · Fredonia, AZThe non-instrument-rated pilots’ loss of situational awareness during a dark night flight over a remote area, which resulted in their failure to maintain an altitude sufficient to ensure adequate terrain clearnance. Contributing to the accident was the…Jul 30, 2011 · N365DP · Substantial damageNTSB WPR11CA355Accident · No injuriesData collectionFinal reportCessna 170A · Mulino, ORThe certified flight instructor's inadequate oversight of his student, and delayed recovery efforts following the student's loss of directional control during landing rollout.Jul 30, 2011 · N9741A · Substantial damageNTSB ERA11CA433Accident · No injuriesData collectionFinal reportEurocopter AS 350 B3 · Humacao, PRThe pilot's failure to maintain clearance from a building during landing.Jul 30, 2011 · N413LP · Substantial damageNTSB ERA11CA432Accident · Serious injuriesData collectionFinal reportMcfarland WM H Rans S6S · Huntington, WVThe failure of both pilots to maintain proper pitch control during takeoff. Contributing to the accident was both pilots' inexperience in the airplane make/model.Jul 30, 2011 · N434WM · Substantial damageNTSB ERA11CA430Accident · No injuriesData collectionFinal reportCessna 182 · Dandrige, TNThe loss of engine power due to fuel exhaustion as a result of poor planning.Jul 30, 2011 · N5813B · Substantial damageNTSB CEN11FA528Accident · 2 fatalField investigationFinal reportWright B Flyer Wright B Flyer · Springfield, OHThe flight crew’s failure to maintain airplane control following a partial loss of engine thrust during cruise flight. Contributing to the accident was the failed weld as a result of incomplete welding on the left propeller shaft, which led to the partial…Jul 30, 2011 · N453WB · Substantial damageNTSB ANC11FA071Accident · 4 fatalField investigationFinal reportCessna U206G · Talkeetna, AKThe inadequate visual lookout and failure to see and avoid by the pilots of both airplanes while maneuvering to land, which resulted in a midair collision. Contributing to the accident was the lack of standardized, unequivocal procedures concerning common…Jul 30, 2011 · N756MP · 2 aircraft · Minor damageNTSB WPR11CA353Accident · No injuriesData collectionFinal reportSloan Roger D Vans RV7A · Sheridan, WYThe pilot's failure to maintain aircraft control during takeoff due to cockpit distractions.Jul 29, 2011 · N742RJ · Substantial damageNTSB ERA11LA428Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Darlington, MDInadequate maintenance of the helicopter's landing gear dampers, which resulted in a main rotor out-of-balance condition and ground resonance encounter.Jul 29, 2011 · N39SH · Substantial damageNTSB ERA11LA427Accident · 1 fatalLimited investigationFinal reportTL Ultralight Sro Sting S3 · Sarasota, FLThe inability of the pilot-in-command (PIC) to recover from an inadvertent spin following a stall demonstration for reasons that could not be determined because aircraft and engine examinations did not reveal any anomalies that would have precluded recovery…Jul 29, 2011 · N2442 · Substantial damageNTSB ERA11LA429Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Pahokee, FLThe flight instructor's misjudgment of the airplane's position and airspeed relative to the runway while returning to the airport after a partial loss of engine power. Contributing to the accident was the separation of the engine's No. 3 cylinder exhaust…Jul 28, 2011 · N1443U · Substantial damageNTSB CEN11CA545Accident · No injuriesData collectionFinal reportAyres S2R-G6 · Forest City, IAThe pilot's inadequate visual lookout during an aerial application run, which resulted in an in-flight collision with a windmill.Jul 28, 2011 · N331BF · Substantial damageNTSB CEN11CA524Accident · Minor injuriesData collectionFinal reportTexas Helicopter OH-13H/M74A · Creston, ILThe pilot's failure to maintain adequate skid clearance from the helicopter cart during landing, resulting in a dynamic rollover.Jul 28, 2011 · N10009 · Substantial damageNTSB WPR11LA364Accident · No injuriesLimited investigationFinal reportNicholson 2000 · Sedona, AZThe pilot’s improper landing flare, which resulted in a hard landing.Jul 27, 2011 · N671T · Substantial damageNTSB WPR11LA352Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B3 · Troutdale, ORThe in-flight separation of the tail rotor drive shaft cover as a result of maintenance personnel not ensuring that it was secured after a maintenance inspection; also causal was the pilot’s inadequate preflight inspection of the helicopter.Jul 27, 2011 · N808LF · Substantial damageNTSB ERA11CA425Accident · Serious injuriesData collectionFinal reportPiper PA-24-250 · Sidney, NYThe pilot's inadequate fuel planning and management, which resulted in fuel starvation and a total loss of engine power during final approach.Jul 27, 2011 · N7365P · Substantial damage