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 WPR22LA168Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Folsom, NMThe pilot’s failure to maintain airspeed and rotor rpm which resulted in a hard landing.Apr 28, 2022 · N41339 · Substantial damageNTSB ERA22LA211Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 152 · Wadsworth, OHThe pilot’s failure to maintain directional control while attempting to land in a crosswind.Apr 28, 2022 · N46733 · Substantial damageNTSB CEN22LA185Accident · 1 fatalClass 3 · LimitedFinal reportSuperior Culver LFA · Syracuse, KSThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an inadvertent aerodynamic stall while returning to the airport following a partial loss of engine power for reasons that could not be determined.Apr 28, 2022 · N37888 · DestroyedNTSB CEN22LA184Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · Terre Haute, INA hard landing, which resulted in the failure of the right main landing gear outer bearing and collapse of the landing gear.Apr 27, 2022 · N73T · Substantial damageNTSB ERA22LA209Accident · Minor injuriesClass 4 · LimitedFinal reportGarlick Helicopters OH-58A+ · Oakland, FLThe pilot’s decision to continue the low-altitude aerial application flight over water conditions that degraded his depth perception, which resulted in an inadvertent collision with the water.Apr 26, 2022 · N281SP · Substantial damageNTSB ERA22LA206Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206 · Lake Apopka, FLA collision with water following a loss of visual reference to the water surface due to sun glare.Apr 26, 2022 · N206BX · Substantial damageNTSB ERA22FA207Accident · 2 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 429 · Elba, NYThe pilots’ inappropriate flight control inputs while in vortex ring state, which resulted in main rotor blade contact with the tail boom and a subsequent in-flight breakup. Also causal was the flight instructor’s inadequate monitoring of the flight.Apr 26, 2022 · N507TJ · Substantial damageNTSB WPR22LA167Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Redding, CAThe student pilot's improper landing flare and remedial action which resulted in a bounced landing.Apr 25, 2022 · N9572W · Substantial damageNTSB WPR22LA165AccidentClass 4 · LimitedFinal reportCessna 182G · Eloy, AZThe unoccupied airplanes exceedance of the critical angle of attack which resulted in a stall, subsequent inverted spin, and impact with terrain.Apr 25, 2022 · N3694U · Substantial damageNTSB ERA22LA208Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24 · Honesdale, PAThe pilot’s failure to maintain clearance with the edge of the asphalt, which resulted in a runway excursion. Contributing to the accident was the pilot’s distraction due to a goose.Apr 25, 2022 · N6121P · Substantial damageNTSB ERA22LA205Accident · No injuriesClass 4 · LimitedFinal reportMaule MX7 · Tampa, FLThe pilot’s failure to maintain directional control during the landing roll.Apr 25, 2022 · N4278B · Substantial damageNTSB ERA22LA204Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172A · Stockbridge, GAThe flight instructor’s delayed remedial action during an unstabilized approach, which resulted in an impact with powerlines and a subsequent loss of controlApr 25, 2022 · N7572T · Substantial damageNTSB ERA22LA202Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Fountain Inn, SCThe pilot’s failure to obtain the proper touchdown point during landing, which resulted in a runway overrun and collision with a fence.Apr 25, 2022 · N9583C · Substantial damageNTSB WPR22LA166Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 170B · Ravensdale, WAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.Apr 24, 2022 · N4398B · Substantial damageNTSB WPR22FA164Accident · 4 fatalClass 3 · FieldFinal reportDiamond Aircraft Ind DA 40 · Cedar City, UTThe pilot’s failure to maintain obstacle clearance, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s decision to operate the airplane above its maximum gross weight.Apr 24, 2022 · N321PF · DestroyedNTSB ERA22LA200Accident · Serious injuriesClass 4 · LimitedFinal reportTitan T51 · Perry, FLThe pilot’s inadequate preflight inspection of the fuel quantity, which resulted in fuel exhaustion, a subsequent total loss of engine power, and an off-airport landing.Apr 24, 2022 · N151CM · Substantial damageNTSB ERA22LA201Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Union, SCThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with terrain.Apr 23, 2022 · N737UY · Substantial damageNTSB ERA22LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Westminster, MDThe student pilot’s failure to attain the proper touchdown point which resulted in a runway overrun.Apr 22, 2022 · N35571 · Substantial damageNTSB WPR22LA163Accident · No injuriesClass 3 · LimitedFinal reportTextron T206H · Santa Barbara, CAThe loss of directional control for undetermined reasons. Contributing was the overstress fracture of the nose gear upper trunnion brace attach point.Apr 21, 2022 · N20617 · Substantial damageNTSB ERA22FA199Accident · 2 fatalClass 3 · FieldFinal reportCessna 340 · Covington, GAThe private pilot’s loss of control in flight, which resulted in a collision with terrain. Contributing to the accident was the student pilot’s decision to obtain flight instruction from the private pilot and the private pilot's insufficient qualifications to…Apr 21, 2022 · N84GR · DestroyedNTSB CEN22LA183Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Wharton, TXThe pilot’s failure to extend the landing gear.Apr 21, 2022 · N66NP · Substantial damageNTSB CEN22LA182Accident · No injuriesClass 4 · LimitedFinal reportPiper-Harris J3C-65 · Hartford, WIThe flight instructor lost control of the airplane while taxiing in gusty wind conditions.Apr 21, 2022 · N9721Y · Substantial damageNTSB WPR22LA161Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172I · Blanding, UTThe pilot’s improper landing flare which, resulted in a bounced landing and loss of airplane control during an aborted landing in gusty wind conditions.Apr 20, 2022 · N46055 · Substantial damageNTSB WPR22FA160Accident · 1 fatalClass 3 · FieldFinal reportCessna 337 · Sylmar, CAThe pilot’s loss of airplane control while troubleshooting a landing gear issue, which resulted in an aerodynamic stall/spin at an altitude too low to recover. Contributing to the accident was the pilot’s impairment from alcohol consumption.Apr 20, 2022 · N143JB · Substantial damageNTSB WPR22LA159Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 42 · Long Beach, CAThe failure of the right main landing gear brace rib for reasons that could not be determined based on available information.Apr 19, 2022 · N822SA · Substantial damageNTSB CEN22LA179Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Englewood, COThe flight instructor’s inadequate supervision of the student pilot and the student pilot’s loss of directional control during landing, which resulted in a runway excursion.Apr 19, 2022 · N711DA · Substantial damageNTSB ERA22LA194Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140B · Panama City, FLA total loss of engine power due to fuel contamination. Contributing to the accident was the inadequate maintenance and inspection of the airplane and engine by maintenance personnel, and the pilot’s inadequate preflight inspection and runup.Apr 18, 2022 · N8891N · Substantial damageNTSB ERA22LA192Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206B · Cedar Key, FLThe pilot’s improper fuel planning during agricultural spraying operations, which resulted in fuel starvation, a loss of engine power, and a hard landing following an autorotation.Apr 18, 2022 · N919AC · Substantial damageNTSB WPR22LA156Accident · Serious injuriesClass 4 · LimitedFinal reportSawby Scott RV-6A · Richland, WAThe pilot’s failure to maintain directional control during the takeoff ground roll.Apr 17, 2022 · N341SS · Substantial damageNTSB WPR22LA155Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Boise, IDThe pilot receiving instructions failure to maintain directional control during landing. Contributing to the accident was the flight instructor’s delayed remedial action.Apr 17, 2022 · N2929D · Substantial damageNTSB ERA22LA190Accident · No injuriesClass 4 · LimitedFinal reportTextron 525B · Caldwell, NJThe flight crew’s failure to attain a proper touchdown point during landing, which resulted in an overrun of the runway and collision with terrain.Apr 17, 2022 · N225SC · Substantial damageNTSB WPR22LA175Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Phoenix, AZThe pilot's improper landing flare and the flight instructor’s delayed remedial action.Apr 16, 2022 · N2837X · Substantial damageNTSB WPR22LA157Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Salt Lake City, UTThe student pilot’s failure to maintain lateral control and terrain clearance while hovering, and the flight instructor’s delayed remedial action which resulted in a dynamic rollover.Apr 16, 2022 · N3297Q · Substantial damageNTSB WPR22LA153Accident · No injuriesClass 4 · LimitedFinal reportStoddard Hamilton Glasair Super II · Oxnard, CAThe pilot’s failure to maintain airplane control while on final approach, which resulted in a collision with a runway approach light.Apr 16, 2022 · N90YY · Substantial damageNTSB ERA22LA196Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Zebulon, NCThe flight instructor’s failure to maintain directional control with a quartering tailwind.Apr 16, 2022 · N7784S · Substantial damageNTSB ERA22LA197Accident · No injuriesClass 4 · LimitedFinal reportCessna 182R · Tuskegee, ALThe pilot’s inadequate compensation for the gusty crosswind wind conditions which resulted in a hard landing and subsequent nose gear collapse.Apr 15, 2022 · N9388X · Substantial damageNTSB ANC22FA030Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R22 Beta · Gila Bend, AZThe student pilot’s failure to maintain control during the landing approach.Apr 15, 2022 · N7516G · Substantial damageNTSB CEN22LA180Accident · Serious injuriesClass 4 · LimitedFinal reportGlobe GC-1B · Huntsville, TXThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.Apr 14, 2022 · N78096 · Substantial damageNTSB WPR22LA158Accident · No injuriesClass 3 · LimitedFinal reportEuropa XS Mono · Eastsound, WAThe pilot inadvertently shut off the engine control unit, which resulted in the engine turning off before the runway landing was attained.Apr 13, 2022 · N194XS · Substantial damageNTSB ERA22LA198Accident · No injuriesClass 3 · LimitedFinal reportCessna 310 · Selma, ALThe failure of maintenance personnel to properly rig the rudder trim system after reinstallation and pilot’s inadequate preflight inspection after recent maintenance, which resulted in an inability to adequately maintain directional control during the flight.Apr 13, 2022 · N7733Q · Substantial damageNTSB CEN22LA176Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Twin Lakes, COThe failure of the left turbocharger at FL230, which resulted in a rapid loss of manifold pressure and subsequent complete loss of engine power due to an overly rich fuel-air mixture setting. Contributing was the smoke in the cabin in IMC, which caused the…Apr 13, 2022 · N112TR · Substantial damageNTSB ERA22LA188Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Calhoun, GAThe pilot’s failure to maintain clearance from wires during takeoff.Apr 12, 2022 · N426DB · Substantial damageNTSB ANC22LA029Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Beluga, AKThe pilot’s excessive touchdown speed, which resulted in a long landing and impact with terrain.Apr 12, 2022 · N135ES · Substantial damageNTSB WPR22LA152Accident · Serious injuriesClass 3 · LimitedFinal reportAdams Balloons A55S · Safford, AZThe pilot’s decision to continue the balloon’s fast approach to an unsuitable confined landing site, which resulted in a collision with powerline wires.Apr 10, 2022 · N866RA · Substantial damageNTSB ERA22LA187Accident · No injuriesClass 3 · LimitedFinal reportLancair IV · Leicester, MAA separation of the window from the airframe for undetermined reasons.Apr 10, 2022 · N7KJ · Substantial damageNTSB ERA22LA184Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Bald Head Island, NCThe pilot’s failure to maintain control during landing on a soft surface.Apr 10, 2022 · N4693S · Substantial damageNTSB ANC22LA028Accident · No injuriesClass 3 · LimitedFinal reportCessna 172H · Chugiak, AKThe pilot’s failure to maintain directional control while landing, which resulted in a runway excursion and nose over.Apr 10, 2022 · N8020L · Substantial damageNTSB WPR22FA148Accident · 1 fatalClass 3 · FieldFinal reportTaylorcraft BL-65 · Counselor, NMA loss of control while maneuvering at a high-density altitude in gusty wind conditions.Apr 9, 2022 · N24345 · Substantial damageNTSB CEN22LA175Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Hebbronville, TXThe pilots improper landing flare which resulted in a hard landing and loss of airplane control.Apr 9, 2022 · N978C · Substantial damageNTSB WPR22LA150Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASK 21 · Valyermo, CAThe gliders encounter with atmospheric conditions where the lift was not sufficient to maintain flight and subsequent impact with mountainous terrain.Apr 8, 2022 · N212NM · Substantial damage