NTSB investigations

3,633 cases where NTSB found Aircraft systems.

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\", '0102'))
  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 DCA16CA197Accident · No injuriesData collectionFinal reportFacebook UK Aquila · Yuma, AZa structural failure of the wing as a result of exceeding the airspeed envelope due to wind gusts which were beyond the capabilities of the autopilot. Contributing to the accident was an insufficient amount of drag to track the glideslope in the presence of…Jun 28, 2016 · N565AQ · Substantial damageNTSB CEN16LA239Accident · Minor injuriesLimited investigationFinal reportPiper J3F 65 · Strasburg, COA partial loss of engine power due to carburetor ice accumulation.Jun 27, 2016 · N29042 · Substantial damageNTSB GAA16CA375Accident · No injuriesData collectionFinal reportCessna A185 · Hayden Lake, IDThe pilot's failure to retract the amphibious airplane's land-wheels prior to landing on a lake, which resulted in a nose over.Jun 26, 2016 · N185TG · Substantial damageNTSB CEN16LA247Accident · Serious injuriesLimited investigationFinal reportBeech E 90 · Longmont, COThe pilot's unintentional activation of the green jump light before the airplane was properly configured and slowed for a jump and the jumpers' improper decision to continue with the jump after they recognized that the airplane was at a higher-than-normal…Jun 26, 2016 · N92DV · Substantial damageNTSB ERA16LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Hollywood, FLThe pilot’s inadequate preflight inspection of the fuel system, which resulted in a total loss of engine power due to water contamination.Jun 25, 2016 · N9836W · Substantial damageNTSB GAA16CA350Accident · No injuriesData collectionFinal reportPiper PA 24 · Springfield, MOThe pilot's failure to ensure that the landing gear was in the down and locked position prior to touchdown.Jun 24, 2016 · N5138P · Substantial damageNTSB WPR16LA129Accident · No injuriesClass 3 · LimitedFinal reportBurkes BR-1 · Brigham City, UTA loss of engine power as a result of a failure of the primary and backup ignition system.Jun 22, 2016 · N677DB · Substantial damageNTSB GAA16CA527Accident · No injuriesData collectionFinal reportSwearingen SA226 · Farmingdale, NYThe pilot-in-command’s failure to extend the landing gear before landing and his failure to use the Before Landing checklist. Contributing to the accident was the pilots’ failure to maintain a sterile cockpit during landing.Jun 20, 2016 · N127WD · Substantial damageNTSB ERA16LA226Accident · Serious injuriesLimited investigationFinal reportRockwell International 112A · Dayton, TNA total loss of engine power due to the failure of the engine-driven fuel pump.Jun 20, 2016 · N1299J · Substantial damageNTSB CEN16LA230Accident · No injuriesLimited investigationFinal reportGlaeser Nieuport 11 · Gardner, KSThe pilot's diverted attention during the approach for the precautionary landing, which resulted in low airspeed, an exceedance of the airplane’s critical angle of attack, and a subsequent aerodynamic stall. Contributing to the accident was the control system…Jun 18, 2016 · N124TG · Substantial damageNTSB CEN16LA223Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Colorado Springs, COA hard landing on rough terrain due to a faulty deployment of the airplane’s airframe parachute system following a partial loss of engine power for reasons that could not be determined, because postaccident examination revealed no malfunctions or anomalies…Jun 18, 2016 · N678Z · Substantial damageNTSB ERA16LA216Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Chatham, MAThe inadequate maintenance of the lower forward clutch actuator bearing for a prolonged period of time, which resulted in a bearing failure. Contributing to the accident was an erroneous maintenance entry, which resulted in the helicopter being operated…Jun 17, 2016 · N141TM · Substantial damageNTSB GAA16CA321Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Delhi, LAThe pilot's inability to maintain directional control during the landing roll as a result of a piece of concrete from the runway impacting the right main landing gear brake during the landing roll, resulting in a right brake failure and a ground loop.Jun 15, 2016 · N1002L · Substantial damageNTSB CEN16LA221Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw HXB · Sealy, TXFailure of maintenance personnel to comply with the engine manufacturer’s mandatory service bulletin, which resulted in failure of the mechanical fuel pump diaphragm and a subsequent total loss of engine power.Jun 15, 2016 · N302CT · DestroyedNTSB GAA16CA307Accident · No injuriesData collectionFinal reportLuscombe 8 · Valparaiso, INThe pilot's improper descent rate during landing, which resulted in a bounced landing, failure of the tailwheel suspension leaf spring, a ground loop, and substantial damage to the left wing.Jun 12, 2016 · N2850K · Substantial damageNTSB GAA16CA299Accident · Minor injuriesData collectionFinal reportBareiss David A Tango 2 · Sunrise Beach Village, TXThe nosewheel fairing becoming packed with debris during landing on the soft field due to a gap between the nosewheel tire and the fairing, which resulted in a loss of control and subsequent nose-over.Jun 10, 2016 · N324TT · Substantial damageNTSB ERA16LA213Accident · No injuriesLimited investigationFinal reportCessna 310 · Apopka, FLThe intermittent failure of the left brake master cylinder, which resulted in asymmetric braking and the subsequent loss of directional control during the landing roll.Jun 10, 2016 · N8943Z · Substantial damageNTSB GAA16CA302Accident · No injuriesData collectionFinal reportPiper PA 28 · Rowesville, SCThe fuel line failure between the fuel transducer and the carburetor, which resulted in a total loss of engine power and subsequent forced off airport landing.Jun 9, 2016 · N7355W · Substantial damageNTSB GAA16CA286Accident · No injuriesData collectionFinal reportCessna 172 · Arlington, WAThe failure of the airplane’s right steering rod end, which resulted in the pilot’s inability to maintain directional control.Jun 6, 2016 · N539MT · Substantial damageNTSB CEN16LA219Accident · No injuriesLimited investigationFinal reportFlohr David J R 80 Tiger Moth · Decatur, TXA failure of the electric fuel boost pump, which resulted in fuel starvation and a subsequent total loss of engine power.Jun 6, 2016 · N8CX · Substantial damageNTSB GAA16CA289Accident · No injuriesData collectionFinal reportAmerican AA 1A · Lone Pine, CAThe pilot's incorrect brake and power application during landing, which resulted in a runway overrun, collision with a dirt berm, nose gear collapse, and nose-over.Jun 5, 2016 · N6391L · Substantial damageNTSB GAA16CA280Accident · No injuriesData collectionFinal reportStaudacher S 300 · Prospect Heights, ILThe pilot's incorrect pitch control during the landing, which resulted in a hard bounced landing, and subsequent left main landing gear collapse, a runway excursion, and a collision with a runway sign.Jun 3, 2016 · N126RG · Substantial damageNTSB WPR16LA127Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Seattle, WAThe pilot’s failure to use the emergency procedures checklist for generator failures or for gear extension following a loss of electrical power due to the separated flag terminal of a diode in overstress, which resulted in a gear-up landing.Jun 2, 2016 · N301DM · Substantial damageNTSB ERA16LA200Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Toughkenamon, PAThe student pilot’s inadvertent actuation of the fuel shutoff valve, which led to a total loss of engine power, forced landing, and impact with a hangar. Contributing to the outcome was maintenance personnel’s inadequate inspection of the fuel shutoff system…Jun 1, 2016 · N83547 · Substantial damageNTSB GAA16CA340Accident · No injuriesData collectionFinal reportCessna 172 · Lumberton, NJThe pilot's hard landing, resulting in a runway excursion and substantial damage to the firewall.May 31, 2016 · N7095G · Substantial damageNTSB GAA16CA275Accident · No injuriesData collectionFinal reportCessna 170 · Saginaw, MIThe pilot's exceedance of the critical angle of attack during the landing flare, which resulted in an aerodynamic stall, hard landing, right main landing gear collapse, runway excursion, and nose over.May 30, 2016 · N1441D · Substantial damageNTSB WPR16LA117Accident · No injuriesLimited investigationFinal reportHowell Bob Howell Special · Minden, NVThe failure of the right main landing gear assembly due to overstress fracture.May 27, 2016 · N4393H · Substantial damageNTSB ERA16FA194Accident · 2 fatalField investigationFinal reportJihlavan Airplanes Sro KP 5 ASA · Rhoadesville, VAThe pilots' loss of control that necessitated the activation of the parachute system and the airplane manufacturer's inadequate design of the front parachute anchor attachment structure, which resulted in a failure of the parachute after it was deployed in…May 24, 2016 · N440JM · DestroyedNTSB CEN16LA197Accident · Minor injuriesLimited investigationFinal reportCessna 501 · Texarkana, ARThe pilot's failure to use supplemental oxygen as required during high-altitude flight, which resulted in his loss of consciousness following a loss of cabin pressurization. Contributing to the accident was the separation of the air conditioning system's…May 24, 2016 · N804ST · Substantial damageNTSB WPR16LA122Accident · Minor injuriesLimited investigationFinal reportRans S 5 · Lodi, CAA total loss of engine power due to fuel starvation as the result of a pinched fuel line. Contributing to the accident was the pilot’s maneuvering just before landing, which resulted in the airplane exceeding its critical angle of attack and experiencing an…May 23, 2016 · N481TJ · Substantial damageNTSB ERA16LA191Accident · Minor injuriesLimited investigationFinal reportSikes Zenith CH750 Stol · Lawrenceburg, TNThe pilot's failure to perform an adequate preflight inspection, which resulted in a loss of control due to an improperly-rigged rudder. Contributing to the accident was the pilot's failure to implement and follow proper flight-testing plans.May 22, 2016 · N925PS · Substantial damageNTSB CEN16LA190Accident · No injuriesLimited investigationFinal reportBeech C24R · Marine City, MIThe misalignment of the right main landing gear, which resulted in the failure of the landing gear to retract and extend properly. Also causal was the pilot's failure to have the airplane inspected after a hard landing that had resulted in substantial damage…May 22, 2016 · N20135 · Substantial damageNTSB ERA16FA188Accident · 1 fatalField investigationFinal reportBeech D35 · Sevierville, TNThe pilot's failure to properly configure the landing gear and the pilot's inappropriate decision to abort the landing after the propeller had contacted the runway, which resulted in a loss of thrust and a subsequent loss of control of the airplane.May 19, 2016 · N2967B · Substantial damageNTSB ERA16LA190Accident · No injuriesLimited investigationFinal reportCessna R182 · Lake City, FLInternal failure of the main electrical contactor, which resulted in a complete loss of electrical power and an inability to extend the landing gear through normal means.May 16, 2016 · N9077C · Substantial damageNTSB ERA16FA186Accident · Serious injuriesField investigationFinal reportPiper PA28 · Homestead, FLThe pilot's improper decision to allow the passenger to attempt a landing, which resulted in a loss of control during landing with a quartering tailwind. Contributing to the severity of the pilot's injuries was the separation of the deteriorated shoulder…May 16, 2016 · N7031R · Substantial damageNTSB WPR16FA111Accident · 1 fatalField investigationFinal reportCessna R182 · Altadena, CAThe pilot's failure to maintain clearance from rising mountainous terrain while flying in instrument meteorological conditions. Contributing to the accident was the loss of radio communications for a reason that could not be determined because of the…May 15, 2016 · N133BW · DestroyedNTSB CEN16LA186Accident · No injuriesLimited investigationFinal reportPiper PA 32R · Alpine, TXThe engine’s decreased performance due to high-density altitude conditions and a partially obstructed fuel injector nozzle. Contributing to the pilot's decision to perform an off-field landing was the anomalous high exhaust gas temperature reading.May 15, 2016 · N185DX · Substantial damageNTSB WPR16LA108Accident · Minor injuriesLimited investigationFinal reportCessna 180 · California City, CAA directional upset on landing due to a thermally induced atmospheric disturbance, which the pilot was unable to successfully counter due to improperly set rudder travel limits.May 13, 2016 · N9370C · Substantial damageNTSB GAA16CA243Accident · No injuriesData collectionFinal reportPiper PA-28 · Crystal River, FLThe student pilot's failure to maintain directional control during the takeoff, which resulted in runway excursion and collision with a ditch. Contributing to the accident was the improper flap retraction procedure employed by the pilot during takeoff.May 13, 2016 · N991A · Substantial damageNTSB CEN16LA180Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Lyons Point, LAA total loss of engine power due to debris contamination of the fuel system. Contributing to the accident was the pilot's inadequate preflight inspection.May 11, 2016 · N8362K · Substantial damageNTSB CEN16LA187Accident · No injuriesLimited investigationFinal reportBeech B100 · Dexter, MOA collapse of the right main landing gear for reasons that could not be determined because of the damage to the landing gear system.May 10, 2016 · N86TR · Substantial damageNTSB CEN16LA178Accident · No injuriesLimited investigationFinal reportMooney M20K · Akron, OHA missing bolt in the nose landing gear assembly, which resulted in the airplane suddenly turning left and the pilot's inability to maintain directional control during a crosswind takeoff.May 10, 2016 · N57535 · Substantial damageNTSB GAA16CA226Accident · No injuriesData collectionFinal reportCessna TR182 · Bloomington, INThe pilot's failure to maintain the airplane's descent rate resulting in a hard landing, and subsequent substantial damage to the firewall.May 7, 2016 · N9281R · Substantial damageNTSB WPR16LA101Accident · No injuriesLimited investigationFinal reportAntonov AN2 · San Bernardino, CAThe mechanic’s failure to inspect the fine fuel filter gascolator as required during the most recent inspection, which resulted in a total loss of engine power due to fuel contamination.May 6, 2016 · N2AN · Substantial damageNTSB GAA16CA221Accident · No injuriesData collectionFinal reportStinson 108 · Batavia, OHThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion. Contributing to the accident was the pilot's incorrect brake application during the runway excursion, which resulted in a nose over.May 6, 2016 · N8068K · Substantial damageNTSB ANC16LA022Accident · Serious injuriesLimited investigationFinal reportAirbus AS350 · Juneau, AKThe pilot's failure to maintain terrain clearance while on approach to land in flat light conditions. Contributing to the severity of the pilot's injuries was the inadequately restrained internal cargo, which shifted forward during the impact and struck the…May 5, 2016 · N194EH · Substantial damageNTSB ERA16FA176Accident · 3 fatalField investigationFinal reportBeech V35 · Syosset, NYThe pilot's loss of airplane control while operating in instrument meteorological conditions with only a partial instrument panel due to a failure of the airplane's vacuum pump. Contributing to the accident were the pilot's spatial disorientation and the…May 3, 2016 · N440H · DestroyedNTSB ANC16LA024Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe overstress fracture and subsequent separation of the left main landing gear axle due to a hard landing, which resulted in the pilot’s inability to maintain directional control of the airplane.May 3, 2016 · N6479X · Substantial damageNTSB CEN16LA184Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Ponca City, OKMaintenance personnel's improper installation of the elevator bolt, which resulted in a loss of elevator control during landing.May 1, 2016 · N8619G · Substantial damageNTSB ERA16LA177Accident · No injuriesLimited investigationFinal reportMaher Daniel J Velocity · Worcester, MAThe overstress failure of the nose landing gear fork assembly.Apr 30, 2016 · N7044Q · Substantial damage