NTSB investigations, 2022

625 cases where NTSB found Aircraft oper/perf/capability.

Cases per year

20082026
NTSB investigations, 2022 per year, 2008–2026: 12,339 cases
2008816
2009839
2010676
2011755
2012751
2013642
2014708
2015664
2016737
2017719
2018729
2019691
2020598
2021590
2022625
2023591
2024560
2025432
2026216

Latest cases

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 year(c.\"eventDate\") = 2022
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0106'))
  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.

NTSB CEN23FA071Accident · 4 fatalClass 3 · FieldFinal reportBell 407 · Galliano, LAThe pilot’s failure to ensure the helicopter was clear of obstacles before takeoff from the helideck, which resulted in the helicopter’s right landing skid pivoting about a helideck perimeter light during takeoff and a dynamic rollover. Additionally, the…Dec 29, 2022 · N595RL · Substantial damageNTSB WPR23LA081Accident · No injuriesClass 4 · LimitedFinal reportEmbraer Executive EMB-505 · Hawthorne, CAA runway overrun due to the pilot’s failure to stop the airplane as a result of diminished braking action due to a water contaminated runway surface.Dec 28, 2022 · N16DF · Substantial damageNTSB WPR23LA078Accident · Serious injuriesClass 3 · LimitedFinal reportAirbus Helicopters EC 130 T2 · Boulder City, NVThe pilot’s failure to apply anti-torque pedal input in a sufficient, timely, and sustained manner while attempting to arrest a turn during a hover-taxi, which resulted in a loss of directional control. Contributing to the severity of the occupants’ injuries…Dec 28, 2022 · N835GC · Substantial damageNTSB ERA23LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Ethel, WVThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.Dec 28, 2022 · N8217M · Substantial damageNTSB WPR23LA076Accident · No injuriesClass 3 · LimitedFinal reportCessna 210N · Morgan, UTFailure of the brake system O-rings on the left landing gear trunnion, which allowed the hydraulic fluid to drain from the left brake system, resulting in a runway excursion and impact with a fence.Dec 26, 2022 · N210CU · Substantial damageNTSB WPR23LA075Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Payson, AZThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.Dec 26, 2022 · N749PJ · Substantial damageNTSB ERA23LA095Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ECA · Hampton, NHThe pilot’s failure to maintain directional control of the airplane while landing in crosswind conditions, which resulted in a runway excursion.Dec 26, 2022 · N2895Z · Substantial damageNTSB CEN23LA070Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BF · Navasota, TXThe student pilot failed to maintain directional control during landing.Dec 26, 2022 · N26625 · Substantial damageNTSB CEN23LA069Accident · No injuriesClass 4 · LimitedFinal reportCessna 150J · South St. Paul, MNThe student pilot’s failure to maintain directional control during the take-off roll with a snow and ice covered runway.Dec 26, 2022 · N51115 · Substantial damageNTSB CEN23LA091Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Pocahantas, IAThe pilot’s landing flare which resulted in a bounced landing and the nose landing gear collapsing. Contributing to the accident was the airplane's encounter with adverse weather conditions which led to structural icing that affected flight characteristics…Dec 20, 2022 · N2930J · Substantial damageNTSB WPR23LA085Accident · Minor injuriesClass 4 · LimitedFinal reportAuto-Gyro Cavalon · Benson, AZA loss of directional control on takeoff, which resulted in the collapse of the nose wheel strut and a runway excursion.Dec 19, 2022 · N518DT · Substantial damageNTSB WPR23LA071Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · San Manual, AZThe pilot’s failure to maintain directional control during landing which, resulted in a runway excursion.Dec 18, 2022 · N4144P · Substantial damageNTSB WPR23LA070Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV6 · Afton, WYThe pilot’s failure to maintain control during landing on a contaminated runway.Dec 18, 2022 · N78HJ · Substantial damageNTSB CEN23LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Denton, TXThe pilot’s failure to maintain clearance from another airplane while taxing in the run-up area.Dec 15, 2022 · N221MF · 2 aircraft · Substantial damageNTSB CEN23LA064Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206-L4 · Gulf of Mexico (Gulf of Mexico)The pilot’s improper takeoff technique that allowed the helicopter skid to drift into a helideck light, resulting in a dynamic rollover.Dec 15, 2022 · N414RL · Substantial damageNTSB ANC23LA009Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 77 · Lihue, HIThe airplane’s exceedance of its critical angle of attack after encountering a downdraft during departure, which resulted in an aerodynamic stall and impact with terrain.Dec 15, 2022 · N991AB · Substantial damageNTSB ERA23LA090Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · San Juan, PRThe pilot’s improper recovery from a bounced landing which resulted in a loss of control and subsequent runway excursion.Dec 14, 2022 · N416PC · Substantial damageNTSB WPR23LA065Accident · No injuriesClass 4 · LimitedFinal reportPiper PA42 · Lewistown, MTThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the out of service visual glideslope indicator and snow obscuring the runway markings.Dec 13, 2022 · C-GZPU · Substantial damageNTSB ERA23LA085Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Knoxville, TNThe pilot’s loss of directional control during engine start.Dec 12, 2022 · N783SF · Substantial damageNTSB ERA23LA084Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Gilgo-Oak Beach-Captree, NYThe flight instructor’s inadequate remedial action while supervising the student pilot’s practice autorotation in gusting wind conditions, which resulted in a dynamic rollover.Dec 11, 2022 · N14HT · Substantial damageNTSB WPR23LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Socorro, NMThe pilot’s improper landing flare, which resulted in a hard bounced landing and loss of control in gusting wind.Dec 10, 2022 · N422B · Substantial damageNTSB WPR23LA064Accident · No injuriesClass 4 · LimitedFinal reportArado-Flugzeugwerke FW190 A-5 · Casa Grande, AZThe pilot’s failure to maintain directional control during the landing roll.Dec 9, 2022 · N190DK · Substantial damageNTSB WPR23LA061Accident · Minor injuriesClass 4 · LimitedFinal reportEurocopter EC 130 B4 · Waimea, HIThe pilot's loss of helicopter control on approach to land due to entering a vortex ring state condition, which resulted in a hard landing.Dec 8, 2022 · N130WS · Substantial damageNTSB ANC23LA017Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Wasilla, AKThe pilot's selection of an unsuitable landing site, which resulted in a nose over after the main landing gear wheels broke through deep snow on the snow-covered runway.Dec 8, 2022 · N3861P · Substantial damageNTSB WPR23LA059Accident · No injuriesClass 4 · LimitedFinal reportBell 206-L4 · Ft Worth, TXThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident, was the flight instructor’s inadequate supervision.Dec 7, 2022 · N2036F · Substantial damageNTSB ERA23LA080Accident · Minor injuriesClass 4 · LimitedFinal reportJames R Dernovsek Kitfox · Woodsfield, OHThe pilot's failure to maintain directional control during the landing roll.Dec 5, 2022 · N257ED · Substantial damageNTSB CEN23LA061Accident · Minor injuriesClass 3 · LimitedFinal reportOrlican S R O M-8 Eagle · St. Louis, MOThe pilot’s failure to maintain adequate airspeed/angle-of-attack during the landing approach, which resulted in an aerodynamic stall and hard landing.Dec 5, 2022 · N602TG · Substantial damageNTSB CEN23FA057Accident · 2 fatalClass 3 · FieldFinal reportCessna 210-5(205) · Cleburne, TXAn in-flight loss of control as a result of spatial disorientation in night instrument meteorological conditions.Dec 5, 2022 · N8149Z · DestroyedNTSB WPR23LA054Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Fergus Falls, MNThe pilot’s failure to maintain directional control during the takeoff roll, resulting in a runway excursion.Dec 4, 2022 · N926HM · Substantial damageNTSB ERA23FA078Accident · 1 fatalClass 3 · FieldFinal reportRotorsport UK Cavalon · Beverly, MAThe pilot’s improper yaw control during the takeoff initial climb, which resulted in an excessive sideslip and a subsequent loss of aircraft control.Dec 4, 2022 · N401GR · Substantial damageNTSB WPR23LA053Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-180 · Morgan, UTThe pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low attitude. Contributing to the accident was the pilot’s loss of visual reference due to snow and flat light conditions.Dec 3, 2022 · N60WY · Substantial damageNTSB CEN23LA058Accident · Minor injuriesClass 4 · LimitedFinal reportStinson 108-3 · Regent, NDThe pilot failed to maintain clearance from high tension wires while maneuvering at low altitude.Dec 3, 2022 · N7659X · Substantial damageNTSB ANC23LA016Accident · No injuriesClass 4 · LimitedFinal reportChampion 7GCBC · Anchorage, AKThe pilot's loss of directional control during takeoff.Dec 3, 2022 · N8365V · Substantial damageNTSB ERA23LA081Accident · No injuriesClass 4 · LimitedFinal reportLearjet 35 · Guantanamo Bay, CubaThe flight crew’s continuation of an unstable approach which resulted in abnormal runway contact during the landing flare and touchdown.Dec 2, 2022 · N979RF · Substantial damageNTSB ERA23FA077Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · Falmouth, MAThe pilot’s failure to maintain clearance from trees during the landing approach. Contributing to the accident was the sun glare, which impaired the pilot's visibility and situational awareness.Dec 2, 2022 · N3515H · Substantial damageNTSB CEN23LA056Accident · Minor injuriesClass 3 · LimitedFinal reportLearjet 45 · Batesville, ARThe crew’s failure to execute a go-around during the unstable approach and long landing, which resulted in a runway excursion.Nov 30, 2022 · N988MC · Substantial damageNTSB WPR23LA052Accident · No injuriesClass 4 · LimitedFinal reportRutan Long-EZ · Mountain Green, UTThe pilot’s flight into a valley with rising terrain that the airplane was incapable of out-climbing.Nov 27, 2022 · N379W · Substantial damageNTSB ERA23LA076Accident · Minor injuriesClass 4 · LimitedFinal reportPhantom Aeronautics X1 · Trinity, NCThe pilot's failure to maintain control of the airplane during initial climb in gusting wind conditions, which resulted in a collision with power lines and trees.Nov 27, 2022 · N5205A · Substantial damageNTSB ERA23LA071Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20J · Gaithersburg, MDThe pilot’s visual flight below published altitude minimums, which resulted in collision with a powerline tower structure.Nov 27, 2022 · N201RF · Substantial damageNTSB ANC23LA014Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Anchorage, AKThe pilot’s failure to maintain directional control of the airplane during landing.Nov 27, 2022 · N5626U · Substantial damageNTSB CEN23FA046Accident · 1 fatalClass 3 · FieldFinal reportExtra EA300 · Wonder Lake, ILThe pilot’s failure to maintain a proper descent path to the runway after he became disorientated by sun glare while on final approach, which resulted in a collision with trees and terrain.Nov 25, 2022 · N361LX · Substantial damageNTSB CEN23LA048Accident · No injuriesClass 4 · LimitedFinal reportHughes 369HS · Oxford, COThe designated pilot examiner’s failure to maintain a proper descent during a practice 180° autorotation which resulted in a hard landing.Nov 23, 2022 · N668M · Substantial damageNTSB ERA23LA074Accident · No injuriesClass 4 · LimitedFinal reportTextron 172 · Newnan, GAThe flight instructor’s inadequate remedial action during a simulated engine failure and low approach, which resulted in a collision with a runway light.Nov 22, 2022 · N407MD · Substantial damageNTSB CEN23LA052Accident · No injuriesClass 4 · LimitedFinal reportBeech 200 · Del Rio, TXThe pilot’s failure to maintain control of the airplane that resulted in an uncontrolled descent and overstress of the airframe during his recovery of the airplane.Nov 22, 2022 · N968T · Substantial damageNTSB CEN23LA047Accident · Minor injuriesClass 4 · LimitedFinal reportSeace David A Gyroplane · Iredell, TXThe pilot's failure to maintain clearance from a power line during low-level maneuvering.Nov 22, 2022 · N44088 · Substantial damageNTSB CEN23LA041Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Saint Joseph, MOThe pilot lost control of the airplane while on the ground due to temporary incapacitation.Nov 20, 2022 · N267PC · Substantial damageNTSB ERA23FA067Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-30 · Winston-Salem, NCContamination and/or misalignment of the regulator section of the right engine’s fuel servo, which resulted in excessive idle fuel flow and a total loss of engine power. Also causal was the pilot's failure to land immediately on the nearest runway at the…Nov 19, 2022 · N7295Y · Substantial damageNTSB CEN23LA053Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Searcy, ARThe pilot’s failure to maintain clearance from the electrical box while repositioning.Nov 19, 2022 · N184SF · Substantial damageNTSB WPR23FA034Accident · 4 fatalClass 2 · FieldFinal reportTextron 208B · Snohomish, WAThe pilot’s improper recovery following a departure from controlled flight after an intentional aerodynamic stall, which resulted in an exceedance of airspeed limitations, airframe overstress, and a subsequent inflight breakup.Nov 18, 2022 · N2069B · Substantial damageNTSB WPR23LA042Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 180 · Kahlotus, WAThe pilot’s failure to check the fuel selector position before takeoff and his improper fuel management, which resulted in fuel starvation and a total loss of engine power. Also causal was the pilot’s loss of airplane control which resulted in an aerodynamic…Nov 15, 2022 · N24227 · Substantial damage