NTSB investigations, 2006
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 LAX07LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZa loss of engine power due to oil starvation to the number 3 cylinder crankpin and connecting rod bearing. The underlying cause of the oil starvation to the number 3 cylinder components could not be ascertained.NTSB LAX07FA060Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Big Pine, CAThe inadequate in-flight/planning decision of both pilots to fly up a box canyon at low altitude, and their failure to maintain clearance from the terrain.NTSB LAX07FA059Accident · 4 fatalField investigationFinal reportPiper PA-46-350P · Concord, CAFailure of the pilot to follow the prescribed instrument approach procedures and to maintain an adequate airspeed while maneuvering in the airport environment that led to a stall.NTSB DFW07LA043Accident · No injuriesLimited investigationFinal reportEurocopter EC120B · Grand Prairie, TXThe flight instructor's inadequate remedial action which resulted in a hard landing. A contributing factor was the lack of suitable terrain for the practice autorotation.NTSB CHI07CA044Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Cheyboygan, MIA loss of engine power for undetermined reasons. A factor was the soft terrain encountered during the lanidng.NTSB LAX07FA062Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Young, AZThe pilot's failure to maintain terrain clearance during cruise flight while flying at night at an altitude to remain clear of clouds and icing conditions. Contributing to the accident were an inadequate weather evaluation, the clouds, icing conditions, and…NTSB DFW07FA042Accident · 1 fatalField investigationFinal reportCessna T210N · Austin, TXThe pilot's failure to maintain control of the airplane while executing an instrument approach for undetermined reasons.NTSB DFW07FA041Accident · 1 fatalField investigationFinal reportBeech A36 · Fayetteville, ARThe pilot's failure to maintain clearance from obstacles. Contributing factors were the below approach/landing weather minimums, and the prevailing dark night conditions.NTSB SEA07FA035Accident · 3 fatalField investigationFinal reportBeech D95A · Gilroy, CAThe certified flight instructor's failure to maintain directional control of the airplane and inadequate supervision of the flight, which resulted in a stall/spin.NTSB CHI07LA043Accident · No injuriesLimited investigationFinal reportCessna 560 · North Canton, OHThe rupture of the hydraulic pressure hose assembly, which was caused by internal wear between the hose's fire sleeve and stainless steel braid, and the failure of the emergency landing gear assembly to deploy the right main landing gear during approach.…NTSB CHI07FA041Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Bucyrus, OHThe inadvertent stall the pilot encountered during cruise flight while inadvertently entering an area of icing and his exceeding the design limits of the airplane during the subsequent descent. Factors were the reported icing weather present aloft, the…NTSB SEA07LA036Accident · No injuriesLimited investigationFinal reportPiper PA 23-235 · Phoenix, AZThe landing gear collapsed for undetermined reasons while the aircraft was standing on the taxiway with the engines operating.NTSB SEA07CA034Accident · No injuriesData collectionFinal reportCessna 172 · Bonners Ferry, IDThe pilot's failure to maintain directional control during the takeoff roll. Contributing factors include icy runway conditions and a snow berm adjacent to the runway.NTSB MIA07LA028Accident · No injuriesLimited investigationFinal reportCessna 150K · Cape Coral, FLThe pilot's in-flight encounter with carburetor ice and inadequate remedial action which resulted in the engine ceasing to operate and a forced landing and damage to the airplane during the landing.NTSB DFW07FA039Accident · 3 fatalField investigationFinal reportBellanca 17-30A · Jay, OKThe loss of engine power for undetermined reasons and the pilot's improper decision to extend the landing gear for the water landing. Contributing factors were the prevailing night conditions and the lack of suitable terrain for the forced landing.NTSB ATL07LA028Accident · Minor injuriesLimited investigationFinal reportScharnhorst RV-4 · Hoschton, GAThe failure of the manufacturer to safety wire the purge valve stop screw during maintenance resulting in a total loss of engine power in cruise flight due to fuel starvation. This resulted in a forced landing, on-ground collision with a berm/terrace, and…NTSB WAS07WA005Accident · 2 fatalForeign investigationCessna 310Q · Mbeya, TanzaniaNTSB ENG06WA040Incident · No injuriesForeign investigationSaab 340 · Mount Isa Queensland, Australia, AustraliaNTSB DFW07CA038Accident · No injuriesData collectionFinal reportCessna 421 · Brackettville, TXThe pilot's failure to maintain proper runway alignment on final approach and his delayed decision to execute a go-around. Factors were the dark night conditions and the inoperative runway edge lights.NTSB DEN07WA038Accident · No injuriesForeign investigationPiper PA-46-350P · Augsburg, GermanyNTSB DEN07IA037Incident · Minor injuriesIncident investigationFinal reportBoeing 737-824 · Colorado Spring, COA short circuit in the primary (non-rechargeable) battery, most likely due to it being recharged. This internal short led to thermal runaway, battery failure, and an explosion.NTSB MIA07CA027Accident · Serious injuriesData collectionFinal reportRichard F. Sheldon Aventura II · Palm Beach Gard, FLThe pilot's failure maintain the proper airspeed during takeoff, which resulted in a stall.NTSB DFW07WA040Accident · 3 fatalForeign investigationPiper PA-34-220T · Cadiz, SpainNTSB NYC07FA048Accident · 2 fatalField investigationFinal reportBell 407 · Dagsboro, DEThe pilot's improper decision to depart under visual flight rules into night instrument meteorological conditions. Contributing to the accident was the fog and the dark night conditions.NTSB NYC07FA047Accident · 1 fatalField investigationFinal reportCessna 310Q · Montgomery, NYImproper maintenance performed on the airplane by maintenance personnel, and the failure of the mechanic with an inspection authorization (IA) to verify the maintenance work performed, which resulted in a reverse elevator trim system, and subsequent loss of…NTSB NYC07CA049Accident · Minor injuriesData collectionFinal reportCessna 172C · Middletown, NYThe pilot misjudging distance/altitude during the turn from base to final, which resulted in an undershoot and subsequent collision with trees. A factor was the haze.NTSB CHI07LA038Accident · No injuriesLimited investigationFinal reportBeech B36TC · Peoria, ILThe loss of engine power due to a fatigue fracture of the exhaust valve as a result of maintenance not performed by the aircraft owner, and the unsuitable terrain encountered during the forced landing.NTSB CHI07CA040Accident · No injuriesData collectionFinal reportSchleicher AS-K13 · Gregory, MIThe pilot's unexpected encounter with wind shear and his inability to remain clear of the trees while on final approach to land.NTSB ANC07FA007Accident · 2 fatalField investigationFinal reportPiper PA-32-301 · Port Heiden, AKThe pilot's failure to maintain control of the airplane during cruise flight, which resulted in an uncontrolled descent, and an in-flight collision with snow-covered terrain. Contributing to the accident were the pilot's spatial disorientation, and dark night…NTSB MIA07LA026Accident · No injuriesLimited investigationFinal reportLingwall Rebich-Pitts · Naples, FLThe experimental airplane's pilot inadequate visual lookout while taxiing for takeoff, which resulted in an on-ground collision with a Piper airplane which was standing with its engine operating in the runup area.NTSB CHI07LA037Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Waterloo, IAThe go-around not performed and the improper flare by the pilot during landing.NTSB ATL07CA027Accident · Serious injuriesData collectionFinal reportPiper J-2 · Williamson, GAThe pilot's inadequate preflight inspection which resulted in fuel exhaustion a subsequent total loss of engine power.NTSB SEA07FA031Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bandon, ORThe loss of aircraft control in the traffic pattern for undetermined reasons.NTSB SEA07CA033Accident · Minor injuriesData collectionFinal reportExtra Flugzeugbau EA 300/L · Boulder City, NVThe pilot-in-command's failure to maintain directional control of the airplane during takeoff.NTSB CHI07IA042Incident · No injuriesIncident investigationFinal reportBell 407 · Raytown, MOThe loss of engine power during cruise flight due to third stage turbine wheel blade fatigue and subsequent separation, which resulted in an emergency landing.NTSB CEN09WA360Incident · No injuriesForeign investigationGulfstream American 690C · Lelystad, NetherlandsNTSB SEA07CA029Accident · No injuriesData collectionFinal reportCessna 172RG · Laurel, MTThe pilot's inadequate compensation for the crosswind conditions during the landing roll, which resulted in a loss of control and subsequent nose over. A contributing factor was the crosswind condition.NTSB NYC07CA045Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Danbury, CTThe student pilot's inadequate recovery from a bounced landing, which resulted in a hard landing.NTSB LAX07FA056Accident · 3 fatalField investigationFinal reportBell 412SP · Hesperia, CAThe pilot's inadvertent encounter with instrument meteorological conditions and subsequent failure to maintain terrain clearance. Contributing to the accident were the dark night conditions, fog, and mountainous terrain.NTSB DFW07FA036Accident · 3 fatalField investigationFinal reportCessna 310Q · Waco, TXThe pilot's failure to maintain sufficient airspeed to avoid a stall during the instrument landing approach, which resulted in an inadvertent stall and collision with terrain. Also causal was the pilot's impairment due to prohibited drugs. Factors associated…NTSB DFW07CA037Accident · No injuriesData collectionFinal reportHughes 269B · Houma, LAA partial loss of engine power as a result of a cracked engine cylinder and broken spark plug which resulted in a hard landing. A factor was that it was not possible to attain proper rotor RPM.NTSB CHI07LA036Accident · Minor injuriesLimited investigationFinal reportNavion Navion G · Coalton, OHThe pilot failed to follow the checklist and lower the landing gear. A factor in the accident was the fence post.NTSB CHI07CA075Accident · No injuriesData collectionFinal reportBombardier BD-100-1A10 · Waukegan, ILThe bird strike during initial climb after takeoff from the departure airport.NTSB NYC07FA043Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Charlottesville, VAA loss of engine power for undetermined reasons.NTSB NYC07CA046Accident · No injuriesData collectionFinal reportCessna 172R · Northhampton, MAThe pilot's inadequate recovery from a bounced landing.NTSB LAX07LA055Accident · Serious injuriesLimited investigationFinal reportHigher Class Super Hornet · Chandler, AZA loss of aircraft control for undetermined reasons.NTSB ATL07LA026Accident · No injuriesLimited investigationFinal reportRidgway Bensen B8M · Johns Island, SCThe pilots improper preflight planning and decision resulting in a total loss of engine power due to fuel exhaustion.NTSB ATL07LA025Accident · 2 fatalLimited investigationFinal reportFagan Rans S-6S · Taylorsville, NCThe pilots failure to maintain airspeed while maneuvering resulting in an inadvertent stall, uncontrolled decent, collision with the ground, and a post crash fire.NTSB SEA07LA028Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Bountiful, UTThe pilot's improper decision to fly up a mountain canyon at low level without knowledge of the wind conditions. Factors associated with the accident are gusty winds, downdrafts, and rough/uneven terrain.NTSB SEA07CA027Accident · No injuriesData collectionFinal reportPiper PA-12 · Antelope Island, UTThe pilot's excessive braking during a precautionary landing at an off-airport landing area. A contributing factor was the pilot's non-standard modification of the oil cooler, which resulted in high engine oil temperature.