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 ANC22FA030Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R22 Beta · Gila Bend, AZThe student pilot’s failure to maintain control during the landing approach.NTSB CEN22LA180Accident · Serious injuriesClass 4 · LimitedFinal reportGlobe GC-1B · Huntsville, TXThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.NTSB WPR22LA158Accident · No injuriesClass 3 · LimitedFinal reportEuropa XS Mono · Eastsound, WAThe pilot inadvertently shut off the engine control unit, which resulted in the engine turning off before the runway landing was attained.NTSB WPR22FA151Accident · 1 fatalClass 3 · FieldFinal reportCessna 208B · Heyburn, IDThe pilot’s failure to maintain altitude during an instrument approach, which resulted in a descent below the approach path and impact with a vent stack. Also causal was the failure of the processing plant to correctly paint the vent stacks, which had been…NTSB ERA22LA198Accident · No injuriesClass 3 · LimitedFinal reportCessna 310 · Selma, ALThe failure of maintenance personnel to properly rig the rudder trim system after reinstallation and pilot’s inadequate preflight inspection after recent maintenance, which resulted in an inability to adequately maintain directional control during the flight.NTSB CEN22LA176Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Twin Lakes, COThe failure of the left turbocharger at FL230, which resulted in a rapid loss of manifold pressure and subsequent complete loss of engine power due to an overly rich fuel-air mixture setting. Contributing was the smoke in the cabin in IMC, which caused the…NTSB ERA22LA188Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Calhoun, GAThe pilot’s failure to maintain clearance from wires during takeoff.NTSB ANC22LA029Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Beluga, AKThe pilot’s excessive touchdown speed, which resulted in a long landing and impact with terrain.NTSB WPR22LA152Accident · Serious injuriesClass 3 · LimitedFinal reportAdams Balloons A55S · Safford, AZThe pilot’s decision to continue the balloon’s fast approach to an unsuitable confined landing site, which resulted in a collision with powerline wires.NTSB ERA22LA184Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Bald Head Island, NCThe pilot’s failure to maintain control during landing on a soft surface.NTSB ANC22LA028Accident · No injuriesClass 3 · LimitedFinal reportCessna 172H · Chugiak, AKThe pilot’s failure to maintain directional control while landing, which resulted in a runway excursion and nose over.NTSB WPR22FA148Accident · 1 fatalClass 3 · FieldFinal reportTaylorcraft BL-65 · Counselor, NMA loss of control while maneuvering at a high-density altitude in gusty wind conditions.NTSB CEN22LA175Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Hebbronville, TXThe pilots improper landing flare which resulted in a hard landing and loss of airplane control.NTSB WPR22LA149Accident · No injuriesClass 3 · LimitedFinal reportDietrich Ryan S-4 Coyote 1 · Chula Vista, CAThe pilot/owner and maintenance personnel’s improper installation of the right wing’s aft lift strut to the right wing, which resulted in a loss of lift during takeoff, an uncommanded right roll, and an impact with terrain.NTSB CEN22LA173Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Tomball, TXThe pilot did not maintain directional control during landing, which led to a runway excursion and nose-over of the airplane.NTSB CEN22LA172Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Evansville, INThe pilot did not maintain directional control during the landing roll resulting in a ground loop.NTSB CEN22LA171Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Peyton, COThe pilot’s decision to not activate the runway lighting and misjudged the runway location, which resulted in a collision with a windsock.NTSB WPR22LA146Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 · Phoenix, AZThe pilot’s failure to maintain helicopter control while on the ground when his attention was diverted, which resulted in a dynamic rollover.NTSB ERA22LA186Accident · Serious injuriesClass 3 · LimitedFinal reportHenry L Berrier JR Arion Lightning LS-1 · Mountain City, TNA total loss of engine power due to intermittent operation of both the engine-driven fuel pump and the electric boost pump. Contributing was the pilot’s delay in rejecting the takeoff, after the initial loss of engine power, which resulted in a collision with…NTSB ERA22LA185Accident · No injuriesClass 4 · LimitedFinal reportPF Cub Flyers CCK-2000 · Collegedale, TNThe pilot's failure to maintain directional control of the airplane during landing, which resulted in a runway excursion and a subsequent nose-over.NTSB ANC22LA045Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Aleknagik, AKThe pilot’s selection of unsuitable terrain for taxi which resulted in an impact with trees.NTSB WPR22LA147Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Tuscon, AZThe loss of directional control during the landing roll, due to missing hardware which resulted in the separation of the nose landing gear torque links.NTSB WPR22LA145Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 162 · Palo Alto, CAThe pilot’s failure to maintain pitch control during a go-around maneuver, which resulted in an aerodynamic stall and impact with the ground.NTSB ERA22LA183Accident · No injuriesClass 4 · LimitedFinal reportCessna 172RG · Waterville, METhe student pilot’s incorrect landing flare, which resulted in a hard bounced landing and nose landing gear collapse.NTSB ERA22LA210Accident · No injuriesClass 4 · LimitedFinal reportHenderson Clifford S Super Bear CSH-1 · Indiana, PAThe pilot's loss of directional control while landing, which resulted in a ground loop.NTSB CEN22LA167Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 · Hawley, TXThe pilot’s poor decision to exit the helicopter with the engine and main rotor still operating.NTSB CEN22FA168Accident · 2 fatalClass 3 · FieldFinal reportCessna TU206F · Marlin, TXThe pilot’s failure to maintain control of the airplane during landing for reasons that could not be determined based on available information.NTSB ERA22LA179Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20M · Manville, NJThe pilot’s delayed go-around decision following an encounter with a tailwind during landing, which resulted in an inability to climb and subsequent impact with trees.NTSB ENG22LA020IncidentClass 3 · LimitedFinal reportBombardier BD-700-2A12 · West Palm Beach, FLAn in-flight engine fire resulted from a fuel leak from fuel nozzle No. 16 pigtail-to-fuel manifold b-nut connection that contacted hot engine parts and ignited. Contributing to the manifold fuel leak was the misalignment between fuel manifold female ferrule…NTSB CEN22LA170Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Houston, TXThe student pilot’s failure to maintain direction control during takeoff in gusty wind conditions.NTSB CEN22LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 172RG · Pearland, TXThe flight instructor's failure to extend the landing gear and perform a before landing checklist.NTSB CEN22LA165Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Calhan, COThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.NTSB WPR22LA143Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Van Nuys, CAThe student pilot’s failure to maintain sufficient distance behind a jet airplane which, resulted in his loss of airplane control due to the jet airplane’s jet blast and the flight instructor’s delayed remedial action.NTSB WPR22LA141Accident · No injuriesClass 4 · LimitedFinal reportFernandes Dale R Glasair II S-FT · Saline Valley, CAThe pilot’s failure to establish a controlled descent rate during landing which resulted in the airplane touching down short of the runway.NTSB ERA22LA180Accident · Minor injuriesClass 4 · LimitedFinal reportHughes 269A · Fort White, FLThe non-instrument-rated pilot’s decision to fly a visual flight rules only helicopter in instrument meteorological conditions, which resulted in a collision with trees and terrain.NTSB ERA22LA177Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 170 · Stoney Point, NCThe pilot’s failure to retract the flaps during a go-around from a bounced landing, which resulted in a collision with trees then terrain.NTSB ERA22LA176Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177RG · Gaithersburg, MDThe pilot’s failure to maintain adequate airspeed while maneuvering on final approach which resulted in a high sink rate and subsequent collision with a fence.NTSB ERA22LA175Accident · Minor injuriesClass 3 · LimitedFinal reportLearjet 45 · Morristown, NJThe captain’s inadequate compensation for crosswind conditions, which resulted in a loss of directional control.NTSB WPR22LA140Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58A · Merced, CAThe pilot’s failure to see and avoid wires while conducting an aerial application flight, which resulted in a wire strike and ground impact.NTSB ENG22LA049IncidentClass 3 · LimitedFinal reportBombardier Global 7500 · Riyadh, Saudi ArabiaAn in-flight engine fire resulted from a fuel leak from fuel nozzle No. 18 pigtail-to-fuel manifold b-nut connection that contacted hot engine parts and ignited. Contributing to the manifold fuel leak was the misalignment between fuel manifold female ferrule…NTSB CEN22LA164Accident · 1 fatalClass 3 · LimitedFinal reportMooney M20E · Kerrville, TXThe pilot’s sudden cardiac event, which resulted in incapacitation, uncontrolled taxi after landing, and collision with a stationary parked airplane.NTSB CEN22LA163Accident · 2 fatalClass 3 · LimitedFinal reportKitfox 7 · Crowell, TXThe pilot's exceedance of the airplane's critical angle of attack during low-level flight, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.NTSB WPR22LA139Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Swan Valley, IDThe pilot’s failure to maintain airplane control during the landing roll on a snow-covered runway surface.NTSB CEN22LA160Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Lampasas, TXThe pilot’s decision to perform a takeoff from a perpendicular taxiway rather than the airport runway, which led to the airplane striking trees at the end of the departure path.NTSB ERA22LA174Accident · Minor injuriesClass 4 · LimitedFinal reportFpna A-22 Valor · Mascotte, FLThe pilot’s incorrect positioning of both wing fuel valves, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN22LA177Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · McAllen, TXThe pilot’s failure to extend the landing gear due to distraction.NTSB CEN22LA166Accident · Serious injuriesClass 4 · LimitedFinal reportBeech B200 · Odessa, TXThe airplane’s encounter with severe clear air turbulence that was not forecasted, which resulted in a serious injury to an unrestrained passenger.NTSB CEN22LA162Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-220T · Slidell, LAThe flight instructor’s failure to adequately correct for a loss of directional control during a simulated single engine approach.NTSB CEN22LA159Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RXS-8 · Yutan, NEThe pilot’s improper brace during landing which resulted in a serious injury during the landing sequence.NTSB ANC22LA026Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Anchorage, AKThe flight instructor’s failure to adequately monitor the student pilot which resulted in an impact with terrain and a nose-over.