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 LAX85FA042Accident · 2 fatalField investigationFinal reportCessna 172N · Jamul, CAThe certified flt instructor and private rated student pilot departed on a local instrument instructional flight. The aircraft departed at aprx 1715 and at 1750 an ELT signal was reported. The aircraft wreckage was located atop a hill at aprx the 2000 ft…NTSB FTW85LA051Accident · No injuriesLimited investigationFinal reportMooney 231 · Abilene, TXAccording to the plt, at about 15 ft AGL, simultaneous with gear retraction, the cabin door popped open and the nose of the airplane 'tucked.' The plt attempted to control the nose attitude but as the propeller began striking the runway surface, power was…NTSB CHI85LA047Accident · Minor injuriesLimited investigationFinal reportRockwell 114 · Strongville, OHPlt was aware runway had a pronounced dip just prior to rotation area of his acft. Passing the dip on takeoff roll, he felt a 'shimmy' which he attributed to nose gear reaction to the dip. Plt considered aborting takeoff, but felt insufficient runway…NTSB SEA85LA017Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Humptulips, WAWhen the hoisting cable on the helicopter failed, the hook end rebounded into the rotor system. The rotor system failed from the structural damage imposed and the acft went into an uncontroled descent impacting the ground on the left skid.NTSB MIA85IA032Incident · No injuriesIncident investigationFinal reportPiper PA-34-200 · Miami, FLThe nose cear collapsed during a landing. An exam disclosed that the hydraulic actuator firewall mounting bracket had failed prior to complete extension of the nose gear. Piper service bulletin, sb 413, related to this problem; however, no logbook entry was…NTSB LAX85LA047Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Yuma, AZThe plt rptd that while en route to Yuma, AZ, the eng began running rough and subsequently quit. During the landing rollthe acft collided with a dirt embankment and nosed over. Examination of the wreckage disclosed both fuel tanks contained only residual…NTSB FTW85FA050Accident · 2 fatalField investigationFinal reportHughes 269B · Clint, TXN9336F, crashed while on a training flt. The certified flt instructor & his student were killed. Investigation revealed that the main drive shaft thrust bearing had failed. A service bulletin dated 1968 mandated replacement of the bearing at 300 hr time in…NTSB DEN85FA028Accident · 1 fatalField investigationFinal reportChampion 7ECA · Sevier, UTThe plt was en route from anchorage, Alaska to prescott, Arizona to be with his dying mother. Weather was described as windy, low ceilings, and approaching dusk when the a/c departed richfield, Utah. A/c was loaded with 284 lbs of cargo. A/c crashed on…NTSB ATL85LA036Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Eads, TNThe plt stated that he was taking off with full pwr. The acft accelerated to about 60 when it went over a small rise in the rwy, the left wheel assembly seperated from the acft at the pt where it attaches to the landing gear strut. The strut dug into the gnd…NTSB MKC85LA020Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Burlington, IAAccording to the pilot the descent into the traffic pattern was late and the base turn performed early leaving the acft high on final. As a result, an excessive rate of descent developed on short final. The high descent rate and diminishing daylight led the…NTSB FTW85LA047Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Edinburg, TXFollowing a bounced landing, plt attempted a go-round, but inadvertenly raised the flaps. The acft settled into a plowed field adjacent to the runway and nosed over.NTSB FTW85FA045Accident · 2 fatalField investigationFinal reportde Havilland DHC-1-22 · Abilene, TXAcft crashed while attempting an intentional low level acrobatic maneuver (left roll) over the rwy. Witnesses stated that the acft made a low pass (100-200' AGL) down the rwy & entered the roll. At the inverted position, the nose fell thru, but the maneuver…NTSB FTW85FA044Accident · Serious injuriesField investigationFinal reportBell 206L-1 · E Cameron Blk 2Total loss of pwr occurred just after lift off from 130 ft high drill rig platform in gulf of Mexico. Plt entered autorotation but touchdown was hard during ditching resulting in a roll over. Post accident testing did not reveal any mechanical failure or…NTSB CHI85LA048Accident · Serious injuriesLimited investigationFinal reportBeech D-45 (T-34) · Bedford, ILThe plt reported that during flt, he proceeded to fly along a river. After a time, he reversed course & began flying along the river in the opposite direction. He said that the flt back was at a lower alt & that the propeller contacted something in the water.…NTSB ATL85LA033Accident · No injuriesLimited investigationFinal reportCessna 182RG · Charleston, SCPilot landed the aircraft with the landing gear in the up position. Examination of the landing gear after the accident revealed no evidence of mechanical malfunction or failure that would have prevented normal gear operation.NTSB ANC85LA029Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Chandalar, AKThe plt reported that the acft hit a wooden sign post and ground looped during takeoff. The acft came to rest about 100 yards from the starting takeoff point.NTSB ANC85LA017Accident · Minor injuriesLimited investigationFinal reportCessna 310J · Tok, AKThe acft crashed during an emerg night landing after the loss of pwr on both engines. Investigation revealed the rt eng was secured because of decreasing oil pressure & a visible oil leak. There were seven airports within reach of the acft when this eng was…NTSB ANC85FA016Accident · No injuriesField investigationFinal reportCessna 180 · Chugiak, AKAcft collided with trees aprx 2,600 ft short of rwy 19 threshold during the landing apch. The acft stopped 35-40 ft AGL in trees and after a few minutes fell to the ground. A descent was made from aprx 10,000 ft with a leaned mixture, closed throttle and no…NTSB FTW85LA046Accident · No injuriesLimited investigationFinal reportReed Bandit 1 · Amarillo, TXThe homebuilt acft, N52957, was observed to land hard, collapse the landing gear & slide into N3376V holding short of the rwy at an intersecting taxiway.NTSB FTW85FA041Accident · 1 fatalField investigationFinal reportNorth American SNJ-5 · Fairview, OKThe acft was engaged in performing at an air show when recovery from a left aileron roll at aprx 300 ft AGL was completed to an upright attitude, however, the acft nose dropped and the acft turned 45 degrees to the right of the rwy heading. It then impacted…NTSB DEN85IA025Incident · Minor injuriesIncident investigationFinal reportAerospatiale SA315B (Lama) · Oak City, UTBoth acft were performing external load operations. N5785V was in level flt to the north. N9362 was in a 60-70 kt slight climb to the southeast. Neither plt, both in rt seats, saw the other acft before contact. Three main rotor blades of N5785V passed through…NTSB CHI85LA046Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Bloomington, INPlt stated that while in cruise flt, the acft nose pitched down abruptly. Plt disengaged the autopilot and noted vacuum system was inoperative. Flt continued on manual control without further incident until late final approach at destination. When flaps were…NTSB ANC85LA018Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Minchumina, AKThe acft made a hard landing on a frozen lake during a precautionary landing. The plt said that cargo on board had shifted in flt and he also had a loss of 15 mph in airspeed. Thinking it might be an icing problem, the plt made the unscheduled landing. No ice…NTSB NYC85LA041Accident · No injuriesLimited investigationFinal reportMooney M20J · Marlboro, NJPlt stated that on late final, with airspeed and descent path normal, acft encountered downdraft and collided with upslope at runway threshold before corrective action could be taken. A 60 degree left crosswind of 15 KTS existed at the time.NTSB NYC85LA027Accident · No injuriesLimited investigationFinal reportTaylorcraft BL-65 · Conyngham, PAThe plt made an emergency landing in a plowed field following a loss of power. During the landing, the left strut & right wing tip were damaged. No reason for the loss of power was found during the investigation.NTSB NYC85LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Waterford, CTN3772M (acft 'a') was on lndg roll on runway 15 when N19091 (acft 'b') initiated taxi across the runway. Acft 'a' swerved to avoid collision but inadequate clrnc was available. Right wing of acft 'a' collided with left wing of acft 'b'. Plt of acft 'b' stated…NTSB NYC85FGM01Accident · Serious injuriesFinal reportCessna 172P · West Mifflin, PAAcft landed long with excessive speed. Plt attempted a go-around but was unable to obtain sufficient flying speed before reaching the end of the rwy which drops off into a steep embankment. When the acft reached the end of the rwy ground effect was lost and…NTSB NYC85FA025Accident · 1 fatalField investigationFinal reportCessna C337 · Taunton, MAAfter departure & at an altitude of 2000 ft the plt noticed that the rear eng fuel flow was low, however, the eng was operating satisfactory. The plt, as a precaution, decided to return to the departure arpt. While returning the plt noted that there was no…NTSB MIA85LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Gainesville, FLThe acft collided with a tractor during taxi. The plt stated that he saw the tractor and thought there was room to pass.NTSB MIA85LA030Accident · No injuriesLimited investigationFinal reportLet L-13 · Homestead, FLAccording to the plt, a downdraft was encountered on base leg causing the acft to descend and decelerate. Unable to reach the rwy the glider landed in an orchard.NTSB MIA85FA029Accident · 2 fatalField investigationFinal reportGates Learjet 24F · St. ThomasWhile executing a night visual approach to runway 9 in visual meteorological conditions the aircraft was allowed to descend; crashing into water 2 miles short of the runway. The pilot was not familiar with the airport and failed to make use of a full…NTSB LAX85LA045Accident · No injuriesLimited investigationFinal reportBell 206B · Inverness, CAAn autorotation was initiated at about 300 ft as eng and rotor RPM began to decrease. Touchdown occurred in soft sand with some forward motion. Full aft cyclic was applied causing the main rotor to contact the tailboom. Exam of the acft fuel system revealed…NTSB FTW85LA042Accident · Minor injuriesLimited investigationFinal reportCessna 441 · Grand Chenier, LAThe pilot told the cameron parrish sheriff that he was attempting to land the aircraft at a small agricultural landing strip after one of the two engines quit due to fuel starvation. The pilot stated that there was nothing wrong with the aircraft except that…NTSB ATL85LA032Accident · No injuriesLimited investigationFinal reportBoeing 75 · Rustburgh, VAThe pilot stated that he was landing on the 1,100 foot long runway to the south with a 16 knot tailwind. The plt continued to state that while on final apch the aircraft had an excessive rate of sink. The plt added full power in an attempt to arrest the…NTSB ANC85LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Talkeetna, AKThe acft crashed during a forced landing following a power loss. Post accident fire destroyed the acft. The acft engine was partially disassembled following the accident and no discrepancies were found. The plt said that he suspected carburetor ice. During…NTSB MKC85LA019Accident · No injuriesLimited investigationFinal reportCessna R172E · Junction City, KSPilot was experiencing communications difficulties, diverted from destination to nearby uncontrolled arpt due to traffic considerations. Plt was unable to contact UNICOM and elected to circle for traffic and wind evaluation. Best runway for wind direction was…NTSB MIA85FA028Accident · Serious injuriesField investigationFinal reportCessna 150 · Orlando, FLAccording to the plt the eng failed while flying at aprx 1500 ft AGL. During the forced landing the acft struck the crown of a sand trap on a golf course in a left wing low, nose low attitude and boumced aprx 60 ft before comming to rest inverted. Post crash…NTSB FTW85LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · Denver City, TXPlt cited gust on landing caused acft to drift to right, plt visual acuteness reduced by landing into setting sun. Corrective control input of left aileron was excessive, causing left wing to drop to ground contact. Acft pivoted about left wing tip and came…NTSB FTW85LA048Accident · No injuriesLimited investigationFinal reportCessna 170B · Amarillo, TXWhen advised of high winds at destination, plt diverted to en route alternate on arrival at alternate, plt was advised of 60 degree crosswind with gusts to 40 mph. Plt had 21 hrs experience in conventional (tailwheel) acft. On landing touchdown, gusts lifted…NTSB FTW85FA040Accident · Serious injuriesField investigationFinal reportCessna T337B · West Monroe, LAThe acft crashed into trees during a forced lndg after both engs lost pwr. The acft had been recently purchased and was being ferried to the new owner. The acft had been flown only 40 hrs since the last annual inspection which was done on 1/19/84. It was…NTSB ATL85LA031Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Hogansville, GAA deplaning passenger walked into the rotating tail rotor. The passenger had been walked away from the acft by the plts brother but she returned on her own and was struck by the tail rotor.NTSB MIA85LA026Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Mayport, FLThe acft crashed about 10 min after departure on the return leg of a x-country flt. Post crash investigation revealed that the eng failed due to fuel exhaustion. The plt stated that he did not visually check the fuel supply because there was no step ladder…NTSB FTW85LA039Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Mission, TXAfter a loss of oil pressure the acft was landed downwind. During the precautionary landing across plowed furrows, the rt wing caught in the sugar cane crop and the acft turned to the rt, collapsing the left landing gear and damaging the left wing. The plts…NTSB DEN85LA024Accident · No injuriesLimited investigationFinal reportCessna 185C · Williston, NDThe acft collided with a bridge during an aborted takeoff after failing to get airborne. The plt aborted the takeoff butthe acft failed to stop in time to avoid a collision with a railroad bridge abutment made of concrete. The plt stated that the acft had…NTSB CHI85LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Alton, ILWhile on a solo training flt, the student plt flew from centralia to Alton, IL, & entered the traffic pattern to land onrwy 11. The wind was reported from 170 deg at 12 KTS gusting to 20 KTS. During the apch, the acft was blown to the left side of the rwy…NTSB ATL85LA030Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Ariton, ALAcft lost pwr and plt attempted to restart engine by switching fuel tanks. Power was not regained and forced landing was made in a field. Plt stated aux tanks were full and rt main contained 1/2 gallon of fuel. Fuel tank selected at time of power loss is…NTSB ATL85LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Reidsville, NCThe plt was making a full stop landing and after bouncing a few times the acft nosed over. The plt said the acft porpoised and his attempts to recover were unsuccessful. The winds were calm and no mechanical malfunctions were reported.NTSB NYC85LA022Accident · No injuriesLimited investigationFinal reportMooney M20C · Landover, MDFlt departed danbury, CT, on x-country flt to college park, MD. According to plt there was sufficient fuel on board, however plt extended flt to northern VA before returning to college park. Prior to reaching arpt a loss of power occurred and plt made gear up…NTSB MKC85LA018Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Algona, IAAt about 100 ft AGL after takeoff, eng lost pwr. Plt attempted to circle to land on closest runway but eng was developing insufficient pwr to maintain altitude in turn. Acft touched down 150 ft short of threshold. Plt did not level wings prior to touchdown.…NTSB ATL85LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Baxley, GAThe acft was damaged during a forced landing into a plowed field after the eng quit. Investigation revealed the plt had been instructed to refuel at his first stop of an extended x-country flt. The acft ran out of fuel aprx 1 mi from the second scheduled stop.