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 WPR12CA240Accident · No injuriesData collectionFinal reportCessna P337H · Jerome, IDThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot's failure to use the checklist before landing.May 30, 2012 · N5KX · Substantial damageNTSB WPR12CA236Accident · No injuriesData collectionFinal reportBell 206B · Burbank, WAThe failure of maintenance personnel to properly torque an air tube fitting, which resulted in a total loss of engine power.May 30, 2012 · N106TV · Substantial damageNTSB DCA12CA082Accident · No injuriesData collectionFinal reportBoeing 747 · Chicago, ILthe B747 Captain's failure to maintain a safe clearance between his wing and the tail of the EMB135 that was stopped on a taxiway.May 30, 2012 · B16481 · 2 aircraft · Minor damageNTSB CEN12LA331Accident · Minor injuriesLimited investigationFinal reportBaldwin Skybolt · Stuttgart, ARThe pilot's inadequate preflight planning, which resulted in the airplane’s overweight takeoff from an airstrip with a high density altitude and subsequent collision with terrain.May 30, 2012 · N24EB · Substantial damageNTSB ANC12CA044Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8F · Tok, AKThe pilot's inadvertent and excessive application of brake pressure during landing, which resulted in a nose over.May 30, 2012 · N9906C · Substantial damageNTSB WPR12FA235Accident · 4 fatalField investigationFinal reportCirrus SR20 · Duck Creek Village, UTThe pilot's failure to maintain sufficient airspeed and airplane control while maneuvering a heavily loaded airplane over high mountainous terrain in a high density altitude environment. Contributing to the accident was the pilot’s lack of experience…May 29, 2012 · N187PG · Substantial damageNTSB CEN12LA330Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-27 · Ionia, MIThe pilot's failure to maintain a proper airspeed in gusting wind conditions, which resulted in an inadvertent stall while maneuvering at an altitude that did not provide a margin for recovery.May 29, 2012 · N127PC · Substantial damageNTSB CEN12CA329Accident · No injuriesData collectionFinal reportBrumbaugh B/Kasowski L Avid Flyer IV · Pryor, OKThe pilot's failure to maintain directional control during a high speed taxi.May 29, 2012 · N85AY · Substantial damageNTSB ANC12CA043Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Anchorage, AKThe pilot’s failure to maintain directional control while landing in a gusting crosswind.May 29, 2012 · N3772Z · Substantial damageNTSB WPR12CA260Accident · No injuriesData collectionFinal reportCessna 172P · Hemet, CAThe student pilot's failure to monitor and maintain clearance from an obstacle during taxi.May 28, 2012 · N216AF · Substantial damageNTSB ERA12CA378Accident · No injuriesData collectionFinal reportPdps Pzl-Bielsko SZD-55-1 · Mocksville, NCThe glider pilot's failure to attain and maintain directional control during takeoff.May 28, 2012 · N817V · Substantial damageNTSB CEN12LA324Accident · 1 fatalLimited investigationFinal reportNorth American T-6G · Perry, MIThe pilot’s failure to maintain control while maneuvering at low altitude after takeoff, resulting in a collision with a barn.May 28, 2012 · N3753G · Substantial damageNTSB CEN12FA321Accident · 1 fatalField investigationFinal reportBell 206-L4 · (Gulf of Mexico)The pilot’s failure to maintain clearance from an obstacle while landing on an obstructed helipad, which resulted in a collision and loss of control. Contributing to the accident was the failure of the helipad owner to mark the helipad closed and the failure…May 28, 2012 · N7077F · Substantial damageNTSB CEN12FA320Accident · 1 fatalField investigationFinal reportTackabury Air-Cam · Fort Morgan, COThe pilot’s failure to maintain control of the airplane while performing a go-around, which resulted in an aerodynamic stall.May 28, 2012 · N788RJ · Substantial damageNTSB WPR12LA246Accident · No injuriesLimited investigationFinal reportBeech B36TC · Santa Ynez, CAA loss of engine power during initial climb due to fuel starvation. Contributing to the accident were the pilot’s inadequate preflight inspection, his failure to properly diagnose the loss of engine power, and his failure to follow the appropriate emergency…May 27, 2012 · N8234M · Substantial damageNTSB WPR12LA231Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Silver City, IDThe pilot‘s failure to maintain airspeed while maneuvering in mountainous terrain with reduced visibility, which resulted in an aerodynamic stall.May 27, 2012 · N4640L · Substantial damageNTSB WPR12CA232Accident · No injuriesData collectionFinal reportCessna 172S · Page, AZThe pilot's failure to maintain directional control during the landing flare.May 27, 2012 · N21718 · Substantial damageNTSB ERA12CA369Accident · No injuriesData collectionFinal reportCessna 172 · Gainesville, GAThe student pilot's improper use of the flight controls during the takeoff and the flight instructor's delayed remedial action. Contributing to the accident was the student pilot’s interference with the flight instructor’s attempted remedial actions.May 27, 2012 · N787LF · Substantial damageNTSB CEN12LA325Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Peoria, ILThe pilot’s loss of control while hover-taxiing.May 27, 2012 · N1UB · Substantial damageNTSB WPR12FA230Accident · 4 fatalField investigationFinal reportCessna 172S · St. George, UTThe pilot's failure to maintain adequate airspeed during an aggressive pitch-up maneuver, which resulted in a low-altitude aerodynamic stall shortly after takeoff. Contributing to the accident was the pilot's impairment from alcohol consumption and an…May 26, 2012 · N953SP · Substantial damageNTSB WPR12CA226Accident · Minor injuriesData collectionFinal reportCessna 182M · Vashon Island, WAThe pilot's loss of directional control during a rejected takeoff, which resulted in a noseover.May 26, 2012 · N70658 · Substantial damageNTSB ERA12LA364Accident · 1 fatalLimited investigationFinal reportMoyes B/Bailey B Dragonfly · Trenton, GAThe airplane's entry into an uncontrolled descent for reasons that could not be determined because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation and it could not be determined whether the…May 26, 2012 · N56FP · Substantial damageNTSB ERA12CA381Accident · No injuriesData collectionFinal reportBoeing A75N1 · Foley, ALThe pilot's failure to maintain airplane control during landing.May 26, 2012 · N60198 · Substantial damageNTSB ERA12CA374Accident · No injuriesData collectionFinal reportPiper PA-18A 150 · Farmingdale, NJThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.May 26, 2012 · N4895A · Substantial damageNTSB CEN12LA353Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Chesterfield, MOThe undercharged and overcharged landing gear dampers, which allowed initiation of the ground resonance event from which the pilot was unable to recover due to his limited experience in helicopters. Contributing to the accident was the ineffective damper…May 26, 2012 · N345MH · Substantial damageNTSB CEN12CA342Accident · No injuriesData collectionFinal reportCessna 172S · Fort Scott, KSThe student pilot’s loss of directional control during the landing roll. Contributing to the accident was the student pilot’s diverted attention to retract the flaps.May 26, 2012 · N5258Y · Substantial damageNTSB WPR12FA237Accident · 1 fatalField investigationFinal reportGulfstream American AA-5A · Lakeview, ORThe pilot’s decision to take off in known adverse weather conditions and his subsequent failure to maintain sufficient airspeed while maneuvering in mountainous terrain and an area of low ceilings, snow, and fog, which resulted in a loss of airplane control.May 25, 2012 · N26837 · Substantial damageNTSB ERA12LA366Accident · No injuriesLimited investigationFinal reportBell 206B · Longboat Key, FLUnknown personnel's failure to comply with the engine manufacturer's engine fuel pump replacement guidance, which resulted in a total loss of engine power due to the engine fuel pump failure.May 25, 2012 · N806LA · Substantial damageNTSB ERA12CA370Accident · No injuriesData collectionFinal reportSmith Allen Storch · Titusville, FLThe pilot’s failure to maintain directional control during landing.May 25, 2012 · N126SR · Substantial damageNTSB CEN12LA323Accident · No injuriesLimited investigationFinal reportThrush S2RHG-T65 · Alicia, ARThe pilot of the Thrush did not execute a go-around prior to landing, which resulted in excessive ground speed after touchdown, and his subsequent loss of directional control, which resulted in a collision with the Air Tractor.May 25, 2012 · N40475 · 2 aircraft · Substantial damageNTSB CEN12LA318Accident · Serious injuriesLimited investigationFinal reportAeros Ltd/Skyranger Skyranger II · Saline, MIThe pilot did not maintain proper control of the airplane while maneuvering at low altitude, which resulted in an aerodynamic stall.May 25, 2012 · N192RR · Substantial damageNTSB CEN12CA315Accident · Minor injuriesData collectionFinal reportCessna 172N · Wichita, KSThe student pilot’s failure to maintain airplane control during landing and the flight instructor’s delayed remedial action, which resulted in a collision with terrain.May 25, 2012 · N73743 · Substantial damageNTSB WPR12CA229Accident · No injuriesData collectionFinal reportRockwell International S-2R · Royal City, WAThe pilot’s failure to maintain adequate clearance from an object during an aerial application, which resulted in damage to the landing gear and led to the airplane ground looping during the subsequent landing.May 24, 2012 · N8468V · Substantial damageNTSB ERA12LA368Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Piney Flats, TNThe mechanic’s improper maintenance of the main transmission aft pinion nut and belt drive system, which resulted in the uncoupling of the tail rotor driveshaft and the subsequent loss of helicopter control.May 24, 2012 · N760DA · Substantial damageNTSB ERA12CA361Accident · No injuriesData collectionFinal reportLydon Patrick F Searey · Sanford, FLThe pilot's failure to ensure that the landing gear was retracted for the water landing.May 24, 2012 · N252JB · Substantial damageNTSB ANC12CA042Accident · No injuriesData collectionFinal reportBeech 1900C · McGrath, AKThe pilot's unstable approach and overrotation, which resulted in a tailstrike.May 24, 2012 · N111AX · Substantial damageNTSB ERA12LA356Accident · No injuriesLimited investigationFinal reportCanadair CL-600-2B16 · Hallandale, FLThe failure of the co-pilot to properly close and latch the passenger door before departure, and the flight crew's failure to ensure that the door was secure by using the door warning system. Contributing to the accident was the flight crew's inadequate use…May 23, 2012 · N207JB · Substantial damageNTSB ERA12LA355Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe failure of the pilot of another airplane to set the parking brake and to maintain a proper visual lookout, which resulted in an on-ground collision.May 23, 2012 · N47749 · 2 aircraft · Minor damageNTSB CEN12FA312Accident · 1 fatalField investigationFinal reportAir Tractor AT-802A · Sedgwick, ARThe inability of both pilots to see and avoid the other airplane, which resulted in a midair collision. Contributing to the accident was the distraction of the Air Tractor pilot by a cellular telephone conversation during the flight.May 23, 2012 · N4126T · 2 aircraft · Substantial damageNTSB CEN12CA313Accident · Serious injuriesData collectionFinal reportAyres S2R-R1340 · Clear Lake, SDThe pilot's failure to perform a detailed observation of the power lines before beginning the aerial application work, which resulted in an inadvertent collision with the two lower wires.May 23, 2012 · N30951 · Substantial damageNTSB WPR12LA225Accident · Serious injuriesLimited investigationFinal reportWaggonner Excalibur · Buhl, IDThe pilot’s failure to maintain control of the airplane while on final approach, which resulted in an aerodynamic stall.May 22, 2012 · N165AW · Substantial damageNTSB WPR12IA248Incident · No injuriesIncident investigationFinal reportEurocopter AS 350 B2 · Seattle, WAFailure of maintenance personnel to ensure that the tail rotor pitch change link bolt was properly secured, which resulted in an in-flight separation of the bolt and subsequent vibration.May 22, 2012 · N105TV · Minor damageNTSB ANC12CA041Accident · No injuriesData collectionFinal reportDehavilland DHC-2 MK. I(L20A) · Talkeetna, AKThe pilot inadvertently landed with the parking brake set.May 22, 2012 · N323KT · Substantial damageNTSB WPR12LA220Accident · 1 fatalLimited investigationFinal reportGrumman G 164D · Nicolaus, CAThe pilot’s failure to maintain airplane control during a low-altitude maneuver.May 21, 2012 · N8267K · Substantial damageNTSB ERA12FA345Accident · 1 fatalField investigationFinal reportShepard Jimmy D JR Pitts S1D · Port Richey, FLThe pilot's decision to conduct aerobatic flight at a low altitude, which resulted in a collision with the water.May 21, 2012 · N360MW · Substantial damageNTSB ERA12CA359Accident · No injuriesData collectionFinal reportBeech V35B · Norwich, NYThe pilot’s failure to maintain airplane control while landing in a crosswind.May 21, 2012 · N6658K · Substantial damageNTSB CEN12LA314Accident · No injuriesLimited investigationFinal reportCessna 152 · Ardmore, OKThe student pilot's improper configuration of the airplane flaps during an aborted landing, which resulted in an inadequate climb rate and subsequent collision with trees.May 21, 2012 · N6102Q · Substantial damageNTSB CEN12FA311Accident · 1 fatalField investigationFinal reportCessna T210L · Boyd, TXThe pilot’s delayed initiation of a go-around and early retraction of the flaps during the maneuver, which resulted in a collision with trees.May 21, 2012 · N29112 · Substantial damageNTSB WPR12LA219Accident · No injuriesLimited investigationFinal reportEnstrom F28 · Twin Falls, IDThe pilot's inability to maintain helicopter control during cruise flight due to the failure of the No. 2 main rotor Lamiflex bearing. Contributing to the accident was the pilot's decision to operate the helicopter with a known deficiency and the helicopter’s…May 20, 2012 · N63VP · Substantial damageNTSB CEN12LA308Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Frankenmuth, MIA partial loss of engine power for undetermined reasons and the pilot’s failure to maintain airspeed, which resulted in an aerodynamic stall.May 20, 2012 · N4595T · Substantial damage