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 WPR22FA094Accident · Minor injuriesClass 3 · FieldFinal reportDassault Mirage F1 CR · Glendale, AZA loss of engine power due to fuel exhaustion as result of the failure of maintenance personnel to ensure the airplane was serviced with the correct amount of fuel, the failure of maintenance personnel and the pilot to adequately check the airplane’s…Feb 10, 2022 · N633AX · DestroyedNTSB WPR22LA093Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Chemehuevi Valley, CAThe student pilot’s loss of directional control during takeoff.Feb 8, 2022 · N6496L · Substantial damageNTSB ENG22FA009Incident · No injuriesClass 3 · FieldFinal reportBoeing 737-8K2 · Las Vegas, NVThe fatigue failure of the right main landing gear initiated by liquid metal embrittlement by cadmium at arc burn locations in the outer cylinder tooling hole area. The arc burns were likely the result of operator error during stylus cadmium plating…Feb 4, 2022 · N817SY · Minor damageNTSB ERA22LA121Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 46-350P · Crystal River, FLCollapse of the nose wheel landing gear assembly due to lateral loads encountered on the turf runway during rollout.Feb 1, 2022 · N35CM · Substantial damageNTSB CEN22LA114Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Cook, MNThe pilot’s failure to ensure the snow-covered takeoff area was safe, which resulted in a collision with ice and subsequent landing gear damage.Jan 29, 2022 · N2923E · Substantial damageNTSB WPR22LA088Accident · No injuriesClass 3 · LimitedFinal reportExtra Flugzeugbau EA 300/L · Phoenix, AZThe failure of the right brake due to the separation of the brake pad from the brake assembly. Also causal was the improper maintenance of the airplane, which resulted in the use of a brake pad that was inappropriate for the airplane make and model.Jan 13, 2022 · N203EX · Substantial damageNTSB WPR22LA076Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172H · Los Angeles, CAThe pilot’s inadequate preflight inspection during which he failed to remove all water contamination in the fuel system, which resulted in a total loss of engine power on takeoff. Contributing to the accident was the condition of the fuel caps, which allowed…Jan 9, 2022 · N8056L · Substantial damageNTSB CEN22LA102Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Grand Forks, NDFailure of the landing gear to properly extend before landing for reasons that could not be determined.Jan 2, 2022 · N5844P · Substantial damageNTSB CEN22FA081Accident · 2 fatalClass 3 · FieldFinal reportCessna 208 · Fulshear, TXThe limitations of the see-and-avoid concept as a method for self-separation of aircraft, which resulted in an inflight collision. Contributing to the accident was the absence of collision avoidance technology on both aircraft.Dec 21, 2021 · N1116N · 2 aircraft · DestroyedNTSB CEN22LA083Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Houston, TXThe instructed pilot and the flight instructor’s failure to extend the landing gear before landing resulting in a wheels up landing.Dec 16, 2021 · N19VS · Substantial damageNTSB CEN22LA079Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Ellinwood, KSThe pilot's improper brake application during the landing roll, which resulted in a nose-over.Dec 13, 2021 · N1616K · Substantial damageNTSB CEN22LA072Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL18 · Abbeville, LAAn electrical fire for reasons that could not be determined.Dec 12, 2021 · N1477D · DestroyedNTSB WPR22LA061Accident · 1 fatalClass 3 · LimitedFinal reportMoul Willis RV-3 · Bermuda Dunes, CAThe pilot’s improper positioning of the fuel shutoff valve, which resulted in a loss of engine power, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack, resulting in an aerodynamic stall and loss of control.Dec 11, 2021 · N9YY · Substantial damageNTSB ERA22FA085Accident · 2 fatalClass 3 · FieldFinal reportBeech V35 · Crab Orchard, KYThe noninstrument-rated pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control and collision with terrain. Contributing to the accident was…Dec 10, 2021 · N5704V · Substantial damageNTSB WPR22LA086Accident · No injuriesClass 4 · LimitedFinal reportCessna 310Q · Corona, CAThe pilot receiving instruction failure to extend the landing gear before landing due to distraction and the flight instructor’s inadequate supervision.Dec 7, 2021 · N310CC · Substantial damageNTSB CEN22LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Tahlequah, OKA loss of yaw control while on final approach, which resulted in the pilot performing an off-runway landing, and a subsequent nose over. The reason for the loss of yaw control could not be determined based on the available evidence.Dec 3, 2021 · N3372A · Substantial damageNTSB WPR22LA058Accident · No injuriesClass 4 · LimitedFinal reportCessna 510 · Havasu, AZThe pilot's failure to extend the landing gear during landing. Contributing to the accident was the pilot’s failure to use a pre-landing checklist.Dec 1, 2021 · N81CB · Substantial damageNTSB CEN22LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-46-310P · Cassville, MOThe pilot’s failure to reinstall the nose landing gear linkage prior to the flight which resulted in a loss of directional control during landing.Dec 1, 2021 · N444DT · Substantial damageNTSB ERA22LA094Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C · Kissimmee, FLThe pilot’s inadvertent application of brakes during touchdown, which resulted in a noseover.Nov 30, 2021 · N656CJ · Substantial damageNTSB ERA22LA080Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-12 · Labelle, FLThe pilot’s improper fuel system modification, which resulted in a loss of engine power due to fuel exhaustion.Nov 30, 2021 · N3098M · Substantial damageNTSB WPR22LA075Accident · Serious injuriesClass 4 · LimitedFinal reportSchulze Erwin E JR SHA Glasair SH-2R · Santa Paula, CAThe pilot’s failure to extend the landing gear before landing.Nov 28, 2021 · N64DS · Substantial damageNTSB WPR22LA063Accident · No injuriesClass 4 · LimitedFinal reportBeech 200 · Eugene, ORThe pilot’s improper checklist use, which resulted in an electrical malfunction and subsequent gear up landing.Nov 28, 2021 · N71VT · Substantial damageNTSB ANC22LA008Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Palmer, AKThe pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power, off-airport landing, and nose over.Nov 26, 2021 · N1380A · Substantial damageNTSB WPR22FA048Accident · 1 fatalClass 3 · FieldFinal reportZenith Zodiac CH601XL · Temecula, CAThe failure of the airplane’s canopy latch system, which resulted in the canopy opening in flight and a loss of airplane control. Contributing to the accident was the lack of a secondary canopy latch as recommended by the kit manufacturer.Nov 23, 2021 · N601KS · DestroyedNTSB WPR22LA047Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Puyallup, WAAn overstress fracture of the left main landing gear pivot assembly, which resulted in the failure of the left main landing gear to fully extend and lock into place.Nov 22, 2021 · N7592Y · Substantial damageNTSB ANC22LA007Accident · No injuriesClass 3 · LimitedFinal reportCessna 207A · Bethel, AKThe improper installation of an avionics wire harness over a fuel line, which resulted in chafing of the wire harness, arcing, and a subsequent fire.Nov 21, 2021 · N9794M · Substantial damageNTSB CEN22LA038Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-160 · West Union, OHA malfunction of the flight controls for reasons that could not be determined based on available information.Nov 15, 2021 · N3463Z · Substantial damageNTSB ERA22LA066Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · St. Petersburg, FLThe pilot’s inadvertent selection of an off fuel selector position, which resulted in a total loss of engine power due to fuel starvation.Nov 12, 2021 · N5862W · Substantial damageNTSB ENG22LA004Occurrence · No injuriesClass 3 · LimitedFinal reportBeech F33 · Bellefontaine, OHThe internal failure of the autopilot pitch servo actuator that caused the autopilot to command a nose down movement of the pitch trim.Nov 12, 2021 · N9035Q · Minor damageNTSB ERA22FA047Accident · 1 fatalClass 3 · FieldFinal reportPiper PA30 · Rock Hill, SCThe pilot’s exceedance of the airplane's critical angle of attack while troubleshooting a landing gear indication, which resulted in an aerodynamic stall at low altitude.Nov 5, 2021 · N8924Y · Substantial damageNTSB WPR22FA022Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Ukiah, CAA power interruption due to water-contaminated fuel, which resulted in the student pilot aborting the takeoff and landing hard. Contributing to the accident were a leak in the left fuel tank that allowed water to enter and damage to the fuel tank that…Oct 28, 2021 · N1870V · Substantial damageNTSB ERA22LA040Accident · No injuriesClass 4 · LimitedFinal reportJack A Frohbieter Questair Venture · Robbinsville, NJThe pilot’s failure to extend the landing gear prior to landing, which resulted in substantial damage to the lower fuselage. Contributing to the accident was the pilot’s failure to utilize the aircraft checklist.Oct 28, 2021 · N281F · Substantial damageNTSB CEN22FA021Accident · 1 fatalClass 3 · FieldFinal reportBeech B36TC · Lena, WIImpairment and subsequent incapacitation of the pilot for reasons that could not be determined. The incapacitation resulted in a loss of engine power due to fuel starvation. Likely contributing was pilot hypoxia due to altitude exposure, possibly worsened by…Oct 27, 2021 · N75RM · Substantial damageNTSB ERA22LA028Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Sligo, PAA total loss of engine power due to fuel exhaustion as a result of the pilots mismanagement of fuel.Oct 23, 2021 · N7371P · Substantial damageNTSB DCA22LA015Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer S A ERJ 170-200 LR · Miami, FLAn abrupt jerk of the airplane as the captain applied the parking brake during the tow that caused a flight attendant to fall and break her wrist.Oct 23, 2021 · N252NN · No damageNTSB WPR22FA021Accident · 1 fatalClass 3 · FieldFinal reportCessna 150L · Dunsmuir, CAThe non-certificated pilot’s improper decision to continue the flight under visual flight rules into instrument meteorological conditions which resulted in controlled flight into terrain.Oct 20, 2021 · N5268Q · Substantial damageNTSB CEN22LA018Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Dallas, TXA temporary loss of engine power during the takeoff due to a damaged fuel pump, which resulted in a forced landing and a runway excursion. The source of the damage to the fuel pump could not be determined.Oct 20, 2021 · N1235U · Substantial damageNTSB DCA22MA009Accident · Serious injuriesClass 2 · MajorFinal reportMcdonnell Douglas DC-9-87 (MD-87) · Brookshire, TXThe jammed condition of both elevators, which resulted from exposure to localized, dynamic high wind while the airplane was parked and prevented the airplane from rotating during the takeoff roll. Also causal was the failure of Everts Air Cargo, the pilots’…Oct 19, 2021 · N987AK · DestroyedNTSB ERA22LA020Accident · No injuriesClass 4 · LimitedFinal reportMooney M20C · Lynchburg, VAThe uncommanded landing gear retraction following a hard landing for reasons that could not be determined.Oct 17, 2021 · N669GJ · Substantial damageNTSB WPR22LA015Accident · Serious injuriesClass 3 · LimitedFinal reportWsk-Mielec AN-2TD · Wilton, CAThe pilot’s inability to control the airplane’s pitch during departure for reasons that could not be determined because of the extensive fragmentation and thermal damage the airplane sustained in the accident sequence.Oct 14, 2021 · N857PF · Substantial damageNTSB ERA22FA015Accident · 1 fatalClass 3 · FieldFinal reportVelocity SE RG · Titusville, FLThe separation of the airplane’s elevator control push-pull tube, which resulted in a loss of control during the approach.Oct 14, 2021 · N755V · DestroyedNTSB WPR22LA014Accident · No injuriesClass 3 · LimitedFinal reportAvid Mark IV · Payette, IDA total loss of engine power during cruise flight due to fuel starvation. Contributing to the accident was the lack of an outlet screen on the fuel system header tank.Oct 13, 2021 · N583DM · Substantial damageNTSB CEN22FA011Accident · 1 fatalClass 3 · FieldFinal reportBeech 58TC · Mesa, COThe maintenance personnel’s failure to properly tighten the turbocharger oil line and the right engine propeller governor, which resulted in a loss of engine power. Contributing to the accident was the loss of airplane control following the loss of engine…Oct 11, 2021 · N6748V · DestroyedNTSB ERA22LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Statesboro, GAThe student pilot’s failure reduce power and apply sufficient braking after landing, which resulted in a runway excursion and impact with objects and terrain.Oct 9, 2021 · N8592B · Substantial damageNTSB ERA22LA007Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 429 · Batavia, NYThe pilot’s failure to disengage the autopilot prior to climbing out of a fog bank.Oct 7, 2021 · N505TJ · Substantial damageNTSB ERA22LA005Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Columbia, SCA failure of the landing gear hydraulic power pack for reasons that could not be determined.Oct 5, 2021 · N6318B · Substantial damageNTSB ERA22FA004Accident · 2 fatalClass 3 · FieldFinal reportDassault Falcon 20 · Thomson, GAThe flight crew’s continuation of an unstable dark night visual approach and the captain’s instruction to use air brakes during the approach contrary to airplane operating limitations, which resulted in a descent below the glide path, and a collision with…Oct 5, 2021 · N283SA · DestroyedNTSB CEN22LA004Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 195 · Watkins, COThe separation of the left main landing gear spring during landing roll due to a preexisting fatigue crack.Oct 4, 2021 · N3027B · Substantial damageNTSB WPR22LA003Accident · No injuriesClass 4 · LimitedFinal reportInterstate S-1A · Independence, ORThe separation of the left rudder pedal interconnect cable during takeoff, which resulted in the student pilot’s inability to maintain directional control.Oct 2, 2021 · N37317 · Substantial damageNTSB ERA22LA038Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C 200 · Riverhead, NYThe pilot's excessive braking during landing which resulted in a noseover and substantial damage.Oct 2, 2021 · N199B · Substantial damage