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 DCA22LA135AccidentClass 4 · LimitedFinal reportAirbus A330 · New York, NYThe ITA Airways flightcrew’s misperception of the distance to maintain separation and safely pass the stopped Air France airplane.NTSB CEN22LA282Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Jacksonville, ILThe pilot’s failure to attain proper flare during landing, resulting in a bounced landing.NTSB CEN22LA255Accident · No injuriesClass 3 · LimitedFinal reportMooney M20E · Stillwater, OKThe inadequate maintenance and inspection of the engine induction air coupling, which impeded airflow to the engine and resulted in the subsequent partial loss of engine power.NTSB CEN22LA304Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Yoakum, TXThe pilot's loss of helicopter control on approach to land due to a settling with power condition, which resulted in a hard landing.NTSB CEN22LA293Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Bynum, TXThe pilot was not able to stop the airplane on the remaining runway after an aborted takeoff, which resulted in a runway excursion and the airplane impacting a fence.NTSB ERA22LA274Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Brevard, NCThe pilot’s failure to maintain altitude while maneuvering the airplane at a low altitude, which resulted in impact with trees and terrain.NTSB CEN22LA256Accident · No injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Madison, MSThe failure of a muffler weld due to inadequate maintenance, which resulted in a fire.NTSB WPR22LA218Accident · Serious injuriesClass 4 · LimitedFinal reportAir Creation USA Skypper · Toledo, WAThe pilot’s improper control input during landing which resulted in an exceedance of the aircraft’s critical angle of attack, aerodynamic stall and impact with the ground.NTSB ERA22LA275Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Gulf Shores, ALThe improper maintenance of the brake system, which resulted in the brakes overheating and catching fire and subsequent substantial damage to the airplane.NTSB CEN22LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Eaton Rapids, MIThe pilot’s failure to maintain airspeed in the climb with a quartering tailwind which resulted in an aerodynamic stall and subsequent impact with trees.NTSB CEN22LA248Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Beaumont, TXThe pilot’s failure to maintain clearance from a power line pole while preparing for a low-level aerial application pass.NTSB ERA22LA267Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Bluffton, OHThe student pilot’s loss of control during climb after an aborted landing, which resulted in an aerodynamic stall.NTSB ERA22LA266Accident · Minor injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5 · Sarasota, FLThe pilot’s inadequate preflight inspection, during which he failed to detect water contamination in the fuel system, which resulted in a loss of engine power on approach.NTSB WPR22LA213Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Auburn, WAA total loss of engine power due to fuel starvation.NTSB ERA22LA319Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Charleston, SCThe failure of the torsion spring inside the drive clutch assembly of the landing gear actuator which prevented normal and manual extension of the landing gear.NTSB CEN22LA291Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Minot, NDThe student pilot’s failure to maintain airspeed and yaw control of the airplane during an aborted takeoff, which resulted in an aerodynamic stall and impact with the ground.NTSB WPR22LA232Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-235 · Copperopolis, CAThe pilot’s failure to maintain lateral control of the airplane during takeoff in gusting wind.NTSB ERA22LA269Accident · No injuriesClass 4 · LimitedFinal reportWalter S Johnson III AR-1 · Butler, PAThe pilot’s failure to monitor rotor disk speed on takeoff, which resulted in blade flapping and the main rotor blades striking the gyroplane’s tail assembly.NTSB ANC22LA043Accident · Minor injuriesClass 4 · LimitedFinal reportPepperd Greg J Caribou Cruiser · Wasilla, AKThe pilot's overapplication of brakes during landing, which resulted in a nose-over.NTSB WPR22LA212Accident · Minor injuriesClass 4 · LimitedFinal reportAviat A-1B · Big Creek, IDThe pilot's failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and collision with fencing.NTSB WPR22FA210Accident · 1 fatalClass 3 · FieldFinal reportMooney M20K · Camarillo, CAThe pilot’s spatial disorientation and loss of airplane control after entering instrument meteorological conditions shortly after takeoff.NTSB CEN22LA245Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 305 · Sioux Falls, SDThe pilot’s failure to maintain directional control after an attempted go-around, which resulted in a runway excursion and impact with terrain.NTSB WPR22LA211Accident · Minor injuriesClass 3 · LimitedFinal reportRans S21 · Fairfield, UTThe owner’s (pilot) failure to properly torque a fuel filter b-nut fitting, which likely introduced air into the fuel system and resulted in a loss of engine power. Contributing to the loss of power was a missing restricted bypass line and a header tank vent…NTSB WPR22LA209Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Sunriver, ORThe pilot's failure to maintain control of the airplane during takeoff, which resulted in a collision with terrain.NTSB CEN22LA246Accident · No injuriesClass 4 · LimitedFinal reportCessna 337G · Greenbrier, ARThe pilot’s improper landing flare, which resulted in a bounced landing and the nose landing gear collapsing.NTSB CEN22LA244Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Salina, KSThe pilot’s poor pitch control during an aborted takeoff which resulted in a hard landing.NTSB CEN22LA242Accident · No injuriesClass 4 · LimitedFinal reportAMD CH2000 · Gladewater, TXThe student pilot’s failure to maintain/attain aircraft control during a go-around from a bounced landing that resulted in an aerodynamic stall and impact with terrain.NTSB CEN22LA239Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · New Braunfels, TXThe pilot’s failure to maintain directional control during takeoff.NTSB ANC22LA044Accident · No injuriesClass 4 · LimitedFinal reportCessna 182R · Anchorage, AKThe pilot’s improper landing flare which resulted in a hard landing.NTSB ANC22FA041Accident · Serious injuriesClass 3 · FieldFinal reportBell 407 · Kalea, HIThe in-flight separation of the tail boom as a result of abnormal loading and fracture of the upper-left tail boom attachment bolt due to a gap between the upper-left longeron and aft fuselage bulkhead.NTSB WPR22LA208Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Fort Duchesne, UTThe pilot’s decision to takeoff from an unimproved surface which resulted in a collision with an object and the airplane nosing over.NTSB DCA22LA126Incident · No injuriesClass 3 · LimitedFinal reportBoeing 757-236 · Tulsa, OKThe flight crew’s misidentification of the intended landing runway. Contributing to the incident were (1) the flight crew’s failure to perceive and correctly interpret visual and auditory indicators – including electronic guidance – that they were approaching…NTSB CEN22LA250Incident · No injuriesClass 3 · LimitedFinal reportBeech 58 · Evansville, INThe failure of the propeller blade due to high-cycle fatigue that originated from damage that occurred at an unknown time. Contributing to the accident was the failure to identify the damage before the accident flight.NTSB CEN22LA243Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MT-7-235 · Flasher, NDThe pilot’s loss of control during a takeoff from a narrow gravel road, resulting in a collision with a fixed obstacle.NTSB CEN22LA238Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · Hot Springs, SDThe passenger lost her grip during landing in a balloon which resulted in her hitting the ground with her shoulder and suffering a serious injury.NTSB ANC22LA042Accident · No injuriesClass 4 · LimitedFinal reportShort Bros. & Harland SC7 · Chisana, AKThe pilot’s selection of an unsuitable landing site, which resulted in the nosewheel collapsing.NTSB WPR22LA207Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 175 · Blackfoot, IDThe pilot’s loss of airplane control during the landing approach which, resulted in an undershoot and collision with a fence.NTSB WPR22LA201Accident · No injuriesClass 4 · LimitedFinal reportBombardier BD100 1A10 · Hawthorne, CAThe multi-engine pilot's failure to maintain clearance from another airplane during taxi.NTSB WPR22FA198Accident · 1 fatalClass 3 · FieldFinal reportBeech 77 · Hemet, CAThe student pilot’s failure to maintain clearance from a cinderblock wall while performing a go-around.NTSB CEN22LA237Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Fort Worth, TXThe student pilot’s inadequate fuel management that resulted in a loss of engine power due to fuel starvation.NTSB WPR22LA206Accident · No injuriesClass 4 · LimitedFinal reportShea Pitts Special S-1C · Reno, NVThe pilot’s failure to maintain directional control during landing roll.NTSB WPR22LA200Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170 · Wheatland, WYThe pilot’s improper landing flare which, resulted in a bounced landing and subsequent nose over.NTSB WPR22LA199Accident · Minor injuriesClass 4 · LimitedFinal reportBearhawk Bearhawk · Holbrook, AZThe pilot’s failure to maintain directional control during landing.NTSB ERA22LA263Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Westminster, MDThe student pilot’s loss of control during a go-around and the delayed remedial action initiated by the flight instructor, which resulted in a runway excursion and collision with trees.NTSB ERA22FA261Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28RT-201 · Panama City, FLMaintenance personnel’s failure to follow the avionics installation guidance for the oil pressure sensor, which resulted in the high-cycle fatigue failure of an line, oil starvation, and the subsequent loss of engine power. Contributing to the accident was…NTSB CEN22LA235Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Nashville, ARThe pilot was not able to stop the airplane on a wet runway due to hydroplaning.NTSB WPR22LA202Accident · Minor injuriesClass 3 · LimitedFinal reportFischer Super Koala · Chelan, WAA total loss of engine power for undetermined reasons.NTSB CEN22FA224Accident · 1 fatalClass 3 · FieldFinal reportSchweizer SGS135 · Midlothian, TXThe pilot’s incapacitation by an aortic dissection (natural disease).NTSB WPR22LA228Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Palm Springs, CAThe failure of the pilot to ensure the landing gear was down and locked before landing.NTSB WPR22LA204Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Snohomish, WAThe total loss of engine power during takeoff due to fuel starvation and the pilot’s improper fuel tank selection and inadequate preflight inspection.