NTSB investigations, 2006
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\") = 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 ATL06LA133Accident · No injuriesLimited investigationFinal reportRobinson R44 · Beaufort, NCThe loss of engine power for undetermined reasons.NTSB SEA06CA191Accident · No injuriesData collectionFinal reportMaule M-6-235 · Ronan, MTThe pilot's failure to maintain directional control during the landing roll in the tailwheel-equipped aircraft. A swale (sunken area) between the runway and the taxiway was a factor.NTSB NYC06LA231Accident · No injuriesLimited investigationFinal reportMooney M-18L · Lexington, KYThe failure of both magnetos which resulted in a loss of engine power during cruise flight.NTSB DFW06CA217Accident · No injuriesData collectionFinal reportBrantly Helicopter B-2B · Carrizo Springs, TXThe loss of engine power due to a malfunction of the electric fuel pump. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DCA06RA076Accident · 154 fatalForeign investigationBoeing 737-800 · Azevedo, BrazilNTSB CHI06CA274Accident · No injuriesData collectionFinal reportBeech B19 · Pontiac, MIThe pilot's failure to perform a go-around when he noticed the airplane was not on a stabilized final approach. Contributing factors to the accident were the hard landing, the subsequent pilot-induced oscillation (porpoise) which resulted in the collapse of…NTSB ATL06CA131Accident · No injuriesData collectionFinal reportBeech A36 · Macon, GAThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation and a forced landing.NTSB LAX06CA299Accident · Minor injuriesData collectionFinal reportBeech 95-55 · Safford, AZThe pilot's inadequate in-flight planning/decision and inaccurate fuel consumption calculations, which led to fuel exhaustion and total loss of power to both engines.NTSB DFW06LA216Accident · 1 fatalLimited investigationFinal reportWeber Venture · El Paso, TXThe aircraft's inadequate landing gear design, which resulted in a loss of directional control and subsequent nose-over. A factor was the owner/builder's failure to incorporate modifications to the landing gear.NTSB CHI06LA273Accident · Minor injuriesLimited investigationFinal reportDaub Pawnee Chief · McCook, NEThe failure of a welded joint at a cyclic control cable bracket located on the main rotor mast which made control of the helicopter impossible for the pilot.NTSB ATL06CA132Accident · No injuriesData collectionFinal reportCessna 180K · Mooresville, NCThe pilot's failure to maintain directional control during the takeoff roll which resulted in a ground loop.NTSB SEA06CA190Accident · No injuriesData collectionFinal reportColtrin RV-6 · Burley, IDA loss of engine power due to the malfunctioning of the carburetor. A factor was the airplane nosing over due to the rough/uneven terrain.NTSB NYC06FA230Accident · 1 fatalField investigationFinal reportBeech S35 · Lake City, FLA loss of control during an unintentional takeoff for an undetermined reason.NTSB NYC06IA229Incident · No injuriesIncident investigationFinal reportAmerican Blimp A-60+ · Manchester, MAA malfunction of the rudder control system, and the pilot's inadequate preflight inspection. Contributing to the incident was the inadequate design of the chain keeper guards.NTSB DEN06CA134Accident · No injuriesData collectionFinal reportCessna 152 · Bennett, COThe pilot's failure to maintain control of the airplane during the aborted takeoff. Factors contributing to the accident were the low airspeed and the pilot's improper in-flight planning.NTSB CHI06CA272Accident · No injuriesData collectionFinal reportBoeing A75N1 · Garrettsville, OHThe pilot's failure to maintain directional control during the takeoff roll. The bush and tree were factors to the accident.NTSB ATL06LA130Accident · Minor injuriesLimited investigationFinal reportBellanca 14-13-2 · Ellijay, GAA loss of engine power due to fuel contamination. Also causal was the mechanic's failure to ensure the aircraft's fuel system was free of contamination while performing an annual inspection.NTSB SEA06CA189Accident · Minor injuriesData collectionFinal reportNorthwing Apache Sport · Brewster, WAThe pilot's failure to maintain control of the aircraft during the landing, resulting in its impact with terrain. A factor was the wind gust condition.NTSB LAX06FA304Accident · 2 fatalField investigationFinal reportCessna 182K · Sedona, AZThe pilot's failure to maintain clearance from trees and terrain while maneuvering in mountainous/hilly terrain in a high density altitude environment.NTSB LAX06CA303Accident · No injuriesData collectionFinal reportCleberg Sportsman 2+2 GS-2 · Tucson, AZThe pilot's failure to maintain directional control of the airplane during landing.NTSB DFW06CA213Accident · No injuriesData collectionFinal reportRobinson R22 · Skiatook, OKThe pilot's failure to maintain control of the helicopter following an encounter with dynamic rollover.NTSB CHI06FA269Accident · 1 fatalField investigationFinal reportCessna 182Q · Cumberland, WIThe pilot's inadvertent attempt to land on water with the wheels down and his failure to verify the gear position prior to landing. Contributing factors were the inoperative gear system due to the open gear selector circuit breaker, which tripped for…NTSB ANC06WA139Accident · 1 fatalForeign investigationBell 204B · Stony Rapids, CanadaNTSB ANC06LA137Accident · No injuriesLimited investigationFinal reportAerospatiale SA319B · Port Alsworth, AKThe pilot's failure to adequately secure the external load rigging of an airplane that was suspended from the helicopter, which resulted in a load shift during cruise flight, producing an abrupt nose-down attitude, and the severing of the tailrotor drive…NTSB ANC06CA138Accident · No injuriesData collectionFinal reportCessna 172 · Palmer, AKThe pilot's failure to follow the checklist to ensure the proper positioning of the magneto switch during the takeoff roll, which resulted in a partial loss of engine power, and a subsequent collision with high vegetation during the takeoff run. A factor…NTSB SEA06LA188Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Trenton, FLA partial loss of engine power just after takeoff due to water contamination of the auto fuel added to the aircraft fuel system just prior to the flight. Factors include the pilot's inadequate preflight, no suitable landing area near the departure end of the…NTSB SEA06CA186Accident · No injuriesData collectionFinal reportCessna 152 · Pembroke Pine, FLThe student pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the runway sign.NTSB DFW06CA214Accident · No injuriesData collectionFinal reportAir Tractor 301 · Big Spring, TXA loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel the airplane. A contributing factor was the lack of suitable terrain for a forced landing.NTSB DFW06CA212Accident · Minor injuriesData collectionFinal reportVans RV4 · Springtown, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL06FA129Accident · 3 fatalField investigationFinal reportBeech F-33A · Alabaster, ALThe pilot's failure to maintain airspeed while maneuvering toward an emergency landing area following the total loss of engine power shortly after takeoff resulting in an inadvertent stall, uncontrolled descent, and collision with the ground, and a fence. A…NTSB SEA06LA185Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Delta, UTA loss of engine power for an undetermined reason during cruise flight.NTSB SEA06CA187Accident · No injuriesData collectionFinal reportCessna 172S · Naples, FLThe student pilot's failure to adequately compensate for wind conditions during the landing roll. A drainage ditch and wind were contributing factors.NTSB NYC06LA228Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Orient, METhe pilot's failure to maintain adequate airspeed during the initial climb which resulted in an inadvertent stall. A factor was his inadequate weight and balance calculations and the gusty wind conditions.NTSB MIA06WA138Accident · 1 fatalForeign investigationBell 212 · San Vicente, ColombiaNTSB MIA06WA137Incident · No injuriesForeign investigationCirrus Design SR22 · Bull Bay, JamaicaNTSB DEN06WA133Accident · 1 fatalForeign investigationPiper PA-28-181 · Bad Schwartau, GermanyNTSB DCA06WA075Incident · No injuriesForeign investigationBoeing 777-200 · Brindisi, ItalyNTSB CHI06LA268Accident · 1 fatalLimited investigationFinal reportWindler Tri Q2 · Branson, MOFatigue failure, originating in an area of surface corrosion, of the right elevator mid span hinge pin and the subsequent failure of the elevator torque tube. Additional causes are the separation of the elevator from the airframe due to the hinge pin and…NTSB CHI06FA264Accident · 1 fatalField investigationFinal reportBeech BE-95-B55 · N. Sioux City, SDThe pilot's failure to maintain control of the airplane during cruise flight, and subsequent inadvertent flat spin from which he could not recover. Contributing to the accident were clouds, turbulence, and rain showers.NTSB CHI06CA270Accident · No injuriesData collectionFinal reportDevereux Mustang II · Auburn, INThe failure of the left main landing gear attachment weld which resulted in the pilot's inablility to maintain directional control of the airplane during the landing roll.NTSB ANC06FA136Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 · Kodiak, AKThe pilot's failure to maintain adequate airspeed while maneuvering to reverse direction, which resulted in an inadvertent stall and an uncontrolled descent. Factors associated with the accident were the inadvertent stall and wind gusts.NTSB SEA06LA184Accident · 1 fatalLimited investigationFinal reportShimer One Design · Lake Wales, FLThe loss of control for an undetermined reason during the landing roll.NTSB NYC06LA227Accident · 2 fatalLimited investigationFinal reportAir Trikes Tourist · Middlebury, VTA loss of control for undetermined reasons.NTSB LAX06LA298Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Auburn, CAthe fatigue failure of the elevator's control rod due to inadequate lubrication. Contributing factors were the inadequate maintenance and the owner-pilot's failure to comply with an airworthiness directive.NTSB ATL06CA128Accident · No injuriesData collectionFinal reportMooney M-20J · Blue Ridge, GAThe pilot's failure to achieve the proper touchdown point on landing resulting in an overrun, and on ground collision with trees.NTSB ANC06CA135Accident · No injuriesData collectionFinal reportCessna 150 · Anchorage, AKThe pilot's misjudged distance/altitude during final approach, which resulted in an undershoot and subsequent in-flight collision with terrain. A factor associated with the accident was a landing gear collapse.NTSB NYC06LA224Accident · Serious injuriesLimited investigationFinal reportGarlick OH-58A · East Bridgewate, MAThe completion center's installation of the incorrect (shorter) release cable, and the ground crewmember's improper movement under the flight path during a bin transfer.NTSB LAX06WA300Accident · Minor injuriesForeign investigationBoeing B75N1 · Canyonleigh,NSW, AustraliaNTSB ATL06LA127Accident · No injuriesLimited investigationFinal reportStinson 108 · Holladay, TNA total loss of engine power in cruise flight due to the fatigue failure of the crankshaft gear resulting in a forced landing and subsequent nose over.NTSB SEA06LA193Accident · No injuriesLimited investigationFinal reportCessna 152 · Lantana, FLThe student pilot's improper recovery from a bounced landing.