NTSB investigations
136 cases where NTSB found Oversight.
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\", '040320')) 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", '040320')) 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 CEN12IA123Incident · No injuriesIncident investigationFinal reportBoeing 737-7H4 · Denver, COThe snowplow operator’s incapacitation due to fatigue, which resulted in the snowplow contacting a parked airplane. Contributing to the incident was the company’s lack of a policy regarding employee fatigue.NTSB ERA11FA495Accident · 1 fatalField investigationFinal reportNorth American T-28C · Martinsburg, WVThe pilot's impairment or incapacitation that occurred during a low-altitude aerobatic maneuver due to complications from a recent heart attack, resulting in his inability to maintain control of the airplane. Contributing to the accident was the Federal…NTSB CEN11FA599Accident · 4 fatalClass 1 · FieldFinal reportEurocopter AS-350-B2 · Mosby, MOThe pilot's failure to confirm that the helicopter had adequate fuel on board to complete the mission before making the first departure, his improper decision to continue the mission and make a second departure after he became aware of a critically low fuel…NTSB CEN11LA491Accident · No injuriesLimited investigationFinal reportBeech C35 · Medina, OHThe loss of engine power due to fuel starvation due to an age-related failure of the engine-driven fuel pump. Also causal was the failure of the maintenance facility to overhaul the fuel pump and the failure of the operator to ensure that the pump was…NTSB OPS11IA653Incident · No injuriesIncident investigationFinal reportBeech 1900C · Fairbanks, AKInadequate air traffic control actions that failed to establish and maintain required separation between the two airplanes. Contributing to the incident was inexperience on the part of the local controller, inadequate oversight by the tower…NTSB CEN11IA369Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145 · Chicago, ILThe overheat and failure the brake during landing due to oxidation of the brake rotors, which went undetected by maintenance personnel. Contributing to the accident was maintenance personnel’s lack of familiarity with detailed brake oxidation inspection…NTSB ANC11LA039Accident · No injuriesLimited investigationFinal reportCessna 170A · Wasilla, AKThe pilot's loss of directional control during landing, which resulted in a runway excursion. Contributing to the accident were the effects of multiple modifications to the main and tailwheel landing gear through the supplemental type certificate and FAA…NTSB OPS11IA476Incident · No injuriesIncident investigationFinal reportBeech 400 · Midland, TXInadequate planning and control instructions issued to the pilots involved by the trainee controller operating the local control position and inadequate supervision by the instructor responsible for the position.NTSB DCA11MA076Accident · 4 fatalClass 1 · MajorFinal reportGulfstream GVI · Roswell, NMThe National Transportation Safety Board determines the probable cause(s) of this accident as follows: an aerodynamic stall and subsequent uncommanded roll during a one engine-inoperative takeoff flight test, which were the result of (1) Gulfstream’s failure…NTSB WPR11LA094Accident · 1 fatalLimited investigationFinal reportRockwell International S-2R · Oakley, CAAn in-flight collision with an unmarked meteorological evaluation tower (MET) during an aerial application flight due to the pilot's failure to see and avoid the obstacle. Contributing to the accident was the lack of visual conspicuity of the MET and the lack…NTSB ERA11LA106Accident · No injuriesLimited investigationFinal reportEurocopter MBB-BK · Cherry Point, NCThe pilot's impairment during cruise flight due to a recurring stroke. Contributing to the accident was the Federal Aviation Administration's inadequate oversight of the pilot's known medical condition.NTSB ERA11GA066Accident · 3 fatalFinal reportCessna M337B · Avon Park, FLThe pilot's inadvertent encounter with an unexpected intense rain shower with severe turbulence at night.NTSB 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…NTSB WPR10FA440Accident · 3 fatalField investigationFinal reportHiller UH 12E · Kamiah, IDIn-flight impact of a passenger's metal clipboard with the helicopter’s tail rotor, which resulted in destruction of the tail rotor and subsequent loss of control of the helicopter. The original location of the clipboard and how it became free could not be…NTSB 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…NTSB WPR10FA371Accident · 3 fatalField investigationFinal reportAmerican Eurocopter AS 350 B3 · Tucson, AZThe repair station technician did not properly install the fuel inlet union during reassembly of the engine; the operator’s maintenance personnel did not adequately inspect the technician's work; and the pilot who performed the post maintenance check flight…NTSB ANC10FA038Accident · 1 fatalField investigationFinal reportPiper PA-18-135 · Willow, AKThe pilot's failure to maintain clearance from a tree due to the effects of impairment from alcohol consumption.NTSB ERA10TA261Accident · No injuriesFinal reportBell 407 · Abingdon, VAThe improper repair of an engine component by a repair facility, which resulted in a complete loss of engine power. Contributing to the accident was the failure of the repair facility to recognize that an improper repair had been accomplished, which allowed…NTSB OPS10IA155Incident · No injuriesIncident investigationFinal reportEmbraer EMB-135KL · Chicago, ILThe air traffic controller's issuance of an improper takeoff clearance to the pilot of the Embraer. Contributing to the incident was the instructor’s inadequate monitoring of the trainee local controller.NTSB CEN10LA142Accident · No injuriesLimited investigationFinal reportBombardier BD-100-1A10 · Wheeling, ILThe deicing vehicle operator's not adhering to company procedures and not maintaining clearance between the vehicle's boom and the airplane's empennage during the airplane's deicing operation.NTSB ERA10FA148Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Springfield, KYThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion, and the pilot's impairment due to alcohol. Contributing to the accident was the Federal Aviation Administration's failure to adequately oversee…NTSB ERA09FA537Accident · 3 fatalField investigationFinal reportEurocopter AS-350 · Georgetown, SCThe pilot’s decision to continue the visual flight rules flight into an area of instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and a loss of control of the helicopter. Contributing to the accident was the inadequate…NTSB ENG09IA017Incident · Minor injuriesIncident investigationFinal reportEmbraer ERJ 190-100 IGW · Nassau, Bahamasfailure of the engine high pressure turbine active clearance control valve fuel rod supply tube coupling seal due to a cross-threaded B-nut as installed during original manufacture.NTSB ERA09FA497Accident · 1 fatalField investigationFinal reportRobinson R44 · Jackson, MSThe pilot's failure to maintain adequate main rotor rpm, for undetermined reasons.NTSB CEN09CA469Accident · Serious injuriesData collectionFinal reportPiper PA-25-235 · Miller, MOThe failure of the operator to shut down aircraft while conducting servicing which resulted in a ground person being struck by the rotating aircraft propeller.NTSB CEN09IA234Incident · No injuriesIncident investigationFinal reportBell 206L-3 · Abilene, TXThe formation and propagation of a fatigue crack in the trailing edge of the main rotor blade due to interconnected porosity and resultant corrosion. The area of interconnected porosity was due to a manufacturing defect which was not detected during the…NTSB DCA09MA027Accident · 50 fatalClass 1 · MajorFinal reportBombardier DHC-8-402 · Clarence Center, NYThe captain’s inappropriate response to the activation of the stick shaker, which led to an aerodynamic stall from which the airplane did not recover. Contributing to the accident were (1) the flight crew's failure to monitor airspeed in relation to the…NTSB ENG09IA002Incident · No injuriesIncident investigationFinal reportBoeing 777 · Atlanta, GAThe fan blade fractured due to a fatigue crack that was the result of the combination of the breakdown of the fan blade lubrication system and residual fatigue life usage following the last overhaul of the fan blade. Contributing to the fracture was the…NTSB ERA09LA020Accident · No injuriesLimited investigationFinal reportSikorsky S-76C · New York, NYThe failure of the flightcrew to stabilize the helicopter over its confined landing area during a hovering left-pedal turn, resulting in tail rotor blade contact with a perimeter fence component and a subsequent loss of directional control. Contributing to…NTSB MIA08MA203Accident · 4 fatalClass 1 · MajorFinal reportAerospatiale SA365N-1 D · District Heights, MDThe pilot's attempt to regain visual conditions by performing a rapid descent and his failure to arrest the descent at the minimum descent altitude during a nonprecision approach. Contributing to the accident were (1) the pilot’s limited recent instrument…NTSB DCA08MA098Accident · 4 fatalClass 1 · MajorFinal reportLearjet LR60 · Columbia, SCThe operator’s inadequate maintenance of the airplane’s tires, which resulted in multiple tire failures during takeoff roll due to severe underinflation, and the captain’s execution of a rejected takeoff (RTO) after V1, which was inconsistent with her…NTSB LAX08PA259Accident · 9 fatalClass 1Final reportSikorsky S-61N · Weaverville, CAThe following actions by Carson Helicopters: 1) the intentional understatement of the helicopter's empty weight, 2) the alteration of the power available chart to exaggerate the helicopter's lift capability, and 3) the practice of using unapproved…NTSB DFW08FA153Accident · 2 fatalField investigationFinal reportCessna 310Q · Steamboat, COThe pilot's failure to maintain clearance from mountainous terrain in day visual conditions. Contributing to the accident was the pilot's impairment due to marijuana and inadequate medical oversight of the pilot by the Federal Aviation Administration.NTSB DFW08LA121Accident · 1 fatalLimited investigationFinal reportTromsness Enterprises Turbine LE · Miami, OKThe pilot's failure to maintain control of the airplane for undetermined reasons. Contributing to the accident included his extensive use of medications and/or his multiple medical conditions and the failure of the FAA to follow up on his reported medication…NTSB DFW08LA118Accident · No injuriesLimited investigationFinal reportVickers Spitfire · Galveston, TXThe Hurricane pilot's failure to maintain directional control during roll-out. Contributing factors were the restricted forward visibility of the tail-wheel equipped Spitfire, the lack of communication to the other aircraft following the Hurricane, and the…NTSB LAX08FA047Accident · 1 fatalField investigationFinal reportBeechcraft V35B · Selma, CAThe pilot's failure to maintain control resulting in the in-flight break-up of the airplane due to aerodynamic overload. Contributing factors included the pilot's impairment due to multiple medical conditions and due to recent use of alcohol.