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 SEA85LA153Accident · Minor injuriesLimited investigationFinal reportBorreson Dragon FLY · Burley, IDThe aircraft crashed due to loss of control during takeoff. The plt reported that during takeoff climb, the nose of the acft pitched down despite the application of aft elevator pressure. The acft contacted the rwy and bounced. The plt then reduced pwr and…NTSB NYC85LA157Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26 · Cambria, NYThe glider, while returning to land after a pleasure flt, encounter a rainshower and strong downdraft. The plt made a landing in a farmers fld. During the landing the right wing caught and the acft ground looped, incurring substantial damage.NTSB MIA85FA202Accident · Minor injuriesField investigationFinal reportPiper PA-32RT-300T · Pembroke Pines, FLThe acft experienced a complete in flt loss of his prop after departure from north perry arpt hollywood FL due to a fatigue failure of the prop hub. The fatigue cracking was due to residual stress resulting from deformation of the material in the hub ass'yNTSB LAX85LA299Accident · Minor injuriesLimited investigationFinal reportBell 206B3 · Grand Canyon, AZDuring a movie filming flight, the helicopter was acting as the camera platform and filming a fixed wing aircraft during a straight in appraoch to the airport, the plt of the helicopter requested a right 180 degree turn at mid field to land at the north…NTSB FTW85LA269Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Pearsall, TXA commercially rated CFI departed on a part 135 air taxi flt, but encountered deteriorating weather conditions. Circling his destination he reported that rain clouds closed in. Anticipating that he would be unable to file IFR in the air, he elected to land in…NTSB FTW85LA268Accident · Minor injuriesLimited investigationFinal reportSikorsky S-76 · Eugene IslandThe plt had landed on the offshore heliport in the gulf of Mexico. The S76 helicopter rolled backward on the platform with the helicopter tilting to its right. The coplt exited the acft and found the right main gear wheel off the platform and into the deck…NTSB CHI85LA264Accident · No injuriesLimited investigationFinal reportCessna 172H · Coleman, WIThe pilot departed on a short x-country flt. Stated fuel aboard was 8 gls. Pilot diverted from drct flt and ran out of fuel after one hour airborne. Ld in farm field. Struck a post with resultant sub damage to airframe.NTSB CHI85LA261Accident · No injuriesLimited investigationFinal reportCessna 188B · Waskish, MNDuring initial takeoff climb of an aerial application flt the plt could not maintain alt. While he was dumping the chemical load the acft struck trees, impacted the terrain and burst into flames. The plt was not properly certificated to fly under FAR part 137.NTSB CHI85LA257Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Oxford, OHWhile on a round-robin flight at night the pilot experienced an alternator failure. As he was returning to his point of origin the battery power depleted leaving him with no radios or landing light and only a flashlight for cockpit lighting. He decided to…NTSB CHI85LA256Accident · Minor injuriesLimited investigationFinal reportRichard E. Rowland Cassutt III M · Kankakee, ILOn landing the homebuilt tailwheel acft, the pilot lost directional control, struck a ditch and flipped over on the acft's back resulting in substantial damage to the acft.NTSB CHI85FA259Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-D1 · Mundelein, ILThe acft contacted terrain in a near vertical attitude aprx 1/4 mile east of the plt's private airstrip. There were no witnesses to the accident, however, the acft was observed flying at low altitudes prior to the accident. An autopsy report on the passenger…NTSB CHI85FA258Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Merom, INThe aircraft was on a visual flight from fairfield Iowa to indianapolis, IN and was about 55 mautical miles south of course when the aircraft broke up in flight. The main wreckage, empennage, and outer wing sections landed within about a quarter of a mile of…NTSB ATL85FA198Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Dothan, ALA witness related that she observed the acft flying low over fields and trees. She lost sight of the acft as it went around a bend in the road. When she rounded the curve she saw the acft nose down in a field with the tail pointed virtually straight up. The…NTSB ATL85FA197Accident · 2 fatalField investigationFinal reportPiper PA-42 · Charlotte, NCThe acft collided with a tree and a pole short of the rwy during a night VFR approach to land. The plt changed from rwy 18 to 36 during the approach. He was seen low & fast on dwnwind which ended in a steep descending turn to ground contact. The twr had…NTSB ANC85LA116Accident · No injuriesLimited investigationFinal reportPiper J-3/100 · Port Lions, AKThe plt lost directional control of the acft during a touch and go landing. The acft veered off the rwy and contacted boulders. The plt reported to bystanders at the accident site that it had been a long time since he had flown an acft equipped with heel…NTSB ANC85LA110Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Dillingham, AKThe plt reported that by the time he had returned to the arpt, the wind velocity had increased to 18 KTS. During the landing, he lost directional control & the acft ground looped & was damaged.NTSB SEA85LA152Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Burns, ORDuring aerial applications the pilot cleared a rise, got a down draft, struck trees and then stalled striking the ground with little forward motion. An intense explosion and fire followed. The fire origin was in the area of the fiberglass fuel tank. An…NTSB MKC85LA142Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Maryville, MOThe plt slowed the airspeed on final apch & the acft stalled. Subsequently, the acft impacted on the rwy & was damaged beyond economical repair. The plt stated that he did not hear the stall warning sys; however, it operated normally during a post-crash check.NTSB MIA85LA201Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Daytona Beach, FLThe acft settled gear up onto the rwy during an attempted go around from a simulated single engine apch. The student flared too high & requested command of both throttles from the CFI. Pwr was applied & the flaps & gear were prematurely retracted. The acft…NTSB LAX85LA296Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Ajo, AZWhile attempting to start the engine for a planned air taxi flight under conditions including an outside air temp of 118 degs f, a fire erupted in the engine compartment. The occupants safety evacuated the acft & had to walk 1/4 of a mile to obtain…NTSB LAX85IA297Incident · No injuriesIncident investigationFinal reportBoeing 737-247 · Los Angeles, CAThe captain stated that the 'b' hydraulic system low oil leval lamp illuminated while the acft was in cruise flt. As he completed the failure check and placed the 'b' system into standby rudder condition that provides hydraulic pressure to only the rudder,…NTSB FTW85LA267Accident · Serious injuriesLimited investigationFinal reportCessna 172E · New Orleans, LAThe pilot stated the engine quit while he was being vectored for an approach to msy airport, New Orleans. He stated orally that he did not run out of fuel. A successful test run was made with adequate power for flight available. The cause of the engine power…NTSB DEN85LA175Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Lordsburg, NMThe plt attempted to take off from a dirt road at or near max gross wieght and at high density alt conditions. The plt said there was a small rise in the road and he eased back on the control yoke. Directional control was lost and the airplane skidded off the…NTSB DCA85AA027Accident · Serious injuriesFinal reportMcdonnell Douglas DC-10-10 · San Juan, PRAfter landing at San Juan, the acft was parked at the customs area, then was towed to gate 15 & loaded for the next flt. The push-back was such that the crew had to taxi to the gen avn parking area & turn around bfr proceeding to rwy 8 for departure. When…NTSB ATL85LA192Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Ashford, ALThe plt was returning to the private ag strip after completing a spray run. During the landing the pilot found that the left brake was inop. In order to prevent running off end of the 1500 ft rwy, the plt elected to ground loop the aircraft. During the…NTSB ATL85FLT08Accident · Serious injuriesFinal reportCessna A188B · Marks, MSThe plt reported that while he was on an aerial application flt, a rain storm suddenly began & forced him to quickly return & land. He reported that the rain was so heavy that he could only see straight down. He contacted his ground crew & asked them to help…NTSB MKC85LA141Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Rushville, MOShortly after the plt departed on a flt, the eng lost power while the acft was cruising at 1800 ft MSL over hilly terrain. The plt reported that the eng speed dropped to 800 RPM & he was unable to correct the situation. During a forced landing on soft…NTSB MIA85LA200Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Daytona Beach, FLThe student plt had been practicing touch and go landings. On his third landing, he permitted too steep an apch and the nose gear contacted the rwy prior to the main gear. A porpoising action then developed which was not arrested prior to failure of the nose…NTSB FTW85FA265Accident · 1 fatalField investigationFinal reportAerospatiale AS35OD · Dallas, TXThe eng to transmission short shaft became disconnected in flt. This resulted in complete loss of pwr to the main rotor assembly. However, the tail rotor assembly was still being powered by the eng. Upon collective pitch application to stop the descent the…NTSB DEN85LA172Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Angle Fire, NMOn June 26, 1985, a Piper pa 28-180, descended and crashed after takeoff from angel Fire airport, NM. The plt reported no mechanical difficulties. The density alt was 10609 ft. the takeoff distance chart indicates a maximum da of 7000 ft. the plt was not…NTSB CHI85LA262Accident · No injuriesLimited investigationFinal reportCessna 182A · Davison, MIAcft touched donw hard and became airborne. On the second ground contact the nose gear collapsed. Plt previously aborted two landings because of excessive airspeed.NTSB CHI85LA255Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Kankakee, ILThe aircraft while clearing the runway, shot wide of the taxiway taxiing onto the grass and into a culvert which was difficult to see resulting in substantial damage to the aircraft.NTSB CHI85LA254Accident · No injuriesLimited investigationFinal reportBell 47G-4 · Lakeville, MNThe acft was being landed on a trailer for transportation. Upon touchdown the right skid hooked on the landing guides and the helicopter rolled to the right side. The main rotor blades struck the ground, the left fuel tank ruptured and an explosion and fire…NTSB CHI85FA253Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Reedsburg, WINo known witnesses observed the plt preflt the acft or takeoff. He departed in the evening while the arpt was not attended. At aprx 2012 CDT, his son observed & recognized the acft. At that time, the son was at his own home about 1/2 mi from the plt's home.…NTSB SEA85LA151Accident · 1 fatalLimited investigationFinal reportBell UH-1B · Hoquiam, WAThe helicopter was being used during an external load operation to move large blocks of wood. However, while hovering, the sling broke. Subsequently, a block of wood struck a company employee on the head while he was working on the ground. The employee was…NTSB SEA85LA150Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Gustavis, AKWhile taxiing the float plane in a gusty x-wind, the wind & water current drifted the acft toward a parked boat. Subsequently, the left wing tip struck the boat & was damaged. But there was no damage to the boat.NTSB SEA85LA149Accident · No injuriesLimited investigationFinal reportPiper PA-25-235-C · Wenatchee, WADuring an aerial applications maneuver the engine ceased operating and a forced landing was made in an orchard in between apple tree rows. Engine and aircraft inspection could not reveal any abnormalities with the exception of a very dirty, partially clogged…NTSB SEA85LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bellevue, WAThe plt reported that during the pre-flt check, she neglected to untie the rear seat belt from the aft control stick. Standard procedure for taxi & takeoff in this float plane was to keep the stick full aft. Since the acft was low on fuel & was taking off in…NTSB SEA85LA145Accident · Serious injuriesLimited investigationFinal reportCessna 310L · Albany, ORThe plt was attempting to bracket the low bar on the 2 bar VASI to avoid landing long on the rwy. On final, the acft landing gear struck unmarked powerlines. The acft then struck the ground in a level attitude. A small fire ensued in the left tip tank. The 4…NTSB MIA85LA199Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Opa Locka, FLThe plt was landing after a x-country flt when the right wing & the prop contacted the rwy. The plt stated that the gear had collapsed during a go-around. However, the landing gear was intact, except for impact damage on the right main gear. No gear…NTSB LAX85LA294Accident · Serious injuriesLimited investigationFinal reportLeslie J. Royal VARI- EZE · Rio Linda, CAAs the acft began its' climb, after takeoff, the canopy partially opened. The pilot lost control of the aircraft as he attempted to relatch the canopy. The acft turned off its previous flight path and collided with a parked acft and truck.NTSB FTW85LA266Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Georgetown, TXThe accident occurred during an glider launch. The tow acft was unable to gain alt, and turned back to the arpt to release the glider. The tow acft began to sink into the trees and was forced to release the glider beyond safe gliding distance to the rwy. The…NTSB ATL85LA196Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mt. Airy, NCWhile nearing completion of a solo x-country flt, the eng quit. The student plt selected an open area, but overshot the intended touchdown point & the acft crashed in the backyard of a single family dwelling. An investigation failed to disclose any system…NTSB ANC85LA108Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Talkeetna, AKWhile in flt, the plt smelled smoke. Within 30 sec, smoke was observed coming from around the firewall & under the floorboards. The acft was over an airstrip, so the plt made a 360 deg turn & landed there. The plt said that he immediately applied brakes when…NTSB NYC85FA155Accident · 1 fatalField investigationFinal reportBeech B95A · Readington, NJPapers were observed to fly out of the acft during takeoff. The acft was observed to 'waver' with the gear down & crash to the ground several minutes later. An exam of the cabin door revealed that it had popped open in flt.NTSB MIA85LA198Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Atlantic Ocean (Atlantic Ocean)The plt reported that during an overwater flt, a fire began in the front section of the acft while he was cruising at 10,500 ft. he radioed his position on the emergency freq (121.5 mhz) & squawked an emergency code (7700) on his transponder. Subsequently, he…NTSB MIA85IA203Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2K · San Juan, PRAfter departure the nose gear unsafe light remained illuminated peter gear retraction. Attempts to get a safe light on the nose gear in the extended position was unsuccessful and when the aircraft landed it settled onto a partially retracted nose gear.…NTSB LAX85LA291Accident · No injuriesLimited investigationFinal reportCessna 180 · Murrieta, CAAt the conclusion of a personal cross country flight, the pilot stated he made a hard landing after which, the aircraft got away from him and ground looped.NTSB LAX85LA290Accident · No injuriesLimited investigationFinal reportLuscombe 8A · San Jose, CAThe pilot lost directional control,during the takeoff phase of a touch and go landing. The acft swerved off the runway as it entered a ground loop that collapsed the right landing gear strut.NTSB LAX85LA289Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lincoln, CADuring arrival at dusk, the plt attempted to lower the landing gear, but did not observe a gear dowm light indication. He recycled the gear several times, then utilized the emergency gear extention sys. He stated that when he used the extention sys, he…