NTSB investigations, 2008
61 cases where the defining event was Sys/Comp malf/fail (non-power).
Cases per year
| 1979 | 1 |
|---|---|
| 2008 | 61 |
| 2009 | 43 |
| 2010 | 38 |
| 2011 | 42 |
| 2012 | 41 |
| 2013 | 37 |
| 2014 | 19 |
| 2015 | 35 |
| 2016 | 27 |
| 2017 | 25 |
| 2018 | 28 |
| 2019 | 24 |
| 2020 | 30 |
| 2021 | 44 |
| 2022 | 53 |
| 2023 | 53 |
| 2024 | 52 |
| 2025 | 47 |
| 2026 | 26 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 2008
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '330')
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 year(c."eventDate") = 2008 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '330') 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 WPR09CA059Accident · No injuriesData collectionFinal reportCessna 210 · Sheridan, WYMaintenance personnel's failure to reinstall the left front pilot's seat correctly, which resulted in the pilot's loss of control and subsequent impact with a taxiway sign.NTSB CEN09FA094Incident · No injuriesField investigationFinal reportBombardier CL-600-2C10 · Chicago, ILThe failure of the left landing gear to extend due to improper maintenance when the landing gear door was replaced. Contributing to the incident was the manufacturer's inadequate maintenance manual instructions.NTSB DCA09IA017Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Philadelphia, PAthe failure of the maintenance personnel to properly complete the installation, and the inspection personnel to conduct the proper functional test, of the left main landing gear uplock assembly.NTSB ERA09IA115Incident · No injuriesIncident investigationFinal reportCessna 402C · Fort Lauderdale, FLThe airplane manufacturer's inadequate inspection procedure resulting in undetected fatigue cracking of the main landing gear barrel of the upper barrel and trunnion assembly.NTSB ERA09IA056Incident · No injuriesIncident investigationFinal reportDeHavilland DHC-8-311 · Philadelphia, PAThe mechanical overload of the nosewheel steering links for undetermined reasons, which resulted in nose landing gear rotation and its subsequent wedging within the wheel well structure.NTSB WPR09LA029Accident · No injuriesLimited investigationFinal reportCessna 421C · Mesa, AZThe failure of the hydraulic landing gear extension systems due to a ruptured line.NTSB WPR09LA016Accident · 1 fatalLimited investigationFinal reportHeisler Lancair Legacy · Parowan, UTThe pilot failed to secure the canopy prior to takeoff, resulting in his inability to control the aircraft during the takeoff. Contributing to the accident was the pilot’s impairment from prescription medications and possible obstructive sleep apnea.NTSB CEN09CA026Accident · Minor injuriesData collectionFinal reportHolland Rotorway 162F · Rutland, SDThe loss of torque due to a failure of a transmission drivebelt and the pilot's delayed landing flare during the autorotation. Contributing to the accident was the dusk light condition and the corn crop.NTSB SEA08IA217Incident · No injuriesIncident investigationFinal reportDiamond DA 40 · San Carlos, CAThe improper assembly of the governor during manufacture.NTSB LAX08CA293Accident · No injuriesData collectionFinal reportBrubaker F1 · Truckee, CAThe failure of the bolts securing the tail wheel to its attach point that resulted in a loss of directional control.NTSB DEN08LA153Accident · No injuriesLimited investigationFinal reportCessna 210 · Pagosa Springs, COThe failure of the landing gear to extend for undetermined reasons.NTSB CHI08CA287Accident · Minor injuriesData collectionFinal reportCessna 172M · Three Lakes, WIThe pilot's failure to attain sufficient altitude to avoid the trees during initial climb. Contributing to the accident were the pilot's failure to ensure the security of the entrance door before takeoff and the unintentional opening of the door.NTSB CHI08FA269Accident · 3 fatalField investigationFinal reportBell 206L-1 · Greensburg, INThe in-flight separation of a main rotor blade due to a fatigue failure of the blade spar, rendering the helicopter uncontrollable, and the manufacturer's production of main rotor blades with latent manufacturing defects, which precipitated the fatigue…NTSB LAX08FA286Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Las Vegas, NVA loss of power in the right engine due to an in-flight fuel-fed fire in the right engine compartment that, while the exact origin could not be determined, was likely related to the right engine-driven fuel pump, its fuel supply line, or fitting. Contributing…NTSB MIA08LA174Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Clarksdale, MSThe mechanic’s failure to torque check the axle-to-spring gear attachment bolts per the manufacturer's Annual/100-Hour Airframe Inspection Checklist, resulting in fatigue failure of the bolts.NTSB MIA08LA168Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Jeannette, PAFailure of the brakes to function due to inadequate inspection of the brake cable by maintenance personnel.NTSB SEA08CA184Accident · No injuriesData collectionFinal reportWheat Excalibur EX · Moses Lake, WAThe right rudder pedal attach rivets sheared due to overload.NTSB DEN08FA140Accident · Serious injuriesField investigationFinal reportAircraft Mfg & Dev. CH601XLi · Farmersville, TXThe inadvertent tail stall and subsequent loss of airplane control as a result of the open canopy. Contributing to the accident was the inadequate emergency procedures provided by the airplane manufacturer and the inadequate design of the canopy latching…NTSB NYC08LA273Accident · No injuriesLimited investigationFinal reportOuzts Rodney Rutan-LongEZ · Winder, GAThe failure of the left brake due to contamination of the brake fluid.NTSB CHI08CA245Accident · No injuriesData collectionFinal reportAir Tractor 301 · Herreid, SDFailure of one of the tailwheel bolts on landing and the pilot's subsequent inability to maintain directional control.NTSB DFW08CA200Accident · No injuriesData collectionFinal reportCurtiss-Wright 12Q · Erie, COFailure of the tail wheel control cable during landing roll out, which resulted in a loss of control.NTSB DEN08IA123Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-114 · Denver, COTotal failure of the right inboard tire. Contributing to this incident were the low pressure of the tire, and the high tire heat generated by the previous rejected takeoff.NTSB LAX08LA242Accident · No injuriesLimited investigationFinal reportGlaser-Dirks Flugzeugbau DG-100G · Truckee, CAA malfunction of the tow release mechanism.NTSB CHI08CA203Accident · No injuriesData collectionFinal reportEnstrom F28F · Amberg, WIThe unsuitable terrain encountered by the pilot during a forced landing following a loss of engine power due to a cylinder head separation. Contributing to the accident was the tree.NTSB LAX08LA217Accident · No injuriesLimited investigationFinal reportLancair LC41-550FG · Hailey, IDThe loss of directional control while taxiing due to the failure of the right brake.NTSB LAX08LA201Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Rainier, ORThe inadvertent extension of the left float's landing gear to near the down position due to a failure of the gear's rear hydraulic seal.NTSB CHI08FA172Accident · No injuriesField investigationFinal reportEnstrom Helicopter 480B · Marinette, WIThe pilot inadvertently operating the helicopter at a gross weight greater than its maximum allowable operating weight, and flying the helicopter at an airspeed greater than the never-to-exceed speed for the helicopter’s gross weight condition, resulting in…NTSB DEN08LA107Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Pine Bluff, ARA total loss of engine power due to fuel starvation as a result of an electrical short in the wiring to the manual fuel switch that closed the fuel valves.NTSB NYC08CA205Accident · No injuriesData collectionFinal reportLuscombe 8A · Indiantown, FLAn inadequate annual inspection that failed to detect a damaged rudder cable which resulted in the cable's subsequent failure during takeoff.NTSB MIA08LA149Accident · No injuriesLimited investigationFinal reportAero Commander 500-B · Charlotte AmaliThe failure of maintenance personnel to identify inadequate clamping of the aluminum line during inspection, and the undetected fatigue cracking of the line which resulted in the loss of hydraulic fluid.NTSB CHI08LA151Accident · No injuriesLimited investigationFinal reportBell 47D1 · Carrollton, OHThe airframe vibration for an undetermined reason.NTSB SEA08LA147Accident · No injuriesLimited investigationFinal reportAero Commander 690A · Tacoma, WAThe collapse of the right main landing gear for undetermined reasons.NTSB DFW08CA152Accident · Serious injuriesData collectionFinal reportRotorway 162F · Gonzales, TXfailure of the main rotor drive belt for undetermined reasons.NTSB MIA08LA106Accident · No injuriesLimited investigationFinal reportEurocopter France AS350 B2 · Hiram, GAThe failure of the starflex arm during engine run-up due to inadequate inspection by maintenance personnel.NTSB DEN08CA089Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164C · De Witt, ARThe pilot's improper decision to attempt to close the canopy in flight, and his diverted attention resulting in the airplane impacting the terrain. Contributing to the accident was the excessively worn canopy latch.NTSB ANC08CA065Accident · No injuriesData collectionFinal reportde Havilland DHC-3 · Talkeetna, AKThe pilot's selection of an unsuitable landing site, which resulted in an overload failure of the tail ski assembly during the landing roll.NTSB CHI08CA117Accident · No injuriesData collectionFinal reportCessna 182D · Madison, INThe inadequate preflight inspection of the landing gear tires by the pilot, which did not identify a worn tire and resulted in a flat tire during landing touchdown. An additional cause was the directional control not possible during the landing rollout, and…NTSB SEA08LA114Accident · No injuriesLimited investigationFinal reportCanup Titan Tornado S · Council, IDThe failure of the tip of the wood propeller due to damage caused by a foreign object.NTSB DFW08LA115Accident · No injuriesLimited investigationFinal reportCessna 421C · Sterling, COFailure and separation of the upper and lower right main gear torque links links, which resulted in a loss of directional control on landing roll-out.NTSB MIA08CA095Accident · No injuriesData collectionFinal reportChampion 7KCAB · Alexander City, ALThe separation of the right tail wheel spring on landing roll out for undetermined reasons, resulting in a loss of directional control and collision with a ditch.NTSB ANC08LA055Accident · No injuriesLimited investigationFinal reportCessna 180 · Kodiak, AKA loss of control during the landing roll due to a failure or malfunction of the brake system, resulting in a loss of control, and structural damage to the airplane.NTSB CHI08CA111Accident · No injuriesData collectionFinal reportVeldhuizen Highlander · Onida, SDThe separation of the right main wheel from the landing gear during takeoff for an undetermined reason.. Contributing to the accident were rough/uneven terrain and that directional control was not possible.NTSB MIA08CA088Accident · Serious injuriesData collectionFinal reportWilliam E. Furr SeaRey · Winter Springs, FLThe pilot's inadequate preflight inspection of the airplane.NTSB CHI08LA104Accident · No injuriesLimited investigationFinal reportVic Tatelman Baby Belle · Lakeland, FLThe failure of the tailrotor driveshaft hanger bearing and jamming of the tailrotor.NTSB DFW08LA100Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Quinton, OKAn undetermined mechanical malfuction associated with the tail rotor drive system which led to a loss of control.NTSB CHI08CA105Accident · No injuriesData collectionFinal reportSchultz Mini 500 · Batavia, OHThe failure of the helicopter's centrifugal clutch during hover which led to the pilot's inability to maintain control of the craft and its subsequent impact with the ground.NTSB DFW08TA092Accident · No injuriesFinal reportRobinson R44 · Topeka, KSA malfunctioning magneto, resulting in a high engine rpm and low rotor warning indications. A contributing factor was the impact with a light pole, during the precautionary landing.NTSB LAX08IA093Incident · No injuriesIncident investigationFinal reportBennett Lancair 320 · Hillsboro, ORThe malfunction of the airplane's battery and alternator that resulted in the failure of the landing gear to extend and lock in place.NTSB DFW08IA087Incident · No injuriesIncident investigationFinal reportBoeing 737-524 · Houston, TXThe flight crew's improper landing technique for an inoperative anti-skid system resulting in locked brakes and four blown main landing gear tires.NTSB LAX08LA086Accident · No injuriesLimited investigationFinal reportCessna 402 · Henderson, NVThe failure of the left main landing gear torque link assembly for undetermined reasons.