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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN14CA017Accident · No injuriesData collectionFinal reportRobinson R22 - Beta · Chicago, ILThe flight instructor's failure to take remedial action in a timely manner.NTSB WPR14CA002Accident · No injuriesData collectionFinal reportAir Tractor AT 401 · Waco, TXThe pilot’s failure to maintain directional control during the takeoff in gusting wind conditions.NTSB WPR14CA001Accident · No injuriesData collectionFinal reportUnknown Unknown · Mount Pleasant, UTThe pilot's failure to maintain aircraft control during landing.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ERA13CA436Accident · No injuriesData collectionFinal reportBeech A23 24 · Lumberton, NJThe pilot's improper landing flare, which resulted in a hard landing.NTSB CEN13CA569Accident · No injuriesData collectionFinal reportRans RV 12 · Hatley, WIThe pilot did not maintain control of the airplane while landing with a crosswind.NTSB 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.NTSB 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.NTSB WPR13CA427Accident · No injuriesData collectionFinal reportAviat A-1C-200 · Dell, MTThe pilot's failure to maintain directional control while taxiing in gusting wind conditions.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN13FA558Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Bolingbrook, ILThe pilot’s failure to maintain control of the airplane during a go-around.NTSB 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.NTSB CEN13CA556Accident · Serious injuriesData collectionFinal reportCessna 152 · Wadsworth, OHThe pilot's failure to adequately maintain airspeed during a go-around.NTSB ANC13CA105Accident · No injuriesData collectionFinal reportPiper PA 18 · Big Lake, AKThe pilot's selection of unsuitable terrain for landing, resulting in abnormal contact with terrain.NTSB 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.NTSB 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…NTSB 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.NTSB CEN13LA555Accident · Serious injuriesLimited investigationFinal reportBuckeye Industries Dream Machine · St. Joseph, MIThe pilot's failure to maintain control of the powered-parachute during takeoff.NTSB 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.NTSB 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.NTSB CEN13CA559Accident · No injuriesData collectionFinal reportCessna 182Q · Goodhue, MNThe pilot's failure to maintain directional control of the airplane during landing.NTSB 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.NTSB WPR13CA426Accident · No injuriesData collectionFinal reportPiper PA28 - 161 · Lancaster, CAThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB 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.NTSB 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.NTSB 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.NTSB ERA13CA425Accident · No injuriesData collectionFinal reportLennox Kenneth J Zodiac 601HDS · Salisbury, MDThe pilot's inadequate compensation for the wind conditions while landing.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ERA13CA438Accident · No injuriesData collectionFinal reportCessna 182P · Newport News, VAThe pilot's failure to maintain directional control during landing resulting in a runway excursion.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB ERA14CA088Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Clermont, FLThe student pilot's failure to maintain directional control during the landing roll.NTSB 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.NTSB 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.