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 DFW06FA180Accident · 2 fatalField investigationFinal reportBeech C24R · Virginia Beach, VAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin while maneuvering at a low altitude. Contributing was the pilot's diverted attention to an open door.NTSB CHI06LA187Accident · 1 fatalLimited investigationFinal reportPiper PA-18-135 · Steubenville, OHThe pilot's failure to maintain clearance from the unmarked power line which resulted in the subsequent impact with the roadway. Factors were the unmarked power line, and the low altitude at which the flight was conducted.NTSB CHI06FA186Accident · 1 fatalField investigationFinal reportCirrus Design SR-22 · Edgewater, MDThe pilot' failure to maintain sufficient airspeed which resulted in a stall. A factor was the pilots failure to properly set the flaps for the go-around.NTSB CHI06CA181Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Indianapolis, INThe failure of the tug driver to maintain clearance from the airplane taxiing on an active taxiway. A factor was the night conditions.NTSB SEA06LA138Accident · No injuriesLimited investigationFinal reportCessna Citation 560 · Hamilton, MTThe pilot's failure to attain the proper touchdown point and to execute a go-around, which lead to an overrun of the runway surface. Contributing to the accident was his failure to maintain the correct landing approach speed (Vref), his failure to maintain…NTSB NYC06CA181Accident · Serious injuriesData collectionFinal reportCarlson Sparrow · New Galilee, PAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and impact with terrain. A factor in the accident was the partial loss of engine power for undetermined reasons.NTSB DFW06CA179Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Georgetown, TXThe flight instructor's inadequate supervision of the flight, which resulted in a loss of engine power due to fuel starvation after the private pilot inadvertently positioned the fuel selector to the OFF position. Contributor factors were the lack of suitable…NTSB SEA06CA143Accident · No injuriesData collectionFinal reportRolladen-Schneider LS3A · Enumclaw, WAThe glider pilot's failure to maintain directional control during the landing roll, resulting in the aircraft impacting the dirt embankment on the side of the emergency run-out area. Factors include the pilot's improper decision not to deploy more airbrakes…NTSB DFW06WA177Accident · 5 fatalForeign investigationCessna 182C · Tepic, MexicoNTSB DFW06CA181Accident · Minor injuriesData collectionFinal reportMooney M20C · Eldorado, TXThe pilot's failure to switch fuel tanks during cruise flight, which resulted in a loss of engine power due to fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI06LA212Accident · No injuriesLimited investigationFinal reportCessna R172K · Grand Rapids, MNThe pilot's failure to maintain control of the airplane during the landing. A factor associated with the accident was the gusty tailwind that prevailed.NTSB CHI06CA183Accident · No injuriesData collectionFinal reportCessna 172S · Baltimore, OHThe pilot's failure to attain sufficient airspeed during the takeoff which resulted in the inadvertent stall and collision with the ground.NTSB ANC06LA086Accident · Serious injuriesLimited investigationFinal reportStorm Zenair CH-701 · Fairbanks, AKThe total loss of engine power for an undetermined reason during cruise flight, which resulted in an emergency descent into trees.NTSB DCA06RA055Accident · 124 fatalForeign investigationAirbus Industrie A310-300 · Irkutsk, RussiaNTSB DCA06RA053Accident · 6 fatalForeign investigationSikorsky S61N · Tenerife, SpainNTSB CHI06CA182Accident · No injuriesData collectionFinal reportCessna 172L · Waterford, OHThe pilot's selection of unsuitable terrain for landing. The runway's downhill slope, the wet grass, the fence, and the embankment were factors.NTSB ATL06LA103Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Gold Hill, NCThe pilot's failure to maintain airspeed while doing a go around, which resulted in an inadvertent stall, loss of control and in-flight collision with the ground. A factor was the pilot's lack of recent experience in the airplane.NTSB ATL06FA102Accident · 5 fatalField investigationFinal reportPiper PA-32-260 · Suches, GAThe pilot's failure to retract the wing flaps and his decision to make a turn while performing a go-around.NTSB ATL06CA104Accident · No injuriesData collectionFinal reportCessna 182H · Birmingham, ALThe pilot's failure to maintain airspeed during final approach resulting in a stall/mush and a hard landing.NTSB ANC06LA093Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Fairbanks, AKThe pilot's inadvertent landing with the landing gear retracted, which resulted in structural damage to the airplane.NTSB SEA06LA141Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Grantsville, UTA lack of lubrication for undetermined reasons, which resulted in the failure of the Nos. 2, 3, 4, 5 and 6 connecting rods, a subsequent total loss of engine power during descent, which resulted in a forced landing. A factor in the accident was the soft sand.NTSB NYC06LA129Accident · No injuriesLimited investigationFinal reportChevrier, Armand J-3K · Charlotte, VTA complete loss of engine power on takeoff for undetermined reasons, which resulted in a forced landing.NTSB LAX06CA227Accident · No injuriesData collectionFinal reportHughes 369D · Kihei, HIthe pilot's failure to maintain an adequate clearance from obstructions, which led to a main rotor blade strike.NTSB LAX06CA226Accident · No injuriesData collectionFinal reportBarnard RV-6 · Groveland, CAthe misjudged flare by the pilot that resulted in a hard bounced landing, and his failure to maintain directional control during the attempted recovery.NTSB DFW06CA178Accident · No injuriesData collectionFinal reportCessna 180 · Downsville, TXThe malfunction in the braking system which caused the parking brake to engage and lock the right main wheel resulting in a loss of directional control.NTSB DFW06CA176Accident · No injuriesData collectionFinal reportCessna 210A · Denver City, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN06LA095Accident · Serious injuriesLimited investigationFinal reportAirbus A319-131 · Masonville, COthe flight's encounter with unexpected turbulence, which resulted in a passenger sustaining a fractured ankle.NTSB DCA06WA054Incident · No injuriesForeign investigationBoeing 737-300 · Stansted, United KingdomNTSB CHI06LA178Accident · 1 fatalLimited investigationFinal reportMoon Rans S-14 · Berlin, ILThe pilot's failure to maintain control of the airplane for undetermined reasons.NTSB CHI06CA185Accident · Minor injuriesData collectionFinal reportCessna 172K · Sullivan, ILThe pilot's misjudged flare and his improper recovery from the bounced landing which led to a loss of directional control and subsequent collision with crops and the ground.NTSB ATL06LA101Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Milledgeville, GAThe improper fabrication of the oil pressure gauge line by maintenance personnel, which resulted in a loss of engine oil and total loss of engine power during cruise flight.NTSB ANC06CA085Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Skwentna, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a loss of control during the landing roll, and an on ground encounter with terrain. Factors associated with the accident are the pilot's failure to maintain directional control, and…NTSB SEA06CA137Accident · No injuriesData collectionFinal reportHughes 369A · Medford, ORThe pilot's misinterpretation of the wind direction (in-flight planning) and subsequent improper descent rate to the ground during a landing attempt. A factor was the tailwind conditions.NTSB DEN06CA093Accident · No injuriesData collectionFinal reportCessna 305A · Saratoga, WYthe pilot's failure to maintain direction control during the takeoff roll.NTSB CHI06CA179Accident · No injuriesData collectionFinal reportAviat A-1 · Watervliet, MIThe presence of the deer on the runway which resulted in the pilot taking evasive action leading to the nose-over. A factor was the excessive braking by the pilot.NTSB CHI06CA177Accident · Minor injuriesData collectionFinal reportCessna T210G · Pontiac, ILA loss of engine power due to the pilot's improper in-flight planning which led to fuel exhaustion and his failure to maintain an adequate airspeed during the landing approach which resulted in an inadvertent stall. The road embankment was a factor.NTSB CHI06CA176Accident · Minor injuriesData collectionFinal reportCessna 182A · Jackson, MIThe pilot's improper preflight planning which led to the exhaustion of the fuel supply during the flight. The overload failure of the nose landing gear was a factor.NTSB ANC06FA089Accident · 1 fatalField investigationFinal reportPiper PA-28 · Manley Hot Spng, AKThe pilot's continued cruise flight into known adverse weather conditions, his failure to maintain aircraft control while maneuvering, and his exceeding the design stress limits of the airplane, which resulted in an in-flight break-up. Factors associated with…NTSB NYC06FA169Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Block Island, RIThe pilot's inadequate preflight decision making and his failure to maintain terrain clearance during departure. Contributing, were low ceilings, rain, and thunderstorms.NTSB LAX06LA225Accident · No injuriesLimited investigationFinal reportCessna 210K · Novato, CAThe failure of the left main landing gear to extend for undetermined reasons.NTSB DFW06CA175Accident · No injuriesData collectionFinal reportCessna C340A · San Antonio, TXThe collapse of the left main landing gear as result of the failure of the gear pivot bolt for undetermined reasons.NTSB DEN06CA092Accident · No injuriesData collectionFinal reportFlaglor High Tow · Jackson, WYthe loss of engine power due to low cylinder compression and fouled spark plugs. Contributing to the accident was the pilot's inadequate preflight planning and preparation.NTSB NYC06LA171Accident · 1 fatalLimited investigationFinal reportBuckeye Dream Machine · Monticello, KYThe misplaced parachute suspension line, which resulted in an in-flight loss of control. A factor was the pilot's inadequate preflight inspection.NTSB NYC06CA173Accident · No injuriesData collectionFinal reportBell 47G-2 · Petersburg, WVThe passenger's inadvertent interference with the flight controls, which resulted in a loss of directional control and subsequent impact with the ground.NTSB DCA06WA057Incident · Serious injuriesForeign investigationBoeing MD-81 · Toyota, JapanNTSB SEA06LA133Accident · No injuriesLimited investigationFinal reportNanchang China CJ-6 · Brewster, WAThe failure of the engine's three planetary gears for undetermined reasons. A factor contributing to the accident was the tree orchard.NTSB SEA06CA132Accident · No injuriesData collectionFinal reportCessna 195 · Great Falls, MTThe pilot's loss of aircraft control during the takeoff roll, and the subsequent inadvertent ground loop.NTSB LAX06CA223Accident · No injuriesData collectionFinal reportPiper PA28-181 · Dorris, CAthe pilot's failure to maintain an adequate airspeed during a go-around, which resulted in a stall/mush. A contributing factor was the high density altitude.NTSB DEN06FA091Accident · 2 fatalField investigationFinal reportBeech A36TC · Montrose, COthe pilot's inadequate preflight planning/decision by not having the airplane refueled prior to takeoff, and allowing the engine to be starved of fuel because he failed to switch the fuel selector valve. A contributing factor was the flight instructor's…NTSB CHI06CA180Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Jefferson City, MOThe dual student's excessive landing flare and his failure to maintain adequate airspeed, which resulted in the airplane stalling. A factor to the accident was the flight instructor's delayed remedial action and the runway edge light that the airplane struck.