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 WPR16FA064Accident · 2 fatalField investigationFinal reportNorth American F51 · Maricopa, AZThe pilot’s failure to maintain airplane control while performing an acrobatic maneuver and his subsequent failure to recover from an inadvertent spin due to insufficient altitude.NTSB GAA16CA530Accident · No injuriesData collectionFinal reportRobinson R22 · Taylor, TXThe flight instructor's improper collective input during a simulated engine failure autorotation with a power recovery, which resulted in a hard, bounced landing and the main rotor blade striking the tailboom.NTSB WPR16LA063Accident · No injuriesLimited investigationFinal reportCessna 172S · San Diego, CAThe failure of the flight instructor of the other airplane to maintain awareness while parked on the ramp with the engine operating, which resulted in impact with the parked airplane.NTSB GAA16CA133Accident · Minor injuriesData collectionFinal reportNorth American P 51 · Dallas, TXThe pilot's failure to extend the landing gear prior to landing, which resulted in substantial damage to the fuselage during landing.NTSB GAA16CA120Accident · Minor injuriesData collectionFinal reportCessna 210 · Park Valley, UTThe pilot's decision to drag the left main landing gear on a snow covered dry lake bed, which resulted in a loss of directional control and a nose over during an aborted landing.NTSB ERA16FA100Accident · 2 fatalField investigationFinal reportCessna 182 · Mobile, ALThe pilot's loss of airplane control during a missed approach in instrument meteorological conditions due to spatial disorientation. Contributing to the accident was the pilot's inadequate preflight and inflight weather planning which resulted the pilot's…NTSB GAA16CA123Accident · No injuriesData collectionFinal reportCessna 150 · Lapeer, MIThe student pilot's failure to achieve an adequate climb rate while turning to avoid obstacles during an aborted landing, resulting in an uncontrolled descent, collision with terrain, and a nose over.NTSB CEN16LA097Accident · No injuriesLimited investigationFinal reportPiper PA 28-140 · Sturtevant, WIThe pilot's failure to maintain a proper glidepath during a landing at dusk, which resulted in impact with a moving ground vehicle. Contributing to the accident was the inoperative precision approach path indicator.NTSB CEN16FA094Accident · 1 fatalField investigationFinal reportCostruzioni Aeronautiche Tecna P92 Echo Super · Arcola, TXThe student pilot's loss of control after exceeding the airplane's critical angle-of-attack, which lead to a power-on, aerodynamic departure stall. Contributing to the accident was the flight instructor's inadequate oversight of the student pilot.NTSB WPR16LA060Accident · No injuriesLimited investigationFinal reportPiper PA46 · Burns, ORThe total loss of engine power for reasons that could not be determined because postaccident examination revealed no evidence of an anomaly that would have precluded normal operation. Contributing to the accident was a preexisting landing gear anomaly that…NTSB GAA16CA150Accident · No injuriesData collectionFinal reportCessna 172 · La Junta, COThe pilot's decision to take off with a tailwind, and exceed the critical angle of attack, which resulted in an aerodynamic stall and impact with the ground.NTSB GAA16CA119Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Everglades, FLThe pilot's failure to maintain adequate wing clearance while taxiing, which resulted in a collision with two unoccupied airplanes.NTSB GAA16CA114Accident · No injuriesData collectionFinal reportCessna 172 · Merritt Island, FLThe student pilot's improper flare which resulted in a porpoise, runway excursion, and nose over.NTSB GAA16LA117Accident · No injuriesLimited investigationFinal reportHelicopteres Guimbal Cabri · Beaumont, TXThe pilot's inadequate compensation for wind during a hover-taxi and his failure to maintain helicopter control due to a loss of tail rotor effectiveness.NTSB GAA16CA115Accident · No injuriesData collectionFinal reportAmerican Legend AL11C 100 · Las Animas, COThe pilot's selection of unsuitable terrain for landing, resulting in a nose over.NTSB ERA16FA097Accident · 3 fatalField investigationFinal reportBrook Aaron D Lancair IV P · Albany, GAThe pilots' failure to maintain control during a takeoff attempt in a high-performance airplane. Contributing to the accident were the pilots' decision to operate the airplane above its maximum gross weight and with an aft center of gravity and their lack of…NTSB WPR16FA059Accident · 2 fatalField investigationFinal reportPiper PA 24-260 · Santa Rosa, CAThe pilot’s failure to maintain airplane control during an instrument approach in night instrument meteorological conditions, which resulted in a collision with terrain. Contributing to the accident was the pilot’s lack of recent experience in night…NTSB OPS16IA004Incident · No injuriesIncident investigationFinal reportAirbus A321 231 · Fort Lauderdale, FLThe air traffic controller's failure to ensure the runway surface area was clear of vehicles before clearing an aircraft for takeoff. Also causal was the flight crew's decision to initiate a takeoff while the Runway Status Lights (RWSL) Takeoff Hold Lights…NTSB GAA16CA116Accident · No injuriesData collectionFinal reportCessna 152 · Durant, OKThe pilot's failure to maintain pitch control during the landing, resulting in a porpoise.NTSB ERA16LA098Accident · No injuriesLimited investigationFinal reportEurocopter France EC 130 B4 · Shoals, WVThe improper locking of the rear passenger door by the specialty nurse, which resulted in the door separating from the helicopter in flight.NTSB WPR16LA058Accident · No injuriesLimited investigationFinal reportCessna 340A · Bakersfield, CAMaintenance personnel’s repeated failure to re-rig the main landing gear (MLG) in accordance with the airplane manufacturer's service manual requirements, which resulted in the collapse of the right MLG.NTSB OPS16IA002Incident · No injuriesIncident investigationFinal reportBombardier CL600 2D24 · Detroit, MIThe local controller's failure to visually scan and ensure that the runway surface was not occupied by a vehicle or other aircraft before issuing a takeoff clearance to the pilot. Contributing to this incident was the relieved controller's failure to monitor…NTSB WPR16LA061Accident · No injuriesLimited investigationFinal reportCessna 210 · Lodi, CAThe pilot's failure to attain a proper touchdown point, which led to a runway excursion.NTSB CEN16FA095Accident · 1 fatalField investigationFinal reportCirrus Design SR22T · Xenia, OHThe pilot's failure to maintain adequate airspeed while turning from the base leg to final, which resulted in the wing's critical angle-of-attack being exceeded and a subsequent aerodynamic stall.NTSB GAA16CA121Accident · No injuriesData collectionFinal reportGlines Kenneth Tailwind W 8 · Big Bear, CAThe pilot's inadvertent landing off the left side of the snow-covered runway, resulting in a ground loop and nose over.NTSB GAA16CA112Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Auburn, WAThe failure of the pilot receiving instruction to maintain directional control during the landing roll, resulting in a ground-loop.NTSB DCA16CA070Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD 88 · Newark, NJthe ground crew's misjudgment of the distance between the B767 wingtip and the MD-88 tail. Contributing to the accident was the slushy condition of the ramp which limited the maneuvering space available.NTSB GAA16CA113Accident · No injuriesData collectionFinal reportCessna TR182 · Prescott, AZThe pilot's failure to extend the landing gear prior to landing, which resulted in substantial damage to the fuselage during landing.NTSB WPR16LA056Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 · Las Vegas, NVThe loss of helicopter control as a result of the loss of tail rotor effectiveness.NTSB GAA16CA110Accident · Minor injuriesData collectionFinal reportPiper PA32RT · Melfa, VAThe pilot's inadequate compensation for a gusting crosswind during landing, which resulted in an aerodynamic stall, impact with a structure, and subsequent postimpact fire.NTSB GAA16CA106Accident · No injuriesData collectionFinal reportPiper PA 28RT-201 · Terrell, TXThe private pilot's exceedance of the airplane's critical angle-of-attack during a go-around in gusting crosswind conditions, which resulted in an aerodynamic stall and a collision with terrain short of the runway.NTSB CEN16LA093Accident · No injuriesLimited investigationFinal reportSocata TBM700 · Wichita, KSThe pilot’s failure to maintain the minimum-recommended approach airspeed in icing conditions, which resulted in a loss of airplane control.NTSB WPR16FA054Accident · 2 fatalField investigationFinal reportCessna 525 · Cedar Fort, UTThe pilot's loss of control due to spatial disorientation while operating in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations, and a subsequent in-flight breakup. Contributing to the accident…NTSB GAA16CA103Accident · No injuriesData collectionFinal reportAviat A-1C · Breckenridge, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB ERA16LA092Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Dublin, GAThe pilot’s inadvertent retraction of the landing gear during the landing roll following a landing approach in gusting wind conditions.NTSB ERA16LA091Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Madison, GAThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA16CA093Accident · No injuriesData collectionFinal reportCessna 210 · Venice, FLThe pilot's failure to properly configure the landing gear, which resulted in a landing with the landing gear in the retracted position.NTSB ERA16CA102Accident · No injuriesData collectionFinal reportTucker Mitchel C H 13 · Zephyrhills, FLThe pilot's failure to maintain aircraft control while on ground standing with the engine running during high crosswind conditions which resulted in a static rollover and collision with the ground.NTSB CEN16LA090Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Overbrook, OKThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion, and his subsequent decision to circle to the north end of the airport due to a light tailwind condition instead of making a downwind landing.NTSB ERA16LA090Accident · No injuriesLimited investigationFinal reportBeech A23 · Kingston, TNThe pilot's inadequate preflight inspection and fuel planning and his improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA16CA109Accident · Minor injuriesData collectionFinal reportCessna CE-208 · Hooper Bay, AKThe pilot's failure to identify the runway, resulting in the airplane touching down a few feet to the right of the runway.NTSB GAA16CA108Accident · No injuriesData collectionFinal reportCessna 180 · Sussex, NJThe student pilot's failure to maintain pitch control during the landing, which resulted in abnormal runway contact, a ground loop, and a nose over.NTSB CEN16FA087Accident · 1 fatalField investigationFinal reportPiper PA 22-108 · Garden City, TXThe pilot's failure to maintain clearance with terrain during a low altitude flight.NTSB CEN16FA086Accident · 1 fatalField investigationFinal reportBeech C35 · Meeker, COThe non-instrument-rated pilot's decision to fly the airplane in instrument meteorological conditions at high altitude for greater than 30 minutes without the use of supplemental oxygen which resulted in hypoxia, and a subsequent loss of control. Contributing…NTSB GAA16LA100Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28 · Ritter Butte, ORThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent impact with terrain.NTSB CEN16FA083Accident · 1 fatalField investigationFinal reportCessna 172N · Gilmer, TXThe pilot's inadequate preflight planning and inspection, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's failure to maintain an appropriate traffic pattern altitude and distance from the…NTSB GAA16CA104Accident · No injuriesData collectionFinal reportCessna 172 · Dothan, ALThe pilot-rated student's hard landing, which resulted in fuselage damage.NTSB CEN16IA091Incident · No injuriesIncident investigationFinal reportMitsubishi MU 300 · Little Rock, ARThe flight crew's inadequate preflight inspection of the airplane, during which they failed to see a fueling mat that had been placed on the inboard trailing edge of the right wing, which the right engine subsequently ingested during the takeoff roll.…NTSB GAA16CA348Accident · No injuriesData collectionFinal reportBeech B200 · Carolina, PRThe pilot's failure to actuate the parking brake prior to leaving his seat, resulting in substantial damage.NTSB WPR16LA050Accident · 1 fatalLimited investigationFinal reportMoore Onex · Fresno, CAThe pilot/builder's failure to properly align the Force One Main Bearing, which resulted in a blockage of the oil transfer hole and culminated with a total engine power loss. Contributing to the accident was the pilot's failure to arrest the bank and sink…