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 ATL88FA210Accident · Serious injuriesField investigationFinal reportCessna 210L · St. Marys, GANTSB SEA88LA136Accident · No injuriesLimited investigationFinal reportCessna 210 · Baker, NVThe pilot stated he landed long on unattended grass strip due to gusty wing conds. The aircraft encountered a ditch or vehicle track hidden by vegetation, shearing nose gear and collapsing left main.NTSB MIA88LA217Accident · No injuriesLimited investigationFinal reportPiper PA-25-235C · Stringer, MSAccording to the pilot while on a ferry flight during normal cruise at an alt of aprx 2000 ft, the eng quit due to fuel exhaustion. During the forced landing the acft collided with a tree.NTSB MIA88LA216Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLWhile on a sightseeing flt, during the landing roll with a direct crosswind from the rt at 9 KTS, the plt reported that the acft turned into the wind. He was unable to correct this with left rudder & braking before the acft travelled into a ditch. He further…NTSB LAX88LA244Accident · No injuriesLimited investigationFinal reportCessna TR182 · Niland, CADuring the takeoff ground run on a dirt road, witnesses stated that the pilot had lifted the nose of the airplane so high that the tail dragged on the ground. The airplane became entangled in weeds near the road, the pilot lost control and the airplane…NTSB CHI88IA159Incident · No injuriesIncident investigationFinal reportBoeing 737-130 · Indianapolis, INFailure to ensure proper alignment and closure of the auxillary power unit lower shroud with the fire seal upon completion of a maintenance action.NTSB SEA88LA123Accident · Serious injuriesLimited investigationFinal reportKaman HH43 · Joseph, ORThe pilot was making the initial long line external load hookup of the day for the purpose of conducting logging operations. The pilot stated that as he maneuvered the aircraft into position the helicopter's main rotor system contacted a tall tree.NTSB MIA88LA215Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe plt stated that while inbound to Vero Beach, he ran out of fuel in the left tank. The engine quit, and he was unable to restart the engine before he crashed into a grove of trees.NTSB MIA88FA214Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Clearwater, FLThe private pilot experienced a rough running engine on takeoff roll and continued the takeoff. After liftoff the engine failed and he crashed into a residence. The engine fuel control and fuel divider block were found to have water, rust and sand in them.…NTSB DEN88LA145Accident · Minor injuriesLimited investigationFinal reportSikorsky S-58J · Sioux Falls, SDN62243 was being used to lift air conditioning units to the top of a shopping mall. The plt stated that he was on the 16th lift of the day and had just taken off when he heard two loud pops and the engine lost power. After jettisoning the load he executed an…NTSB CHI88LA154Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Thief Rvr Falls, MNNTSB BFO88LA064Accident · No injuriesLimited investigationFinal reportHughes 369D · Clarksburg, WVThe student and instructor practiced several maneuvers. At the time of the accident they were doing straight-in landings. The student did one landing after a demo by the instructor. The student was doing his second landing which the instructor described as…NTSB NYC88LA176Accident · No injuriesLimited investigationFinal reportLake LA-4 · Linden, NJHard landing due to improper level off of the student and the flight instructor's inadequate supervision. The left wing partially failed because of overload and the aircraft made a forced landing in a swamp.NTSB MIA88LA212Accident · No injuriesLimited investigationFinal reportBell 47D1 · Ruleville, MSDuring an aerial application flt while spraying chemicals the plt reported that the engine quit. The pilot attempted an autorotation but was too low and slow to complete it. The aircraft landed hard in the field of crops and nosed over. Examination of the…NTSB MIA88FA213Accident · 2 fatalField investigationFinal reportFranklin Drifter XP-503 · Lake Wales, FLThe owner rprtd the plt flew the acft at a company picnic without authorization. Company psnl saw the experimental, amateur built acft takeoff from the company strip, then maneuver for a low pass over the area at about 150 to 200 ft AGL. Some estimated the…NTSB LAX88FA246Accident · 1 fatalField investigationFinal reportCessna 152 · Verdi, NVFailure of the pilot to gain sufficient altitude prior to negotiating mountainous terrain with forecast high winds. Contributing to this accident was the weather phenomena known as 'mountain wave' which created downdrafts that exceeded the aircraft's climb…NTSB LAX88FA245Accident · 4 fatalField investigationFinal reportCessna 320D · Mammoth Lakes, CAThe pilot executed a left (south) crosswind departure towards higher terrain after departing runway 27; the plt was following a slower single engine airplane that had preceded his departure. Ground witnesses reported that as the airplane approached the higher…NTSB FTW88LA128Accident · No injuriesLimited investigationFinal reportCessna 170 · Marble Falls, TXThe pilot lost directional control during the lndg on runway 17. The aircraft collided with the terrain and trees after veering off the right side of the runway. The pilot reported a left quartering headwind of 25 knots gusting to 35 knots. The acft was…NTSB DEN88LA152Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Fort Collins, COThis Balloon flt was part of a rally. The flt departed from a stadium, climbed to 500' and then made a controlled descent and landing. After the next takeoff and climb to about 125' when the burner was turned off the plt noticed that fuel was not flowing to…NTSB CHI88LA158Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Mishawaka, INAfter short personal flight, the pilot of the balloon made a landing in an open field. The gondola turned over and was dragged through the field. The pax suffered serious injuries.NTSB CHI88LA152Accident · No injuriesLimited investigationFinal reportCessna 172M · Breckenridge, MIThe student pilot was attempting to land on the private airstrip when the aircraft touched down hard on the runway. The aircraft bounced back up into the air. The pilot was unable to maintain control of the aircraft and upon impacting back onto the runway the…NTSB CHI88FA147Accident · 1 fatalField investigationFinal reportCessna 150G · Plymouth, OHNTSB ANC88FA083Accident · 4 fatalField investigationFinal reportCessna 185 · Whittier, AKThe flight departed six mile lake on elmendorf air force base and was destined for coghill lake. The airplane was found at the 2500 foot level of a mountain on the north side of burns glacier. The airplane heading was 324 degrees. The heading to go through…NTSB ANC88DAG05Accident · 2 fatalFinal reportPiper PA-18A · Mcgrath, AKThe airplane crashed approximately 94 miles east of the city of Mcgrath, Alaska. The pilot and passenger were fatally injured and the Piper PA-18 airplane was substantially damaged. The airplane impacted ground in a near vertical attitude near the end of a…NTSB SEA88FA122Accident · 5 fatalField investigationFinal reportCessna TU-206-G · Root Ranch, IDShortly after takeoff, prior to reaching 500 feet AGL, the pilot lost control of the aircraft and struck trees. After striking trees the aircraft then impacted the ground and exploded into flames. Witnesses stated that from the time of rotation to the time…NTSB NYC88LA194Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Bally, PAThe plt was taking off with a left tailwind/crosswind. At liftoff, the left wing dropped and the pilot attempted to correct with rudder. The acft collided with the terrain.NTSB NYC88LA175Accident · No injuriesLimited investigationFinal reportCessna 150M · W. Seneca, NYThe instructor pilot stated that the student pilot conducted the preflight and reported the fuel 'down a little.' The instructor did not visually verify the amount of fuel on board. Investigation revealed that the acft ran out of fuel and was forced to land…NTSB NYC88DHM01Accident · Serious injuriesFinal reportRutgers Agriplane · Freehold, NJThe plt was working for a firm that was developing the experimental, light weight, crop duster in a joint venture with another firm. An acdnt occurred as he was operating the acft at the location of one of the firms. The plt stated that after takeoff, 'I was…NTSB DEN88LA146Accident · No injuriesLimited investigationFinal reportCessna 188 · Sentinel Butte, NDThe pilot took off from his private airstrip near Sentinel Butte, ND, en route to beach, ND. He said there was a narrow cloud ahead, approximately 5-8 miles long, and emitting lightning, but it did not appear to him to threaten flight safety. The pilot said…NTSB DEN88LA144Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Colorado Spring, COThe plt and pax departed st. louis and stopped twice enroute due to wx. The plt was given landing clearance on rwy 17 at Colorado springs and the wind was reported to be from 190 degrees at 12 KTS. Witnesses at the arpt stated N4878S 'porpoised' several times…NTSB CHI88LA151Accident · No injuriesLimited investigationFinal reportCessna 177 · Lowell, INThe student pilot was on final approach for landing when the aircraft began to drift to the left of the runway. The pilot decided to go-around and added full power, pushed the carburetor heat in and retracted the flaps to '1/2'. According to the pilot he…NTSB CHI88LA148Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Menomonee Falls, WINTSB CHI88FA153Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Hamm Lake, MNLoss of control in flight, either by the student or by the instructor, at an altitude insufficient to allow for a recovery, by the flight instructor, before the resulting out of control descent caused the accident airplane to strike the terrain.NTSB ATL88LA209Accident · No injuriesLimited investigationFinal reportCessna 195A · Memphis, TNThe plt reported that the left wheel separated from the airplane during ldg rollout on rwy 27, allowing the left gear to drag on the rwy. The airplane then bounced, veered to the right, and skidded to a stop. The left ldg gear collapsed as the acft stopped.…NTSB ATL88FA254Accident · 1 fatalField investigationFinal reportCessna T207 · Petros, TNNTSB ANC88LA081Accident · 1 fatalLimited investigationFinal reportCessna 206 · Naknek, AKThe pilot was hauling fish from remote beach sites in Alaska to a nearby gravel airstrip. Witnesses reported seeing the airplane make two approaches to the field in weather estimated as visibility 1/2 mile in fog, and a ceiling of 100-200 feet. After the two…NTSB NYC88LA177Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Laconia, NHThe plt stated that after pickup on a banner tow operation, the tow became twisted and he elected to return and release. On downwind, the acft began a rapid descent which the plt could not compensate for, even after releasing the banner and adding power.…NTSB NYC88DHD03Accident · Serious injuriesFinal reportSchweizer SGS 1-23H-15 · Hammonton, NJThe glider pilot's failure to avoid the stall/spin encountered during low altitude operation in the traffic pattern.NTSB MKC88FA120Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Beedeville, ARIntentional buzzing performed, visual outlook not maintained and over confidence in personal ability by the pilot in command.NTSB MIA88LA211Accident · No injuriesLimited investigationFinal reportCessna 152 · Marathon, FLThe student plt was on his 1st solo x-c flt. A portion of the flt included a 30 mi stretch over the Florida bay section of the gulf of Mexico. The flt carried no flotation gear. 5.2 hrs into the flt, the eng quit & a ditching was performed near a pleasure…NTSB LAX88LA248Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Weaverville, CAAt the end of a cross country flt, the plt was landing the airplane in a 5 kt, gusting to 10 kt tailwind. The airplane did not touch down until past mid-field and the plt said the brakes were not effective until two thirds of the way down the rwy. The…NTSB LAX88DVG07Accident · No injuriesFinal reportSnow AT-301 · Davis, CAAt the end of an aerial application flight, en route to home base, the engine quit. The pilot made an emergency landing in a field, where during the landing roll the airplane collided with a bale of hay and nosed over. Inspection of the engine revealed that…NTSB LAX88DVD06Accident · Serious injuriesFinal reportLocolce/Blackwell Falcon XP · Antioch, CAWhile entering downwind for landing, the rudder did not respond. The airplane began to yaw to the left at a 30 degree banking spiral turn. The pilot deployed the emergency parachute and the airplane collided with the terrain. Inspection of the airplane…NTSB CHI88LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Grafton, WIWhile landing at a 1,900' sod airstrip with a 10 knot crosswind, the aircraft swerved to the left, ran off the runway and struck some small trees and shrubs. The pilot lacked total experience in low wing aircraft and lacked familiarity with that particular…NTSB CHI88DEI01Accident · No injuriesFinal reportVan Wormer Emeraude SSE-328R · Elyria, OHAccording to the plt, the eng seemed to lose power as the acft was climbing thru about 50 ft AGL after takeoff. Subsequently, the acft settled to the ground, crossed a road & collided with a chain link fence. It came to rest about 150 ft from where it 1st…NTSB CHI88DEC04Accident · No injuriesFinal reportPerkins Dragonfly · Fowlerville, MIThe pilot failed to maintain positive control of his homebuilt aircraft by taking appropriate actions for recovery from the bounced landing. The aircraft contacted the ground abruptly on the third bounce and the upper wing spar failed. The pilot's lack of…NTSB BFO88IA065Incident · No injuriesIncident investigationFinal reportCessna T210R · Washington, DCImproper maintenance resulting in the routing of wire which caused an electrical short and inflight smoke.NTSB BFO88FA063Accident · No injuriesField investigationFinal reportPiper PA-23 · Friendly, MDShortly after takeoff at an altitude of 200 ft AGL, a power loss was experienced on the left engine. According to the plt, when the throttle was retarded to verify the engine failure, the engine seemed to 'come back to life'. The throttle was advanced and…NTSB NYC88LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · East Hampton, NYThe pilot reported that he had experienced a partial power loss on downwind of a VFR traffic pattern. He stated that just after entering downwind he lowered the landing gear. As the speed decreased below 132 knots he advanced the throttles. There was no…NTSB NYC88LA173Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Akron, NYThe pilot's inadequate preflight resulted in a delayed aborted take-off. After an inadvertent retraction of the landing gear the aircraft skidded off the end of the runway into rough terrain.