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.
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
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 ERA23LA059Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA-1A · Sparta, TNA total loss of engine power due to an accumulation of carburetor ice, resulting in an off-airport landing and substantial damage to the airplane.NTSB ERA23LA064Accident · No injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Athens, GAThe operator’s and the pilot’s continued operation of the airplane with a known electrical problem, resulting in a loss of electrical power and a gear-up landing.NTSB CEN23LA025Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Greenville, ILThe mechanic’s failure to inspect and clean the entire fuel nozzle assembly in accordance with the engine maintenance manual, which resulted in fuel starvation and a partial loss of engine power, an autorotation, and a hard landing.NTSB ERA23LA053Accident · Minor injuriesClass 4 · LimitedFinal reportSchmidt Randall M Bushby Mustang II · Statesboro, GAA total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the likely inaccurate right fuel quantity indicating system.NTSB ERA23FA045Accident · 2 fatalClass 3 · FieldFinal reportBearhawk Patrol · Hanover Township, PAThe pilot’s decision to unlatch his seatbelt during flight, which allowed him to exit the airplane and impact the tail, resulting in a loss of control and impact with terrain.NTSB ERA23LA167Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Winter Haven, FLThe pilot’s failure to properly secure the rear seat headset, resulting in an obstruction of the airplane’s rudder controls.NTSB WPR23LA022Accident · Serious injuriesClass 3 · LimitedFinal reportBeech V35B · Nogales, AZThe pilot’s failure to establish a positive rate of climb before retracting the landing gear when he executed an aborted landing, which resulted in a propeller strike, diminished climb performance, and the inadvertent contact with terrain.NTSB WPR23LA021Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Georgetown, CAThe pilot’s failure to maintain control during an attempted go-around, which resulted in a runway excursion and a separation of the right main landing gear.NTSB WPR23LA017Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177RG · Mesa, AZThe failure of maintenance personnel to properly secure the fuel supply line to the fuel flow divider, which resulted in a fuel leak, fuel exhaustion, and a total loss of engine power.NTSB ERA23FA023Accident · 2 fatalClass 3 · FieldFinal reportPeryera Adventura II · Miramar, FLThe pilot’s failure to remove the ECU select switch per the manufacturer’s service bulletin, which resulted in a loss of engine power.NTSB CEN23LA014Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 62 · Dallas, TXA total loss of airplane electrical power for undetermined reasons, which resulted in a complete loss of engine power to both engines. Contributing was the worn main battery and the incorrectly wired ECU backup batteries.NTSB CEN23LA012Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Paola, KSThe pilot’s improper positioning of the fuel selector, which resulted in fuel starvation and a loss of engine power during a departure climb.NTSB WPR23LA012Accident · No injuriesClass 3 · LimitedFinal reportCessna T210L · Marana, AZA failure of a retaining ring in the airplane’s left main landing gear door actuator and the subsequent complete loss of hydraulic fluid, which resulted in a gear-up landing.NTSB CEN23LA009Accident · Minor injuriesClass 4 · LimitedFinal reportYates Mike E Roaring Eagle · Stanwood, IAThe pilot’s exceedance of the airplane’s critical angle of attack in the traffic pattern, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover. Contributing to the accident was the partial loss of engine…NTSB ERA23LA009Accident · Minor injuriesClass 3 · LimitedFinal reportSwensen Fisher Celebrity · Greensboro, NCThe pilot/mechanic’s failure to remove excess sealant from the header fuel tank after recent maintenance, which resulted in fuel starvation to the engine and a loss of engine power. Contributing to the accident was the pilot’s inflight decision making…NTSB ANC23FA001Accident · 1 fatalClass 3 · FieldFinal reportCessna A185F · Fairbanks, AKThe improperly maintained floats, which allowed water to fill the front compartments and resulted in the airplane nosing over during taxi. Contributing to the fatal injury of the pilot was the improperly secured cargo, which prevented the pilot from egressing…NTSB WPR23LA033Accident · No injuriesClass 4 · LimitedFinal reportRaytheon A36 · Freeport, ILThe pilot’s failure to extend the landing gear.NTSB CEN23LA003Accident · No injuriesClass 3 · LimitedFinal reportEmbraer S A EMB-545 · Houston, TXThe crew failed to ensure the main entry door was locked before departure. Contributing to the accident was a corroded/jammed door sensor that provided an erroneous locked indication to the crew alerting system.NTSB ERA23LA002Accident · Serious injuriesClass 4 · LimitedFinal reportAeronca 7AC · Murray, KYThe incorrect (reverse) rigging of the elevator cables by maintenance personnel and their subsequent failure to verify that the rigging was correct during post-maintenance checks and the pilot's inadequate preflight check.NTSB WPR22LA365Accident · Minor injuriesClass 4 · LimitedFinal reportMary Alexander JA30 Superstol · Groveland, CAThe pilot's excessive application of brake during an attempt to avoid wildlife while taxing resulted in a nose over.NTSB WPR22FA361Accident · 1 fatalClass 3 · FieldFinal reportGrumman American Avn. AA-5B · Sahuarita, AZThe pilot's loss of control following a separation of the aileron carry-through cable.NTSB WPR22LA357Accident · No injuriesClass 3 · LimitedFinal reportVashon Ranger R7 · Glendale, AZFailure of the landing gear due to material deficiencies that reduced the strength of the landing gear.NTSB CEN22LA434Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · McGregor, TXThe flight crew’s failure to ensure the landing gear was down which resulted in a gear up landing and subsequent runway excursion.NTSB ERA22LA434Accident · No injuriesClass 3 · LimitedFinal reportCessna 414 · Augusta, GAThe failure of the nose landing gear to fully extend and lock into position for reasons that could not be determined, which resulted in its collapse during landing.NTSB WPR22LA355Accident · Minor injuriesClass 4 · LimitedFinal reportHartunian Robert Pulsar XP · Big Bear, CAThe pilot’s inability to maintain directional control after landing with an excessive ground speed due to a tailwind which, resulted in a severe shimmy which subsequently damaged a hydraulic brake line.NTSB ANC22LA080Accident · 1 fatalClass 3 · LimitedFinal reportCessna 180A · Skwentna, AKThe failure of the landing gear float due to inadequate maintenance of the floats and corrosion.NTSB CEN22LA430Accident · No injuriesClass 3 · LimitedFinal reportAgusta AW139 · Houma, LAThe inflight loss of collective control of the helicopter due to thermal damage of a collective control torque tube that abraded with misrouted electrical wiring, which resulted in an electrical short and inflight fire. Contributing to the accident were the…NTSB DCA22LA212Incident · No injuriesClass 3 · LimitedFinal reportAirbus A330-243 · Los Angeles, CAUncommanded movement of the trimmable horizontal stabilizer control wheel for reasons that could not be determined based on the available evidence.NTSB WPR22LA353Accident · No injuriesClass 3 · LimitedFinal reportCessna 525B · Pasco, WAThe failure of the pilot to ensure the landing gear was extended before landing. Contributing was the pilot’s failure to fly a stabilized approach, and his configuration of the airplane that prevented activation of the landing gear not extended warning system…NTSB ANC22LA079Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Tok, AKThe pilot’s improper application of the brakes, which resulted in a nose-over and substantial damage to the rudder and wings.NTSB ANC22LA077Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Anchorage, AKThe pilot’s inadvertent application of the brakes during the landing roll, which resulted in a nose-over and substantial damage to the rudder and wings.NTSB CEN22LA427Accident · No injuriesClass 3 · LimitedFinal reportCessna A188A · Canby, MNThe pilot’s failure to maintain airplane control during the landing, which resulted in an overload failure of the tailwheel cross tube and subsequent impact with the runway.NTSB ERA22FA405Accident · 1 fatalClass 3 · FieldFinal reportBeech 95-B55 · Hartwell, GAThe pilot’s spatial disorientation and subsequent loss of airplane control following a perceived undetermined problem with the airplane’s gyroscopic instrumentation.NTSB WPR22LA341Accident · No injuriesClass 3 · LimitedFinal reportCessna 750 · Mesa, AZThe pilot’s improper decision to depart on the accident flight with a known hydraulic leak, resulting in an in-flight hydraulic system failure, and the pilot’s attempt to land during an unstabilized approach, which resulted in a loss of control during the…NTSB CEN22LA407Accident · No injuriesClass 4 · LimitedFinal reportBeech 36 · Tupelo, MSThe pilot’s failure to extend the landing gear for a landing.NTSB DCA22MA193Accident · 10 fatalClass 1 · MajorFinal reportDehavilland DHC-3 · Freeland, WAThe in-flight unthreading of the clamp nut from the horizontal stabilizer trim actuator barrel due to a missing lock ring, which resulted in the horizontal stabilizer moving to an extreme trailing-edge-down position rendering the airplane’s pitch…NTSB WPR22LA337Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 180 · Seeley Lake, MTThe loss of engine power due to fuel starvation as a result of unporting of the fuel.NTSB CEN22FA405Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR22 · Tomball, TXThe flight instructor’s inadequate supervision of the flight, which allowed for an unintentional movement of the mixture control to the cutoff position that remained unnoticed until the airplane lost engine power due to fuel starvation and descended below the…NTSB ERA22LA396Accident · No injuriesClass 4 · LimitedFinal reportNavion Navion · Newburyport, MAThe pilot’s excessive application of brakes while landing, which resulted in a nose gear collapse.NTSB WPR22LA323Accident · No injuriesClass 3 · LimitedFinal reportCessna 182K · Tooele, UTLoss of brake pressure to both sets of brakes during taxi due to failed brake caliper O-ring seals, which resulted in a loss of directional control.NTSB WPR22LA318Accident · No injuriesClass 4 · LimitedFinal reportLeon E Everett Carbon CUB EX · Maricopa, AZThe pilot's failure to maintain airplane control during landing with a crosswind and the use of excessive braking application, which resulted in a nose over.NTSB CEN22LA396Accident · Minor injuriesClass 4 · LimitedFinal reportJavron Experimental PA18 Replica · Osceola, IAThe stuck right brake at landing which resulted in a loss of control.NTSB WPR22LA322Accident · Minor injuriesClass 3 · LimitedFinal reportRay E Roberts Kitfox V Vixen · Caldwell, IDThe partial loss of engine power due to a loose wire leading to the engine’s electronic control unit (ECU). Contributing was the pilot’s exceedance of the critical angle of attack while maneuvering, which resulted in an aerodynamic stall at an altitude too…NTSB ERA22LA415Accident · No injuriesClass 4 · LimitedFinal reportCessna T210N · Georgetown, DEThe pilot's failure to extend the landing gear before landing. Contributing to the accident was an inoperative landing gear warning horn.NTSB WPR22LA324Accident · No injuriesClass 3 · LimitedFinal reportChampion 7GCBA · Athol, IDThe failure of the right brake due to a disconnected master cylinder piston rod, which led to the departure of the airplane from the runway surface. Contributing to the accident was the mechanic’s failure to adequately inspect the connection between the…NTSB WPR22LA313Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-30 · St Ignatius, MTA partial loss of power during takeoff for undetermined reasons.NTSB ERA22LA382Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7AC · Clermont, FLThe pilot’s inability to maintain directional control while landing due to a worn tailwheel locking mechanism, which resulted in a runway excursion and collision with terrain.NTSB ERA22LA408Accident · No injuriesClass 4 · LimitedFinal reportMooney M20E · Hollywood, MDThe pilot's failure to extend the landing gear before landing.NTSB WPR22LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Avalon, CAThe pilot’s failure to extend the landing gear before landing, resulting in a gear up landing and substantial damage to the airplane’s belly.NTSB WPR22FA298Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Blyn, WAThe pilot’s continued operation of the airplane with known mechanical malfunctions with the flight displays, and his continued flight into instrument meteorological conditions, which resulted in an inflight collision with terrain while maneuvering.