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 ERA17LA258Accident · No injuriesLimited investigationFinal reportKubassek David Zenith 601 · Aiken, SCThe failure of the nose landing gear’s (NLG) lower bearing, which resulted in the pilot’s inability to maintain directional control during landing, a runway excursion, and the NLG collapsing.Jul 22, 2017 · N651JL · Substantial damageNTSB CEN17LA283Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Austin, TXThe pilot's improper decision to attempt to take off after two previous failed attempts from choppy water with a high outside temperature and the airplane near its maximum gross weight, which degraded the airplane’s performance and resulted in its inability…Jul 22, 2017 · N3119D · Substantial damageNTSB WPR17LA159Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Van Nuys, CAAn improper repair of the right magneto's tachometer and governor signal wire, which failed during cruise flight and initiated a simultaneous malfunction of both the engine tachometer and governor control system, which resulted in erroneous and contradictory…Jul 21, 2017 · N3254E · Substantial damageNTSB GAA17CA434Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Bozeman, MTThe flight instructor’s unstabilized autorotation, which resulted in a hard landing.Jul 21, 2017 · N28VH · Substantial damageNTSB CEN17LA280Accident · No injuriesLimited investigationFinal reportStinson 108 · Lee's Summit, MOThe pilot’s loss of directional control during landing due to the failure of the right brake seal.Jul 21, 2017 · N8954K · Substantial damageNTSB ANC17CA038Accident · No injuriesData collectionFinal reportDehavilland DHC 2 · Dilllingham, AKThe pilot's failure to set the wing flaps to the "takeoff" position, which resulted in a longer-than-normal takeoff run and collision with terrain.Jul 21, 2017 · N364RA · Substantial damageNTSB ERA17LA262Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11BC · Gilbert, SCThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion.Jul 20, 2017 · N3154E · Substantial damageNTSB ERA17LA254Accident · No injuriesLimited investigationFinal reportCessna 152 · Tamarac, FLThe flight instructor's failure to ensure that the airplane's fuel system was free of water contamination before departing, which resulted in a total loss of engine power and subsequent forced landing.Jul 20, 2017 · N714UY · Substantial damageNTSB ERA17CA250Accident · No injuriesData collectionFinal reportCessna 172 · Factoryville, PAThe pilot's failure to attain the proper touchdown point, which resulted in a runway overrun.Jul 20, 2017 · N4876F · Substantial damageNTSB CEN17LA313Accident · No injuriesLimited investigationFinal reportCanion Michael W Zodiac 601XL · Grady, ARThe loss of engine power due to a lack of ignition resulting from a broken alternator wire.Jul 20, 2017 · N577M · Substantial damageNTSB CEN17CA346Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Logan, IAThe pilot’s failure to maintain clearance from a wire during an agricultural application flight.Jul 20, 2017 · N192E · Substantial damageNTSB WPR17LA158Accident · Serious injuriesLimited investigationFinal reportEnstrom F 28C · Ontario, CAThe student pilot's mismanagement of the main rotor rpm, which resulted in low rotor rpm, a high descent rate, and a subsequent hard landing.Jul 19, 2017 · N5697B · Substantial damageNTSB GAA17CA447Accident · No injuriesData collectionFinal reportMichael Dean Grissom Grissom Pober Pixie · Louisburg, NCThe pilot’s improper landing flare, which resulted in a hard landing.Jul 19, 2017 · N489MG · Substantial damageNTSB ERA17LA256Accident · Minor injuriesLimited investigationFinal reportD & K Baby Belle · Spartanburg, SCThe pilot's failure to maintain helicopter control during the approach to landing.Jul 19, 2017 · N211CJ · Substantial damageNTSB ERA17LA249Accident · Serious injuriesLimited investigationFinal reportGrumman G 164 · Marydel, DEThe pilot's failure to maintain adequate clearance from power lines while conducting an aerial application flight.Jul 19, 2017 · N691Y · Substantial damageNTSB ERA17FA248Accident · 1 fatalField investigationFinal reportAircraft Mfg & Dvlpmt CH601XLi Slsa · Towanda, PAA partial loss of engine power for reasons that could not be determined based on the available information, and the pilot's exceedance of the airplane's critical angle of attack during an attempted return to the airport, which resulted in an aerodynamic stall…Jul 19, 2017 · N601PH · DestroyedNTSB GAA17CA425Accident · No injuriesData collectionFinal reportPiper PA28R · Bowling Green, OHThe pilot’s and flight instructor’s failure to extend the landing gear.Jul 18, 2017 · N786BG · Substantial damageNTSB GAA17CA424Accident · Minor injuriesData collectionFinal reportSalerno Kenneth G JR Kitfox Series 7 · Owyhee, ORThe pilot's failure to maintain directional control during takeoff from a rough, dirt airstrip.Jul 18, 2017 · N702KF · Substantial damageNTSB GAA17CA420Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2008 · Lone Rock, WIThe student pilot’s improper landing flare, which resulted in a bounced landing and subsequent loss of directional control and runway excursion during the aborted landing. Contributing to the improper landing flare was the student’s distraction by a deer…Jul 18, 2017 · N445X · Substantial damageNTSB CEN17LA284Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Reyno, ARThe pilot’s inadvertent use of the propeller control, which caused the propeller to feather while in flight with the engine still operating, resulting in a loss of thrust and a subsequent forced landing.Jul 18, 2017 · N816FF · Substantial damageNTSB CEN17LA275Accident · Minor injuriesLimited investigationFinal reportGolden Circle Air T-BIRD II · Dunn Center, NDThe pilot's failure to maintain airplane control, his inadequate quartering tailwind correction during takeoff, and his decision to continue the takeoff to the south with insufficient road length remaining.Jul 18, 2017 · UNREG · Substantial damageNTSB CEN17LA272Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Pierce, NEThe pilot’s failure to maintain clearance from trees during a low-level agricultural aerial application flight.Jul 18, 2017 · N7388Z · Substantial damageNTSB WPR17FA155Accident · 2 fatalField investigationFinal reportEvolution 19 Lancair Evolution · Mesa, AZThe pilot's failure to maintain adequate airspeed while maneuvering for landing, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent stall/spin. Contributing to the accident was the pilot's distraction due to a failure…Jul 17, 2017 · N571JM · Substantial damageNTSB GAA17CA415Accident · No injuriesData collectionFinal reportCessna 195 · Leavenworth, KSThe pilot’s inadvertent toe brake application during the landing roll, which resulted in a runway excursion and a ground loop.Jul 17, 2017 · N4432C · Substantial damageNTSB ERA17LA247Accident · No injuriesLimited investigationFinal reportAeroprakt A 20 Vista Cruiser · Shirley, NYThe pilot's inadvertent activation of the engine's choke control during a downdraft encounter, which resulted in a total loss of engine power.Jul 17, 2017 · N55US · Substantial damageNTSB GAA17CA417Accident · No injuriesData collectionFinal reportPerner/Pitts S1S · Brenham, TXThe pilot's failure to maintain lateral/bank and yaw control during a go-around.Jul 16, 2017 · N714H · Substantial damageNTSB GAA17CA414Accident · No injuriesData collectionFinal reportCessna TU206 · Albuquerque, NMThe pilot’s improper landing flare in gusting wind conditions, which resulted in a porpoised landing.Jul 16, 2017 · N166Z · Substantial damageNTSB ERA17LA252Accident · No injuriesLimited investigationFinal reportCessna R172 · Naples, METhe pilot's failure to maintain airplane control during landing.Jul 16, 2017 · N736NK · Substantial damageNTSB ANC17LA037Accident · No injuriesClass 3 · LimitedFinal reportCessna A185 · Wasilla, AKThe pilot’s failure to manage fuel quantity in flight, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow manufacturer guidance for restoring engine power after emptying a fuel…Jul 16, 2017 · N401WC · Substantial damageNTSB WPR17LA157Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Ogden, UTThe failure of the No. 4 cylinder exhaust valve head, which resulted in a total loss of engine power due to oil starvation.Jul 15, 2017 · N754AP · Substantial damageNTSB WPR17LA156Accident · No injuriesClass 3 · LimitedFinal reportSimmons Gary F Stol CH 701 · Kenwood, CAFailure of the flywheel drive assembly, which resulted in a loss of engine power and subsequent forced landing to uneven terrain.Jul 15, 2017 · N422ES · Substantial damageNTSB GAA17CA422Accident · No injuriesData collectionFinal reportPiper PA32 · Marion, IAThe pilot’s failure to maintain directional control during the landing roll.Jul 15, 2017 · N31841 · Substantial damageNTSB GAA17CA412Accident · No injuriesData collectionFinal reportMooney M20C · Washington Island, WIThe pilot's failure to maintain a proper approach path, which resulted in impact with trees.Jul 15, 2017 · N9303V · Substantial damageNTSB ERA17LA246Accident · No injuriesClass 3 · LimitedFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Stevensville, MDThe fatigue failure of an exhaust valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power.Jul 15, 2017 · N561TU · Substantial damageNTSB CEN17LA274Accident · No injuriesLimited investigationFinal reportEndler Glasair/Glasair 1-Td SH2 · Colorado Springs, COThe pilot's failure to lock the castering tailwheel in accordance with the airplane Owner's Manual and a checklist item and to abort the takeoff after the airplane exceeded its normal takeoff distance and/or reached the limit of the rudder control authority…Jul 15, 2017 · N181AL · DestroyedNTSB ANC17FA035Accident · 1 fatalField investigationFinal reportAeronca 15AC · Big Lake, AKThe pilot's failure to maintain clearance from trees during low-altitude flight, which resulted in an in-flight collision and impact with terrain.Jul 15, 2017 · N1370H · Substantial damageNTSB WPR17LA154Accident · No injuriesClass 3 · LimitedFinal reportBeech D55 · Hailey, IDThe pilot’s loss of directional control during landing.Jul 14, 2017 · N1796A · Substantial damageNTSB WPR17LA153Accident · Minor injuriesClass 3 · LimitedFinal reportClark James T Vans RV8 · Spokane, WAAn inflight engine fire for reasons that could not be determined based on the available information, which melted the air filter element and obstructed the engine's air intakes, resulting in a total loss of engine power.Jul 14, 2017 · N559JC · Substantial damageNTSB WPR17FA152Accident · 1 fatalField investigationFinal reportJansen Pazmany PL 2 · El Monte, CAA total loss of engine power due to fuel starvation for reasons that could not be determined based on the available evidence. Also causal was the pilot's decision to return to the runway following the loss of engine power, and his failure to maintain airspeed…Jul 14, 2017 · N186EJ · Substantial damageNTSB GAA17CA419Accident · No injuriesData collectionFinal reportPiper PA28 · Fort Worth, TXThe student pilot’s improper landing flare, which resulted in a bounced landing and a propeller strike.Jul 14, 2017 · N82629 · Substantial damageNTSB ERA17LA242Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Key Biscayne, FLThe nearly complete blockage of the right fuel tank strainer with organic material, which resulted in fuel starvation and the subsequent total loss of engine power. Contributing to the fuel starvation was the pilot receiving instruction’s and the flight…Jul 14, 2017 · N80457 · Substantial damageNTSB ERA17CA244Accident · No injuriesData collectionFinal reportMooney M20R · Venice, FLThe pilot’s failure to maintain directional control during landing in a gusting crosswind conditions.Jul 14, 2017 · N57GX · Substantial damageNTSB WPR17FA150Accident · 2 fatalField investigationFinal reportCirrus Design SR22T · Schellville, CAThe pilot's failure to maintain adequate airspeed after a loss of engine power, which resulted in an aerodynamic stall at a low altitude from which the pilot was unable to recover. The loss of engine power resulted from the pilot's improper selection for the…Jul 13, 2017 · N821SG · DestroyedNTSB WPR17FA149Accident · 2 fatalField investigationFinal reportAviat A · Herriman, UTThe flight instructor's decision to conduct a low-altitude flight into a box canyon in high density altitude conditions and his failure to maintain airspeed while maneuvering to escape the canyon, which resulted in an exceedance of the airplane's critical…Jul 13, 2017 · N211AM · DestroyedNTSB GAA17CA409Accident · No injuriesData collectionFinal reportProgressive Aerodyne Searey LSA · Spicewood, TXThe pilot’s failure to retract the landing gear before landing on water.Jul 13, 2017 · N108SR · Substantial damageNTSB GAA17CA408Accident · No injuriesData collectionFinal reportPiper PA 18 · Denali, AKThe pilot’s failure to maintain directional control while landing on a narrow, unimproved airstrip in gusting wind conditions.Jul 13, 2017 · N8560C · Substantial damageNTSB ERA17FA241Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau EA 300/L · Winchester, NHThe noninstrument-rated pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and collision with terrain. Contributing to the accident was the pilot's self-induced pressure to complete…Jul 13, 2017 · N210MX · DestroyedNTSB CEN17FA266Accident · 2 fatalField investigationFinal reportPiper PA31T · Tyler, TXThe loss of engine power and the subsequent pilot's loss of control for reasons that could not be determined because post-accident engine examination revealed no anomalies.Jul 13, 2017 · N47GW · DestroyedNTSB GAA17CA407Accident · No injuriesData collectionFinal reportGerald Donovan Rans S-16 · Los Lunas, NMThe pilot's failure to maintain directional control during takeoff.Jul 12, 2017 · N116GD · Substantial damageNTSB WPR17LA162Accident · No injuriesLimited investigationFinal reportCessna A185E · Nampa, IDThe pilot’s failure to maintain directional control of the tailwheel airplane during the landing roll.Jul 11, 2017 · N185LC · Substantial damage