NTSB investigations
3,929 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 177 |
|---|---|
| 1983 | 260 |
| 1984 | 220 |
| 1985 | 186 |
| 1986 | 184 |
| 1987 | 182 |
| 1988 | 194 |
| 1989 | 141 |
| 1990 | 134 |
| 1991 | 144 |
| 1992 | 149 |
| 1993 | 132 |
| 1994 | 115 |
| 1995 | 141 |
| 1996 | 148 |
| 1997 | 139 |
| 1998 | 135 |
| 1999 | 132 |
| 2000 | 146 |
| 2001 | 120 |
| 2002 | 140 |
| 2003 | 140 |
| 2004 | 122 |
| 2005 | 113 |
| 2006 | 114 |
| 2007 | 121 |
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 c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130) 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 CHI08CA056Accident · No injuriesData collectionFinal reportErcoupe 415D · Abingdon, ILThe loose clamp on the throttle cable which prevented application of engine power. A factor in the accident was the low altitude when the throttle cable slipped.NTSB MIA08CA046Accident · No injuriesData collectionFinal reportCessna Citation 510 · Pittsburgh, PAThe flight crew's inadequate preflight, which failed to detect the blockage of the left wing's fuel vent port.NTSB LAX08IA042Incident · No injuriesIncident investigationFinal reportEurocopter France AS350 B3 · Fresno, CAMalfunction of a hydraulic servo while on final approach due to excessive wear of the locking finger.NTSB DFW08IA045Incident · No injuriesIncident investigationFinal reportBell 407 · Hig Island A595The loss of tail rotor effectiveness for undetermined reasons.NTSB CHI08FA050Accident · Serious injuriesField investigationFinal reportBoeing 777-222 · Chicago, ILEmergency evacuation due to dense smoke in the cabin and the possibility of an on-board fire, which resulted in a serious injury to one of the 264 passengers and crew. An additional cause was the failure of an engine bearing, allowing oil to migrate into the…NTSB NYC08LA060Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Plant City, FLA loss of rotor drive due to excessive slack and breakage of the drive belts. Contributing to the accident was the pilot departing in the helicopter after the rotor engagement time during engine start exceeded the time outlined in the pilot's operating…NTSB NYC08LA052Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Gainesville, FLThe pilot's failure to follow the published emergency procedure. Contributing to the accident was a malfunction of the clutch assembly.NTSB NYC08FA051Accident · 1 fatalField investigationFinal reportBeech 60 · New Castle, DEThe pilot's failure to maintain adequate airspeed during a split flap takeoff, which resulted in an aerodynamic stall. Contributing to the accident were the failure of the right flap drive mechanism and the pilot's failure to verify that both flaps were…NTSB LAX08IA032Incident · No injuriesIncident investigationFinal reportRobinson R22 Beta · Fresno, CAFailure of the tail rotor system support bracket during landing.NTSB DFW08FA038Accident · 2 fatalField investigationFinal reportCessna T210M · Tulsa, OKThe pilot's failure to maintain clearance from the power transmission line(s). Contributing to the accident were the loss of aircraft electrical power, diverted attention, and the night conditions.NTSB DEN08IA033Incident · No injuriesIncident investigationFinal reportBoeing 737-832 · Phoenix, AZDelamination of the right outboard tire tread during the takeoff roll due to underinflation and/or overloading during use in service.NTSB NYC08LA043Accident · No injuriesLimited investigationFinal reportRobinson R22 · Suffolk, VAThe V-drive belts' rolling off the sheaves for undetermined reasons, resulting in a loss of power to the rotor system, and the pilot's failure to maintain adequate rotor rpm during the autorotation, resulting in a hard landing.NTSB DFW08FA031Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Ranger, TXThe pilot's intentional performance of aerobatic maneuvers that exceeded the design limits of the airplane structure.NTSB DEN08LA038Accident · No injuriesLimited investigationFinal reportRotorway Exec 162-F · New Century, KSWhile on approach the tail rotor spar failed due to metal fatigue .NTSB CHI08CA032Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Alliance, OHThe pilot's inadvertent activation of the parking brake which resulted in the toe brakes becoming ineffective. Contributing to the accident was the airport perimeter fence, the ditch, and the vehicle.NTSB DEN08LA028Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Canon City, COthe failure of the landing gear hinge point attachment for undetermined reasons.NTSB ENG08IA001IncidentIncident investigationFinal reportBoeing 757-225 · Charlotte, NCThe truck beam fracture initiated by fatigue and stress corrosion cracking from pits that were present on the ID surface of the truck beam, under the protective finishes. Crack propagation occurred by alternating modes of stress corrosion cracking and fatigue…NTSB DEN08LA021Accident · No injuriesLimited investigationFinal reportCessna T210K · Los Alamos, NMThe binding of the nose landing gear doors for undetermined reasons, resulting in the pilot having to make a nose gear up landing.NTSB LAX08LA024Accident · 1 fatalLimited investigationFinal reportNorth Wing Mustang II 17.5 · Tracy, CAFailure or disconnection of a wing support/brace assembly for undetermined reasons during an undetermined phase of flight.NTSB CHI08IA022Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Fargo, NDThe failure of the Brake and Steering Control Unit, which allowed the nose landing gear to turn to the 90-degree position.NTSB NYC08LA018Accident · No injuriesLimited investigationFinal reportBlair Skybolt · Guntersville, ALSeparation of the right tailwheel control link spring from the right control arm of the tailwheel, which resulted in a loss of control during landing.NTSB DFW08CA016Accident · No injuriesData collectionFinal reportWard RC 350 HP · Magnolia, TXThe in-flight fire and loss of engine power as a result of a ruptured fuel line for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI08IA026Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A320-232 · Chicago, ILThe misrouted and reversed antiskid wiring by vendor maintenance personnel leading to the runway excursion. Contributing to the incident were the runway sign, the vendor's maintenance personnel not understanding the entire maintenance procedures in the dual…NTSB CHI08CA012Accident · No injuriesData collectionFinal reportCessna 210C · Columbus, OHThe hydraulic system pump leak which resulted in the failure of the emergency landing gear system to extend and lock the landing gear for landing and the flap system.NTSB MIA08FA003Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Newton, GAThe failure of the right wing wooden spar due while the airplane was in cruise flight, due to the mechanic's inadequate annual inspection and his failure to comply with an airworthiness directive.NTSB ANC07FA109Accident · 4 fatalField investigationFinal reportHelio H-295 · King Salmon, AKA corrosion-induced fatigue fracture of the airplane's left wing to fuselage attachment cap fitting, which resulted in a partial separation of the left wing, and an uncontrolled descent.NTSB LAX07CA288Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Laurel, MTCorrosion and fatigue-induced failure of the landing gear structure.NTSB LAX07CA283Accident · No injuriesData collectionFinal reportLuscombe 8E · Ramona, CAthe installation and subsequent failure of an incorrect part, which jammed in one wheel's brake caliper and induced the pilot's loss of directional control.NTSB DEN08IA030Incident · No injuriesIncident investigationFinal reportBeech C90A · Emporia, KSThe improper installation of the right elevator trim tab attachment hardware by maintenance personnel which resulted in excessive wear, fatigue, and the failure of the push-pull tube.NTSB NYC07LA237Accident · No injuriesLimited investigationFinal reportOrtiz G/Saint J RV-10 · Hiram, GASeparation of the passenger cabin door during cruise flight for undetermined reasons.NTSB LAX07LA274Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · El Monte, CAa failure of the main rotor drive system V-belts due to damage sustained when the alternator drive belt failed and pieces of that belt got between the main drive belts and their associated pulleys. A contributing factor was the uneven terrain encountered in…NTSB SEA07LA259Accident · 1 fatalLimited investigationFinal reportRose Peregrine · Reno, NVThe overspeed of the modified racing engine during takeoff that created an oil mist on the exhaust and smoke, and the pilot's failure to maintain a speed above stall speed (Vs) during his attempted emergency landing. Contributing to the accident was the…NTSB DFW07FA198Accident · 2 fatalField investigationFinal reportFairchild Hiller FH-1100 · Hosston, LAThe in-flight separation of the main rotor mast while in cruise flight following a mast bumping event. The reason for the mast bumping event was not determined.NTSB MIA07LA148Accident · No injuriesLimited investigationFinal reportBell 206B3 · Lakeland, FLThe failure of company maintenance personnel to replace the tail rotor drive shafts following tail rotor blade damage in 1999, the failure of maintenance personnel to replace the tail rotor drive shafts in 2004, following their knowledge that the tail rotor…NTSB LAX07CA266Accident · No injuriesData collectionFinal reportAmerican Air Racing Thunder Mustang · Reno, NVFire resulting from vegetation contacting hot brakes following an aborted takeoff.NTSB LAX07CA262Accident · No injuriesData collectionFinal reportWessel Vortex · Mesa, AZFailure of the muffler's mounting strap and subsequent loss of engine power due to propeller blade separation during cruise flight. A contributing factor was the unsuitable terrain for a forced landing.NTSB DEN07LA160Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lawrence, KSTotal failure of the landing gear retraction/extension assembly. Contributing factors in this accident were worn parts in the landing gear retraction/extension assembly, and mechanical binding of the extension assembly.NTSB SEA07LA245Accident · Serious injuriesLimited investigationFinal reportFitt Kitfox · Diamond Springs, CAOil starvation during climb due to an unidentified piece of plastic material blocking an oil supply tube and the pilot's inadequate maintenance of the lubricating system. Contributing to the accident was the rough terrain.NTSB CHI07LA277Accident · Minor injuriesLimited investigationFinal reportBell 47G-5A · Anoka, MNThe loss of helicopter pitch control for undetermined reasons during the aerial application maneuver and the pilot's inability to control the aircraft during the descent.. A contributing factor to the accident was the soft terrain.NTSB CHI07LA273Accident · 1 fatalLimited investigationFinal reportTerpstra Exec 162F · Winamac, INThe inadequate installation of the horizontal stabilizer bracket by the pilot, the fatigue fracture seperation of vertical stabilizer bracket during cruise flight, and the aircraft control not possible by the pilot.NTSB NYC07IA194Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · New Bern, NCA failure of the stabilator control cable turnbuckle terminal fitting due to corrosion. Contributing to the accident were the mechanic's inadequate annual inspection, and the aircraft manufacturer's failure to provide adequate information in its maintenance…NTSB NYC07IA199Incident · No injuriesIncident investigationFinal reportPiper PA-32R-301T · Alton, ILThe component manufacturer's inadequate fabrication of the transient voltage suppressor.NTSB NYC07CA190Accident · No injuriesData collectionFinal reportAckert Dakota Hawk DH23 · Sebring, FLPreexisting cracking of the landing gear tubing.NTSB SEA07CA224Accident · No injuriesData collectionFinal reportCessna 421B · Oceanside, CAThe collapse of the right main landing gear during the landing roll for undetermined reason, which resulted in a loss of directional control and collision with a fence.NTSB NYC07LA188Accident · No injuriesLimited investigationFinal reportBell 206B · Warrenton, VAThe flight instructor's failure to maintain adequate rotor rpm during touchdown.NTSB CHI07CA229Accident · Serious injuriesData collectionFinal reportNetz KIS TR2 · Willow Springs, MOThe improper installation of the aileron control pushrod which led to a separation of the pushrod and subsequent loss of aircraft control. A factor was the pilot not being able to control the airplane after the pushrod separation.NTSB SEA07LA217Accident · 2 fatalLimited investigationFinal reportTaylorcraft BF12 · West Linn, ORThe corrosion, fatigue fracture, and subsequent separation of the left wing lift strut attachment fitting. Also causal was the inadequate maintenance and annual inspection by the owner/pilot/mechanic.NTSB SEA07TA212Accident · No injuriesFinal reportHughes 369D · Omak, WAThe pilot's failure to maintain clearance from the surface of a pond that he was using as a water bucket refill site, which resulted in a tail rotor strike to the water's surface and a torsional overload failure of the tail rotor drive shaft.NTSB SEA07LA213Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Spokane, WAThe locking/seizing of a main landing gear brake mechanism during the landing roll.NTSB MIA07LA123Accident · No injuriesLimited investigationFinal reportLarry J. Cook Lancair 320 · Destin, FLThe separation of a portion of a propeller blade due to fatigue cracking which initiated in an area of corrosion that was not detected during propeller overhaul 10 flight hours before the accident.