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 CEN14CA017Accident · No injuriesData collectionFinal reportRobinson R22 - Beta · Chicago, ILThe flight instructor's failure to take remedial action in a timely manner.Oct 2, 2013 · N554SA · Substantial damageNTSB WPR14CA002Accident · No injuriesData collectionFinal reportAir Tractor AT 401 · Waco, TXThe pilot’s failure to maintain directional control during the takeoff in gusting wind conditions.Oct 1, 2013 · N1013R · Substantial damageNTSB WPR14CA001Accident · No injuriesData collectionFinal reportUnknown Unknown · Mount Pleasant, UTThe pilot's failure to maintain aircraft control during landing.Oct 1, 2013 · N224KF · Substantial damageNTSB WPR13FA430Accident · 4 fatalField investigationFinal reportCessna 525A · Santa Monica, CAThe pilot’s failure to adequately decrease the airplane’s ground speed or maintain directional control during the landing roll, which resulted in a runway excursion and collision with an airport sign and structure and a subsequent postcrash fire.Sep 30, 2013 · N194SJ · DestroyedNTSB ERA13CA435Accident · Minor injuriesData collectionFinal reportAeronca 65 CA · Thomaston, GAThe pilot's inadequate pre-flight planning and in-flight monitoring of the fuel level which resulted in a total loss of engine power due to fuel exhaustion.Sep 30, 2013 · N33879 · Substantial damageNTSB CEN13LA581Accident · No injuriesLimited investigationFinal reportCessna 172 · Rio Vista, TXThe student pilot’s failure to maintain adequate airspeed during the initial climb after an excessive takeoff run from a grass airstrip, which resulted in the exceedance of the airplane's critical angle-of-attack and a subsequent aerodynamic stall and loss of…Sep 30, 2013 · N8878B · Substantial damageNTSB CEN13LA570Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · Algona, IAFuel exhaustion as a result of the pilot's failure to ensure he had sufficient fuel on board to complete the planned flight. Contributing to the accident was the incomplete information provided by the airport's AWOS.Sep 30, 2013 · N31688 · Substantial damageNTSB ANC13CA107Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Wasilla, AKThe pilot's improper preflight inspection, and failure to remove heavy frost from the airplane prior to attempting a takeoff.Sep 30, 2013 · N40579 · Substantial damageNTSB WPR13LA429Accident · Minor injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · Santa Maria, CAThe pilot's inadequate monitoring of the environment and failure to maintain clearance from transmission wires during a low-altitude maneuver.Sep 29, 2013 · N38113 · Substantial damageNTSB ERA13LA434Accident · 1 fatalLimited investigationFinal reportTimothy J Cowper Pitts Special S-1E · Edinburg, NYThe pilot’s failure to maintain adequate airspeed during low-altitude maneuvering, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.Sep 29, 2013 · N85AT · DestroyedNTSB ERA13CA436Accident · No injuriesData collectionFinal reportBeech A23 24 · Lumberton, NJThe pilot's improper landing flare, which resulted in a hard landing.Sep 29, 2013 · N7626R · Substantial damageNTSB CEN13CA569Accident · No injuriesData collectionFinal reportRans RV 12 · Hatley, WIThe pilot did not maintain control of the airplane while landing with a crosswind.Sep 29, 2013 · N817RV · Substantial damageNTSB ANC13CA106Accident · No injuriesData collectionFinal reportCessna 185E · Pilot Point, AKThe pilot's decision to land the airplane on the ramp, in the vicinity of buildings, in gusty wind conditions.Sep 29, 2013 · N1592F · Substantial damageNTSB WPR13CA428Accident · Minor injuriesData collectionFinal reportCessna 182Q · Big Bear, CAThe pilot's failure to maintain a stabilized landing approach, which resulted in a collision with a fence short of the runway.Sep 28, 2013 · N759UP · Substantial damageNTSB WPR13CA427Accident · No injuriesData collectionFinal reportAviat A-1C-200 · Dell, MTThe pilot's failure to maintain directional control while taxiing in gusting wind conditions.Sep 27, 2013 · N53WY · Substantial damageNTSB ERA13LA433Accident · 1 fatalLimited investigationFinal reportEnstrom F-28C · Bloomsburg, PAThe relieved pilot’s failure to maintain clearance from the rotating main rotor blades after he exited the helicopter.Sep 27, 2013 · N631DP · Minor damageNTSB CEN13CA564Accident · Serious injuriesData collectionFinal reportTreidel Mark/R F D Dominator · Watkins, COThe pilot's loss of control of the gyroplane during takeoff roll, following his inadvertent release of the cyclic control.Sep 26, 2013 · N728PJ · Substantial damageNTSB WPR13CA424Accident · Minor injuriesData collectionFinal reportRobinson R44 - II · Flagstaff, AZThe pilot's failure to maintain rotor rpm while landing in a gusty wind at a high density altitude.Sep 25, 2013 · N190SH · Substantial damageNTSB CEN13LA565Accident · No injuriesLimited investigationFinal reportCessna 210-5(205) · Weatherford, OKThe pilot’s inadequate preflight inspection and fuel planning, which resulted in fuel exhaustion and a total loss of engine power during descent.Sep 25, 2013 · N8472Z · Substantial damageNTSB CEN13FA558Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Bolingbrook, ILThe pilot’s failure to maintain control of the airplane during a go-around.Sep 25, 2013 · N406DC · DestroyedNTSB WPR13LA420Accident · 1 fatalLimited investigationFinal reportMiller RV6 · Williams, CAThe pilot's improper decision to fly at a low altitude, which resulted in his failure to maintain clearance from power lines.Sep 24, 2013 · N67GM · DestroyedNTSB CEN13CA556Accident · Serious injuriesData collectionFinal reportCessna 152 · Wadsworth, OHThe pilot's failure to adequately maintain airspeed during a go-around.Sep 24, 2013 · N24800 · Substantial damageNTSB ANC13CA105Accident · No injuriesData collectionFinal reportPiper PA 18 · Big Lake, AKThe pilot's selection of unsuitable terrain for landing, resulting in abnormal contact with terrain.Sep 24, 2013 · N1214A · Substantial damageNTSB WPR13LA419Accident · No injuriesLimited investigationFinal reportPiper PA60 602P · Sandpoint, IDThe pilot's failure to fly the approach at the appropriate landing speed and attain the correct touchdown point, which resulted in a runway overrun.Sep 23, 2013 · N35FD · Substantial damageNTSB ERA13LA428Accident · No injuriesLimited investigationFinal reportBeech A36 · Wellington, FLA total loss of engine power due to an interruption in fuel flow, which was most likely due to fuel starvation. Contributing to the accident was the pilot’s failure to maintain control of the airplane while performing the subsequent forced landing to a wet…Sep 23, 2013 · N40KG · Substantial damageNTSB CEN13LA562Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Mack, COA total loss of engine power due to the failure of the engine crankshaft, which resulted from maintenance personnel’s application of insufficient torque on the engine case through bolts.Sep 23, 2013 · N426TF · Substantial damageNTSB CEN13LA555Accident · Serious injuriesLimited investigationFinal reportBuckeye Industries Dream Machine · St. Joseph, MIThe pilot's failure to maintain control of the powered-parachute during takeoff.Sep 23, 2013 · N6122F · Substantial damageNTSB ERA13CA426Accident · Serious injuriesData collectionFinal reportMarconi Fred I JR Velocity XL/RG · Pahokee, FLThe pilot's failure to ensure that the landing gear were extended during the simulated forced landing attempt. Contributing to the outcome was the pilot's decision to continue the aborted landing after the propeller had contacted the runway.Sep 22, 2013 · N244FM · Substantial damageNTSB CEN13LA567Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12 D · Laguna Park, TXThe pilot’s inadequate flare during landing, which resulted in a hard landing and the subsequent collapse of the left main landing gear.Sep 22, 2013 · N96473 · Substantial damageNTSB CEN13CA559Accident · No injuriesData collectionFinal reportCessna 182Q · Goodhue, MNThe pilot's failure to maintain directional control of the airplane during landing.Sep 22, 2013 · N94303 · Substantial damageNTSB WPR13FA417Accident · 2 fatalField investigationFinal reportBell UH-1V · Cordes Lakes, AZThe pilot's improper maintenance on the helicopter’s main rotor blade pitch control system, which resulted in an in-flight loss of main rotor blade pitch control, mast bumping, and mast failure.Sep 21, 2013 · N22490 · DestroyedNTSB WPR13CA426Accident · No injuriesData collectionFinal reportPiper PA28 - 161 · Lancaster, CAThe pilot's failure to maintain directional control of the airplane during the landing roll.Sep 21, 2013 · N6313C · Substantial damageNTSB WPR13CA422Accident · No injuriesData collectionFinal reportBeech 35 - Undesignat · Seattle, WAThe pilot's distracted attention and failure to extend the landing gear, which resulted in a gear up landing.Sep 21, 2013 · N5894S · Substantial damageNTSB WPR13CA418Accident · No injuriesData collectionFinal reportGrob G 103 Twin II · Morgan, UTAn incorrect descent rate while on final approach as a result of the flight instructor's delayed remedial action, which lead to an off-field landing and impact with terrain.Sep 21, 2013 · N54554 · Substantial damageNTSB ERA13CA427Accident · Minor injuriesData collectionFinal reportCessna 182E · Middletown Springs, VTThe pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion.Sep 21, 2013 · N3152Y · Substantial damageNTSB ERA13CA425Accident · No injuriesData collectionFinal reportLennox Kenneth J Zodiac 601HDS · Salisbury, MDThe pilot's inadequate compensation for the wind conditions while landing.Sep 21, 2013 · N99KL · Substantial damageNTSB ERA13LA421Accident · Serious injuriesLimited investigationFinal reportAmerican Eurocopter AS350B2 · Canton, MSThe pilot’s improper decision to continue flight with a low engine oil pressure warning light instead of landing immediately in accordance with the flight manual emergency checklist. Contributing to the accident was the maintenance technician’s failure to…Sep 20, 2013 · N810LE · Substantial damageNTSB ERA13FA424Accident · 1 fatalField investigationFinal reportBrown Robert K RV7A · Hamilton Township, NJThe pilot's improper aerobatic maneuver that resulted in a loss of control, exceedance of the airplane's design limitations, and a subsequent in-flight breakup of the airplane.Sep 20, 2013 · N174BK · DestroyedNTSB ERA13CA423Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · Ridgely, MDThe flight instructor's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall and collision with terrain.Sep 20, 2013 · N619BV · Substantial damageNTSB WPR13LA416Accident · Serious injuriesLimited investigationFinal reportBeech C90 - A · Idaho Falls, IDThe pilot's inadequate preflight fuel planning, which resulted in departure with insufficient fuel to complete the flight, and consequent inflight power loss due to fuel exhaustion.Sep 19, 2013 · N191TP · Substantial damageNTSB ERA13CA422Accident · No injuriesData collectionFinal reportUniversal Stinson 108 1 · Lawrenceville, GAThe pilot's failure to maintain directional control during the landing, resulting in a ground loop, runway excursion, and structural damage to the right wing.Sep 19, 2013 · N8384K · Substantial damageNTSB ANC13CA104Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Delta Junction, AKThe pilot's inadequate takeoff planning and judgment that did not consider the reduced acceleration due to snow-covered terrain, which resulted in an aborted takeoff and collision with terrain.Sep 19, 2013 · N7190D · Substantial damageNTSB ERA13CA438Accident · No injuriesData collectionFinal reportCessna 182P · Newport News, VAThe pilot's failure to maintain directional control during landing resulting in a runway excursion.Sep 18, 2013 · N58482 · Substantial damageNTSB WPR13LA414Accident · No injuriesLimited investigationFinal reportCessna 180 - B · Redmond, ORThe pilot's inability to counter an unexpected wind gust after touchdown, which resulted in a loss of directional control.Sep 16, 2013 · N5112E · Substantial damageNTSB WPR13CA413Accident · No injuriesData collectionFinal reportCessna T310R · San Luis Obispo, CAThe pilot's inadvertent action of retracting the landing gear instead of the flaps during the landing roll, which resulted in the right main landing gear collapsing.Sep 16, 2013 · N712SB · Substantial damageNTSB WPR13CA412Accident · Minor injuriesData collectionFinal reportPiper PA 11 · Bozeman, MTThe pilot's failure to maintain aircraft control and inadequate compensation for the high gusty wind conditions during taxi.Sep 16, 2013 · N4988M · Substantial damageNTSB WPR13LA407Accident · No injuriesLimited investigationFinal reportMooney M20J · Lund, NVThe pilot’s failure to monitor the environment, which led to a collision with power lines during climbout. Contributing to the accident was the loss of engine power during low-altitude flight for reasons that could not be determined because postaccident…Sep 15, 2013 · N1079K · Substantial damageNTSB ERA14CA088Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Clermont, FLThe student pilot's failure to maintain directional control during the landing roll.Sep 15, 2013 · N321BA · Substantial damageNTSB WPR13CA409Accident · No injuriesData collectionFinal reportCessna 195A · Meadow Creek, MTThe pilot's failure to maintain directional control during the takeoff roll on a rough turf runway.Sep 14, 2013 · N4324N · Substantial damageNTSB ERA13CA417Accident · Serious injuriesData collectionFinal reportMiller/Culpepper Christen Eagle II · Blythe, GAThe pilot's failure to maintain aircraft control during takeoff which resulted in a stall and collision with terrain.Sep 14, 2013 · N887AS · Substantial damage