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 CHI86FA141Accident · 1 fatalField investigationFinal reportPiper PA-34-200 · Angola, INThe pilot diverted into Angola, an airfield he had never landed at before, due to an unidentified electrical problem at night. He was given vectors to the airport and reported the field in sight. He then said he was going to circle to lose altitude prior to…NTSB ANC86LA058Accident · No injuriesLimited investigationFinal reportHiller 12-C · Palmer, AKThe pilot stated that he drew too much rotor pitch for the h.p. available. The helicopter lost control and rolled over on its side.NTSB SEA86FA126Accident · 4 fatalField investigationFinal reportLake LA-4-250 · Blue River, ORSeveral witnesses reported seeing the acft flying near the eugene arpt at an alt of 400 to 500 ft AGL. The acft was heading toward the Blue River. The acft was then seen flying over the Blue River forest ranger station aprx 7 minutes prior to the accident. At…NTSB MIA86LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe plt stated that during the takeoff portion of a touch and go landing he lost directional control of the acft. The acft veered left off the rwy, struck a ditch and the landing gear collapsed.NTSB MIA86LA162Accident · No injuriesLimited investigationFinal reportCessna 182E · Crystal River, FLThe plt stated that just before descent he pushed the propeller control full forward, experienced a runaway prop and lost oil pressure. Moments later a connecting rod failure was experienced and an emergency landing was executed in amarshy area northwest of…NTSB LAX86LA225Accident · No injuriesLimited investigationFinal reportCessna 150D · Lancaster, CAThe acft collided with a 60 foot tall pine tree while maneuvering over a residential area. The pilot indicated that he was heading west at 750 feet above the ground with 30 degrees of flaps at approximately 60 mph airspeed with fifty percent power applied. He…NTSB LAX86LA224Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tonopah, AZThe acft collided with a truck during takeoff ground run from an interstate. The plt indicated the acft had run out of fuel on the x-country flt and he had not refueled at the departure point. He landed on the interstate without incident and sent his pax for…NTSB LAX86FA223Accident · 2 fatalField investigationFinal reportGeneral Balloon AX-6 · Temecula, CAThe balloon was going to participate in a 'hare and hound' event and had departed a festival staging area on a positioning flight. Prior to departing the area the balloon had flown for about 45 minutes. While enroute to the positioning area the balloon had…NTSB LAX86FA221Accident · 1 fatalField investigationFinal reportAerospatiale TB20 · Van Nuys, CAWhile in the traffic pattern for rwy 16L the light acft plt was cautioned about possible wake turbulence from an arriving C-130 hercules acft landing on rwy 16R. The light acft plt acknowledged observing the C-130, which was above him. The C-130 landed on rwy…NTSB LAX86FA220Accident · 3 fatalField investigationFinal reportPiper PA-28-160 · Chino, CAAt the end of a 5.3 hr flt, the plt entered the traffic pattern & was hi on base & final apch. He elected to go around, but the eng lost power due to fuel exhaustion at about 200' AGL, just past the dep end of the rwy. The plt attempted to return to the rwy.…NTSB DEN86LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Pierre, SDPlt said that while in cruise flt eng loss power. Plt made forced landing on road and lost directional control. Acft struck ditch, fence, then overturned. Acft last refueled two days before and was flown for one hour. Plt did not service acft prior to…NTSB CHI86MA142Incident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-9-31 · Chicago, ILU.S. Air flight 373 passed over American airlines flight 695 at the intersection of runways 32R and 4L while both aircraft were taking off. Both aircraft had been cleared for takeoff by the local controller at o'hare tower. The aircraft came within twenty…NTSB CHI86FER07Accident · No injuriesFinal reportCessna 172P · Webster, WIShortly after lift-off, the plt noted a loss of power as the acft was climbing, about 40 ft above the rwy. He rprtd the eng 'appeared to run a little above idle.' He landed the acft on the remaining rwy, but it contd off the departure end & nosed over. No…NTSB BFO86LA026Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Selbyville, DEThe acft impacted trees while attempting to release a banner at the drop zone. The acft was reportedly equipped with separate towing and release mechanisms, so that up to four banners could be towed in succession without the acft having to land. The plt…NTSB BFO86LA025Accident · Minor injuriesLimited investigationFinal reportCessna 340A · Washington, DCThe acft was reportedly too high to land on the rwy initially assigned by ATC. ATC directed the acft to fly over the arpt and enter downwind traffic for another rwy. The plt was later asked by ATC if he could make a short apch and he replied affirmative. The…NTSB ATL86LA135Accident · No injuriesLimited investigationFinal reportCessna T210N · Dothan, ALWhile on final approach for landing the aircraft lost total power and the pilot attempted a forced landing on a road. The aircraft landed across the road and ran into an open field. The pilot stated that the aircraft ran out of fuel.NTSB ATL86LA134Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Enterprise, ALDuring the touchdown landing phase on runway 23, the aircraft veered off the left side and crashed following an attempted go-around. The pilot applied full power, but was unable to clear a tree line off the departure end. As the pilot elected to abort, the…NTSB ATL86LA131Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lawrenceburg, TNThe student plt had asked a pvt plt to ride with him while he (the student) took his son in law up for a ride. When approaching the rwy for landing, the student plt allowed the acft to collide with the berm short of the rwy. The acft came to a stop on the…NTSB ATL86LA130Accident · No injuriesLimited investigationFinal reportCessna 150M · Littleton, NCPIC made low pass to let friend know he would land at airport for prearranged meeting. PIC reported he was low and slow. When go-around was attempted acft controls were mushy and acft would not climb. Later pilot commented he thought he was on the backside of…NTSB ATL86FA133Accident · 1 fatalField investigationFinal reportCessna 172 · Douglasville, GAThe acft was observed flying at low alt & circling several houses. The plt landed on a grass strip, then after a short time, he & his passenger took off again. The acft was again observed circling several houses at low alt in an area near the strip. A witness…NTSB ATL86FA132Accident · 1 fatalField investigationFinal reportCessna 172D · Athens, GADuring the return from a local sightseeing flight, the pilot reported over the UNICOM that they were making an emergency approach and were out of fuel. An interview with one of the non-pilot passengers revealed that prior to the flight they discussed…NTSB MIA86LA161Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Tallahassee, FLWhile on final apch the acft was blown to the right of the rwy where the left wing struck a dirt mound. The acft then spun to the left and came to rest aprx 75 ft from the edge of the rwy. The plt stated that he decided to try and salvage the landing during…NTSB MIA86LA160Accident · Minor injuriesLimited investigationFinal reportVarga 2150A · Kiln, MSThe plt stated that while on local flight he ran out of fuel & upon landing in a field, the acft struck a tree, severing the wings.NTSB LAX86LA218Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Julian, CAThe acft collided with wires on final apch to a private airstrip while on a personal VFR x-country flt. The plt stated that he was concerned about his fuel quanity and decided to make a precautionary landing at an arpt other than his dest. The plt realized he…NTSB DEN86FTK01Accident · Serious injuriesFinal reportBellanca 7GCBC · Huron, SDThe acft contacted powerlines and descended uncontrolled to ground impact. The plt reported that he was checking fields when the accident occurred. The acft was traveling to the west into the setting sun when accident occurred.NTSB DEN86FA137Accident · No injuriesField investigationFinal reportBeech BE-99C · Laramie, WYThis part 135 IFR flt was inbound for landing at Laramie, Wyoming. During the en route and approach for ldg portions of the flt the acft picked up a moderate to heavy load of ice. During the landing flare the acft stalled, hit the rwy, bounced, veered off the…NTSB ANC86FA057Accident · Serious injuriesField investigationFinal reportWSK PZL-M-18 · Palmer, AKAircraft executed steep left 180 degree turn about 50 feet above runway just after takeoff. Pilot lost control and crashed. Turbulence and windshear had been reported. Wind speed and direction was variable.NTSB MIA86LA159Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Tallahassee, FLWhile in the traffic pattern the acft's electrical system failed due to internal failure of the alternator. The plt failed to extend the landing gear by the emergency gear extension handle and a gear up landing resulted.NTSB LAX86LA219Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Tucson, AZThe helicopter landed hard after a practice autorotation with a power recovery. At aprx 550 ft AGL the CFI announced a simulated eng failure to the ATP and the throttle was closed to flight idle. The ATP entered an autorotation smoothly and turned left…NTSB FTW86LRD14Accident · No injuriesFinal reportGrumman G-164A · Guedan, LAThe pilot lost engine power at an altitude of about 150 feet AGL following takeoff. He impacted a raised roadbed during the forced landing, flipped inverted, slid to a stop, and burned. The fire damage prevented determination of the cause of engine failure.NTSB FTW86LA087Accident · No injuriesLimited investigationFinal reportBoeing PT-13/E-75 · Dallas, TXThe plt had just departed the arpt, started to turn crosswind at 500 ft and began climbing, when the eng started sputtering and lost pwr. He did not have enough alt to return to the arpt and had to ditch the acft 200 yds off the north end of the rwy. No…NTSB DEN86LA136Accident · No injuriesLimited investigationFinal reportCessna 421C · Albuquerque, NMAcft was landing on rwy 17. Plt said he struck a rabbit with left main landing gear and lost all braking action on left side. Plt used right brake to decelerate but overran rwy end and struck dirt bank.NTSB ATL86LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Toccoa, GAThe pilot made three unsuccessful attempts to land the aircraft on the runway. During the third attempt the aircraft bounced on the runway and the pilot applied power to go-around. During the attempted go-around the aircraft collided with trees on the left…NTSB ATL86FA129Accident · 1 fatalField investigationFinal reportCessna 182P · Bay Minette, ALThe acft collided with trees during a descent. The plt was attempting to fly below the overcast to determine his location. The plt radioed just prior to his descent to announce his intentions to his destination UNICOM. There were no further communications…NTSB NYC86LA128Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Ephrata, PAThe Enstrom F28C was cruising enroute when it experienced a loss of power for reasons unknown. During the landing, in a large open field, the main rotor was damaged and the tail rotor separated from the tail boom. The lone occupant, the pilot, was uninjured…NTSB MKC86LA109Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Stuttgart, ARDuring an agricultural spray maneuver back to a field the PIC was fertilizing, the PIC stated he allowed the acft to become too slow and the aircraft descended into trees which bordered the field. The PIC stated he should have been flying with a lighter load…NTSB MKC86LA108Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tekamah, NEThe pilot stated that as he was finishing his run spraying pine trees and was pulling up when the engine lost power. The right wings struck trees and the aircraft nosed over during the forced landing.NTSB MIA86LA158Accident · No injuriesLimited investigationFinal reportCessna 182A · Winter Haven, FLThe plt stated that as he was taxiing the acft from landing, the nose gear became stuck in soft dirt. The propeller then struck the ground and the acft nosed over.NTSB MIA86LA157Accident · No injuriesLimited investigationFinal reportCessna 182F · Sanford, FLThe plt stated that as he attempted to land he did not notice the apch lights at the end of the rwy. The left wing and windshield struck the lights, after which, the acft landed without further incident.NTSB DEN86LA134Accident · No injuriesLimited investigationFinal reportCessna 172H · Great Falls, MTThe plt reported that after landing on rwy 24 he was back taxiing on rwy 06 when he encountered strong, gusty surface winds. He said he stopped and was looking for a place to tie down when a strong gust flipped the acft onto its back. Surface wind at the time…NTSB SEA86LA125Accident · Serious injuriesLimited investigationFinal reportMaule M-6-235 · Fallon, NVThe plt was attempting a precautionary landing on a remote ranch strip after encountering turbulence and high winds enroute. Control was lost on short final when the acft was caught by a gust of wind. The acft contacted the ground on one wingtip and…NTSB SEA86LA124Accident · Minor injuriesLimited investigationFinal reportCessna 206T · Murphy, IDThe pilot attempted to land with excessive airspeed and altitude. A bounced landing occurred with a touchdown being more than 2/3 way down the runway. During VFR co-around, a departure stall was entered and the aircraft struck the ground with the left wing…NTSB MKC86LA105Accident · No injuriesLimited investigationFinal reportBeech A36 · Mountain Home, ARThe PIC rptd gear failure and gear warning horn about 5 to 10 seconds into the landing roll. The PIC rptd 3 in the green before touchdown to the rwy. Subsequent inspection of the landing gear showed no mechanical or other deficiency. Inadvertent movement of…NTSB LAX86LA217Accident · No injuriesLimited investigationFinal reportCessna 172N · Thermal, CAThe student pilot was returning to Thermal airport, Thermal, CA after completing a round robin solo cross country flight. While landing on runway 30 the student encountered a 90 degree right crosswind and lost control of the airplane. The airplane exited the…NTSB FTW86FA086Accident · 1 fatalField investigationFinal reportCessna 172G · Blackwell, OKThe pilot of N5878R, a Cessna 172G, had no previous experience in formation flying. The pilot of N2603E, an Aeronca 7AC, stated he had many hours of formation flying in the military during world war ii and has made an occasional formation flight since that…NTSB DEN86LA135Accident · No injuriesLimited investigationFinal reportCessna T210M · Erie, COThe plt reports that he remembers going through the checklist on downwind following a short flight from a nearby airport. He does not remember doing a final 'down and green' check and the aircraft was landed gear up.NTSB ATL86LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Natural Bridge, ALThe student plt reported making an error during preflt planning for the solo x-country flt. The student's instructor didnot detect the error. The student plt flew an incorrect hdg, became lost and ran out of fuel. A forced ldg was made in a field.NTSB ANC86LA056Accident · No injuriesLimited investigationFinal reportCessna A185E · Tok, AKThe pilot-in-command stated that upon landing in a crosswind, a gust of wind caused the airplane to become airborne. Upon touching down again the airplane was in a crab and the pilot lost control and the airplane struck the left wingtip, then the right…NTSB NYC86LA126Accident · No injuriesLimited investigationFinal reportCessna P206A · Wellsboro, PAThe acft was cruising at 5,500 ft when the plt experienced a total loss of power. He tried to make it to the Wellsboro arpt, however, he was unable to and landed the acft in a field. The acft ran through a fence and was substantially damaged. When the engine…NTSB NYC86LA125Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Spring Valley, NYThe plt was making an apch to rwy 08 which is 2185 ft long and 50 ft wide. The last 1/3 of the rwy slopes down noticeably. The acft struck parked cars in a parking lot located off the departure end of the rwy. There were no witnesses to the accident. The arpt…