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 MKC86LA056Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Des Moines, IAThe student pilot stated he was on the takeoff roll for a practice flight when he lost directional control and ran off the left edge of the runway and stayed there until it impacted a taxi/intersection sign.NTSB MIA86LA068Accident · No injuriesLimited investigationFinal reportAerospatiale 350-B · Las Piedras, PRPilot stated that while flaring to enter a hover to reverse direction for takeoff the tail rotor guard struck the ground and separated. The helicopter was nosed over forward and as it was flared a second time the tail rotor struck the ground causing loss of…NTSB SEA86LA050Accident · No injuriesLimited investigationFinal reportCessna T210-H · Cascade Locks, ORDuring landing roll on the 1800 foot long 30 foot wide wet runway, the aircraft veered right off the runway and then nosed over. The pilot applied brakes twice with no effect and the third time they grabbed. No malfunctions were found during inspection or…NTSB SEA86LA049Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Metlakatla, AKWind was 070 degrees at 20 KTS with 6-12 inch sweels. N127WA was positioned at north side of dock for departure toward east. N1018H was holding at east side of dock. Deck hand cast off N127WA before plt started engine; acft began to drift back into dock. Plt…NTSB MIA86LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · San Juan, PRThe student pilot, on his third supervised solo flight, lost control of the aircraft during the landing roll and collided with an aircraft parked south of the runway.NTSB LAX86FA102Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Bridgeport, CADrg flt over mountainous terrain, the plt encountered instrument meteorological conditions along his route of flt. A witness observed the acft flying at about 200 ft AGL under a cloud layer, then it disappeared in a snow shower. A search was initiated & the…NTSB ATL86FA066Accident · 2 fatalField investigationFinal reportCessna 152 · Lexington, NCThe plt/mechanic had completed a top overhaul on the acft eng and was believed to have been conducting a night maintenance flight when the accident occurred. The acft impacted the ground in a near vertical attitude in a wooded areaaprx one mile from the…NTSB FTW86LRD06Accident · No injuriesFinal reportAir Tractor AT301 · Gilbert, LAOn January 29, 1986, an airtractor AT310, N5218S, owned by halcom flying service, was substantially damaged due to a fire which occurred during an attempted engine start. N5218S was to be flown to another location for maintenance purposes.NTSB DCA86AA017Accident · 2 fatalFinal reportCessna P210N · Keflavik, IcelandAt 1146 gmt, N4906K deptd on a 5 hr flt to narssarssuaq, greenland with an estd 7 hrs of fuel. When the plt rprtd 60 mi sw of greenland, the destn vis was below IFR min & the ceiling at the altn arpt was below the mda. The plt elected to cont to reykjavik,…NTSB CHI86LA080Accident · Minor injuriesLimited investigationFinal reportChampion Citabria 7GCBC · Ely, MNDuring a descent from 1000 ft AGL to 200 ft AGL to photograph wildlife the pilot applied carb heat. When he advanced the throttle at 200 ft to level off the engine did not respond. The aircraft then settled into trees. Temperature at the time was -5 deg f.,…NTSB CHI86FA079Accident · 2 fatalField investigationFinal reportCessna 421C · Birmingham, MIAt rotation the right eng failed. The acft entered a skidding turn to the rt and continued to climb to about 100 ft AGL. During the turn 110 deg from t.o. heading acft rolled inverted and descended into a car port. Extensive post impact fire destroyed acft,…NTSB SEA86FA047Accident · 1 fatalField investigationFinal reportCessna TR182RG · Reno, NVThe pilot was flying his Cessna TR182RG back to Reno cannon airport, a facility with a frequent mixture of light general aviation aircraft and heavy turbine air carrier operations. The pilot had acquired the majority of his terminal experience in and around…NTSB SEA86FA046Accident · 3 fatalField investigationFinal reportCessna 401 · S. Lake Tahoe, CAAcft took off in clear wx but below-freezing temps with heavy frost on acft surfaces. No preflight, run-up or warm-up performed. On initial climb, left eng power loss occurred for undet reason, but probably associated with temp/cold eng operation. Plt turned…NTSB MIA86IA066Incident · Minor injuriesIncident investigationFinal reportBoeing 747-123 · Miami, FLShortly after departure the crew noted smoke in the cabin and the cockpit. The captain declared an emergency and landed back at the departure airport. He then directed an emergency evacuation. During the evacuation several emergency slides failed to deploy…NTSB LAX86FUQ01Accident · Serious injuriesFinal reportStriplin Ranger · Lancaster, CAThe acft crashed in a flat stalled attitude at a high sink rate after a power loss in an attempted go-around. The pilot had been instructed to stand-by for a go-around because of traffic. The plt continued his approach off-set to the north of the rwy, at 50…NTSB FTW86LRG12Accident · No injuriesFinal reportFairchild 24R-46A · Lakeway, TXThe dual instructional flight terminated in a crosswind landing with the rated pilot receiving dual instruction manipulating the controls. During the landing rollout directional control was lost and the aircraft veered to the left. According to the instructor…NTSB DEN86FA069Accident · No injuriesField investigationFinal reportBell 206L-1 · Missoula, MTThe helicopter, equipped with landing skid snow pads, was parked on a narrow ramp extension to a roof top helipad that was surrounded by a concrete curb. Upon takeoff to a hover, the right snow pad struck and became momentartily caught on bolts protruding…NTSB CHI86FA077Accident · 2 fatalField investigationFinal reportMooney M20C · Loogootee, INPlt experienced loss of pwr during cruise flt at 6,000 feet. ATC vectored acft toward daviess county arpt, approximately 10 miles away. Plt reported acft on fire. Witnesses saw N9307V in a left bank turn then 'nose dive into ground.' Post crash exam of engine…NTSB ATL86FA064Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Milwaukee, NCThe acft was observed to descend and level off at low alt. Witnesses indicated that it leveled off just above the trees, then rolled to the right and dove into wooded terrain. The eng was reported to be running loud and steady until impact. No preimpact part…NTSB MKC86LA057Accident · No injuriesLimited investigationFinal reportCessna 310R · Kansas City, MOThe airplane was being taxied toward a parking spot in front of a hangar and the right brake failed and the left wing contacted the front of the hangar.NTSB LAX86LA100Accident · Minor injuriesLimited investigationFinal reportErcoupe E · Apple Valley, CAThe plt stated that the acft's eng lost power and the acft flipped over during an attempted forced landing on a dirt road in front of his residence. A witness stated that the acft made three low passes over the dirt road prior to touchdown. A witness…NTSB LAX86LA098Accident · Minor injuriesLimited investigationFinal reportBell 222UT · La Habra, CAOn January 26, 1986 a Bell 222UT collided with a 3/8 inch support cable. The pilot saw the lower of two of the three support cables about 75 feet AGL as he was transitioning to forward flight from a vertical max performance t/o. the pilot applied aft cyclic…NTSB LAX86FA099Accident · 1 fatalField investigationFinal reportCessna 172A · Strathmore, CAUpon returning to his home airport, the non-instrument rated pilot was unable to see the runway due to heavy fog covering the area. He entered a right descending turn in an attempt to descend under the fog. The aircraft collided with orange trees…NTSB CHI86LA078Accident · No injuriesLimited investigationFinal reportMooney M20-K · Madison, WIA gear up landing was performed by the pilot. He stated that he was distracted by an airliner ahead of him in the pattern and did not consult his before landing checklist. He also stated that he had not flown much in the last three months.NTSB SEA86LA048Accident · No injuriesLimited investigationFinal reportCessna 206 · Wenatchee, WAThe pilot diverted from his intended destination of pangborn field to a local private airstrip due to local fog. 8' of crusted snow was present on the runway and the aircraft nosed over on landing roll.NTSB SEA86LA045Accident · Minor injuriesLimited investigationFinal reportBellanca 1413-2 · Vancouver, WAA total loss of power occurred due to a previously burnt flex hose which blocked air from coming into the induction system. The aircraft was unable to reach the runway and struck trees before it came to rest on the roof top of a residence.NTSB LAX86LA097Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Lake Havasucity, AZOn January 25, 1986 a Cessna 182 collided with the runway surface after the nose wheel collapsed on runway 5 at lake havasu city airport, Arizona. VMC prevailed at the time with the UNICOM reported winds from 270 degrees at 17 knots and gusting. The…NTSB LAX86FVD04Accident · 1 fatalFinal reportVangrunsven RV-3A · Fortuna, CAThe acft stalled in a turn during a forced landing after the engine lost power. Post acc investigation revealed an inoperative fuel selector valve. Witnesses said that the acft did not sound like it was developing full pwr during take off roll. Shortly after…NTSB FTW86LRA07Accident · Serious injuriesFinal reportBell 206L-1 · Sabine Pass, TXAcft encountered deteriorating weather enroute from shore to an oil rig that was under tow in the gulf of Mexico. Upon encountering IMC conditions, the plt climbed to 600' AGL for better obstacle clearance and turned back toward the beach. During a subsequent…NTSB CHI86LA075Accident · No injuriesLimited investigationFinal reportCessna 172 · Baraboo, WIThe plt attempted a x-wind landing that was beyond his capabilities. He stated that if the x-wind was excessive he intended to divert to another arpt with a more favorable runway. At touchdown the aircraft drifted right into a two foot high snow bank off the…NTSB ANC86LA023Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe pilot stated that during the landing roll he lost directional control of the aircraft. The aircraft struck a row of trees of the end of the landing area.NTSB MKC86LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Bancroft, IAThe plt became disoriented on a night, VFR flt and landed at an arpt to determine his location. The unattended arpt did not have a phone so the plt tookoff again enroute to his original dest. He became disoriented a second time and, because the acft was…NTSB MIA86LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Melbourne, FLThe plt stated that on his landing rollout he lost control of the acft & veered off the left side of rwy 9L collapsing the nose gear.NTSB LAX86LA096Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Half Moon Bay, CAThe plt reported that on approach he was 'a little high & hot' for the 5000-FT-long rwy. He said that at midfield he was 100 ft. AGL & he decided to go around. Upon applying power only 700 RPM was obtained, so he then attempted to land the acft at the end of…NTSB FTW86LRA06Accident · Minor injuriesFinal reportAerospatiale AS-350D · Freeport, TXWhile on a maintenance test flt the helicopter experienced an eng failure. An autorotation was entered and a hard landing occurred which resulted in a roll over. The flt originated at oyster creek heliport and returned twice for maintenance adjustments and…NTSB FTW86LRA05Accident · No injuriesFinal reportCessna 172 · Tomball, TXThe acft veered off the left side of the rwy during landing. The nose wheel dug into mud and the acft nosed over. The plt said he was unable to correct the violent turn to the left.NTSB CHI86FEI02Accident · Serious injuriesFinal reportCessna 150H · Strongsville, OHDuring preflight, the student pilot noticed water in the fuel tank when he checked the fuel drain. He notified his instructor, but no further action was taken. Shortly after takeoff the engine quit. An emergency landing was performed in a parking lot and one…NTSB ATL86LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Atlanta, GAThe pilot was unable to start the engine and elected to rotate the propeller by hand to free the congealed oil in the engine. When the propeller was rotated the engine started and the aircraft taxied into another parked aircraft. Post-accident examination of…NTSB MIA86LA063Accident · No injuriesLimited investigationFinal reportCessna 310J · Opa Locka, FLThe pilot/owner reported that he had the left main landing gear repaired twice previously due to left gear collapses upon landing. He also stated that he had just picked up the aircraft from the mechanic performing the last repair. When upon the first landing…NTSB FTW86LRG11Accident · No injuriesFinal reportCessna 172M · Mcallen, TXThe acft crashed into two trees during a forced landing after the eng lost pwr. The plt was in the process of lndg at an arpt when the controller asked him to make a 360 turn because of traffic and to use rwy 13 instead of 18. As the plt turned rt for a new…NTSB DEN86LA073Accident · Serious injuriesLimited investigationFinal reportEipper Quicksilver MX II · Albuquerque, NMThe plt stated that while returning to the airfield, the eng quit as a result of fuel starvation. The plt was not certified and the aircraft was unregistered.NTSB CHI86LA076Accident · No injuriesLimited investigationFinal reportCessna 177 · Indianapolis, INThe student pilot flared too high, damaging the aircraft upon touchdown.NTSB CHI86LA074Accident · No injuriesLimited investigationFinal reportCessna L-19 · Kenosha, WIThe pilot drained the fuel tanks until no evidence of water was present. Alcohol & 100LL was added prior to takeoff. In the traffic pattern engine power was lost. The runway was over flown & a collision with a fence insued during the forced landing. Water was…NTSB FTW86LA036Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Corpus Christi, TXThe student was receiving dual instrument flt instruction. She had conducted several practice instrument apchs, all in VMC conditions. The last was an ILS to rwy 13 at Corpus Christi int'l arpt. It started in VMC conditions but entered clouds at about 550 ft.…NTSB ATL86FA063Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Anniston, ALThe acft was observed flying through the base of the low level cloud layer prior to its impact on the side of a mountain. The plt was not instrument rated, had not filed a flt plan nor obtained a wx briefing. The impact point was several hundred ft below the…NTSB MIA86LA062Accident · Minor injuriesLimited investigationFinal reportRockwell 112TC · Atlantic Ocean (Atlantic Ocean)The aircraft was in cruise flight when the pilot reported an engine failure. The pilot executed a forced landing to the Atlantic Ocean and the aircraft sank, and was not recovered. The cause of the engine failure is undetermined.NTSB FTW86LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Flynn, TXThe engine lost power while in cruise flight about 9 miles short of the pilot's planned destination. He made a forced landing in an open field. After rolling about 75 feet the airplane wheels bogged in and it flipped inverted. The owner of the aircraft, Mr.…NTSB FTW86LA039Accident · No injuriesLimited investigationFinal reportSocata MS Rallye 235C · Brenham, TXThe right flap push rod experienced a progressive type failure from repeated excessive force being applied by the flap drive motor. The excessive force was caused by the flap rollers being neglected during maintenance to the extent that they became dry and…NTSB FTW86LA038Accident · No injuriesLimited investigationFinal reportCessna 172G · Spring, TXThe pilot continued VFR flight into IFR weather conditions which he had encountered near his destination during the last few moments of his approximate four hour, night, cross-country flight. He then turned back to houston intercontinental airport to land. He…NTSB CHI86MA071Accident · 3 fatalMajor investigationFinal reportBell 206B · Ellendale, MNThe purpose of the flt was to take a news crew to a location to cover a story. The news crew had attempted to hire another helicopter, but that operator refused due to forcast low visibility. This plt, however, agreed to fly. Altho he was certified for…