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.

NTSB CEN22LA122Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206 · Eldorado, ILOverheating of two lithium batteries in the paramedic’s flight suit pocket resulting in an explosion and fire that seriously injured the paramedic as the helicopter was about to take off.Feb 12, 2022 · N469AE · Minor damageNTSB CEN22LA120Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Murphysboro, ILThe pilot’s failure to maintain clearance from power lines during approach for landing.Feb 12, 2022 · N737SY · Substantial damageNTSB CEN22LA118Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20J · Katy, TXThe pilot’s failure to maintain a proper glidepath while on the final approach segment of the traffic pattern in dark night conditions.Feb 12, 2022 · N201VZ · Substantial damageNTSB WPR22LA096Accident · No injuriesClass 4 · LimitedFinal reportBell 47 · Fallon, NVThe pilot's failure to maintain control of the helicopter during a hover which, resulted in a collision with a hangar.Feb 11, 2022 · N1023V · Substantial damageNTSB ERA22LA119Accident · No injuriesClass 4 · LimitedFinal reportGreat Lakes 2T-1A-2 · Naples, FLThe biplane pilot’s inadequate visual lookout, which resulted in an on-ground collision with another airplane while taxiing.Feb 11, 2022 · N87G · 2 aircraft · Minor damageNTSB CEN22LA117Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22T · Lincoln, NEThe pilot’s decision to continue the flight with abnormal engine indications and the subsequent failure of the No. 5 cylinder connecting rod for unknown reasons.Feb 11, 2022 · N317KJ · Substantial damageNTSB WPR22LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Carrizozo, NMThe pilot's failure to maintain directional control during the landing roll.Feb 10, 2022 · N4750B · Substantial damageNTSB WPR22FA094Accident · Minor injuriesClass 3 · FieldFinal reportDassault Mirage F1 CR · Glendale, AZA loss of engine power due to fuel exhaustion as result of the failure of maintenance personnel to ensure the airplane was serviced with the correct amount of fuel, the failure of maintenance personnel and the pilot to adequately check the airplane’s…Feb 10, 2022 · N633AX · DestroyedNTSB ERA22LA127Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210N · Honesdale, PAThe pilot’s failure to attain the proper touchdown point, which resulted in a runway overrun and collision with terrain.Feb 10, 2022 · N5276C · Substantial damageNTSB WPR22LA097Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20J · Paradise, CAThe pilot’s failure to maintain a proper glidepath which resulted in a collision with terrain.Feb 9, 2022 · N201VJ · Substantial damageNTSB ERA22LA125Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Pinehurst, NCThe in-flight encounter while on final approach with high-speed trailing vortices from a military helicopter, resulting in abnormal runway contact. Contributing to the accident was the Cirrus pilot’s incorrect selection of the common traffic advisory…Feb 9, 2022 · N987AA · Substantial damageNTSB ERA22LA118Accident · No injuriesClass 4 · LimitedFinal reportHiller UH-12E4 · Shrewsbury, PAThe pilot’s failure to maintain control during the descent which resulted in a hard landing.Feb 9, 2022 · N64741 · Substantial damageNTSB CEN22LA125Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Burleson, TXThe student pilot accidentally pulling the mixture control in the landing pattern which resulted in a loss of engine power and forced landing.Feb 9, 2022 · N11373 · Substantial damageNTSB WPR22LA099Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Napa, CAThe loss of engine power for undetermined reasons, which resulted in an off-airport landing on unimproved terrain.Feb 8, 2022 · N9500E · Substantial damageNTSB WPR22LA093Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Chemehuevi Valley, CAThe student pilot’s loss of directional control during takeoff.Feb 8, 2022 · N6496L · Substantial damageNTSB CEN22LA116Accident · Serious injuriesClass 4 · LimitedFinal reportBeech C35 · Shell Knob, MOThe pilot’s failure to maintain airplane control that resulted in an aerodynamic stall during approach and impact with terrain.Feb 8, 2022 · N1908D · DestroyedNTSB WPR22LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna T207 · Crane Island, WAThe pilot’s failure to obtain a proper touch down location on a wet grass runway, resulting in a runway overrun and impact with terrain.Feb 7, 2022 · N684S · Substantial damageNTSB ERA22LA116Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 · Gilbert, SCThe pilot’s improper flap setting, which resulted in a collision with trees during a takeoff attempt from a short grass field.Feb 5, 2022 · N1454Z · Substantial damageNTSB ANC22LA017Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Kasilof, AKThe pilot’s decision to land on an unmaintained runway surface, which resulted in a loss of control and nose over.Feb 5, 2022 · N23RB · Substantial damageNTSB ENG22FA009Incident · No injuriesClass 3 · FieldFinal reportBoeing 737-8K2 · Las Vegas, NVThe fatigue failure of the right main landing gear initiated by liquid metal embrittlement by cadmium at arc burn locations in the outer cylinder tooling hole area. The arc burns were likely the result of operator error during stylus cadmium plating…Feb 4, 2022 · N817SY · Minor damageNTSB ERA22LA115Accident · No injuriesClass 3 · LimitedFinal reportPilatus PC-12/47E · Ronkonkoma, NYThe pilot’s failure to properly position the power control lever before starting the engine as required per the checklist. Contributing to the accident were the ice on the ramp and the pilot’s failure to secure the engine using the condition lever.Feb 2, 2022 · N357JK · Substantial damageNTSB WPR22LA091Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Gila Bend, AZThe pilot's failure to maintain directional control during the landing rollFeb 1, 2022 · N185DG · Substantial damageNTSB ERA22FA114Accident · 1 fatalClass 3 · FieldFinal reportCessna 310 · Danville, VAThe pilot’s impairment due to exposure to carbon monoxide as a result of undetected engine exhaust penetration into the cockpit, resulting in the pilot's failure to maintain a minimum controllable airspeed after partially securing an engine after takeoff.Feb 1, 2022 · N622QT · DestroyedNTSB CEN22FA113Accident · 1 fatalClass 3 · FieldFinal reportCessna 182T · Heath, OHThe pilot’s failure to maintain altitude after takeoff, which resulted in collision with trees and terrain.Feb 1, 2022 · N716MC · DestroyedNTSB ERA22LA112Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 195 · Palm Coast, FLThe pilot’s inadequate fuel planning and preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.Jan 31, 2022 · N597K · Substantial damageNTSB CEN22FA109Accident · 1 fatalClass 3 · FieldFinal reportChristavia MK1 · Oral, SDThe noncertificated pilot’s failure to maintain control of the airplane, which led to the airplane exceeding its critical angle-of-attack and subsequent aerodynamic stall. Contributing to the accident was the pilot’s decision to attempt a flight with no…Jan 31, 2022 · N3177F · Substantial damageNTSB ERA22LA113Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Waynesboro, VAThe student pilot’s loss of directional control while landing.Jan 30, 2022 · N1766V · Substantial damageNTSB ERA22LA111Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Louisville, KYThe pilot’s failure to maintain directional control during landing in cross wind conditions.Jan 30, 2022 · N20312 · Substantial damageNTSB CEN22LA114Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Cook, MNThe pilot’s failure to ensure the snow-covered takeoff area was safe, which resulted in a collision with ice and subsequent landing gear damage.Jan 29, 2022 · N2923E · Substantial damageNTSB CEN22LA112Accident · No injuriesClass 4 · LimitedFinal reportVans RV4 · Hortonville, WIThe loss of direction control while maneuvering off the plowed surface to avoid a collision with a vehicle.Jan 29, 2022 · N544WM · Substantial damageNTSB WPR22LA090Accident · Minor injuriesClass 3 · LimitedFinal reportTextron TTX Inc. T240 · Ravendale, CAThe inadequate maintenance and inspection of the engine induction system, which resulted in the separation of the right induction tube from the turbocharger compressor outlet and the subsequent loss of engine power during departure.Jan 28, 2022 · N420WT · Substantial damageNTSB ANC22LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Skwenta, AKThe pilot’s failure to maintain adequate clearance from a tree while landing.Jan 28, 2022 · N189BH · Substantial damageNTSB WPR22LA085Accident · No injuriesClass 4 · LimitedFinal reportUniversal Stinson 108-2 · Byron, CAThe pilot’s inadequate flare and loss of directional control during landing which resulted in a runway excursion. Contributing to the accident was the instructor’s delayed remedial action.Jan 27, 2022 · N9433K · Substantial damageNTSB WPR22LA083Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F33A · Williams, AZThe pilot’s activation of the auxiliary fuel boost pump shortly after takeoff, which resulted in an excess amount of fuel to the engine and a total loss of engine power.Jan 26, 2022 · N1HH · Substantial damageNTSB CEN22LA110Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Fort Carson, COThe windshear encounter on short final approach, which resulted in an excessive decent rate and ground impact.Jan 25, 2022 · N974DA · Substantial damageNTSB DCA22LA069Accident · No injuriesClass 4 · LimitedFinal reportAirbus A320-232 · Hayden, COThe captain’s rotation of the airplane pitch before the rotation speed on takeoff due to his surprise about encountering head on landing traffic, which resulted in an exceedance of the airplane’s pitch limit and a subsequent tail strike. Contributing to the…Jan 22, 2022 · N760JB · Substantial damageNTSB WPR22LA082Accident · No injuriesClass 4 · LimitedFinal reportWight Albert A Kitfox Speedster · Shelton, WAThe pilot’s failure to maintain directional control during the landing roll.Jan 21, 2022 · N139KF · Substantial damageNTSB CEN22LA107Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Angola, INThe pilot’s failure to ensure adequate terrain clearance during an approach. Contributing to the accident was the flight instructor’s delayed remedial action when the airplane descended too low after transitioning to a visual descent to the runway.Jan 21, 2022 · N42VR · Substantial damageNTSB ERA22LA437Accident · No injuriesClass 4 · LimitedFinal reportWhiting Cleon Glasair SH-2 · Palmetto, FLThe pilot’s loss of directional control during takeoff roll.Jan 20, 2022 · N5125X · Substantial damageNTSB WPR22LA081Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28 · Scottsdale, AZA loss of engine power due to oil exhaustion.Jan 18, 2022 · N5276W · Substantial damageNTSB CEN22LA104Accident · No injuriesClass 4 · LimitedFinal reportBeech V35B · McKinney, TXThe pilot’s failure to maintain control during the landing with gusty wind.Jan 18, 2022 · N3735B · Substantial damageNTSB CEN22LA103Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 120 · Sturtevant, WIThe pilot’s loss of directional control during the takeoff for reasons that could not be determined based on the available evidence, which resulted in a runway excursion.Jan 18, 2022 · N90129 · Substantial damageNTSB CEN22LA101Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6C · San Antonio, TXThe pilot’s loss of directional control during landing.Jan 16, 2022 · N16JG · Substantial damageNTSB ANC22LA013Accident · Minor injuriesClass 4 · LimitedFinal reportLeach Michael Rans S7S · Winnemucca, NVThe pilot’s failure to ensure the airplane’s wings were free of contaminates before departure.Jan 16, 2022 · N828S · Substantial damageNTSB CEN22LA108Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Lamesa, TXThe pilot’s failure to maintain clearance from terrain during a descent that resulted in an impact with terrain.Jan 15, 2022 · N6916D · Substantial damageNTSB ANC22LA012Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Hana, HIThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall and subsequent impact with terrain.Jan 15, 2022 · N992SA · Substantial damageNTSB WPR22LA080Accident · Serious injuriesClass 3 · LimitedFinal reportWalter Tachiki Tachiki 750 Cruzer · Spanish Fork, UTA partial loss of engine power due to an obstructed catalytic converter, which most likely resulted from the pilot’s failure to properly repair or replace it after it was likely damaged during a previous incident. Contributing to the accident was the pilot’s…Jan 14, 2022 · N145WT · Substantial damageNTSB CEN22LA105Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Carrizo Springs, TXThe pilot’s failure to maintain directional control of the airplane during landing with a gusting crosswind that resulted in a runway excursion.Jan 14, 2022 · N646CA · Substantial damageNTSB CEN22FA100Accident · 2 fatalClass 3 · FieldFinal reportBell 407 · Houma, LAThe pilot’s sudden loss of consciousness for undetermined reasons during cruise flight, which resulted in a loss of control and impact with terrain.Jan 14, 2022 · N167RL · DestroyedNTSB WPR22LA079Accident · No injuriesClass 4 · LimitedFinal report2021fx3 CCX-2000 · Redmond, ORThe pilot's failure to maintain directional control during the landing roll.Jan 13, 2022 · N917HB · Substantial damage