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 ERA11FA334Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Westbrook, CTA total loss of engine power during approach due to inadequate torque on the No. 3 cylinder hold-down nuts.Jun 10, 2011 · N8233P · Substantial damageNTSB ERA11CA338Accident · No injuriesData collectionFinal reportCessna 172R · Naples, FLThe pilot’s improper flare and recovery from a bounced landing.Jun 10, 2011 · N2458G · Substantial damageNTSB CEN11CA389Accident · No injuriesData collectionFinal reportConner Leroy RV6A · Oakwood, OKThe pilot's improper decision to land on a road with obstacles.Jun 10, 2011 · N25LC · Substantial damageNTSB WPR11LA254Accident · No injuriesLimited investigationFinal reportCessna 177 · Santa Clarita, CAThe pilot's inadequate preflight verification of the fuel quantity and his inadequate fuel consumption calculations, which resulted in fuel exhaustion.Jun 9, 2011 · N2301Y · Substantial damageNTSB ERA11FA332Accident · 2 fatalField investigationFinal reportCessna 152 · Vero Beach, FLThe pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and subsequent spin.Jun 9, 2011 · N48869 · Substantial damageNTSB WPR11CA259Accident · No injuriesData collectionFinal reportCessna 172P · Palo Alto, CAThe pilot's failure to maintain directional control during the landing roll.Jun 8, 2011 · N9849L · Substantial damageNTSB ERA11CA331Accident · Serious injuriesData collectionFinal reportCessna 172 · Ghent, NYThe pilot's delayed decision to abort the landing and execute a go-around.Jun 8, 2011 · N8895B · Substantial damageNTSB ANC11CA042Accident · No injuriesData collectionFinal reportCessna 182P · Anchorage, AKThe pilot's inadequate compensation for crosswind conditions and his failure to maintain control of the airplane during a water landing.Jun 8, 2011 · N58924 · Substantial damageNTSB WPR11CA252Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Odessa, WAThe pilot's failure to maintain clearance from the other aircraft.Jun 7, 2011 · N6072X · 2 aircraft · Minor damageNTSB WPR11FA248Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Astoria, ORThe student pilot’s failure to maintain adequate airspeed while maneuvering for landing, which resulted in a stall/spin. Contributing to the accident were the pilot's distraction and anxiety from a reported failure of the airplane's electrical system.Jun 5, 2011 · N511FS · Substantial damageNTSB ERA11CA329Accident · No injuriesData collectionFinal reportRemos Remos G-3/600 · Apoka, FLThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and collision with a hangar.Jun 5, 2011 · N13GX · Substantial damageNTSB CEN11LA372Accident · Minor injuriesLimited investigationFinal reportMooney M20J · North Canton, OHThe pilot’s improper landing flare and recovery from a bounced landing, which resulted in a loss of control.Jun 5, 2011 · N1146B · Substantial damageNTSB CEN11CA377Accident · Minor injuriesData collectionFinal reportKamtz Russell H RV-6A · Dexter, NMThe pilot's failure to maintain clearance from a fence while landing at night.Jun 5, 2011 · N820RC · Substantial damageNTSB WPR11CA247Accident · No injuriesData collectionFinal reportSieber Paul P Nieuport 11 · Bellingham, WAThe pilot's failure to maintain directional control during landing rollout.Jun 4, 2011 · N118PS · Substantial damageNTSB ERA11LA326Accident · 1 fatalLimited investigationFinal reportBuckeye Dream Machine · Russellville, TNThe pilot’s failure to switch fuel tanks when the fuel was exhausted, which resulted in fuel starvation and a total loss of engine power.Jun 4, 2011 · N3561F · Substantial damageNTSB CEN11LA374Accident · Serious injuriesLimited investigationFinal reportMalkin Roy K Searey · Minneapolis, MNThe pilot's failure to maintain adequate airspeed during takeoff, which resulted in an inadvertent stall. Contributing to the accident was the degraded engine performance due to the improper servicing and maintenance of the fuel system.Jun 4, 2011 · N242RM · Substantial damageNTSB CEN11LA373Accident · No injuriesLimited investigationFinal reportMooney M20R · Lake In The Hills, ILThe pilot's improper landing flare and recovery from a bounced landing, which resulted in a loss of control. Contributing to the accident was the certified flight instructor’s inadequate supervision.Jun 4, 2011 · N5816P · Substantial damageNTSB CEN11LA371Accident · No injuriesLimited investigationFinal reportRedding David RV9A · Edgewood, NMThe pilot's failure to abort the takeoff roll.Jun 4, 2011 · N514R · Substantial damageNTSB WPR11CA249Accident · Minor injuriesData collectionFinal reportRusk Smith Super Cub · Heron, MTThe floatplane's collision with a submerged object during a water landing.Jun 3, 2011 · N316BR · Substantial damageNTSB ERA11CA324Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Honea Path, SCThe student pilot's loss of control during the takeoff.Jun 3, 2011 · N84572 · Substantial damageNTSB CEN11IA369Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145 · Chicago, ILThe overheat and failure the brake during landing due to oxidation of the brake rotors, which went undetected by maintenance personnel. Contributing to the accident was maintenance personnel’s lack of familiarity with detailed brake oxidation inspection…Jun 3, 2011 · N607AE · No damageNTSB WPR11LA253Accident · No injuriesLimited investigationFinal reportCessna A188B · Pine Bluffs, WYA partial loss of engine power during takeoff for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have precluded normal operation.Jun 2, 2011 · N9496G · Substantial damageNTSB WPR11LA245Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Lake Havasu, AZThe failure of the low pressure switch in the normal landing gear system, which prevented normal operation of that system, and the misrigging of the emergency extension gear release valve, which prevented the system from being depressurized to allow for the…Jun 2, 2011 · N712MK · Substantial damageNTSB ANC11LA041Accident · No injuriesLimited investigationFinal reportEclipse EA500 · Nome, AKThe pilot landed without lowering the landing gear. Contributing to the accident was the pilot's decision to fly the airplane with an inoperative wing flap system.Jun 2, 2011 · N168TT · Substantial damageNTSB WPR11LA244Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Stockton, CAThe pilot's failure to maintain clearance from obstacles.Jun 1, 2011 · N68012 · Substantial damageNTSB WPR11FA242Accident · 4 fatalField investigationFinal reportCessna 172R · Wendover, UTThe pilot did not maintain adequate airspeed during the downwind turn resulting in an aerodynamic stall, in-flight loss of control, and spin. Contributing to the accident was the pilot’s inadequate preflight planning and exceedance of the approved weight and…Jun 1, 2011 · N475ER · Substantial damageNTSB ERA11CA323Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Wurstboro, NYThe flying pilot's failure to maintain aircraft control and the flight instructor's inadequate supervision while landing with a gusting wind. Contributing to the accident was the lack of communication between the flight instructor and pilot under evaluation…Jun 1, 2011 · N2656H · Substantial damageNTSB WPR11LA300Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Los Angeles, CAThe ground crewmembers’ failure to follow proper procedures for removing a stuck or jammed tow bar, which resulted in a ground crew injury.May 31, 2011 · N526UA · Minor damageNTSB ERA11CA319Accident · Serious injuriesData collectionFinal reportAero AT SP Zoo AT-4 LSA · Concord, NHThe student pilot's loss of aircraft control during a go-around maneuver following a bounced landing.May 31, 2011 · N709PR · Substantial damageNTSB CEN11LA366Accident · No injuriesLimited investigationFinal reportCessna 150F · Sully, IAThe pilot's failure to attain an adequate climb rate during the initial takeoff, resulting in the airplane settling back down and departing the runway. Contributing to the accident was the pilot's inadequate preflight planning and preparation.May 31, 2011 · N7818F · Substantial damageNTSB ERA11FA321Accident · 4 fatalField investigationFinal reportBeech V35 · Ellijay, GAThe pilot’s failure to maintain adequate clearance from terrain while maneuvering in a mountainous area.May 30, 2011 · N29MW · Substantial damageNTSB CEN11LA367Accident · Minor injuriesLimited investigationFinal reportJones Cozy Mark IV · Sioux City, IAThe pilot's improper installation of the gascolator gasket during the airplane's last condition inspection, which resulted in a partial loss of engine power while maneuvering.May 30, 2011 · N204TJ · Substantial damageNTSB WPR11FA241Accident · 3 fatalField investigationFinal reportCessna R172K · Cold Springs, NVThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in a controlled collision with terrain.May 29, 2011 · N9831V · Substantial damageNTSB ERA11TA318Accident · Minor injuriesFinal reportBell OH-58A · Ft. Pierce, FLThe pilot's failure to recognize and avoid a loss of tail rotor effectiveness, which resulted in a loss of control and hard landing.May 29, 2011 · N911SL · Substantial damageNTSB ERA11IA320Incident · No injuriesIncident investigationFinal reportRobinson Helicopter R22 Mariner · Redding, CTThe pilot's inadequate helicopter preflight inspection and the mechanic’s inadequate annual inspection, both of which failed to detect a worn bolt in the tail rotor teeter hinge prior to its fracture due to fatigue.May 29, 2011 · N8313E · No damageNTSB CEN11FA359Accident · Minor injuriesField investigationFinal reportEurocopter AS 350 B2 · Fort Worth, TXThe pilot’s loss of control due to his not maintaining adequate airspeed and altitude during a simulated hydraulic flight control failure. Contributing to the accident was the flight instructor’s inadequate supervision and delayed remedial response.May 29, 2011 · N747CH · Substantial damageNTSB CEN11FA358Accident · 2 fatalField investigationFinal reportRockwell 112 · Bryan, TXThe pilot's inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion, and his improper control inputs following the loss of engine power, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to…May 29, 2011 · N1041J · Substantial damageNTSB ANC11CA040Accident · No injuriesData collectionFinal reportCessna 140 · Chickaloon, AKThe pilot's improper decision to take off downwind from unsuitable terrain.May 29, 2011 · N89424 · Substantial damageNTSB WPR11LA238Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hazelton, IDA total loss of engine power during low-level maneuvering due to an excessively worn carburetor.May 28, 2011 · N9724 · Substantial damageNTSB ANC11LA048Accident · No injuriesLimited investigationFinal reportDehavilland DHC-3T · Bettles Field, AKThe pilot's selection of unsuitable terrain for the landing, which resulted in a loss of directional control.May 28, 2011 · N87AW · Substantial damageNTSB ANC11LA039Accident · No injuriesLimited investigationFinal reportCessna 170A · Wasilla, AKThe pilot's loss of directional control during landing, which resulted in a runway excursion. Contributing to the accident were the effects of multiple modifications to the main and tailwheel landing gear through the supplemental type certificate and FAA…May 28, 2011 · N1742D · Substantial damageNTSB WPR11FA239Accident · 1 fatalField investigationFinal reportBrantly B-2B · Weaverville, CAThe student pilot's decision to fly in windy conditions that exceeded his capabilities, which resulted in his subsequent loss of helicopter control. Contributing to the accident was his lack of flight experience in the accident helicopter.May 27, 2011 · N222DW · Substantial damageNTSB WPR11CA243Accident · No injuriesData collectionFinal reportBell 206B3 · Glendale, AZThe certified flight instructor's failure to maintain adequate main rotor RPM during the autorotation.May 27, 2011 · N59383 · Substantial damageNTSB ERA11LA330Accident · No injuriesLimited investigationFinal reportBeech C90 · Camden, SCThe pilot's in-flight decision to continue toward his destination, through known significant weather, when safer alternatives were available.May 27, 2011 · N291CC · Substantial damageNTSB ERA11IA316Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries Gulfstream 200 · Newburgh, NYThe flight crew did not ensure that the landing gear selector handle was in the full down (extend) position. Contributing to the incident was inadequate checklist information.May 27, 2011 · N749QS · Minor damageNTSB CEN11LA396Accident · Minor injuriesLimited investigationFinal reportGrumman G164 · Oak Ridge, LAThe flight instructor's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and subsequent impact with trees.May 27, 2011 · N2LU · Substantial damageNTSB CEN11LA365Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Freemont, MIThe pilot’s failure to attain a positive climb rate following takeoff for reasons that could not be determined because the propeller was not provided for further examination. Contributing to the accident was the pilot's impairment from alcohol.May 27, 2011 · N60147 · Substantial damageNTSB ANC11LA038Accident · No injuriesLimited investigationFinal reportCessna P206C · Wasilla, AKThe pilot's failure to maintain directional control during takeoff from an unpaved airstrip, resulting in a collision with trees.May 27, 2011 · N8665Z · Substantial damageNTSB ANC11FA037Accident · 5 fatalField investigationFinal reportCessna 180 · Chugiak, AKThe pilot's loss of control of the airplane during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in make and model, his lack of currency in FAA required takeoffs and landings, and his…May 27, 2011 · N4955A · Substantial damageNTSB ANC11CA036Accident · No injuriesData collectionFinal reportPiper J5A · Palmer, AKThe pilot's inadequate compensation for wind conditions.May 27, 2011 · N2364 · Substantial damage