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 WPR21LA275Accident · No injuriesClass 4 · LimitedFinal reportCessna 180C · Ogden, UTThe pilot’s loss of directional control while taxiing at high speed, which resulted in a ground loop.NTSB WPR21LA259Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Lander, WYThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a fence.NTSB CEN21FA305Accident · 2 fatalClass 3 · FieldFinal reportHawker Beechcraft G36 · Aspen, COThe pilot’s failure to navigate through mountainous terrain, which resulted in controlled flight into terrain.NTSB CEN21FA304Accident · 1 fatalClass 3 · FieldFinal reportFocke-Wulf FWP-149D · Killeen, TXThe total loss of engine power due to a fatigue failure of a crankshaft counterweight mounting lobe, which resulted in a counterweight separation and catastrophic secondary damage to the engine drivetrain. Contributing to the accident was the mislabeled…NTSB ANC21LA055Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot’s improper flight control inputs which resulted in a loss of directional control and a nose-over.NTSB ANC21LA052Accident · Serious injuriesClass 4 · LimitedFinal reportChampion 7GCBC · Palmer, AKThe pilot’s selection of unsuitable terrain for landing which resulted in a nose-over.NTSB CEN21LA306Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Pottsboro, TXThe airplane’s degraded performance from the rough, grass runway surface and the pilot’s delayed decision to abort the takeoff resulting in a runway excursion.NTSB ANC21LA051Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Hoonah, AKThe pilot’s failure to maintain directional control during landing.NTSB ERA21LA281Accident · No injuriesClass 4 · LimitedFinal reportCessna 402A · Fort Lauderdale, FLThe pilot’s loss of directional control during takeoff with a fogged wind screen and sun glare, which resulted in a runway excursion and a collision with a taxiway sign.NTSB DCA21FA174Accident · Serious injuriesClass 2 · FieldFinal reportBoeing 737-275C · Honolulu, HIThe flight crewmembers’ misidentification of the damaged engine (after leveling off the airplane and reducing thrust) and their use of only the damaged engine for thrust during the remainder of the flight, resulting in an unintentional descent and forced…NTSB CEN21LA302Accident · Minor injuriesClass 3 · LimitedFinal reportPiper Aerostar 600A · Wichita, KSThe pilot’s improper fuel planning and management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN21FA300Accident · 2 fatalClass 3 · FieldFinal reportBeech 35-33 · Roff, OKThe pilot’s loss of airplane control due to spatial disorientation during low-level nighttime flight.NTSB WPR21LA264Accident · No injuriesClass 4 · LimitedFinal reportChristen Industries A-1 · Twin Falls, IDPartial loss of engine power during a low pass, due to carburetor icing and the pilot’s failure to use carburetor heat during the landing approach.NTSB WPR21FA258Accident · 2 fatalClass 3 · FieldFinal reportCessna 172R · Missoula, MTThe pilot’s failure to maintain airspeed and exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB ERA21LA307Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Carrollton, ALThe pilot’s incorrect preflight planning and poor in-flight planning, resulting in fuel exhaustion. Contributing to the damage was the inadvertent encounter with a hole during the forced landing.NTSB CEN21LA308Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Tyler, TXThe pilot’s failure to maintain proper airspeed on approach resulting in an extended touchdown, bounced landing, and runway excursion.NTSB CEN21FA299Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Lamoni, IAThe pilot did not maintain aircraft control during an attempted go-around after a bounced landing, which resulted in impact with terrain and a postimpact fire.NTSB ANC21LA056Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 170B · North Pole, AKThe pilot’s exceedance of the airplane’s takeoff performance limitations, which prevented the airplane from gaining sufficient altitude to clear the trees off the departure end of the runway.NTSB ANC21LA054Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot’s excessive use of brakes during landing, which resulted in a nose-over. Contributing to the accident was the flight instructor’s inadequate supervision and the gusty tailwind conditions.NTSB WPR21LA255Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Terreton, IDThe pilot's exceedance of the airplane's critical angle of attack during a go-around, which resulted in an aerodynamic stall and subsequent impact with terrain.NTSB CEN21FA297Accident · 1 fatalClass 3 · FieldFinal reportEarthstar Gull 2000 · Curtiss, WIThe non-instrument-rated pilot’s decision to depart into instrument meteorological conditions with dense fog and low clouds, which resulted in spatial disorientation and a loss of airplane control. Contributing to the accident was the pilot’s self-imposed…NTSB WPR21LA261Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-A55 · North Las Vegas, NVThe pilot’s inability to maintain directional control during landing roll due to a flat tire.NTSB WPR21LA257Accident · No injuriesClass 4 · LimitedFinal reportWheeler C / Wheeler K Lancair 235 · Borrego Springs, CAThe pilot’s failure to maintain airplane control during a crosswind landing which resulted in an impact with terrain.NTSB WPR21LA252Accident · No injuriesClass 4 · LimitedFinal reportSilverLight AR-1 · Lakeside, ORThe pilot’s inadequate decision to continue the takeoff after sufficient airspeed was not attained and his failure to maintain aircraft control while maneuvering to avoid obstructions, which resulted in a collision with the ground.NTSB ERA21LA275Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Rome, NYThe pilot's improper termination of a practice autorotation with power recovery, which resulted in low rotor rpm, an unstable landing, and a rollover. Contributing to the accident was the evaluator's inadequate oversight.NTSB ERA21FA274Accident · 2 fatalClass 3 · FieldFinal reportCessna 152 · St. Augustine, FLThe flight instructor’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall during the landing approach.NTSB CEN21LA296Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Hoxie, ARThe pilot’s failure to ensure an adequate fuel supply for the intended flight.NTSB WPR21LA256Accident · No injuriesClass 4 · LimitedFinal reportMooney M20 · Nampa, IDThe pilot’s failure to use the landing checklist and to extend the landing gear, which resulted in a gear-up landing.NTSB ERA21LA273Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Woodland, TNThe student pilot’s inadequate monitoring of his fuel state during a solo training flight, which resulted in fuel starvation, a total loss of engine power, and a forced landing.NTSB ERA21LA272Accident · Minor injuriesClass 4 · LimitedFinal reportBell 47G-2A-1 · Brasstown, NCThe pilot’s inflight loss of control while conducting a hovering maneuver.NTSB ERA21LA271Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Bentleyville, PAThe flight instructor and student pilot’s inadequate preflight performance planning which resulted in a takeoff attempt with insufficient available runway, a loss of control, and impact with terrain.NTSB CEN21LA295Accident · Serious injuriesClass 4 · LimitedFinal reportFlight Design Ctls · Ray, MIThe flight instructor’s improper decision to direct the student pilot to exit the airplane with the engine running, which resulted in serious injury when the student walked into the propeller arc.NTSB CEN21LA294Accident · No injuriesClass 3 · LimitedFinal reportConsolidated Aeronautics Lake LA-4-200 · Mio, MIThe pilot’s failure to abort the takeoff roll when the engine did not produce full power.NTSB ANC21LA050Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Dillingham, AKThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions which resulted in a loss of control and impact with terrain.NTSB WPR21LA249Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20F · Marion, MTThe pilot’s improper rotation during takeoff from a high-altitude airport and his failure to abort the takeoff, which resulted in an impact with trees and terrain. Contributing to the accident was the pilot’s improper management of the turbocharger, which…NTSB WPR21FA243Accident · 1 fatalClass 3 · FieldFinal reportFeraca Edward M Searey LSX · Logan, UTThe pilot’s loss of airplane control while maneuvering at a low altitude, which resulted in a collision with a house.NTSB ERA21LA270Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Waxhaw, NCThe pilot’s failure to maintain clearance from powerlines during a low-level aerial application flight.NTSB CEN21LA292Accident · Minor injuriesClass 4 · LimitedFinal reportCurnutt Elton E SKY Ranger B · Ellicott, COThe pilot’s loss of control while maneuvering at low altitude.NTSB WPR21LA248Accident · No injuriesClass 4 · LimitedFinal reportDewsnup Dave Zenair CH 701 SP · Chester, CAThe pilot’s failure to properly position of the fuel selector valve, which resulted in a loss of engine power during initial climb due to fuel starvation.NTSB WPR21LA244Accident · No injuriesClass 4 · LimitedFinal reportCessna 182E · Ririe, IDThe pilot’s encounter with a tailwind during takeoff roll, which resulted in an aborted takeoff, collision with a ditch and subsequent nose over.NTSB WPR21FA242Accident · 5 fatalClass 3 · FieldFinal reportCameron Balloons US O-120 · Albuquerque, NMThe failure of the pilot to maintain adequate clearance from power lines while maneuvering for landing. Contributing to the accident was the pilot’s use of impairing, illicit drugs.NTSB WPR21LA247Accident · No injuriesClass 4 · LimitedFinal reportShort Bros SD-360-300 · Las Vegas, NVThe pilot’s failure to extend the landing gear during landing and the check pilot’s inadequate supervision.NTSB ERA21LA282Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Mount Pocono, PAThe pilot’s loss of aircraft control following a bounced landing.NTSB ERA21LA269Accident · 1 fatalClass 3 · LimitedFinal reportGarlick Helicopters OH-58A+ · Alpine, ALThe pilot’s failure to maintain clearance from powerlines during a low-level aerial application flight, resulting in main rotor blade impact with a fiber-optic cable, a loss of control, and the helicopter’s subsequent impact with terrain.NTSB CEN21LA298Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 500 S · Jennings, LAThe pilot’s failure to extend the landing gear before landing.NTSB CEN21LA293Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Porter, TXThe pilot’s decision to continue the takeoff with degraded engine performance, which resulted in an inability to climb and a subsequent forced landing. The reason for the engine’s degraded performance could not be determined based on available information.NTSB CEN21LA291Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Loveland, COThe flight instructor’s failure to maintain aircraft control during the landing flare and subsequent attempted go-around with a strong quartering crosswind.NTSB WPR21LA246Accident · No injuriesClass 4 · LimitedFinal reportAirborne Australia XT582 · Carson City, NVThe student pilot's failure to maintain directional control during landing in gusting wind, which resulted in a runway excursion and impact with terrain.NTSB CEN21LA312Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · St. Louis, MOThe pilot’s failure to maintain directional control during the landing roll with hydroplaning conditions.NTSB WPR21LA240Accident · No injuriesClass 4 · LimitedFinal reportCessna T206 · Apple Valley, CAThe pilot's distraction due to adjusting the radio while taxing at night, which resulted in a taxiway excursion and subsequent impact with terrain.