NTSB investigations

19,222 cases where NTSB found Aircraft.

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\", '01'))
  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 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 WPR23LA060Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 177 · Willow Spring, AZThe airplane’s loss of engine power for undetermined reasons.Nov 27, 2022 · N2994X · 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 ERA23LA073Accident · No injuriesClass 3 · LimitedFinal reportChilds Michael A Rotorway Exec 162-F · Titusville, FLA failure of the No. 4 exhaust valve spring retainer, which resulted in a partial loss of engine power.Nov 27, 2022 · N8006A · 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 CEN23FA045Accident · No injuriesClass 3 · FieldFinal reportCirrus Design SF50 · Mount Comfort, INThe uncommanded activation of the CAPS autopilot mode due to corrosion of the system’s electrical components. Contributing to the accident was the pilot’s failure to identify the CAPS autopilot mode and promptly follow the procedures in the airplane flight…Nov 25, 2022 · N15VJ · Substantial damageNTSB WPR23FA044Accident · 1 fatalClass 3 · FieldFinal reportGallagher XLT-RG · Banning, CAAn inflight engine fire for reasons that could not be determined that resulted in impact with terrain.Nov 23, 2022 · N101BH · DestroyedNTSB 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 ERA23FA070Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Charlotte, NCThe inadequate inspections of the forward left control rod end attachment hardware to the stationary swashplate by the pilot and by maintenance personnel, resulting in an eventual loosening and backing out of the hardware and subsequent loss of helicopter…Nov 22, 2022 · N7094J · 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 CEN23LA040Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150L · Cypress, TXFailure of the engine exhaust valve during cruise flight, which resulted in a loss of engine power and a forced landing.Nov 20, 2022 · N10612 · Substantial damageNTSB ANC23LA006Accident · No injuriesClass 3 · LimitedFinal reportCessna 207 · Bethel, AKThe total loss of engine power during cruise flight due to fuel starvation and the pilot’s mismanagement of the available fuel.Nov 20, 2022 · N23CF · 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 ERA23LA065Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Manassas, VAAn engine fire caused by chafing and subsequent electrical arcing of the alternator wire near a fuel source.Nov 18, 2022 · N8129M · Substantial damageNTSB CEN23FA038Accident · 1 fatalClass 3 · FieldFinal reportCessna 421C · Decatur, TXA loss of power on the left engine due to fuel starvation and the subsequent loss of power on the right engine for undetermined reasons.Nov 18, 2022 · N6797L · DestroyedNTSB 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 damageNTSB ERA23FA060Accident · 1 fatalClass 3 · FieldFinal reportDetrick Donald G Detrick DA-2 · Oak Hill, FLThe student pilot’s failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and collision with a tree.Nov 15, 2022 · N4307Q · Substantial damageNTSB CEN23LA037Accident · Minor injuriesClass 3 · LimitedFinal reportFairchild SA227-AT · Pewaukee, WIThe flight crew’s failure to maintain adequate airspeed and their exceedance of the airplane’s critical angle of attack during the instrument approach, which resulted in an aerodynamic stall. Contributing to the accident was an undetermined anomaly in the…Nov 15, 2022 · N247DH · Substantial damageNTSB ERA23LA066Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18-150 · St. Augustine, FLThe pilot’s failure to appropriately use carburetor heat, which resulted in a total loss of engine power due to carburetor icing.Nov 14, 2022 · N9858P · Substantial damageNTSB ERA23LA062Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Perry, GAThe pilot’s failure to maintain directional control during touchdown in a crosswind, which resulted in a runway excursion.Nov 14, 2022 · N81PW · Substantial damageNTSB ERA23LA058Accident · No injuriesClass 3 · LimitedFinal reportAntonov AN2 · Opa-Locka, FLThe pilot's failure to properly configure the cowl flaps and oil cooler shutters, which resulted in a total loss of engine power due to overheating of the engine. Contributing to the accident was the pilot's decision to operate the airplane in with an…Nov 14, 2022 · CU-A1885 · Substantial damageNTSB WPR23LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · San Jose, CAThe student pilots unstabilized approach and improper landing flare, which resulted in a hard bounced landing.Nov 13, 2022 · N5171B · Substantial damageNTSB ERA23LA110Accident · No injuriesClass 4 · LimitedFinal reportCessna 310J · Fulton, NYThe pilots failure to slow the airplane down prior to turning off the runway, which resulted in damage to the airplane’s fuselage structure in the vicinity of the nose landing gear.Nov 13, 2022 · N3048L · Substantial damageNTSB CEN23LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Manchester, MIA partial loss of engine power as a result of carburetor ice.Nov 13, 2022 · N222UM · Substantial damageNTSB WPR23LA043Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 · Kapolei, HIThe pilot receiving instruction’s rapid reduction in throttle during hover autorotation training which resulted in a loss of control and collision with the ground.Nov 11, 2022 · N948WB · Substantial damageNTSB WPR23LA031Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150G · Star Valley, AZThe failure of the No. 1 cylinder exhaust or intake valve which resulted in the partial loss of engine power and subsequent impact with terrain.Nov 11, 2022 · N3131J · Substantial damageNTSB CEN23LA033Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8E · Bridgeport, TXThe pilot’s loss of control due to a wind gust during landing.Nov 9, 2022 · N1855K · Substantial damageNTSB CEN23FA031Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Bignell, NEThe pilot’s flight into low instrument flight rules conditions and turbulence, which resulted in spatial disorientation, loss of control, and an impact with terrain. Contributing to the accident was the pilot’s lack of total instrument experience.Nov 9, 2022 · N234PM · DestroyedNTSB ERA23LA051Accident · No injuriesClass 4 · LimitedFinal reportPipistrel D O O Virus SW · Cross City, FLThe pilots’ inadequate preflight fuel planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent deployment of the ballistic parachute recovery system.Nov 7, 2022 · N91RR · Substantial damageNTSB CEN23LA028Accident · Serious injuriesClass 3 · LimitedFinal reportBeech E-90 · Slidell, LAThe pilot’s failure to maintain airplane control during an attempted go-around in low visibility conditions.Nov 7, 2022 · N809DM · DestroyedNTSB CEN23LA030Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Murdo, SDThe pilot’s failure to maintain directional control during takeoff with strong gusty surface winds.Nov 6, 2022 · N699XM · Substantial damageNTSB WPR23FA027Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR20 · San Diego, CAThe student pilot’s exceedance of the critical angle of attack during a go-around, resulting in an aerodynamic stall and impact with terrain following a non-stabilized approach to land.Nov 5, 2022 · N700YZ · Substantial damageNTSB ERA23LA050Accident · Minor injuriesClass 4 · LimitedFinal reportBeech B-60 · Farmingdale, NYThe pilot’s improper preflight inspection of the airplane’s fuel system, resulting in him commencing the flight with an inadequate fuel supply.Nov 5, 2022 · N51AL · Substantial damageNTSB CEN23LA027Accident · No injuriesClass 3 · LimitedFinal reportCessna R172E · Aguilar, COFailure of the engine cylinder assembly, which resulted in a loss of engine power during cruise flight and an impact with a fence during the forced landing.Nov 5, 2022 · N6051U · Substantial damageNTSB CEN23LA026Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Mesquite, TXThe student pilot’s failure to maintain directional control while taking off from a touch and go landing.Nov 5, 2022 · N787TF · Substantial damageNTSB ANC23FA003Accident · 2 fatalClass 3 · FieldFinal reportAirborne Windsports Edge XT-912L · Mokuleia, HIStructural failure of the wing for undetermined reasons, which resulted in a loss of control.Nov 5, 2022 · N444EZ · Substantial damageNTSB WPR23LA028Accident · No injuriesClass 3 · LimitedFinal reportEclipse Aerospace EA500 · Mesa, AZMaintenance personnel’s failure to properly align the right brake wheel speed transducer, which rendered the right wheel brake ineffective during landing, and the pilot’s subsequent failure to follow the correct procedures to restore braking action during the…Nov 4, 2022 · N150NE · Substantial damageNTSB ERA23LA063Accident · No injuriesClass 3 · LimitedFinal reportHagerty Glasair Super IIS-TD · Jasper, GAThe loss of engine power due to the failure of the engine-driven fuel pump and the pilot’s failure to use the electric fuel pump, which resulted in a forced, hard landing.Nov 4, 2022 · N430JV · Substantial damageNTSB ERA23LA059Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA-1A · Sparta, TNA total loss of engine power due to an accumulation of carburetor ice, resulting in an off-airport landing and substantial damage to the airplane.Nov 4, 2022 · N7254L · Substantial damageNTSB ERA23LA064Accident · No injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Athens, GAThe operator’s and the pilot’s continued operation of the airplane with a known electrical problem, resulting in a loss of electrical power and a gear-up landing.Nov 3, 2022 · N101DC · Substantial damageNTSB DCA23LA060Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A319 · New Orleans, LAThe captain’s pitch up input to avoid an overspeed condition, which resulted in a flight attendant falling and fracturing her ankle. Contributing was the airplane’s excessive airspeed during the transition to the automation-managed descent profile.Nov 3, 2022 · N519NK · No damageNTSB CEN23LA025Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Greenville, ILThe mechanic’s failure to inspect and clean the entire fuel nozzle assembly in accordance with the engine maintenance manual, which resulted in fuel starvation and a partial loss of engine power, an autorotation, and a hard landing.Nov 3, 2022 · N61KH · Substantial damage