NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 DEN07LA049Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMThe pilot-rated dual student's failure to maintain sufficient airspeed during the landing approach to avoid a stall. Also causal was the flight instructor's failure to provide adequate supervision. Factors associated with the accident are an inadvertent…NTSB CHI07LA059Accident · Minor injuriesLimited investigationFinal reportCessna 425 · Harbor Springs, MIThe pilot's failure to maintain aircraft control and adequate airspeed during landing flare. Contributing to the accident was the aerodynamic stall/mush encountered at a low altitude.NTSB SEA07LA046Accident · Serious injuriesLimited investigationFinal reportCessna TR182 · San Diego, CAThe pilot's failure to maintain control of the airplane during takeoff. A contributing factor to the accident was the improper takeoff configuration of the airplane.NTSB MIA07CA035Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Lakeland, FLThe flight instructor's selection of an unsuitable landing site, which resulted in an inadvertent dynamic rollover during landing. A factor associated with the accident was the inadvertent dynamic rollover.NTSB SEA07LA044Accident · No injuriesLimited investigationFinal reportCessna 172S · Lancaster, CAThe reason for the loss of directional control was undetermined.NTSB OPS07IA002Incident · No injuriesIncident investigationFinal reportBoeing 757-212 · Atlanta, GAThis incident was caused by the local controller's issuance of an improper takeoff clearance to DAL1606. Contributing was the failure of the oncoming and outgoing local controllers to provide and receive a complete position relief briefing; and the oncoming…NTSB MIA07RA034Accident · 2 fatalForeign investigationGates Learjet 24F · Guadalajara, MexicoNTSB DFW07FA055Accident · 1 fatalField investigationFinal reportCessna 310 · Jackson, MSThe pilot's loss of control for undetermined reasons.NTSB CHI07CA058Accident · No injuriesData collectionFinal reportLearjet 35A · Columbus, OHThe pilot's failure to maintain aircraft control during an inflight maneuver which resulted in the design stress limits of the airplane being exceeded. A factor was the excessive airspeed encountered during recovery.NTSB CHI07CA057Accident · Serious injuriesData collectionFinal reportBarron Thorp T18 · Edinburg, OHThe pilot's improper in-flight decision not to refuel prior to fuel exhaustion. A factor to the accident was the tree line that the airplane impacted during the forced landing.NTSB ANC07FA013Accident · 1 fatalField investigationFinal reportCessna 207A · Kenai, AKThe total loss of engine power during cruise flight due to the disintegration of engine bearings and the fracture of a connecting rod, which resulted in a ditching into ice covered ocean water. Factors contributing to the survivability of the accident were…NTSB NYC07FA055Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Jamestown, NYThe pilot's incorrect selection of the right engine fuel selector position, which resulted in fuel starvation of the right engine, a loss of the right engine's power, and a loss of control during initial climb. Contributing to the accident were the pilot's…NTSB DEN07IA048Incident · No injuriesIncident investigationFinal reportRaytheon B300 · Englewood, COThis case was modified 10/30/2007 Failure of the nose landing gear upper torque knee due to overstress, and the pilot's inability to maintain aircraft control.NTSB ANC07WA012Accident · 1 fatalForeign investigationBeech A-100 · Sandy Bay, CanadaNTSB SEA07LA043Accident · No injuriesLimited investigationFinal reportBell 206B · Boise, IDThe pilot's failure to maintain clearance from tall brush during a low-hover pedal turn. A factor was the six foot-tall brush located adjacent to the area where the pilot was operating.NTSB ENG07WA028Incident · No injuriesForeign investigationMcdonnell Douglas MD11 · Jfk, NYNTSB DEN07CA047Accident · No injuriesData collectionFinal reportCessna 182G · Lamar, COthe pilot's inability to maintain directional control resulting in an impact with a snow bank. Contributing factors include the obscured runway lights, inoperative landing lights, and the pilot's improper decision to operate an airplane with known systems…NTSB ANC07LA014Accident · No injuriesLimited investigationFinal reportCessna 207 · Kipnuk, AKThe pilot's failure to maintain adequate clearance from terrain during the landing roll, which resulted in a collision with a snow berm with the left main landing gear, and subsequent damage to the right wing. Factors contributing to the accident were dark…NTSB MIA07LA041Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Immokalee, FLThe failure of the glider towing "weak link," for undetermined reasons, at an inadequate altitude to effect a normal landing, resulting in a hard landing.NTSB MIA07CA033Accident · Minor injuriesData collectionFinal reportRyan Aeronautical ST3KR · Lake Butler, FLa partial loss of engine power due to a disconnected throttle control push-rod, which resulted in a forced landing and collision with trees and the ground.NTSB WAS07WA007Accident · 1 fatalForeign investigationPiper PA-31-350 · Selous, TanzaniaNTSB SEA07CA042Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Buckley, WAThe pilot's failure to release brake pressure soon enough when his airplane skidded from wet grass onto dry terrain during an off-airport, full-stop landing. A factor was the change in terrain from wet grass to dry ground in the landing area.NTSB OPS07IA001Incident · No injuriesIncident investigationFinal reportSwearingen SW-4 · Denver, COThe probable cause of the incident was the Key Lime Air flight 4216 pilot's inadvertant entry onto the active runway. A contributing factor to the incident was the failure of the Denver tower ground and local controllers to detect the aircraft on the airport…NTSB DFW07CA053Accident · No injuriesData collectionFinal reportEnstrom F28A · Bruceville, TXThe instructor pilot's improper demonstration of an autorotation, resulting in the helicopter's main rotor blades impacting the ground.NTSB DEN07FA045Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Manzanola, COthe pilot's failure to maintain control of the airplane after an inadvertent encounter with instrument meteorological conditions resulting in the subsequent impact with terrain. Contributing factors were the pilot's inadequate preflight planning, self-induced…NTSB CHI07CA055Accident · No injuriesData collectionFinal reportCessna 150M · Bristol, WIThe pilot's selection of unsuitable terrain to taxi on for takeoff. A factor was the soft terrain condition.NTSB ATL07FA031Accident · 3 fatalField investigationFinal reportCessna 182P · Columbia, SCThe pilot's failure to follow approach procedures by descending below the prescribed descision height altitude resulting in an in-flight collision with trees and the ground. This report was modified on January 25, 2008.NTSB SEA07LA041Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Lyman, WAThe pilot's intentional flight into adverse weather conditions, which resulted in a loss of engine power during hover due to snow and ice ingestion. Factors associated with the accident are the pilot's delayed remedial actions, and snow and icing conditions.NTSB NYC07CA054Accident · No injuriesData collectionFinal reportCessna R182 · Hackettstown, NJThe pilot-in-command's delayed aborted takeoff, which resulted in a runway overrun and collision with terrain. A factor was the rocks off the end of the runway.NTSB DFW07FA051Accident · 2 fatalField investigationFinal reportCessna 182R · Batesville, ARThe pilot's failure to maintain clearance from trees. A contributing factor to the accident was the prevailing low ceilings.NTSB DFW07FA049Accident · 3 fatalField investigationFinal reportCessna 172H · Armstrong, TXThe pilot's continued flight into adverse weather conditions resulting in a loss of control. Contributing factors were the dark night conditions, the clouds. low ceilings, and the pilot's limited night and instrument experience.NTSB DEN07LA044Accident · Serious injuriesLimited investigationFinal reportMarino Exec 162F-1995 · Baldwin City, KSthe failure of the tail rotor drive belt for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI07CA054Accident · No injuriesData collectionFinal reportCessna 172S · Alton, ILThe student pilot's inadequate recovery from a bounced landing, which resulted in the airplane impacting a runway sign. A factor in the accident was the student pilot's misjudged landing flare.NTSB DFW07LA052Accident · No injuriesLimited investigationFinal reportFairchild Merlin SA-226-T · Tulsa, OKThe loss of control as result of the malfunction of the nose wheel steering mechanism during landing for undetermined reasons.NTSB CHI07FA052Accident · 1 fatalField investigationFinal reportBeech 58 · Washington, INThe pilot's failure to maintain clearance from trees and terrain while attempting to return to the departure airport for undetermined reasons after takeoff. The intervening tree line was a contributing factor.NTSB LAX07CA070Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Jackpot, NVthe pilot's failure to maintain directional control after encountering loose snow conditions on the runway.NTSB DEN07CA046Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Walden, COThe pilot experiencing lateral flight control stiffness for undetermined reasons and the pilot's intentional wheels up landing. Factors were the snow covered and rough/uneven terrain.NTSB DCA07RA019Accident · 102 fatalForeign investigationBoeing 737-400 · Makassar, IndonesiaNTSB NYC07FA052Accident · 4 fatalField investigationFinal reportCessna TR182 · Charlotte, NCThe pilot's spatial disorientation, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was instrument meteorological conditions.NTSB NYC07CA053Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Cumberland, MDThe pilot's misjudgment of the airplane's distance/altitude during the landing approach.NTSB LAX07LA067Accident · 1 fatalLimited investigationFinal reportCessna 150J · San Diego, CAThe pilot's improper use of the throttle and failure to maintain an adequate airspeed that resulted in a stall/spin.NTSB DFW07CA048Accident · No injuriesData collectionFinal reportCessna 172S · Spicewood, TXThe pilot's failure to compensate for the existing wind conditions resulting in a loss of directional control. Factors were the gusty crosswind and the muddy terrain.NTSB DFW07CA047Accident · No injuriesData collectionFinal reportPiper PA 32R 301T · Crystal Beach, TXThe pilot's touchdown too far down the runway resulting in an overrun. Factors were the wet grass runway and the trailer.NTSB DEN07LA042Accident · Serious injuriesLimited investigationFinal reportMino Kitfox 3 · Canon City, COThe certificated flight instructor's failure to adequately supervise the dual student during the landing flare-touchdown, which resulted in a hard landing and a nose over. A factor associated with the accident is the dual student's improper recovery from a…NTSB DCA07WA021Incident · No injuriesForeign investigationBoeing B757-200 · Athens, GreeceNTSB CHI07LA051Accident · 1 fatalLimited investigationFinal reportPiper PA-32-300 · Romeo, MIThe pilot's failure to maintain aircraft control and proper rate of descent during the VOR approach. Factors associated with the accident were the low cloud conditions and moderate to heavy rain.NTSB ANC07LA011Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Albany, GAThe loss of engine power during cruise flight due to a fractured crankshaft, resulting in an off-airport forced landing in a muddy field.NTSB WAS07WA006Accident · Minor injuriesForeign investigationde Havilland DHC-5 · Nairobi, KenyaNTSB SEA07LA040Accident · 1 fatalLimited investigationFinal reportTessier Avid Flyer · Hillsboro, ORThe loss of engine power during maneuvering flight due to carburetor icing, and inadvertent flight into instrument meteorological conditions. Factors were the ambient weather conditions conducive to carburetor icing and fog.NTSB LAX07LA081Accident · No injuriesLimited investigationFinal reportCessna 140 · Van Nuys, CAFailure of the pilot under instruction to maintain directional control of the airplane and the flight instructor's inadequate supervision.