NTSB investigations, 1999
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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 year(c.\"eventDate\") = 1999 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") = 1999 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 MIA00LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Hickory, NCThe certified flight instructor (CFI) failure to maintain directional control on rough terrain on takeoff. This resulted in the airplane veering to the left, colliding with bushes after the airplane became airborne, and subsequent in-flight collision with…NTSB MIA00LA053Accident · 1 fatalLimited investigationFinal reportSwertfeger Velocity 173 Elite · Murfreesboro, TNThe failure of an unknown maintenance person to comply with an Airworthiness Directive (replace center body bellows seal assembly and tube bushings) and Service Bulletin (replace fuel diaphragm) resulting in an in-flight power loss due to an over rich…NTSB LAX00LA053Accident · No injuriesLimited investigationFinal reportCessna 172A · Shoshone, CAThe pilot's inadequate compensation for the existing strong and gusting wind conditions and his subsequent failure to maintain directional control.NTSB LAX00LA052Accident · Minor injuriesLimited investigationFinal reportRhea KR-2 · Moreno Valley, CAAn undetected fuel leak from an improperly manufactured right tank into the internal wing spaces, which resulted in fuel exhaustion.NTSB FTW00LA049Accident · No injuriesLimited investigationFinal reportCessna 172 · Fort Worth, TXThe student pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise.NTSB FTW00LA048Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Brownsboro, TXThe loss of tail rotor effectiveness as a result of tail rotor vortex ring state.NTSB FTW00FA046Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Edgewood, TXthe pilot's failure to maintain aircraft control during a forced landing which resulted in a stall/spin. Contributing factors were the failure of the engine driven fuel pump, the engine manufacturer's use of an inadequate fuel pump which was only intended for…NTSB DCA00WA014Accident · No injuriesForeign investigationMcDonnell Douglas DC-10-30F · Amsterdam, NetherlandsNTSB NYC00LA054Accident · No injuriesLimited investigationFinal reportMooney 20J · New Milford, CTFailure of 3 of the 4 connecting rods for an undetermined reason.NTSB LAX00LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Concord, CAthe pilot's failure to use a checklist and remove the control gust lock.NTSB FTW00LA050Accident · No injuriesLimited investigationFinal reportCessna 172S · Sugar Land, TXThe student pilot's failure to maintain control of the airplane during the landing roll.NTSB FTW00LA047Accident · Serious injuriesLimited investigationFinal reportBeech BE-95A · Big Lake, TXthe pilot-in-command's failure to maintain directional control of the airplane during the aborted landing. Contributing factors were the crosswind, turbulence, and the pilot's lack of total experience in the make and model of aircraft.NTSB CHI00LA049Accident · No injuriesLimited investigationFinal reportRotorway Exec 90 · Georgetown, INthe pilot's failure to maintain control of the helicopter. Factors associated with the accident were the gusty tailwind condition and the low altitude at which the helicopter was hovering.NTSB CHI00LA048Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Hanover, MIfuel starvation and the pilot's improper fuel tank selector position. A factor was the swampy terrain.NTSB CHI00LA047Accident · No injuriesLimited investigationFinal reportDouglas DC-8-62 · Indianapolis, INthe flight crew misjudged the clearance between their right wing and the radome of the parked aircraft. A factor associated with the accident was the ground handling contractor failed to identify the unsafe/hazardous condition that existed on the congested…NTSB ATL00FA016Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Geneva, ALThe pilot's failure to maintain adequate airspeed during takeoff which resulted in a stall and the subsequent collision with trees.NTSB FTW00LA045Accident · No injuriesLimited investigationFinal reportCartercopters Cartercopter · Olney, TXThe pilot's failure to maintain rotor rpm during takeoff, which resulted in a hard landing following the aborted takeoff.NTSB DEN00LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-31T1 · Santa Fe, NMThe pilot initiating lift off at an airspeed insufficient to maintain flight and retracting the landing gear prematurely resulting in a stall mush. A factor was the pilot incorrectly setting the elevator trim.NTSB DEN00LA029Accident · No injuriesLimited investigationFinal reportBeech N-35 · Englewood, COA forced landing on unsuitable terrain due a complete loss of power. A factor was the pilot inadvertently placing the fuel selector to the off position while executing the approach for landing checklist.NTSB SEA00LA032Accident · No injuriesLimited investigationFinal reportCessna 140 · Helena, MTSeparation of the left main landing gear. Factors include inadequate preflight inspection by the pilot, and inadequate inspection at the time of annual inspection by maintenance personnel.NTSB NYC00LA052Accident · No injuriesLimited investigationFinal reportCessna P210N · Greenwood, DEthe failure of the pilot to use full power for takeoff, which resulted in not obtaining a positive rate of climb and the inadvertent collision with trees. A factor was the fog.NTSB MIA00LA051Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Woodville, FLThe pilot's improper preflight planning resulting in loss of engine power due to fuel exhaustion and the collision with trees during a forced landing.NTSB DEN00FA028Accident · No injuriesField investigationFinal reportHughes 369D · Peyton, COan uncontrolled touchdown following entry into a "out-of-ground effect" hover. Factors were loss of tail rotor effectiveness, and the pilot's lack of recent experience in kind of aircraft and total experience in type of aircraft.NTSB ATL00LA015Accident · No injuriesLimited investigationFinal reportMaule M7-235C · Iuka, MSThe separation of the nicopress fitting allowing a release of the rudder cable resulting in a loss of control during landing roll. A factor was the manufacturer's use of an improperly calibrated crimping tool.NTSB FTW00LA044Accident · Minor injuriesLimited investigationFinal reportBeech F35 · Elk City, OKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB DEN00LA027Accident · No injuriesLimited investigationFinal reportCessna 182R · Farmington, NMThe pilot's inadequate preflight planning, and his improper inflight decision to not land and refuel, which resulted in fuel exhaustion.NTSB CHI00LA046Accident · No injuriesLimited investigationFinal reportCessna 150B · Omaha, NEThe pilots failure to use carburetor heat during takeoff in weather conducive for serious carburetor ice. Factors were the weather that was conducive for carburetor icing and the presence of the truck that the aircraft impacted.NTSB MIA00LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Fort Lauderdale, FLThe failure of the pilot to maintain minimum flying airspeed, (Vso) during takeoff following a partial loss of engine power resulting in the aircraft stalling, an uncontrolled descent, and collision with trees. A factor in the accident was the failure of the…NTSB CHI00WA045Accident · Serious injuriesForeign investigationBoeing 777-222 · London, United KingdomNTSB CHI00LA044Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Salina, KSThe pilot's failure to follow the published practice autorotation procedures, the improper use of throttle, and the inadequate flare.NTSB CHI00LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Mankato, MNthe pilots failure to maintain a proper glidepath. Factors were the dark night and the pilots lack of recent night flying experience.NTSB CHI00FA042Accident · 2 fatalField investigationFinal reportCessna 210D · Saint Charles, MOthe aircraft control not maintained by the pilot and the pilot exceeded the design limits of the aircraft. The clouds and night conditions were contributing factors.NTSB SEA00FA031Accident · 1 fatalField investigationFinal reportMooney M20-M · Missoula, MTEngine failure for undetermined reasons. Factors include the lack of suitable terrain for an emergency landing, trees and mountainous terrain.NTSB NYC00MA048Accident · 3 fatalMajor investigationFinal reportIsrael Aircraft Industries 1124A · Gouldsboro, PAThe improper assembly of the horizontal stabilizer trim actuator unit by maintenance personnel.NTSB NYC00LA053Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Shamokin, PAThe pilot's failure to maintain aircraft control.NTSB NYC00LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Wales, MEFuel exhaustion due to a blocked fuel feed line.NTSB IAD00WA012Accident · Minor injuriesForeign investigationde Havilland DH-6 Twin Otter · Ago-6, AYNTSB IAD00LA013Accident · Serious injuriesLimited investigationFinal reportRogers RAF 2000 · Franklin, NYwas the pilot's failure to abort the takeoff due to inadequate rotor rpm.NTSB FTW00LA042Accident · No injuriesLimited investigationFinal reportKing Lancair 235/320 · Sterling City, TXThe fatigue fracture of the propeller attaching bolts, due to improper torque during the installation of the propeller by other maintenance personnel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Springhill, LAThe pilot's inadequate compensation for the wind conditions, which resulted in a loss of aircraft control. Factors were the gusty winds, and the pilot's inadequate weather evaluation.NTSB CHI00LA043Accident · 2 fatalLimited investigationFinal reportMcCarty Wittman W-8 Tailwind · Jamestown, NDthe wing spar failure due to its inadequate construction by the owner/builder.NTSB SEA00FA030Accident · 1 fatalField investigationFinal reportCessna 140A · Harper, ORThe pilot-in-command's failure to maintain terrain clearance. Factors include meteorological conditions obscuring the pilot's visibility and incapacitation due to illegal substances.NTSB NYC00LA050Accident · Minor injuriesLimited investigationFinal reportMooney M20-C · Reading, PAThe failure of the number two connecting rod after an improper overhaul by maintenance personnel.NTSB MIA00FA048Accident · 1 fatalField investigationFinal reportCessna U-3A · Brooksville, MSThe in-flight loss of control for undetermined reasons resulting in the collision with terrain.NTSB LAX00LA043Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Scottsdale, AZThe pilot's failure to follow the manufacturer's published emergency procedures for engine loss of power resulting in a forced landing in an open construction area where the airplane collided with a berm. A related factor was the loss of engine power in the…NTSB FTW00RA043Accident · 1 fatalForeign investigationBell UH-1H · Cali, ColombiaNTSB DEN00LA026Accident · No injuriesLimited investigationFinal reportCessna 421C · Gillette, WYThe collision with a deer on the runway during a night landing. A factor was the dark night.NTSB ANC00LA019Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Wasilla, AKThe pilot's failure to remove frost from the wing surface of the airplane. A factor in the accident was the pilot's delay in aborting the takeoff run.NTSB CHI00FA039Accident · 2 fatalField investigationFinal reportCessna 310N · Danville, ILAircraft control not being maintained by the flight instructor and the flight instructor's inadequate supervision of the flight. Factors to the accident were the flight instructor's VFR flight into IMC weather conditions, the inadequate preflight…NTSB NYC00FA047Accident · 4 fatalField investigationFinal reportBeech 58TC · Hasbrouck Hts., NJthe failure of the pilot to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall/spin.