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 ERA22FA086Accident · 1 fatalClass 3 · FieldFinal reportSwearingen SA226 · Bedford, NHThe pilot’s failure to secure and feather the left engine and increase power on the right engine after a perceived loss of engine power in the left engine, which resulted in a loss of control and impact with terrain just short of the runway. Contributing to…NTSB CEN22FA069Accident · 1 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Steamboat Springs, COThe pilot’s failure to adhere to the published instrument approach procedure, which resulted in controlled flight into terrain.NTSB ERA22FA085Accident · 2 fatalClass 3 · FieldFinal reportBeech V35 · Crab Orchard, KYThe noninstrument-rated pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control and collision with terrain. Contributing to the accident was…NTSB WPR22LA060Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Hillsboro, ORThe on-ground collision with a tree during an off airport precautionary landing. Contributing was the partial loss of engine power for undetermined reasons.NTSB CEN22LA075Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Rockwall, TXThe pilot’s failure to go-around during the unstable visual approach, which resulted in a bounced touchdown near the end of the runway and the subsequent runway excursion.NTSB CEN22LA068Accident · Serious injuriesClass 4 · LimitedFinal reportCHR International Safari 400 · McKinney, TXThe pilot did not remove the cyclic control lock during preflight, which resulted in a loss of control during the initial hover.NTSB CEN22FA067Accident · 2 fatalClass 3 · FieldFinal reportPiper PA 28-140 · Houston, TXThe student pilot’s decision to depart into night instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB ERA22FA083Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Statesboro, GAThe pilot’s decision to initiate a visual flight rules flight into dark night instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of control shortly after takeoff.NTSB CEN22FA064Accident · 1 fatalClass 3 · FieldFinal reportVans RV-4 · Walsenburg, COThe pilot’s failure to maintain clearance from terrain while intentionally maneuvering in a canyon at low altitude. Contributing to the accident was the pilot’s decision to enter a canyon environment at a low altitude, and the sudden change in wind conditions…NTSB WPR22LA086Accident · No injuriesClass 4 · LimitedFinal reportCessna 310Q · Corona, CAThe pilot receiving instruction failure to extend the landing gear before landing due to distraction and the flight instructor’s inadequate supervision.NTSB WPR22FA055Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-31-350 · Medford, ORThe pilot’s failure to maintain aircraft control during the initial climb into clouds due to spatial disorientation, which resulted in an uncontrolled descent and collision with terrain.NTSB WPR22LA056Accident · No injuriesClass 4 · LimitedFinal reportMonte Clark Vans RV8 · Hamilton, MTThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB WPR22FA054Accident · 4 fatalClass 3 · FieldFinal reportBeech V35 · Visalia, CAThe pilot’s loss of control due to spatial disorientation shortly after takeoff. Contributing to the accident was the pilot’s decision to depart into night instrument meteorological conditions.NTSB ERA22LA081Accident · Serious injuriesClass 4 · LimitedFinal reportGlobe GC-1B · Bennettsville, SCThe pilot’s inadequate preflight planning, resulting in a takeoff attempt from a grass parking area instead of the runway and subsequent impact with a pole.NTSB CEN22LA071Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV8 · Wichita Falls, TXThe pilot’s improper fuel management that resulted in a total loss of engine power due to fuel starvation.NTSB CEN22FA058Accident · 1 fatalClass 3 · FieldFinal reportCessna 182L · Bonnerdale, ARThe noninstrument rated pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent impact with terrain.NTSB WPR22LA059Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Hachita, NMThe pilot’s failure to adequately monitor the environment during a low level operation, which resulted in collision with vegetation.NTSB WPR22FA053Accident · 1 fatalClass 3 · FieldFinal reportRussell W Dyer Vortex · Lakeport, CAThe pilot’s loss of control for reasons that could not be determined and the delayed remedial action to recover from the power pushover event.NTSB CEN22LA063Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · St. Louis, MOThe pilot’s failure to apply power during the recovery procedure for the practice autorotation, which resulted in a hard landing.NTSB ANC22LA009Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 208 · Port Alsworth, AKThe pilot's failure to maintain a proper approach path which resulted in landing short of the runway and impact with terrain.NTSB WPR22LA058Accident · No injuriesClass 4 · LimitedFinal reportCessna 510 · Havasu, AZThe pilot's failure to extend the landing gear during landing. Contributing to the accident was the pilot’s failure to use a pre-landing checklist.NTSB CEN22LA061Accident · Serious injuriesClass 4 · LimitedFinal reportExperimental Nieuport-12 · Midland, TXThe pilot’s loss of directional control during a high-speed taxi operation and subsequent collision with terrain during the inadvertent flight.NTSB CEN22LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-46-310P · Cassville, MOThe pilot’s failure to reinstall the nose landing gear linkage prior to the flight which resulted in a loss of directional control during landing.NTSB WPR22LA051Accident · No injuriesClass 4 · LimitedFinal reportTravel Air 4-D · Riverside, CAThe pilot's failure to abort a high-speed taxi in time before the airplane exited the end of the airstrip which resulted in the pilot’s over application of the brakes and subsequent nose over.NTSB ERA22LA094Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C · Kissimmee, FLThe pilot’s inadvertent application of brakes during touchdown, which resulted in a noseover.NTSB ERA22LA080Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-12 · Labelle, FLThe pilot’s improper fuel system modification, which resulted in a loss of engine power due to fuel exhaustion.NTSB ANC22LA010Accident · No injuriesClass 4 · LimitedFinal reportFound Acft Canada FBA-2C1 · Kenai, AKThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.NTSB ERA22LA079Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA46 · Cornelia, GAThe pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion and collision with terrain.NTSB WPR22LA075Accident · Serious injuriesClass 4 · LimitedFinal reportSchulze Erwin E JR SHA Glasair SH-2R · Santa Paula, CAThe pilot’s failure to extend the landing gear before landing.NTSB WPR22LA063Accident · No injuriesClass 4 · LimitedFinal reportBeech 200 · Eugene, ORThe pilot’s improper checklist use, which resulted in an electrical malfunction and subsequent gear up landing.NTSB CEN22FA053Accident · 1 fatalClass 3 · FieldFinal reportBell 206 · Perry, OKA loss of lateral control during a hover that resulted in an impact with terrain. Based on the available evidence, the reason for the loss of lateral control could not be determined.NTSB WPR22LA052Accident · No injuriesClass 4 · LimitedFinal reportBagley Curtis Lynn Rans S-6S Coyote II · Fairfield, UTThe pilot's failure to maintain directional control during takeoff with a right crosswind.NTSB ERA22LA093Accident · No injuriesClass 4 · LimitedFinal reportTecnam P92 · Apopka, FLThe pilot's failure to maintain directional control while landing in a gusting crosswind, which resulted in a runway excursion and impact with a hangar.NTSB ANC22LA008Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Palmer, AKThe pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power, off-airport landing, and nose over.NTSB WPR22LA050Accident · Serious injuriesClass 4 · LimitedFinal reportAlon A2 · Frazier Park, CAThe pilot’s failure to maintain adequate airspeed while on approach for landing which, resulted in an aerodynamic stall and collision with terrain.NTSB WPR22LA049Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft BL-65 · New Cuyama, CAThe pilot’s decision to intentionally crash the airplane.NTSB ERA22FA076Accident · 2 fatalClass 3 · FieldFinal reportCessna T210R · Grove City, PAA catastrophic engine failure due to oil starvation after the pilot’s failure to secure the oil filler cap before flight. Contributing to the accident was the pilots’ decision to continue the flight following the oil loss event and precautionary landing.NTSB WPR22FA048Accident · 1 fatalClass 3 · FieldFinal reportZenith Zodiac CH601XL · Temecula, CAThe failure of the airplane’s canopy latch system, which resulted in the canopy opening in flight and a loss of airplane control. Contributing to the accident was the lack of a secondary canopy latch as recommended by the kit manufacturer.NTSB ERA22LA077Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-301 · Orlando, FLThe pilot’s inadequate compensation for winds during the landing roll.NTSB ERA22LA074Accident · No injuriesClass 4 · LimitedFinal reportBeech C35 · Perry, GAThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with a parked airplane.NTSB WPR22LA045Accident · No injuriesClass 4 · LimitedFinal reportElvin Jack R JR Rotorway Exec 162F · Scio, ORThe pilot’s improper maintenance on the tail rotor assembly, which resulted in the loss of control and roll over.NTSB CEN22FA042Accident · 3 fatalClass 3 · FieldFinal reportCessna T310R · Chadron, NEThe incapacitating effects of a myocardial infarction (heart attack), which resulted in the pilot's loss of airplane control and impact with terrain.NTSB WPR22FA044Accident · 1 fatalClass 3 · FieldFinal reportJahnke Lionel G Glasair III · Big Bear City, CAThe pilot’s failure to maintain clearance from mountainous terrain for reasons that could not be determined based on the available information, which resulted in controlled flight into terrain.NTSB ERA22LA070Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Old Bridge, NJThe student pilot’s loss of control during a go-around, which resulted in an aerodynamic stall.NTSB CEN22LA043Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Wheeling, ILThe student pilot’s improper landing flare, which resulted in a hard landing. Contributing was the student pilot’s self-induced pressure to land after being admonished by the controller.NTSB ERA22LA069Accident · Serious injuriesClass 4 · LimitedFinal reportK Copters 47G-2 · Lancaster, PAThe flight instructor’s failure to ensure a positive transfer of aircraft control, which resulted in a loss of control and collision with terrain.NTSB WPR22FA043Accident · 1 fatalClass 3 · FieldFinal reportCessna 182Q · Carlsbad, NMThe pilot's failure to maintain separation from an FM tower guy wire while on an aerial survey flight.NTSB CEN22LA041Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Miamisburg, OHThe student pilot’s failure to maintain control of the helicopter during a low-altitude hover shortly after liftoff.NTSB WPR22LA042Accident · No injuriesClass 4 · LimitedFinal reportPhoenix Air U-15 Phoenix · Carlsbad, CAThe pilot’s failure to maintain distance with an airport sign while taxiing.NTSB ERA22LA072Accident · No injuriesClass 4 · LimitedFinal reportAeronca O58B · Jonestown, PAThe pilot’s incorrect glide path and landing flare, which resulted in a collision with obstacles on final approach and a hard landing.