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 WPR24LA258Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Camarillo, CAThe pilot’s loss of directional control during landing, which resulted in a nose over.Jul 25, 2024 · N5708N · Substantial damageNTSB WPR24LA253Accident · No injuriesClass 4 · LimitedFinal reportCanadian Car & Foundry Harvard MK IV · Oshkosh, WIThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Jul 25, 2024 · N52494 · Substantial damageNTSB ERA24LA324Accident · No injuriesClass 4 · LimitedFinal reportLake LA4 · Catskill, NYThe pilot’s failure to maintain control of the airplane during a takeoff from water in gusting wind conditions.Jul 25, 2024 · N1166L · Substantial damageNTSB ERA24FA323Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Trenton, METhe pilot’s aggressive pitch and power control inputs while executing a missed approach, which resulted in his spatial disorientation and a loss of airplane control.Jul 25, 2024 · N990PT · DestroyedNTSB WPR24LA262Accident · No injuriesClass 4 · LimitedFinal reportHiller UH-12E · Bonners Ferry, IDThe pilot’s improper selection of a landing site, which resulted in a main rotor strike. Contributing to the accident was the pilot’s improper performance planning and altitude selection over water, which resulted in an rpm droop.Jul 24, 2024 · N3375T · Substantial damageNTSB WPR24LA254Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-34-220T · Roy, UTThe flight instructor’s decision to shut down an engine on an extended leg of the airport traffic pattern, which led to a loss of performance and inability to maintain altitude.Jul 24, 2024 · N134MG · Substantial damageNTSB CEN24LA285Accident · Serious injuriesClass 4 · LimitedFinal reportCessna A188B · Sumner, NEThe pilot’s failure to maintain clearance from a power line during the spray pass.Jul 24, 2024 · N9576G · Substantial damageNTSB CEN24LA283Accident · No injuriesClass 4 · LimitedFinal reportEvektor-Aerotechnik A S Harmony LSA · Cahokia Heights, ILThe student pilot’s failure to maintain directional control during landing rollout that resulted in a lateral runway excursion and impact with a runway sign.Jul 24, 2024 · N468JA · Substantial damageNTSB WPR24LA260Accident · No injuriesClass 3 · LimitedFinal reportKitfox Series V · La Grande, ORSeparation of the propeller blades from progressive damage at the blade roots due to overtightening of the hub bolts.Jul 23, 2024 · N53562 · Substantial damageNTSB WPR24FA252Accident · 2 fatalClass 3 · FieldFinal reportTextron T206H · Kneeland, CAThe pilot’s delayed decision to perform a go-around after an unstabilized approach, which resulted in a loss of control, runway overrun, and impact with terrain.Jul 23, 2024 · N460DC · DestroyedNTSB ERA24LA325Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Cuba, NYA separation of the left main landing gear wheel assembly during landing.Jul 23, 2024 · N504CT · Substantial damageNTSB ERA24FA318Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Ronkonkoma, NYA loss of engine power during initial climb for undetermined reasons. Contributing to the outcome was the pilot's failure to maintain control of the airplane following the loss of engine power and his decision to perform an intersection takeoff which, reduced…Jul 22, 2024 · N1089W · Substantial damageNTSB CEN24FA278Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Oxford, INThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed while maneuvering during an agricultural flight, which resulted in an aerodynamic stall and a loss of control at too low of an altitude to recover.…Jul 22, 2024 · N602WR · Substantial damageNTSB CEN24FA277Accident · 2 fatalClass 3 · FieldFinal reportLancair ES · Oshkosh, WIThe pilot’s failure to maintain adequate airspeed which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall while maneuvering for traffic spacing.Jul 22, 2024 · N18BG · DestroyedNTSB ERA24LA312Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Rural Retreat, VAA loss of directional control during the landing roll.Jul 21, 2024 · N185GS · Substantial damageNTSB ERA24LA311Accident · Serious injuriesClass 3 · LimitedFinal reportChampion 7ECA · Beaufort, NCThe pilot’s inadequate fuel planning and preflight inspection, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing.Jul 21, 2024 · N9581S · Substantial damageNTSB ERA24FA310Accident · 1 fatalClass 3 · FieldFinal reportWilliams John Titan T-51 Mustang · Geneva, OHA sudden propeller overspeed and subsequent separation of the propeller blades and hub, while maneuvering at high speed and at low altitude, which resulted in a collision with a tree during the subsequent forced landing attempt.Jul 21, 2024 · N751TX · Substantial damageNTSB CEN24LA279Accident · Serious injuriesClass 4 · LimitedFinal reportEvolution Revolt · Rochelle, ILThe pilot’s failure to maintain terrain clearance during a low-level turn, that resulted in an impact with the ground.Jul 21, 2024 · N798EE · Substantial damageNTSB CEN24LA276Accident · No injuriesClass 4 · LimitedFinal reportBell 206 · Cornland, ILThe pilot was unable to see a wire due to the setting sun and the helicopter subsequently struck the wire.Jul 21, 2024 · N26UK · Substantial damageNTSB CEN24LA275Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206B · Cuba City, WIThe pilot’s failure to maintain clearance from a wire during an agricultural application pass.Jul 21, 2024 · N67110 · Substantial damageNTSB ERA24FA309Accident · 1 fatalClass 3 · FieldFinal reportCessna 208 · Youngstown, NYThe pilot’s loss of control in flight which resulted in the airplane impacting the ground at a high rate of speed and descent.Jul 20, 2024 · N1259K · DestroyedNTSB CEN24LA328Accident · No injuriesClass 3 · LimitedFinal reportHawker Beechcraft Hawker 900XP · Telluride, COThe flight crew’s failure to properly configure the airplane for takeoff in a high-density altitude environment, which resulted in a loss of control and a subsequent runway excursion. Contributing to the accident was the flight crew’s failure to use…Jul 20, 2024 · N526FC · Substantial damageNTSB CEN24LA282Accident · No injuriesClass 3 · LimitedFinal reportJust Highlander · Oshkosh, WIThe reported uncommanded retraction of the flaps while on short final for unknown reasons, which resulted in a hard landing.Jul 20, 2024 · N707KM · Substantial damageNTSB CEN24LA281Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver GT-400 · Mansfield, MOThe pilot’s failure to maintain control after takeoff, which resulted in an aerodynamic stall.Jul 20, 2024 · N919PS · Substantial damageNTSB ANC24LA068Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver U-6A · Pedro Bay, AKThe pilot’s failure to maintain directional control of the airplane during takeoff. Contributing to the accident was sun glare.Jul 20, 2024 · N65223 · Substantial damageNTSB ERA24LA352Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Danville, KYThe pilot’s failure to maintain control of the airplane while landing and his inadequate communication to the pilot-rated passenger of her role during the flight.Jul 19, 2024 · N9991E · Substantial damageNTSB ERA24LA316Accident · 1 fatalClass 3 · LimitedFinal reportSheaffer Leroy B Kitfox Model IV · Palmyra, PAThe pilot’s failure to maintain directional control of the tailwheel airplane during takeoff from a narrow runway with a crosswind, which resulted in a runway excursion and collision with terrain.Jul 19, 2024 · N788KF · Substantial damageNTSB ERA24FA308Accident · 3 fatalClass 3 · FieldFinal reportBeech B-60 · Vienna Center, OHThe pilot’s loss of airplane control during a single-engine go-around. Also contributing to the accident was fuel system contamination, which resulted in detonation and a total loss of left engine power.Jul 19, 2024 · N23553 · DestroyedNTSB CEN24LA280Accident · No injuriesClass 4 · LimitedFinal reportCessna 195A · Greenville, MIThe pilot’s loss of directional control during landing which led to a ground-loop.Jul 19, 2024 · N1524D · Substantial damageNTSB WPR24LA251Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Carlsbad, CAThe pilot’s failure to maintain lateral control of the helicopter while departing with a crosswind, which resulted in a dynamic rollover.Jul 18, 2024 · N886JB · Substantial damageNTSB WPR24LA250Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75N1/N2S-3 · Hollister, CAThe pilot’s loss of directional control on landing, which resulted in a nose over.Jul 18, 2024 · N54173 · Substantial damageNTSB CEN24LA272Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Oakland, NEThe pilot’s failure to maintain coordinated flight during aerial-application operations, which resulted in fuel migration between the interconnected wing fuel tanks, and his failure to adequately monitor fuel levels during the flight which resulted in a loss…Jul 17, 2024 · N622AW · Substantial damageNTSB CEN24LA271Accident · Serious injuriesClass 3 · LimitedFinal reportMcdonnell Douglas Helicopter 600N · Eagle Lake, TXThe operator’s improper installation of the fuel system, which resulted in fuel starvation, a loss of engine power, and impact with terrain.Jul 16, 2024 · N609RP · DestroyedNTSB CEN24LA269Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-36-375 · Avoca, NEA partial loss of engine power due to the loose left magneto which resulted in erratic engine timing.Jul 16, 2024 · N2386X · Substantial damageNTSB CEN24LA268Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Arcola, TXLoss of engine power due to fuel starvation as a result of the mechanic’s failure to properly secure the fuel system gascolator strainer bowl following an annual inspection.Jul 16, 2024 · N1941V · Substantial damageNTSB WPR24LA248Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Ritzville, WAMaintenance personnel’s improper installation of the No. 2 cylinder exhaust valve, which allowed the valve to drop into the cylinder and resulted in a total loss of engine power.Jul 15, 2024 · N714PW · Substantial damageNTSB CEN24LA274Accident · No injuriesClass 4 · LimitedFinal reportCessna A188 · David City, NEThe pilot’s failure to maintain directional control during takeoff.Jul 15, 2024 · N9807V · Substantial damageNTSB WPR24LA246Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Grady, NMThe pilot’s failure to maintain directional control during takeoff with a quartering tailwind.Jul 14, 2024 · N1000Y · Substantial damageNTSB ERA24LA317Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Montauk, NYThe pilot’s failure to maintain an appropriate glide path during the landing approach in terrain induced turbulence, resulting in a hard landing and subsequent runway excursion.Jul 14, 2024 · N8201R · Substantial damageNTSB CEN24LA265Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Le Roy, MIThe pilot’s failure to maintain control of the airplane while performing a go-around, which resulted in an inflight collision with trees.Jul 14, 2024 · N7827K · Substantial damageNTSB CEN24LA263Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Lockhart, TXThe pilot’s decision to continue the landing attempt with insufficient runway remaining, which resulted in a runway overrun.Jul 14, 2024 · N9561V · Substantial damageNTSB WPR24LA245Accident · Serious injuriesClass 4 · LimitedFinal reportKubicek Factory S R O BB26Z · Casper, WYThe pilot's inability to maintain control of the balloon after encountering high wind conditions and windshear during the landing, which resulted in the pilot’s ejection from the basket and serious injury.Jul 13, 2024 · N307CK · No damageNTSB WPR24LA243Accident · No injuriesClass 3 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Cottonwood, AZThe pilot’s low-speed, high-power maneuvering in high density altitude and near maximum gross weight, which resulted in an uncommanded right yaw due to a loss of tail rotor effectiveness and a subsequent hard landing.Jul 13, 2024 · N473E · Substantial damageNTSB WPR24LA241Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Herriman, UTA hard landing following a total loss of engine power due to fuel starvation as a result of the improper idle setting of the helicopter’s engine. Contributing to the loss of engine power was the instructor’s reduction of engine power past that recommended by…Jul 13, 2024 · N6960 · Substantial damageNTSB WPR24LA240Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182B · Soldier, IDA total loss of engine power resulting from the failure of the No. 1 piston and the No. 2 piston connecting rod due to detonation.Jul 13, 2024 · N2617G · Substantial damageNTSB CEN24LA266Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172G · West Bend, WIThe pilot’s failure to maintain directional control during the landing roll.Jul 13, 2024 · N129GW · Substantial damageNTSB ANC24LA064Accident · No injuriesClass 3 · LimitedFinal reportDehavilland DHC-2T · Petersville, AKAn in-flight loss of thrust due to an uncommanded feathering of the propeller for reasons that could not be determined.Jul 13, 2024 · N535KT · Substantial damageNTSB ERA24LA321Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Pisgah Forest, NCThe pilot’s failure to maintain proper altitude and airspeed on final approach, resulting in a runway excursion and substantial damage to the airplane.Jul 12, 2024 · N5VV · Substantial damageNTSB CEN24LA264Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Mount Vernon, ILThe pilot’s failure to lower the landing gear, resulting in a wheel up landing. Contributing to the accident was the intermittent warning horn which likely did not sound to warn the pilot about the misconfigured landing gear.Jul 12, 2024 · N9776Y · Substantial damageNTSB CEN24LA262Accident · No injuriesClass 4 · LimitedFinal reportSkystar Kitfox · Hackney, KSThe pilot’s failure to maintain directional control during the landing roll in a gusting wind condition.Jul 12, 2024 · N1078P · Substantial damage