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 ERA19LA159Accident · Minor injuriesClass 3 · LimitedFinal reportZenair Zodiac CH601 · Angier, NCA partial loss of engine power due to partial interruption of the fuel supply for undetermined reasons.Apr 27, 2019 · N61PG · Substantial damageNTSB CEN19LA129Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 23 · Sulphur Spring, TXThe pilot’s inadequate preflight inspection, during which he failed to detect the water contamination in the left fuel, which resulted in a partial loss of power in the left engine. Contributing to the accident was the total loss of power in the right engine…Apr 27, 2019 · N233P · Substantial damageNTSB WPR19LA122Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Oakridge, ORA total loss of engine power following the failure of a 3rd stage turbine blade due to low- and high-cycle fatigue.Apr 26, 2019 · N206JH · Substantial damageNTSB GAA19CA253Accident · No injuriesData collectionFinal reportStearman A75N1(PT17) · Gila Bend, AZThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a ditch.Apr 26, 2019 · N67823 · Substantial damageNTSB GAA19CA231Accident · No injuriesData collectionFinal reportBeech 76 · St Charles, MOThe pilot receiving instruction's failure to extend the landing gear. Contributing to the accident were the pilot receiving instruction's failure to complete the landing checklist and the flight instructor's inadequate monitoring of the pilot.Apr 26, 2019 · N3733D · Substantial damageNTSB GAA19CA226Accident · No injuriesData collectionFinal reportGuimbal Cabri · McMinnville, ORThe pilot's improper landing flare during a turning, full-down autorotation, which resulted in a lower-than-normal rotor rpm, a faster-than-normal ground run speed, and the subsequent loss of directional control, a runway excursion, and a roll-over.…Apr 26, 2019 · N367PA · Substantial damageNTSB CEN19LA127Accident · No injuriesClass 3 · LimitedFinal reportBeech 50 · Sheldon, MOA partial loss of engine power on both engines due to detonation for undetermined reasons.Apr 26, 2019 · N29Y · Substantial damageNTSB WPR19FA121Accident · 2 fatalClass 3 · FieldFinal reportTL Ultralight Sro Stingsport · Madera, CAThe pilot's exceedance of the airplane's critical angle of attack during the simulated engine failure on initial climb after takeoff, which resulted in an aerodynamic stall and subsequent loss of control at too low of an altitude to recover.Apr 25, 2019 · N797N · DestroyedNTSB ERA19LA158Accident · Serious injuriesClass 3 · LimitedFinal reportAcro Super Acro Sport I · Elberton, GAThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Apr 25, 2019 · N20FB · Substantial damageNTSB GAA19CA219Accident · No injuriesData collectionFinal reportCessna 180 · Morgan, UTThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and an attempted aborted landing and impact with bushes and terrain.Apr 24, 2019 · N1628C · Substantial damageNTSB ERA19LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Key West, FLThe pilot's decision to attempt a takeoff in rough sea conditions, resulting in damage to the floats and the sinking of the seaplane.Apr 23, 2019 · N366TA · Substantial damageNTSB ERA19FA155Accident · 2 fatalClass 2 · FieldFinal reportBellanca 1730 · Henderson, KYThe student pilot's failure to maintain proper airspeed, which resulted in the exceedance of the airplane's critical angle of attack at a low altitude, in the airport traffic pattern, following a total loss of engine power due to fuel exhaustion. Contributing…Apr 23, 2019 · N9693E · Substantial damageNTSB WPR19LA130Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Prineville, ORThe pilot’s failure to maintain directional control during takeoff with a crosswind.Apr 22, 2019 · N4567C · Substantial damageNTSB ERA19LA157Accident · Serious injuriesClass 3 · LimitedFinal reportBarrows Bearhawk LSA · Holly Springs, NCThe pilot's failure to maintain clearance from powerlines during the visual approach.Apr 22, 2019 · N289EH · Substantial damageNTSB CEN19FA124Accident · 6 fatalClass 2 · FieldFinal reportBeech 58 · Kerrville, TXThe pilot's inadequate preflight fuel planning and fuel management, which resulted in a loss of engine power due to fuel exhaustion. Also causal was the pilot's failure to follow the one-engine inoperative checklist and maintain the airplane's minimum…Apr 22, 2019 · N501CE · Substantial damageNTSB CEN19LA123Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R66 · St Jacob, ILThe pilot's in-flight collision with an unmarked wire during an aerial application flight; the wire lacked contrast with the surrounding environment.Apr 21, 2019 · N766WC · Substantial damageNTSB CEN19FA122Accident · 2 fatalClass 3 · FieldFinal reportRans S7 · Kingsland, TXThe exceedance of the airplane's critical angle of attack during a steep climb after takeoff, which resulted in an aerodynamic stall and spin into terrain.Apr 21, 2019 · N25TX · DestroyedNTSB GAA19CA225Accident · No injuriesData collectionFinal reportCessna 172 · Scottsdale, AZThe pilot's improper rudder inputs and failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with a runway sign.Apr 20, 2019 · N6023V · Substantial damageNTSB GAA19CA218Accident · No injuriesData collectionFinal reportCessna 180 · Reedsburg, WIThe pilot's loss of directional control and subsequent improper brake application during the landing roll, which resulted in a nose-over.Apr 20, 2019 · N59DW · Substantial damageNTSB CEN19LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · St. Cloud, MNThe pilot's failure to maintain directional control during a crosswind landing. Contributing to the accident was the pilot’s decision to land in crosswind conditions given his lack of recent experience in those conditions.Apr 20, 2019 · N40956 · Substantial damageNTSB WPR19LA117Accident · Minor injuriesClass 3 · LimitedFinal reportNanchang CJ 6 · Grass Valley, CAA loss of brake control due to fatigue fracture of the brake control cable, which resulted in the separation of the cable from the brake handle.Apr 19, 2019 · N621JM · Substantial damageNTSB WPR19FA115Accident · 1 fatalClass 3 · FieldFinal reportBeech 60 · Fullerton, CAThe pilot’s use of an unapproved elevator control lock device, and his failure to remove that device and correctly position the elevator before flight, which resulted in a loss of control during takeoff. Contributing to the accident was his failure to perform…Apr 19, 2019 · N65MY · DestroyedNTSB CEN19LA126Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Dwight, ILA partial loss of engine power due to a restriction in fuel flow for undetermined reasons.Apr 19, 2019 · N838JH · Substantial damageNTSB WPR19FA116Accident · 2 fatalClass 3 · FieldFinal reportVans RV8 · Brookings, ORThe pilot’s failure to maintain aircraft control during an aggressive maneuver that resulted in a nose down collision with terrain.Apr 18, 2019 · N791PF · Substantial damageNTSB GAA19CA216Accident · No injuriesData collectionFinal reportBell 47G · Donna, TXThe pilot's failure to maintain altitude during an agricultural application flight.Apr 17, 2019 · N96671 · Substantial damageNTSB GAA19CA212Accident · Minor injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe pilot's failure to maintain lateral control during landing and his exceedance of the airplane’s critical angle of attack during the subsequent aborted landing, which resulted in an aerodynamic stall.Apr 17, 2019 · N425PA · Substantial damageNTSB WPR19LA112Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT502 · Morganza, LAA loss of aircraft control due to the separation of the elevator pushrod attachment bolt.Apr 16, 2019 · N599LA · Substantial damageNTSB WPR19LA111Accident · No injuriesClass 3 · LimitedFinal reportMD Helicopter 369 · Hauula, HIFuel exhaustion as a result of the pilot’s fuel burn miscalculation. Contributing to the accident was the inoperative caution light indicating low fuel level.Apr 16, 2019 · N593C · Substantial damageNTSB WPR19FA109Accident · 2 fatalClass 3 · FieldFinal reportBell 206 · Fort McDowell, AZThe separation of the main rotor head from the mast as a result of a sudden displacement of the cyclic stick during a low-G maneuver, leading to mast bumping. Contributing to the accident were the unsecure positioning of the flight test engineer’s laptop…Apr 16, 2019 · N61PH · DestroyedNTSB GAA19CA211Accident · No injuriesData collectionFinal reportTubbs S/Performance Air PA-18-225 · Denver, COThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.Apr 16, 2019 · N755K · Substantial damageNTSB GAA19CA208Accident · Serious injuriesData collectionFinal reportAirframes Unlimited Outlaw · Elizabeth, COThe pilot's failure to maintain adequate airspeed and his subsequent decision to initiate a turn, which resulted in the powered parachute’s descent and impact with a fence.Apr 15, 2019 · N5622D · Substantial damageNTSB GAA19CA206Accident · No injuriesData collectionFinal reportPiper PA28R · Hutchinson, KSThe pilot's failure to extend the landing gear before landing.Apr 15, 2019 · N55275 · Substantial damageNTSB ERA19LA152Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Dublin, GAA partial loss of engine power on takeoff due to separation of the diffuser assembly as a result of incomplete braze joint surfaces on the vane airfoils.Apr 15, 2019 · N395AE · Substantial damageNTSB WPR19TA110Accident · Serious injuriesClass 3Final reportKubicek BB100 · St. Helena, CAThe balloon pilot's encounter with unforecasted wind, which resulted in his decision to land in unsuitable terrain and a subsequent hard landing. Contributing to the severity of passenger injury was the pilot’s failure to provide a proper safety briefing.Apr 14, 2019 · N355WC · Minor damageNTSB GAA19CA214Accident · No injuriesData collectionFinal reportCessna 180 · Limington, METhe pilot's failure to maintain directional control during touchdown, which resulted in runway excursion onto snow.Apr 14, 2019 · N4796B · Substantial damageNTSB GAA19CA213Accident · Minor injuriesData collectionFinal reportCessna 152 · Bangor, METhe pilot's improper landing flare, which resulted in a hard landing.Apr 14, 2019 · N4916B · Substantial damageNTSB GAA19CA205Accident · No injuriesData collectionFinal reportPiper PA22 · Seward, AKThe pilot's failure to maintain directional control during an attempted go-around, which resulted in impact with a snowbank.Apr 14, 2019 · N3821P · Substantial damageNTSB ERA19LA150Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · New York, NYThe pilot's decision to initiate a flight into low instrument flight rules conditions, which resulted in six missed approaches at two airports and a total loss of engine power due to fuel exhaustion. Contributing to the accident was the external pressure the…Apr 14, 2019 · N5296H · Substantial damageNTSB WPR19LA108Accident · Serious injuriesClass 3 · LimitedFinal reportEuropa XS · Winters, CAThe pilot's failure to properly install a wrist pin circlip, which resulted in internal damage to the No. 5 cylinder and a subsequent total loss of engine power.Apr 13, 2019 · N120EJ · Substantial damageNTSB ERA19TA153Accident · No injuriesClass 3Final reportRobinson R22 · Bradenton Beach, FLThe pilot's improper decision to execute a low altitude turn that resulted in a strong tailwind and to reduce the airspeed to 0 knots and the flight instructor's diverted attention and inadequate monitoring, which resulted in the helicopter settling with…Apr 13, 2019 · N689M · Substantial damageNTSB CEN19FA120Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Lake, MSThe noninstrument-rated pilot’s loss of control while flying in dark night instrument meteorological weather conditions with convective activity, which resulted in the airplane exceeding its structural limitations and experiencing an in-flight breakup.…Apr 13, 2019 · N4890L · DestroyedNTSB CEN19FA119Accident · 3 fatalClass 2 · FieldFinal reportRockwell International NA-265-65 · New Albany, MSAn unidentified electrical system malfunction that led to the pilots losing awareness of the airplane's performance in instrument meteorological conditions and resulted in a loss of control of the airplane.Apr 13, 2019 · N265DS · DestroyedNTSB ANC19LA016Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Bethel, AKA total loss of engine power due to a fatigue failure of the crankshaft. A contributing factor was the inadequate inspection during the engine’s last overhaul.Apr 12, 2019 · N4466T · Substantial damageNTSB GAA19CA204Accident · No injuriesData collectionFinal reportCessna R182 · Marysville, OHThe pilot's failure to maintain directional control during the landing roll in gusting crosswind conditions, which resulted in a runway excursion and nose-over.Apr 11, 2019 · N2238T · Substantial damageNTSB GAA19CA203Accident · No injuriesData collectionFinal reportCessna 172 · Fullteron, CAThe student pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and nose-over.Apr 11, 2019 · N9964L · Substantial damageNTSB ERA19LA151Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Fulton, NYA total loss of engine power due to carburetor icing. Contributing was the pilot’s failure to leave the carburetor heat on fully after his initial application of carburetor heat.Apr 11, 2019 · N3795J · Substantial damageNTSB DCA19LA134Accident · No injuriesClass 3 · LimitedFinal reportAirbus A321 · New York, NYThe captain’s excessive left rudder pedal input during the takeoff ground roll, which caused a large heading deviation and a left roll upon rotation that resulted in the left wingtip striking the ground.Apr 11, 2019 · N114NN · Substantial damageNTSB GAA19CA202Accident · Minor injuriesData collectionFinal reportPiper PA 12 · Sisters, ORThe pilot's failure to maintain pitch control during the landing roll, which resulted in a nose-over.Apr 10, 2019 · N92798 · Substantial damageNTSB ERA19CA147Accident · Minor injuriesData collectionFinal reportGaskins Safari 400 · Gallatin, TNThe pilot/owner's improper decision to make a right turn instead of terminating the approach to a hover and his subsequent loss of helicopter control while attempting to land on sloping terrain, which resulted in a roll-over.Apr 10, 2019 · N104CV · Substantial damageNTSB ERA19CA148Accident · Minor injuriesData collectionFinal reportCessna 152 · Lancaster, PAThe student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with a runway marker.Apr 8, 2019 · N68727 · Substantial damage