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 GAA16CA404Accident · No injuriesData collectionFinal reportCessna 177 · Wickenburg, AZThe pilot's incorrect balked landing procedure, which resulted in an uncontrolled descent, hard landing, a runway excursion, and nose gear collapse.Jul 29, 2016 · N34867 · Substantial damageNTSB GAA16CA388Accident · No injuriesData collectionFinal reportCanadian Light Acft Sales &Svc Bushcaddy Explorer · Island Pond, VTThe pilot's exceedance of the airplane's critical angle-of-attack during approach, resulting in an inadvertent stall and hard landing.Jul 29, 2016 · N335BE · Substantial damageNTSB CEN16LA303Accident · No injuriesLimited investigationFinal reportHughes 269A · Morris, MNThe pilot's failure to maintain clearance from terrain due to his distraction by the navigation system.Jul 29, 2016 · N269JB · Substantial damageNTSB GAA16CA403Accident · No injuriesData collectionFinal reportCessna 172 · Rexburg, IDThe student pilot's failure to retract the flaps during a go-around in high density altitude conditions, resulting in the airplane's inability to climb and a subsequent collision with terrain and nose over.Jul 28, 2016 · N3677S · Substantial damageNTSB GAA16CA402Accident · No injuriesData collectionFinal reportCirrus Design SR · Henderson, NVThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and a landing gear collapse.Jul 28, 2016 · N341CP · Substantial damageNTSB CEN16LA291Accident · 1 fatalLimited investigationFinal reportAir Tractor AT602 · David City, NEThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall and impact with terrain.Jul 28, 2016 · N2033N · Substantial damageNTSB CEN16FA295Accident · 1 fatalField investigationFinal reportMooney M20J · Holmen, WIThe pilot's loss of airplane control during an instrument approach. Contributing to the accident was the pilot's lack of instrument flight proficiency.Jul 28, 2016 · N54PM · DestroyedNTSB CEN16FA290Accident · 1 fatalField investigationFinal reportFlight Design Ctls · Fond du Lac, WICarburetor contamination following exposure to water in the fuel, which resulted in a carburetor malfunction and a partial loss of engine power. Contributing to the accident was the pilot's loss of airplane control that resulted in a stall.Jul 28, 2016 · N527TS · Substantial damageNTSB GAA16CA399Accident · No injuriesData collectionFinal reportAir Tractor AT 301 · Bird Island, MNThe pilot's diverted attention inside the cockpit and failure to maintain the airplane's altitude while maneuvering at a low altitude, resulting in an impact with terrain.Jul 27, 2016 · N7311X · Substantial damageNTSB GAA16CA398Accident · No injuriesData collectionFinal reportCessna 152 · Denton, TXThe student pilot's improper approach descent rate and landing flare attitude, which resulted in a hard landing and collapse of the nose landing gear.Jul 27, 2016 · N4702P · Substantial damageNTSB GAA16CA394Accident · No injuriesData collectionFinal reportAlon A2 · Alamosa, COThe pilot's failure to maintain aircraft control during takeoff on an uneven runway surface, which resulted in it becoming airborne prematurely, an aerodynamic stall, and impact with terrain.Jul 27, 2016 · N5690F · Substantial damageNTSB GAA16CA410Accident · No injuriesData collectionFinal reportAeronca 11AC · Gig Harbor, WAThe pilot's failure to maintain directional control during landing, and subsequent wing tip strike, which resulted in substantial damage to the rear spar.Jul 26, 2016 · N9791E · Substantial damageNTSB CEN16FA286Accident · Minor injuriesClass 3 · FieldFinal reportEmbraer EMB-505 · Sugar Land, TXThe airplane’s hydroplaning during the landing roll, which resulted in a runway excursion. Contributing to the accident was the pilot’s continuation of an unstabilized approach, his decision to land in heavy rain conditions, and his improper use of the main…Jul 26, 2016 · N362FX · Substantial damageNTSB GAA16CA393Accident · No injuriesData collectionFinal reportCessna 188 · What Cheer, IAThe loss of engine power for undetermined reasons due to the pilot not making the airplane or engine available for examination, which resulted in a forced landing and an impact with terrain.Jul 25, 2016 · N9979G · Substantial damageNTSB ERA16FA269Accident · 1 fatalField investigationFinal reportYakovlev YAK11 · West Mifflin, PAA malfunction of the electrical system, which resulted in an electrical fire in the right wing root of the airplane, which compromised the fuel system and resulted in ignition of fuel. Contributing to the accident was the routing of the electrical wiring near…Jul 25, 2016 · N5940 · Substantial damageNTSB WPR16LA150Accident · No injuriesLimited investigationFinal reportBeech 65 A90 · Byron, CAThe pilot’s failure to maintain an adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and subsequent spin. Also causal to the accident was the pilot’s failure to follow prescribed spin…Jul 24, 2016 · N256TA · Substantial damageNTSB GAA16CA426Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Cordova, SCThe pilot's failure to maintain the runway heading, which resulted in the airplane not being aligned with the runway and a subsequent runway excursion.Jul 24, 2016 · N68JK · Substantial damageNTSB GAA16CA389Accident · Minor injuriesData collectionFinal reportCirrus Design SR22 · Hyannis, MAThe pilot's failure to maintain an appropriate descent rate during landing, which resulted in a hard landing, followed by a loss of directional control, runway excursion, and an impact with a security fence and vehicles during the subsequent attempt to abort…Jul 24, 2016 · N799MR · Substantial damageNTSB ERA16LA274Accident · Minor injuriesLimited investigationFinal reportAlisport Silent 2 Targa · London, KYThe pilot's failure to properly secure the right side of the canopy before takeoff, and an in-flight collision with trees while maneuvering with an open canopy. Contributing to the pilot's failure to properly secure the canopy was the lack of a visual…Jul 24, 2016 · N602SL · Substantial damageNTSB CEN16LA283Accident · Serious injuriesLimited investigationFinal reportBristell E-LSA · Oshkosh, WIThe pilot’s exceedance of the airplane’s critical angle of attack on short final approach, which resulted in an inadvertent aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot’s distraction with other traffic in the…Jul 24, 2016 · N167BL · Substantial damageNTSB WPR16LA149Accident · No injuriesLimited investigationFinal reportSwartz Gene Titan T 51 Mustang · Lancaster, CAA total loss of engine power due to the separation of a flywheel magnet, which impacted the attachment bracket for the primary and secondary ignition and disrupted the timing of the ignition system, rendering it inoperative.Jul 23, 2016 · N5103 · Substantial damageNTSB GAA16CA395Accident · No injuriesData collectionFinal reportEngineering & Research 415 · Collinsville, OKThe pilot's failure to maintain directional control during takeoff in a high density altitude condition, which resulted in a runway excursion and impact with a tree.Jul 23, 2016 · N2377H · Substantial damageNTSB ERA16LA268Accident · No injuriesLimited investigationFinal reportFrank Ware Velocity TXL · Sebastian, FLThe total loss of engine power due to maintenance personnel’s improper setting of the aneroid adjustment.Jul 23, 2016 · N916TC · Substantial damageNTSB ERA16LA267Accident · Serious injuriesLimited investigationFinal reportTemple Benjamin Freedom Master FM-2 · East Haddam, CTThe pilot’s loss of airplane control during the initial climb.Jul 23, 2016 · N282XT · Substantial damageNTSB GAA16CA390Accident · No injuriesData collectionFinal reportPiper PA46 · Claremore, OKThe pilot's failure to maintain directional control during takeoff after multiple climb attempts at insufficient airspeed, which resulted in a runway excursion, a landing gear collapse, and a collision with a ditch.Jul 22, 2016 · N9111P · Substantial damageNTSB GAA16CA387Accident · Minor injuriesData collectionFinal reportCessna 182 · Hogansville, GAThe pilot's failure to replace the left fuel cap following the preflight inspection, which resulted in fuel exhaustion, a loss of engine power, an emergency landing, and impact with terrain.Jul 22, 2016 · N9072X · Substantial damageNTSB ERA16LA266Accident · 1 fatalLimited investigationFinal reportRepublic RC 3 · Winter Haven, FLImproper installation of a fuel line by unknown personnel, which resulted in a total loss of engine power during initial climb due to fuel starvation.Jul 22, 2016 · N87570 · Substantial damageNTSB CEN16LA289Accident · Minor injuriesLimited investigationFinal reportBell OH 58A · Lake Mills, IAThe pilot's inadequate visual lookout, which resulted in a wire strike.Jul 22, 2016 · N288NS · Substantial damageNTSB CEN16LA287Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Dodge Center, MNA partial loss of engine power due to carburetor ice.Jul 22, 2016 · N8019K · Substantial damageNTSB CEN16LA281Accident · 2 fatalLimited investigationFinal reportVans RV9 · Springfield, OHThe pilot’s decision to fly into known thunderstorms, which resulted in an in-flight breakup.Jul 22, 2016 · N807LK · DestroyedNTSB CEN16LA288Accident · No injuriesLimited investigationFinal reportCessna 208B · Baldwin, WIThe pilot's decision to land the fully loaded parachutist drop airplane on a wet grass runway that had insufficient length for the landing in high temperature conditions, which resulted in a runway overrun, when a more suitable longer runway was available at…Jul 21, 2016 · N7581F · Substantial damageNTSB CEN16FA278Accident · 2 fatalField investigationFinal reportHarris-Runyan Skybolt 300 · Fairmont, OKThe pilot's delay in recovering from an aerobatic maneuver resulting in collision with terrain.Jul 21, 2016 · N511GS · Substantial damageNTSB CEN16FA276Accident · 1 fatalField investigationFinal reportPiper PA 30 · Plainfield, ILThe pilot's failure to maintain airplane control during an en route climb near convective activity, which resulted in an aerodynamic stall, an uncontrolled descent, and a subsequent in-flight breakup due to an exceedance of the airplane's design load…Jul 21, 2016 · N7409Y · DestroyedNTSB CEN16CA277Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Topeka, KSThe pilot’s failure to maintain clearance from a wire during an agricultural flight.Jul 21, 2016 · N7997 · Substantial damageNTSB GAA16CA391Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind HK 36 · Blanchester, OHThe pilot's failure to maintain directional control of the powered glider during the landing roll.Jul 20, 2016 · N526TC · Substantial damageNTSB ERA16CA264Accident · Serious injuriesData collectionFinal reportAeronca 7BCM · Connellsville, PAThe pilot's failure to properly set the throttle and secure the airplane before hand-propping the engine for startup.Jul 20, 2016 · N1639E · Substantial damageNTSB CEN16LA275Accident · Minor injuriesClass 3 · LimitedFinal reportMeyers 200 · Huron, SDThe partial loss of engine power due an unsecured throttle cable. The reason for the unsecured throttle cable could not be determined.Jul 20, 2016 · N229RS · Substantial damageNTSB ANC16CA049Accident · No injuriesData collectionFinal reportCessna U206 · Cordova, AKThe pilot's improper landing flare, which resulted in a hard landing and subsequent landing gear separation and collapse.Jul 20, 2016 · N1222V · Substantial damageNTSB ERA16LA263Accident · No injuriesLimited investigationFinal reportTecnam P2008 · Warrenton, VAThe pilot’s decision to begin the takeoff roll with helicopter traffic on the runway, which led to a rejected takeoff. Contributing to the accident was the pilot’s improper use of the toe brakes, which he had limited experience using and resulted in a runway…Jul 19, 2016 · N615BS · Substantial damageNTSB CEN16LA274Accident · No injuriesLimited investigationFinal reportChance Vought F4U 5 · East Troy, WIA failure of the O-ring in the left brake master cylinder for reasons that could not be determined, which resulted in a loss of directional control during landing.Jul 19, 2016 · N179PT · Substantial damageNTSB CEN16LA273Accident · No injuriesLimited investigationFinal reportBrandt Sonex · Lodi, WIThe separated rocker arm assembly for undetermined reasons, which resulted in the partial loss of engine power and led to the landing gear collapsing during the subsequent forced landing.Jul 19, 2016 · N393SX · Substantial damageNTSB CEN16LA270Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Weatherford, TXAn electrical system malfunction for reasons that could not be determined, and the subsequent loss of engine power due to the loss of the electrical boost pumps. Also causal was the pilot's improper emergency action following the loss of engine power due to…Jul 19, 2016 · N2644F · Substantial damageNTSB CEN16FA269Accident · 2 fatalField investigationFinal reportAeronca 11AC · Ishpeming, MIThe pilot's failure to maintain airspeed following a loss of engine power due to carburetor icing while turning from base to final at a low altitude, which resulted in the airplane's wing exceeding its critical angle of attack and a subsequent aerodynamic…Jul 19, 2016 · N85893 · Substantial damageNTSB ANC16LA047Accident · No injuriesLimited investigationFinal reportAeropro CZ A220 · McCarthy, AKThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a loss of control and impact with terrain. Contributing to the accident were engine power surges due to the bent carburetor throttle valve lever.Jul 19, 2016 · N151J · Substantial damageNTSB ANC16LA046Accident · No injuriesLimited investigationFinal reportCessna A185 · Illiamna, AKThe overstress fracture of the left main landing (MLG) gear axle attachment bolts and the subsequent separation of the left MLG wheel, which resulted in the pilot’s inability to control the airplane.Jul 19, 2016 · N85CF · Substantial damageNTSB ANC16CA055Accident · No injuriesData collectionFinal reportKirbybilt Xcalibur · Valdez, AKThe pilot's failure to maintain an adequate glide path during landing, which resulted in the airplane landing short of the airstrip, a landing gear collapse, and subsequent substantial damage to the fuselage.Jul 19, 2016 · N505XC · Substantial damageNTSB WPR16FA144Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA40 F · Logan, UTThe pilot's exceedance of the airplane's critical angle of attack while maneuvering in turbulence and gusty wind conditions, which resulted in an aerodynamic stall/spin.Jul 18, 2016 · N419FP · DestroyedNTSB WPR16CA145Accident · Minor injuriesData collectionFinal reportBeech 19A · Helena, MTThe pilot's failure to reposition the fuel selector valve to the on position prior to takeoff resulting in a loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to properly complete the pre-takeoff checklist.Jul 18, 2016 · N7645R · Substantial damageNTSB GAA16CA386Accident · No injuriesData collectionFinal reportCessna 172 · Chesterfield, MOThe student pilot's improper pitch control during the landing flare, which resulted in a porpoise and substantial damage to the firewall.Jul 18, 2016 · N128RM · Substantial damageNTSB GAA16CA383Accident · No injuriesData collectionFinal reportAeronca 7AC · Lenoir, NCThe pilot's encounter with instrument meteorological conditions, which resulted in an emergency descent through fog, a runway overrun on a wet grass runway, and a collision with a ditch and vegetation. Contributing to the accident was the pilot's failure to…Jul 18, 2016 · N84690 · Substantial damage