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 CEN11LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Durango, COA total loss of engine power due to the pilot inadvertently moving the fuel selector to the OFF position. Contributing to the accident was the pilot's unfamiliarity with this model accident airplane.Oct 3, 2010 · N2593 · Substantial damageNTSB ERA11LA011Accident · No injuriesLimited investigationFinal reportGrumman G164 · Edison, GALeakage of hydraulic fluid from the internal fuselage line fitting, resulting in a subsequent loss of the right brake’s effectiveness.Oct 1, 2010 · N48417 · Substantial damageNTSB ERA11CA002Accident · No injuriesData collectionFinal reportFleet 16B · Lake City, SCThe pilot’s improper use of the brakes while taxiing.Oct 1, 2010 · N8742 · Substantial damageNTSB ANC10LA101Accident · No injuriesLimited investigationFinal reportCessna 150F · North Pole, AKThe overstress separation of the left nose wheel steering linkage rod end during the takeoff roll, which resulted in a loss of control.Oct 1, 2010 · N3569L · Substantial damageNTSB WPR10LA479Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Spokane, WAThe failure of a manufacturing splice of the right main landing gear tire’s inner tube, which resulted in a deflated tire and a consequent loss of directional control on landing.Sep 30, 2010 · N90SE · Substantial damageNTSB WPR10IA482Incident · No injuriesIncident investigationFinal reportBeech F90 · Idaho Falls, IDThe partial retraction/collapse of the main landing gear during the landing roll for undetermined reasons.Sep 29, 2010 · N124BK · Minor damageNTSB WPR10LA476Accident · No injuriesLimited investigationFinal reportCessna 310R · Great Falls, MTThe uncommanded retraction of the right main landing gear during taxi due to the failure of the landing gear extension system to move the right main gear upper side link into the locked position for undetermined reasons.Sep 28, 2010 · N455TB · Substantial damageNTSB ENG10IA055Incident · No injuriesIncident investigationFinal reportBombardier CL600 2B19 · Milwaukee, WIThe failure of the left main landing gear (MLG) to extend normally and manually for reasons that could not be conclusively determined.Sep 28, 2010 · N498CA · Minor damageNTSB CEN10LA572Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Tulsa, OKA shorted terminal lug on the landing gear hydraulic pump which resulted in a cabin fire. Contributing to the accident was the lack of clear installation procedures for the hydraulic pump.Sep 28, 2010 · N5145U · DestroyedNTSB ENG10IA053Incident · No injuriesIncident investigationFinal reportBombardier CL600 2D24 · John F. Kennedy International Airport, NYThe probable cause of the incident was the restriction of the right main landing gear door against the fuselage wheel well body fairing which prevented the extension of the right main landing gear.Sep 26, 2010 · N133EV · Minor damageNTSB CEN10LA564Accident · No injuriesLimited investigationFinal reportCessna 310K · Boerne Stage, TXThe pilot’s failure to ensure that the landing gear was extended prior to landing, resulting in a landing on the partially extended landing gear.Sep 26, 2010 · N550JW · Substantial damageNTSB ERA10TA501Accident · Minor injuriesFinal reportEurocopter AS-350 · Covington, GAThe flight instructor's loss of control of the helicopter during the intentional demonstration of a low speed, hydraulics-off maneuver, that was warned against in the helicopter manufacturer's flight manual.Sep 24, 2010 · N91DK · Substantial damageNTSB ENG10WA052Incident · No injuriesForeign investigationBoeing 747 · Hong Kong, ChinaOn September 21, 2010, 0930 Coordinated Universal Time (UTC), an Air Cargo Germany, a Boeing B-747-412F,registered as D-ACGD, was performing a left turn to line up with Runway 25L for take-off 31C at Hong Kong International Airport. Just before finishing the…Sep 21, 2010 · D-ACGD · Minor damageNTSB WPR10LA462Accident · 1 fatalLimited investigationFinal reportCosmos Phase II · El Mirage, CAThe pilot's improper preflight and starting procedures, which resulted in an inadvertent takeoff with the gust lock still installed.Sep 20, 2010 · N56078 · Substantial damageNTSB ERA10LA485Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Rainelle, WVThe improper rigging of the fuel selector by maintenance personnel, which resulted in a total loss of engine power.Sep 18, 2010 · N86BR · Substantial damageNTSB CEN10LA567Accident · No injuriesLimited investigationFinal reportCessna 320 · Denton, TXThe failure of the landing gear push-pull rod.Sep 18, 2010 · N56VP · Substantial damageNTSB CEN10LA551Accident · Minor injuriesLimited investigationFinal reportMccauley Gene E RV-6A · Kokomo, INCollapse of the nose landing gear during landing rollout on an unpaved runway due to a loss of ground clearance with the landing gear fork, causing the airplane to nose over.Sep 18, 2010 · N343BG · Substantial damageNTSB ANC10CA095Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Coal Creek, AKThe pilot's improper recovery from a bounced landing.Sep 17, 2010 · N9764P · Substantial damageNTSB WPR10LA458Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Mammoth, CADynamic rollover of the helicopter during a precautionary landing.Sep 16, 2010 · N2153S · Substantial damageNTSB ANC10LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Dillingham, AKBoth pilots’ failure to see and avoid each other during initial climb, resulting in a midair collision. Contributing to the accident was the pilot of N9699P’s inability to use his airplane's radio for air traffic advisories.Sep 16, 2010 · N9699P · 2 aircraft · Substantial damageNTSB ERA10LA478Accident · No injuriesLimited investigationFinal reportPiaggio P-180 · Clearwater, FLThe flight crew did not ensure that the landing gear was down and that it indicated down through the takeoff sequence.Sep 12, 2010 · N590JL · Substantial damageNTSB CEN10CA533Accident · No injuriesData collectionFinal reportPiper PA46-310P · Farmington, NMThe pilot’s premature retraction of the landing gear and the flaps during landing. Contributing to the accident was the inadvertent dimming of the cockpit lighting, resulting in a perceived unsafe gear configuration.Sep 12, 2010 · N24WW · Substantial damageNTSB WPR10LA464Accident · 1 fatalLimited investigationFinal reportHughes OH-6A · Majuro (Pacific Ocean)A loss of helicopter control for undetermined reasons.Sep 11, 2010 · N74LB · Substantial damageNTSB ANC10CA092Accident · Minor injuriesData collectionFinal reportPiper J5A · Chickaloon, AKThe pilot's excessive use of brakes during a rejected takeoff, resulting in a nose over.Sep 11, 2010 · N35589 · Substantial damageNTSB WPR10LA457Accident · No injuriesLimited investigationFinal reportMyers THORP-18 · Jerome, IDThe pilot's failure to maintain directional control during the landing roll in gusty crosswinds.Sep 10, 2010 · N330JH · Substantial damageNTSB CEN10IA535Incident · No injuriesIncident investigationFinal reportEmbraer 500 · Brenham, TXThe pilots’ decision to depart with a known failed brake control unit.Sep 10, 2010 · N226CP · Minor damageNTSB ERA10CA472Accident · Minor injuriesData collectionFinal reportCessna 180 · Huron, NYThe pilot's inadequate preflight planning and preparation, which resulted in a total loss of engine power due to fuel exhaustion.Sep 9, 2010 · N180LE · Substantial damageNTSB WPR10CA480Accident · No injuriesData collectionFinal reportCessna A185 · Santa Ynez, CAThe pilot's failure to maintain directional control, likely due to the inadvertent control interference by a passenger. A finding in the accident was the pilot's improper pre flight briefing.Sep 6, 2010 · N4622C · Substantial damageNTSB CEN10CA540Accident · No injuriesData collectionFinal reportBeech E-90 · Colorado Springs, COThe pilot’s failure to ensure that the airplane’s parking brake was properly set before diverting his attention to other tasks.Sep 5, 2010 · N16LH · Substantial damageNTSB WPR10FA448Accident · 3 fatalField investigationFinal reportBeech 65 · Redwood City, CAA loss of power in the right engine for undetermined reasons and the pilot’s subsequent failure to maintain adequate airspeed, which resulted in a loss of control. Contributing to the loss of control was the regulatory certification basis of the airplane that…Sep 2, 2010 · N832B · Substantial damageNTSB ERA10CA467Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Churchville, MDThe pilot’s failure to ensure that the fuel valve was in the "ON" position during his preflight inspection, resulting in the loss of engine power during takeoff.Sep 1, 2010 · N2156K · Substantial damageNTSB ERA10LA458Accident · No injuriesLimited investigationFinal reportBird CK · Eagles Mere, PAThe loss of engine power due to fuel starvation as a result of degradation of the fuel tank coating which blocked the fuel supply.Aug 31, 2010 · N765N · Substantial damageNTSB ANC10LA081Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Port Alsworth, AKThe overstress fracture and failure of a main landing gear wheel during landing, resulting in the right wing striking the ground.Aug 29, 2010 · N9569K · Substantial damageNTSB WPR10LA441Accident · No injuriesLimited investigationFinal reportCessna TR182 · Spanish Fork, UTThe pilot did not extend the landing gear due to his impairment from alcohol.Aug 28, 2010 · N738MP · Substantial damageNTSB ERA10LA449Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7HC · Louisville, KYA loss of engine power due to fuel system contamination resulting in damage to the carburetor float.Aug 27, 2010 · N8919R · Substantial damageNTSB CEN10CA510Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Basile, LAThe loss of directional control during landing due to failure of the right brake for undetermined reasons.Aug 27, 2010 · N63E · Substantial damageNTSB CEN10IA554Incident · No injuriesIncident investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Bloomington, ILThe cracked nose landing gear fork assembly found during the preflight inspection.Aug 26, 2010 · N409AM · Minor damageNTSB ANC10CA079Accident · No injuriesData collectionFinal reportPiper PA-14 · Talkeetna, AKA faulty fuel quantity indication in-flight, which precipitated a precautionary off-airport landing, and collision with a road sign.Aug 26, 2010 · N5114H · Substantial damageNTSB WPR10LA421Accident · No injuriesLimited investigationFinal reportCessna U206 · Grangeville, IDThe pilot’s decision to fly with a known defective nosewheel assembly, which resulted in a loss of directional control and nose-over on landing after the assembly shifted out of alignment during the flight.Aug 23, 2010 · N29100 · Substantial damageNTSB CEN10LA506Accident · No injuriesLimited investigationFinal reportAshcraft DR107 · Aurora, ILThe low cycle fatigue failure of the tail wheel spring during landing.Aug 21, 2010 · N123TA · Substantial damageNTSB WPR10CA414Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Buena, WAThe pilot’s excessive brake application, resulting in a nose over.Aug 19, 2010 · N1662P · Substantial damageNTSB ERA10CA425Accident · No injuriesData collectionFinal reportRyan Navion B · Fort Myers, FLThe binding of the trim wheel on the instrument panel and the pilot’s improper decision to depart with a known mechanical deficiency.Aug 16, 2010 · N5382K · Substantial damageNTSB ERA10LA423Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Eastover, NCThe uncommanded retraction of the nose gear for undetermined reasons and the pilot's improper decision to continue the takeoff after the propeller began to contact the ground.Aug 15, 2010 · N792Y · Substantial damageNTSB CEN10LA492Accident · Serious injuriesLimited investigationFinal reportInfinity Infinity · Little Rock, ARThe failure of the control lanyard for undetermined reasons.Aug 12, 2010 · N208FA · Substantial damageNTSB ERA10LA410Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Eastman, GABoth pilots’ failure to use emergency checklist procedures for restarting the engine after the loss of engine power due to fuel starvation.Aug 10, 2010 · N730FT · Substantial damageNTSB ERA10CA412Accident · No injuriesData collectionFinal reportMooney M20M · Poughkeepsie, NYThe pilot's improper flare which resulted in a hard landing, loss of directional control and runway excursion.Aug 9, 2010 · N9153Z · Substantial damageNTSB ANC10MA068Accident · 5 fatalClass 1 · MajorFinal reportDehavilland DHC-3 · Aleknagik, AKThe pilot's temporary unresponsiveness for reasons that could not be established from the available information. Contributing to the investigation's inability to determine exactly what occurred in the final minutes of the flight was the lack of a cockpit…Aug 9, 2010 · N455A · Substantial damageNTSB ERA10LA405Accident · No injuriesLimited investigationFinal reportGlines Sportsman GS-2 · Morrisville, VTThe pilot's improper flare during a forced landing. Contributing to the accident was a loss of fuel pressure for undetermined reasons.Aug 7, 2010 · N546SG · Substantial damageNTSB ERA10FA404Accident · 2 fatalField investigationFinal reportBeech 58 · Saltsburg, PAThe pilot’s loss of control of the airplane during low-airspeed airwork and his failure to promptly recover the airplane from the aerodynamic stall, which resulted in a spin. Contributing to the accident were the pilot and certified flight instructor’s…Aug 7, 2010 · N28MR · Substantial damageNTSB WPR10FA384Accident · Minor injuriesField investigationFinal reportCessna 172 · Roche Harbor, WAThe pilot’s failure to attain an adequate climb airspeed due to his use of flaps for takeoff, and his selection of a runway, which resulted in an uphill, and possibly downwind, takeoff and subsequent collision with a known obstacle. Contributing to the…Aug 6, 2010 · N9730H · Substantial damage