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 ATL07CA085Accident · Serious injuriesData collectionFinal reportRobert J. Jackson RV6-A · Summerville, GAThe pilot's failure to maintain sufficient airspeed to avoid a stall during the landing flare, resulting in an uncontrolled descent and in-flight collision with the runway.NTSB SEA07CA136Accident · Minor injuriesData collectionFinal reportLidgard 4-1200 · Spartanburg, SCThe pilot lost directional control of the airplane during takeoff. A contributing factor was the pilot's lack of experience in the accident airplane make/model.NTSB OPS07IA004Incident · No injuriesIncident investigationFinal reportEmbraer 170 · San Francisco, CAFailure of SFO tower local controller to provide adequate separation between two aircraft departing intersecting runways.NTSB NYC07FA126Accident · 3 fatalField investigationFinal reportColumbia Aircraft Mfg LC42-550FG · Burnsville, NCThe pilot's improper recovery from a bounced landing resulting in a loss of directional control and subsequent impact with several parked airplanes.NTSB NYC07CA127Accident · Minor injuriesData collectionFinal reportWroblewski Searey · Freeport, PAThe pilot's improper flare, which resulted in a nose over while attempting to land on a river. A factor in this accident was the glassy water landing conditions.NTSB ANC07CA039Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot's failure to maintain altitude/clearance while maneuvering, which resulted in a collision with trees. A factor contributing to the accident was dusk lighting conditions.NTSB NYC07CA128Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Nashua, NHThe flight instructor's inadvertent entry into a vortex ring state (settling with power). Factors to the accident was the tailwind.NTSB MIA07WA145Accident · No injuriesForeign investigationDouglas DC-3 · Acaricuara, ColombiaNTSB LAX07LA175Accident · 1 fatalLimited investigationFinal reportSkygear Skygear · Chino, CAThe pilot's failure to maintain an adequate airspeed that resulted in an inadvertent stall.NTSB LAX07LA173Accident · Minor injuriesLimited investigationFinal reportWestland Helicopters Wasp HAS MK1 · Ramona, CAFailure of the pilot to maintain clearance from a tree while performing a precautionary landing. Contributing to the accident was the failure of a snubber dampener that induced a severe vibration in the rotor system.NTSB DEN07CA096Accident · No injuriesData collectionFinal reportCessna 172P · Manhattan, KSThe flight instructor's failure to maintain control of the airplane during the landing. A contributing factor was the inadvertent encounter with the military helicopter's rotor wash.NTSB CHI07CA156Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Elwood, INThe commercial pilot's failure to maintain adequate altitude and airspeed which resulted in the airplane mushing into the terrain during the simulated forced landing along with the CFI's failure to adequately supervise the commercial pilot's actions.NTSB CHI07CA155Accident · No injuriesData collectionFinal reportChampion 7EC · Sioux Falls, SDThe pilot's inadequate compensation for the wind conditions and the excessive pull-up during the initial takeoff climb which resulted in the stall. A factor associated with the accident was the crosswind condition.NTSB MIA07CA101Accident · No injuriesData collectionFinal reportMooney M20R · Carthage, NCThe delay by the pilot-in-command to recover from a bounced landing resulting in a hard landing and subsequent collapse of the nose and left main landing gears.NTSB ENG07WA041Incident · No injuriesForeign investigationBeech B200 · Broome, Australia, AustraliaNTSB DFW07LA120Accident · 1 fatalLimited investigationFinal reportCessna U206G · Leeville, LAThe failure of the operator of the powerboat to maintain separation from the departing floatplane.NTSB DFW07CA121Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Lubbock, TXThe failure of the engine fuel supply line and the separation of the number one cylinder exhaust pipe resulting in an engine fire.NTSB NYC07LA125Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Leesburg, VAThe loss of engine power that resulted from the failure of an exhaust valve rocker arm during cruise.NTSB NYC07LA124Accident · 2 fatalLimited investigationFinal reportBoeing Stearman A75N1 · Charleston, SCAn in-flight collision with water for undetermined reasons.NTSB LAX07LA180Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Winslow, AZLoss of engine power for undetermined reasons.NTSB LAX07CA174Accident · No injuriesData collectionFinal reportBeech 76 · Pahokee, FLthe flying pilot's inadequate compensation for the known gusty crosswind conditions, and failure to maintain proper alignment with the landing runway.NTSB DFW07LA157Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Castroville, TXThe flight instructor's inability to maintain directional control due to the drag created by the tall grass adjacent to the runway. A contributing factor was the tall grass.NTSB DEN07WA093Accident · 1 fatalForeign investigationGrumman American AG-5B · Fulda-Jossa, GermanyNTSB CHI07LA154Accident · Serious injuriesLimited investigationFinal reportCessna 421 · Chesterfield, MOMaintenance personnel failed to comply with an Airworthiness Directive which resulted in the total failure of the starter adapter gear teeth and the crankshaft gear teeth and the pilot failed to follow the published emergency procedures. Contributing to the…NTSB SEA07LA249Accident · 1 fatalLimited investigationFinal reportCessna 177 · Pinecliff, WAThe pilot's failure to maintain clearance from the trees while maneuvering in mountainous terrain. Factors include the mountainous terrain, low ceilings, and trees in the area where the pilot was maneuvering.NTSB NYC07LA123Accident · Serious injuriesLimited investigationFinal reportDever Stits Playmate SA11A · Connellsville, PAThe pilot's inability to maintain control of the airplane due to an undetermined physiological impairment.NTSB LAX07CA172Accident · No injuriesData collectionFinal reportSchweizer SGS2-33A · Los Alamitos, CAfailure of the towrope during the initial climb out.NTSB DFW07GA119Accident · 1 fatalFinal reportEurocopter AS 350 B3 · San Elizario, TXThe pilot's encounter with a vortex ring state and his inability to maintain control of the helicopter.NTSB CHI07CA152Accident · No injuriesData collectionFinal reportCessna 421C · Kokomo, INThe pilot not obtaining proper alignment with the runway during the emergency landing after takeoff, which imparted an excessive side load on the landing gear. Factors contributing to the accident were the unstabilized approach and engine shutdown due to the…NTSB CHI07LA150Accident · 2 fatalLimited investigationFinal reportWood Vans RV7A · Marysville, OHThe pilot's failure to maintain clearance from an object during a go-around and subsequent failure to maintain adequate airspeed. An airport sign and an inadvertent stall were factors.NTSB ATL07CA084Accident · No injuriesData collectionFinal reportRotorway Rotorway Intl 162F · Argyle, NYThe loss of engine power due to the sticking of the exhaust valves that resulted from carbon buildup.NTSB SEA07LA129Accident · 1 fatalLimited investigationFinal reportSIAI-Marchetti FN-333 · Minden, NVThe loss of engine power as a result of fuel starvation due to the pilot's improper positioning of the fuel selector and failure to select a tank containing fuel.NTSB DFW07LA118Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5B · Hilltop Lakes, TXThe loss of engine power due to carburetor ice. Contributing factors were the lack of suitable terrain for a forced landing and the weather conditions that were conducive to carburetor ice.NTSB DFW07CA122Accident · Minor injuriesData collectionFinal reportLuciani RV8 · Tomball, TXThe deflated right main landing gear tire, which resulted in a loss of control during the landing roll and a nose over. A factor associated with the accident was the pilot's decision to operate the airplane without having the leaking tire inspected.NTSB SEA07LA133Accident · No injuriesLimited investigationFinal reportBeech B-99 · Billings, MTThe total failure of the nose landing gear actuator and the subsequent nose gear collapse during landing.NTSB SEA07LA132Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26A · Lake Elsinore, CAThe glider's encounter with a downdraft while in the traffic pattern, resulting in insufficient altitude to reach the airport. A contributing factor was the pilot's selection of an unsuitable off-airport landing area, which led to an on-ground collision with…NTSB NYC07CA122Accident · Minor injuriesData collectionFinal reportHanson Gerald Hanson Bucker 131E · Memphis, TNThe pilot's inadequate visual lookout that resulted in a collision with a lighting structure in the grass while landing. A factor in the accident was the pilot's intentional landing in the runway safety area.NTSB MIA07CA100Accident · Serious injuriesData collectionFinal reportHillery W. Grice Alley Cat 1 · Fairhope, ALThe failure of the pilot-in-command to maintain terrain clearance while completing a loop at an airshow, resulting in impact with the runway.NTSB DFW07CA117Accident · Minor injuriesData collectionFinal reportCessna A188B · Fabens, TXThe pilot's failure to compensate for the existing wind conditions during takeoff. A contributing factor was the crosswind.NTSB CHI07LA151Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Fishers, INThe fatigue separation of the engine mount's nose gear actuator attachment foot during landing.NTSB CHI07LA147Accident · 1 fatalLimited investigationFinal reportThrush S2RHG-T65 · Tyndall, SDThe pilot not maintaining altitude/clearance from a powerline while maneuvering. A factor was the low visibility associated with the thunderstorm and the powerlines.NTSB CHI07CA148Accident · No injuriesData collectionFinal reportCessna A188 · Scotland, SDThe pilot not maintaining adequate airspeed during takeoff, which resulted in an inadvertent stall. Factors contributing to the accident were the sudden wind shift and the low altitude at which the stall occurred.NTSB ANC07LA038Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Kenai, AKThe left main landing gear attaching bolts sheared during landing, which resulted in the left main landing gear collapsing and the left wing and the stabilator striking the ground.NTSB SEA07LA131Accident · No injuriesLimited investigationFinal reportCessna 150M · Spanish Fork, UTThe student pilot's inadequate compensation for gusty crosswind conditions, and his failure to maintain directional control during the landing roll. Factors include gusty crosswinds, and a ditch near the runway environment.NTSB SEA07LA126Accident · 1 fatalLimited investigationFinal reportCessna 150G · Pahrump, NVThe loss of engine power due to fuel contamination followed by the pilot's failure to maintain aircraft control during takeoff. Contributing factors were the pilot's inadequate preflight and an inadequate 100-hour maintenance inspection by other maintenance…NTSB SEA07CA128Accident · No injuriesData collectionFinal reportForney F-1 · Morgan, UTThe pilot's failure to maintain clearance of the hill on final approach to a landing. Contributing factors were the downdraft weather condition, the hilly terrain, and his lack of familiarity with the geographical area.NTSB SEA07CA127Accident · No injuriesData collectionFinal reportCessna A185F · Renton, WAThe pilot's loss of aircraft control during a landing attempt, which resulted in an inadvertent ground loop.NTSB NYC07LA121Accident · No injuriesLimited investigationFinal reportDouglas DC-9-31 · Syracuse, NYThe senior ground agent's failure to follow written procedures and directives.NTSB CHI07CA149Accident · Minor injuriesData collectionFinal reportPiper J3C · Waterford, MIThe pilot's failure to maintain control of the airplane, causing a water loop. A factor in the accident was the water loop encountered.NTSB SEA07CA125Accident · No injuriesData collectionFinal reportCessna 170B · Fairfield, IDThe pilot's failure to maintain adequate airspeed while turning from base to final, resulting in an inadvertent stall/mush and subsequent collision with terrain.