NTSB investigations
996 cases where the sequence of events included Sys/Comp malf/fail (non-power).
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '330' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '330' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA20LA259Accident · No injuriesClass 3 · LimitedFinal reportBeech 400 · Montgomery, ALLanding with the left main landing gear retracted due to the failure of the landing gear control unit, which resulted in substantial damage.NTSB WPR20LA226Accident · No injuriesClass 3 · LimitedFinal reportBoeing B75 · Chino, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN20LA263Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Eveleth, MNThe seizure of the airplane’s engine-driven fuel pump due to internal contamination, which led to a total loss of engine power. The source of the contamination could not be determined based on available evidence.NTSB ERA20LA237Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Titusville, FLThe loss of directional control during landing due to the fracture of the steering horn bolts, which rendered the nosewheel steering ineffective and resulted from the airplane being towed over the left turn limits at an undetermined time before the accident.NTSB GAA20WA115Incident · No injuriesForeign investigationBeech 900XP · Paris, FranceThe government of France has notified the NTSB of an accident involving a BEECH 900XP airplane that occurred on June 26, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB ERA20CA200Accident · No injuriesClass 4 · Data collectionFinal reportVans RV8 · Hampton, GAA right main landing gear break malfunction during landing. Contributing to the accident was a worn right main landing gear caliper pin and pressure plate hole.NTSB ERA20LA192Accident · No injuriesClass 3 · LimitedFinal reportBeech F90 · Knoxville, TNA failure of the left main landing gear scissors, which resulted in a landing gear collapse following a precautionary landing with the landing gear in an intermediate position..NTSB CEN20LA179Accident · 1 fatalClass 3 · LimitedFinal reportCessna P210 · Burlington, WIThe pilot did not maintain a safe altitude during the visual approach, and subsequently lost control which resulted an impact with trees and terrain.NTSB CEN20LA175Accident · No injuriesClass 3 · LimitedFinal reportBeech 1900 · San Antonio, TXThe failure of the left main landing gear upper drag leg arm due to substandard mechanical properties, which resulted in a collapse of the landing gear upon landing.NTSB ERA20CA130Accident · No injuriesData collectionFinal reportCessna 172 · West Palm Beach, FLThe failure of the nosewheel steerage linkage during takeoff, which resulted in a loss of directional control and impact with an obstacle during an attempted aborted landing.NTSB CEN20CA114Accident · No injuriesData collectionFinal reportVans RV8 · Harrison, OHThe malfunction of the steerable tailwheel, which resulted in a loss of directional control during the landing roll and subsequent impact with the precision approach path indicator lights system.NTSB WPR20LA104Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · San Jose, CAThe failure to properly service the hydraulic power pack prevented a normal landing gear extension. Contributing to the accident was the failure of the landing gear emergency release valve to function properly for reasons that could not be determined based on…NTSB DCA20WA094Incident · No injuriesForeign investigationBoeing 737 · Monterrey, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on February 27, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13.All…NTSB ERA20CA100Accident · No injuriesData collectionFinal reportCessna 402 · Barnstable, MAThe pilot's failure to properly secure the crew hatch door before takeoff, which resulted in the door’s forward hinge assembly tearing from its fuselage mount point.NTSB CEN20CA079Accident · No injuriesData collectionFinal reportAir Tractor AT-504 · Fort Morgan, COThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in the left main landing gear tire bursting and the tailwheel assembly failing.NTSB WPR20WA106Incident · No injuriesForeign investigationAerospatiale AS350 · Bankstown Aerodrome, AustraliaThe government of Australia has notified the NTSB of an accident involving a Aerospatiale AS350 helicopter that occurred on February 05, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under…NTSB ERA20CA103Accident · No injuriesData collectionFinal reportPiper PA28RT · Fort Myers, FLThe fracture of the right main landing gear torque link bolt on landing, which resulted in the landing gear assembly rotating freely, the subsequent loss of directional control, and the landing gear collapsing.NTSB CEN20LA069Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Woody Creek, COWater trapped in the static system, which resulted in incorrect airspeed display information and the pilot’s forced landing.NTSB ERA20LA077Accident · No injuriesClass 3 · LimitedFinal reportVelocity Elite RG · St. Petersburg, FLA failure of the propeller pitch change electric motor, which resulted in an improper setting for takeoff and a subsequent runway overrun. Also causal was the inadequate maintenance and inspection of the propeller system and the pilot’s failure to follow the…NTSB ANC20LA013Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Fairbanks, AKThe improper installation of a hydraulic line at the right main landing gear (MLG) unlock actuator, which resulted in a total loss of system hydraulic pressure and failure of the landing gear to extend. Contributing to the accident was the failure of the…NTSB ERA20FA068Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Newborn, GAThe pilot’s impairment/incapacitation from carbon monoxide poisoning due to a degraded muffler. Contributing to the accident was the pilot’s failure to properly maintain the airplane.NTSB ERA20LA070Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210 · Concord, NCA malfunction of the left main landing gear brake during landing for undetermined reasons. Contributing was the pilot’s failure to attain a proper touchdown point and maintain an appropriate approach speed while landing on the wet turf runway.NTSB DCA20WA044Incident · No injuriesForeign investigationBoeing 737 · Manchester, United KingdomThe AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO…NTSB ERA20CA036Accident · Minor injuriesData collectionFinal reportPiper PA32 · Venice, FLA stuck brake caliper, which overheated while the pilot was taxiing the airplane, caught fire, and subsequently destroyed the airplane.NTSB ENG20IA005Incident · No injuriesClass 3 · IncidentFinal reportAgusta A109 · Penobscot, MEFatigue fracture of the main rotor blade tip cap leading edge and subsequent partial separation of the tip cap, resulting in increased vibrations in the main rotor.NTSB WPR20LA012Accident · No injuriesClass 3 · LimitedFinal reportCzech Sport Sportcruiser · Holden, UTThe fatigue failure of the No. 2 cylinder intake valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power. Contributing to the severity of the damage was the improper deployment of the ballistic…NTSB ERA20LA008Accident · No injuriesClass 3 · LimitedFinal reportRaytheon Hawker · Fort Myers, FLMaintenance personnel's improper installation of the nose landing gear assembly, which resulted in separation of the actuator arm and the failure of a nose landing gear to lock in place.NTSB CEN19TA333Accident · No injuriesClass 3Final reportLancair Lancair 320 · Bolivar, MOInadequate maintenance of the airplane, which resulted in a lack of adequate hydraulic fluid, malfunction of the landing gear extension system, and the landing gear collapse on landing.NTSB ERA19LA268Accident · Minor injuriesClass 3 · LimitedFinal reportBeech K35 · St. Augustine, FLAn unintended brake application of the right main landing gear brake system during the landing rollout due to excessive play between the brake caliper anchor bolts and their bushings.NTSB CEN19LA313Accident · No injuriesClass 3 · LimitedFinal reportJackson Velocity · Mack, COA propeller overspeed due to failure of the electronic ignition timing ring attachment screws, and a runway overrun during the subsequent forced landing.NTSB CEN19LA292Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Denver, COA total loss of electrical power for reasons that could not be determined, and the student pilot’s subsequent runway overrun during a no-flap landing.NTSB ERA19LA255Accident · No injuriesClass 3 · LimitedFinal reportCessna 310 · Tampa, FLThe failure of the right main landing gear to fully extend and lock for reasons that could not be determined.NTSB WPR19LA237Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · Eugene, ORThe failure of the landing gear electric motor to shut off after landing gear retraction, which resulted in the motor overheating, burning out, and producing smoke in the cockpit. The pilot’s decision to land with the landing gear retracted resulted in…NTSB WPR19LA220Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Phoenix, AZThe failure of the landing gear due to the nose gear being positioned to the far right during retraction, which caused the nose gear to jam upon retraction.NTSB ERA19LA239Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Chattanooga, TNThe improper maintenance of the airplane’s landing gear system, which resulted in a hydraulic fluid leak and insufficient pressure to extend and lock the landing gear during the accident flight.NTSB CEN19LA246Accident · No injuriesClass 3 · LimitedFinal reportSwearingen SA227 · El Paso, TXFailure of the left main landing gear to fully extend due to a lack of hydraulic fluid and during emergency extension procedures, which resulted in the collapse of the landing gear during landing and the subsequent runway excursion and collision with a sign.NTSB CEN19LA240Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Blair, NEThe failure of the lower actuator bearing support bracket, which resulted in the misalignment of the clutch actuator, the loss of belt tension on the main rotor drive system, and the subsequent forced landing on sloped terrain.NTSB ANC19LA049Accident · No injuriesClass 3 · LimitedFinal reportCessna A185 · Talkeetna, AKA fracture of the right outboard landing gear bracket for undetermined reasons.NTSB WPR19LA195Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Hurricane, UTMaintenance personnel's improper installation of a throttle cable to the throttle body arm, which resulted in a throttle detachment during takeoff and subsequent loss of power. Contributing to the accident was the inadequate inspection of the throttle…NTSB CEN19LA187Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Danbury, TXA failed electrical relay, which provided an improper indication of a governor and clutch problem, which resulted in the pilot conducting a precautionary landing during which he failed to maintain sufficient main rotor speed.NTSB ERA19FA201Accident · 2 fatalClass 2 · FieldFinal reportBeech E55 · Hope Mills, NCThe pilot's failure to disengage an uncommanded nose-down pitch input. Contributing to the accident was improper maintenance of the pitch trim servo, which would have precluded a physical override of the pitch servo.NTSB ENG19WA039Accident · Minor injuriesForeign investigationAtr ATR42 · Manaus, BrazilThe government of Brazil has notified the NTSB of an accident involving a ATR 42-300 airplane that occurred on June 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB CEN19LA168Accident · No injuriesClass 3 · LimitedFinal reportRockwell 690 · Jacksonville, FLThe overstress fracture of the roll pin in the nose landing gear (NLG) spacer assembly which caused interference between the nose wheel actuator rod and the left forward gear door actuating rods preventing the NLG to fully extend into the full down and locked…NTSB DCA19WA162Incident · No injuriesForeign investigationBoeing 737 · Singapore, SingaporeThe Singapore Ministry of Transport (MOT) has notified the NTSB of an incident involving a Boeing 737, which occurred on June 5, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the investigation under the provisions of ICAO Annex 13 as…NTSB WPR19WA156Accident · 2 fatalForeign investigationCessna T210 · Mount Isa, AustraliaOn May 26, 2019, at 0547 coordinated universal time, a Cessna T210M, registration VH-SUX, collided with terrain during a surveying flight near Mount Isa, Queensland, Australia. The two crew were fatally injured, and the airplane sustained substantial…NTSB CEN19LA142Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA44 · Centralia, ILThe failure of the nose landing gear to extend for reasons that could not be determined based on the available information.NTSB WPR19LA141Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Boulder City, NVThe pilot’s improper monitoring and failure to maintain airspeed during a critical phase of flight, which resulted in an exceedance of the airplane’s critical angle of attack, an aerodynamic stall, and subsequent impact with terrain.NTSB CEN19FA100Accident · 1 fatalClass 2 · FieldFinal reportCessna 421 · Plain City, OHA loss of airspeed indication due to icing of the airplane's pitot probe, and the pilot's loss of control while maneuvering.NTSB ERA19LA194Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Mount Holly, NJFailure of the pilot's seat back due to a sheared bolt during the landing roll, which resulted in a loss of directional control and runway excursion.NTSB ERA19FA118Accident · 1 fatalClass 3 · FieldFinal reportHughes 369 · Talking Rock, GAA fatigue failure of the overrunning clutch subassembly due to abnormal bending loads due to cracks on the center engine mount, which resulted in an inflight loss of power. Contributing to the accident was the helicopter's low altitude and airspeed when the…