NTSB investigations, 2006
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 2006 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") = 2006 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 LAX06CA296Accident · No injuriesData collectionFinal reportBell 47G · Angels Camp, CAa hard landing due to the pilot's inadequate compensation for a wind shift encountered on final approach and his failure to maintain an adequate translational lift airspeed.NTSB LAX06CA295Accident · No injuriesData collectionFinal reportBeech A36 · Chandler, AZthe student's failure to establish a stabilized approach, which resulted in a bounced landing and a loss of directional control. Also causal was the flight instructor's inadequate supervision of the flight, delayed remedial action, and failure to verbally…NTSB DCA06WA073Incident · No injuriesForeign investigationBoeing 777 · Brisbane, AustraliaNTSB ANC06CA133Accident · No injuriesData collectionFinal reportPiper PA-18 · Koliganek, AKThe pilot's failure to maintain adequate altitude/clearance from rising terrain while maneuvering at a low altitude, which resulted in an in-flight collision with terrain. Factors associated with the accident were a downdraft, the pilot's intentional low…NTSB NYC06LA223Accident · Serious injuriesLimited investigationFinal reportBoeing 737-700 · Hastings, NEThe airplane's in flight encounter with thunderstorm related turbulence.NTSB NYC06CA225Accident · No injuriesData collectionFinal reportPiper PA-25-180 · Mount Holly, NJThe pilot's improper starting procedure, which resulted in an uncontrolled taxi, and collision with a parked airplane.NTSB MIA06CA139Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Fort Lauderdale, FLThe inadequate installation of a flexible hydraulic hose at the nose landing gear actuator by an unknown person resulting in the total loss of hydraulic fluid, the inability of the pilot to extend the landing gear, and subsequent wheels-up landing.NTSB LAX06CA297Accident · No injuriesData collectionFinal reportMooney M20J · Temecula, CAThe pilot's failure to flare that resulted in a hard landing.NTSB DCA06WA074Incident · No injuriesForeign investigationBoeing 767-300 · IcelandNTSB CHI06WA280Accident · 1 fatalForeign investigationGuscott VariViggen · Plaster Rock, CanadaNTSB CHI06LA263Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Prospect Height, ILThe partial loss of engine power during takeoff due to the flight crews failure to use carburetor heat and the flight instructor's inadequate planning/decision. A factor was the unsuitable terrain for a forced landing.NTSB ANC06LA140Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe pilot's failure to refuel the airplane before departure, which resulted in fuel exhaustion, and a total loss of engine power during cruise flight. Factors contributing to the accident were an inaccurate fuel tank indication on one of the two fuel tanks,…NTSB SEA06CA192Accident · No injuriesData collectionFinal reportAmorde Glasair II-S RG · Rockford, IDThe pilot's failure to maintain aircraft control during landing. A contributing factor was gusty winds.NTSB LAX06CA294Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5 · Watsonville, CAA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight planning, en route fuel consumption calculations, and in-flight decision to continue to the destination instead of stopping en route for fuel.NTSB CHI06CA266Accident · No injuriesData collectionFinal reportMD Helicopters 369FF · Port Clinton, OHThe pilot not maintaining clearance from the water during the survey flight. A factor was the low altitude the survey flight was flown at.NTSB ANC06FA131Accident · 2 fatalField investigationFinal reportde Havilland DHC-2 · Skwentna, AKThe pilot's continued VFR flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain. A factor associated with the accident was a low cloud ceiling.NTSB DFW06WA211Accident · 1 fatalForeign investigationPiper PA-46-310P · Toluca, MexicoNTSB DFW06CA215Accident · No injuriesData collectionFinal reportMaule MT-7 · Ponca, ARThe pilot's improper flare resulting in a hard landing.NTSB DEN06FA132Accident · 4 fatalField investigationFinal reportBeech 35-C33 · Telluride, COThe pilot's inadvertent flight into mountain wave turbulence resulting in the airplane's loss of control and subsequent impact into mountainous terrain. Factors contributing to the accident were the mountain wave turbulence and high winds.NTSB DEN06FA131Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Maybell, COThe pilot's improper in-flight planning and decision making resulting in an inadvertent encounter with severe icing conditions during cruise flight and subsequent loss of aircraft control. Contributing factors include the pilot's failure to obtain a weather…NTSB CHI06CA267Accident · No injuriesData collectionFinal reportColumbia 350 · Bloomington, INThe pilot did not comply with the pilot operating handbook warning when he intentionally opened the cabin door during flight.NTSB DEN06GA128Accident · 2 fatalFinal reportPiper PA-23-250 · Fort Meade, FLA loss of power in the right engine while manuevering for reasons undetermined, and failure to maintain aircraft control which resulted in an inadvertent stall. Contributing factors were the airspeed below Vmc, and an altitude too low to afford a safe…NTSB DCA06WA072Accident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Subic Bay, PhilippinesNTSB CHI06LA262Accident · No injuriesLimited investigationFinal reportCessna 310P · Kennett, MOSeparation of the left main landing gear torque link during landing resulting in a loss of control and runway excursion. Contributing factors were a failure to comply with the airframe manufacturer's service bulletin, and the pilot's inability to maintain…NTSB SEA06CA183Accident · No injuriesData collectionFinal reportCessna 305A · Lewistown, MTThe pilot's failure to maintain aircraft control during landing, which resulted in an inadvertent swerve and nose down. A contributing factor was the gusty wind condition.NTSB SEA06CA181Accident · No injuriesData collectionFinal reportCessna 172M · Moab, UTThe pilot's failure to obtain current NOTAMS which resulted in an on-ground collision with a construction berm while landing.NTSB NYC07WA089Accident · 3 fatalForeign investigationMD Helicopters MD-600N · Novokuznetsk, RussiaNTSB ENG06WA036Incident · No injuriesForeign investigationCessna 560 · Calgary, CanadaNTSB DEN06CA127Accident · No injuriesData collectionFinal reportPiper PA-46T-350P · Colo. Springs, COThe pilot's failure to maintain control of the airplane, resulting in an inadvertent stall. Contributing factors in this accident were the jet blast encounter, and the pilot's failure to initiate a go-around when he felt an unsafe condition existed.NTSB CHI06WA271Accident · No injuriesForeign investigationPiper PA-46-350P · Suwalki, PolandNTSB CHI06CA265Accident · No injuriesData collectionFinal reportPiper PA-34-220T · Dayton, OHThe pilot's inadvertent wheels up landing.NTSB SEA06CA180Accident · No injuriesData collectionFinal reportBeech B36TC · Cedar City, UTInadvertent collision with a deer during takeoff. A contributing factor was night conditions.NTSB LAX06TA291Accident · No injuriesFinal reportCessna U206G · Wasco, CAThe pilot's improper decision in leaving the engine running while he left the airplane unattended.NTSB LAX06LA292Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G-103A Twin II Acro · Minden, NVThe inadequate pre-takeoff checks by the flightcrew that failed to detect that the spoilers were deployed during the takeoff and initial climb. Also causal was the inadequate supervision of the flight by the flight instructor.NTSB DCA06WA069Incident · No injuriesForeign investigationBoeing 737 · Auckland, New ZealandNTSB SEA06CA182Accident · No injuriesData collectionFinal reportMaule M-4-180V · Lewistown, MTThe airplane inadvertently impacted a coyote hole during the landing roll on unsuitable terrain.NTSB SEA06CA179Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Kanab, UTThe pilot's failure to maintain aircraft control during the takeoff roll. Contributing factors were the rough/uneven conditions of the dirt runway, the wind gusts, and the berms and ditches on both sides of the runway.NTSB DEN06LA126Accident · Serious injuriesLimited investigationFinal reportBeech 77 · Live Oak, FLa loss of engine power for reasons undetermined, and an inadvertent stall while maneuvering.NTSB CHI06LA260Accident · No injuriesLimited investigationFinal reportEndless Skies L164 · Durand, MIThe kit builder's improper installation of the aileron bracket leading to the aileron flutter during cruise that resulted in the wing spars' failure.NTSB ANC06CA132Accident · No injuriesData collectionFinal reportPiper PA-12 · Noatak, AKThe pilot's selection of an unsuitable landing site, which resulted in a loss of control during the landing roll and a nose over. Factors associated with the accident were soft terrain and the pilot's failure to maintain directional control.NTSB NYC06LA220Accident · Serious injuriesLimited investigationFinal reportFlight Design Ctsw · Tunkhannock, PAThe pilot's improper recovery from a bounced landing.NTSB LAX06LA293Accident · 2 fatalLimited investigationFinal reportChampion 7EC · Clipper Mills, CAThe pilot failed to maintain clearance from mountainous terrain. A contributing factor was the pilot's impairment from ingestion of marijuana.NTSB LAX06LA290Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Van Nuys, CAInadequate maintenance adjustment and missing mixture spring, which resulted in a loss of engine power during approach.NTSB DEN06WA130Accident · 2 fatalForeign investigationRobinson R-22 Beta · St. Florian, AustriaNTSB CHI06CA259Accident · No injuriesData collectionFinal reportLuscombe 8E · Dodgeville, WIThe pilot encountering unsuitable terrain during the precautionary landing. A factor was the ditch the pilot encountered.NTSB DEN06CA125Accident · Minor injuriesData collectionFinal reportThomas Velocity · Conway, SCthe loss of engine power due to fuel starvation. The cause of the fuel starvation was not determined. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB DEN06CA124Accident · No injuriesData collectionFinal reportBell 47G-2 · Hayden, ALengine fire for reasons undetermined.NTSB DEN06CA123Accident · Serious injuriesData collectionFinal reportParsons JN4-D Jenny Replica · Crossville, TNA loss of control in flight due to a disconnected rudder control cable. Contributing to the accident was the pilot's inability to control the roll.NTSB CHI06LA258Accident · 1 fatalLimited investigationFinal reportGarner Garner Falcon · Newton, IAAn inflight collision with terrain during an unknown phase of flight. A factor was the pilot's lack of experience.NTSB ANC06CA126Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's excessive braking during the landing roll, which resulted in a loss of control and a nose over.