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 NYC87DHA01Accident · No injuriesFinal reportPiper PA-28-180 · Lehighton, PAStudent pilot with a certified flight instructor while on the landing roll encountered a crosswind. Directional control was lost the aircraft departed the runway causing substantial damage due coming to final rest in a ditch.NTSB MKC87FA033Accident · 2 fatalField investigationFinal reportChampion 7ECA · Cambridge, NEThe low time PIC had been flying his acft over the farm land in search of coyotes. Several of the grd crew had flown as psngrs with him during the time period of this search. Witnesses stated that they saw the acft turn left and right as it was spotting the…NTSB MIA87IA054Incident · Minor injuriesIncident investigationFinal reportBoeing 747-121 · Miami, FLDuring taxi for takeoff the captain of the air carrier became partially incapacitated. The first officer took over and the flight taxied back to the gate. The captain was evacuated to a local hospital where he was treated with glucose for hypoglycemia and…NTSB DEN87FA039Accident · 1 fatalField investigationFinal reportCessna 172E · Crossroads, NMThe student plt with no simulated or actual instrument and a total of 9 hours night flt time called the amarillo FAA fss, who briefed him on wx for a flt from borger, Texas, to big spring, Texas, located 210 NM south. He was briefed on marginal VFR wx en…NTSB CHI87DET01Accident · No injuriesFinal reportPitts S1S · Warsaw, INAccording to the pilot after touchdown the right brake seemed to lock up with a 'skidding' noise as the aircraft left the runway. The pilot stated he was having difficulty keeping his toes off the brakes as he was attempting to maintain directional control.…NTSB SEA87LA038Accident · No injuriesLimited investigationFinal reportCessna 172 · Yamhill, ORThe plt was landing on a one way short narrow airstrip. He stated a gust of wind occurred just prior to touchdown. The aircraft then bounced and the plt added power. The aircraft then bounced several times and the nose gear collapsed. The aircraft then nosed…NTSB NYC87LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Old Bridge, NJThe plt took off fm the marlboro arpt & flew to 2 other arpts before lndg at the miller arpt at burgettstown, PA, where the eng was shut down. He had difficulty in starting the eng & remained on the gnd about 1 hr. The plt told an aviation safety inspector…NTSB LAX87FA066Accident · 1 fatalField investigationFinal reportMooney M20K · Flagstaff, AZThe pilot encountered clouds and temperatures below freezing during a cross country flight at 17,500 feet above mean sea level. The engine failed shortly after the encounter with the weather. The pilot was unable to restart the engine during the forced…NTSB FTW87LA036Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Lubbock, TXThe plt stated that after a normal apch, he made a hard landing on the main gear and the acft bounced. He further stated that the second contact was hard on the main gear and that the nose gear collapsed when it touched down the 2nd time. Damage sustained by…NTSB FTW87LA034Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Arlington, TXA student pilot on solo flight in the local area of Arlington airport (F54) TX. Substantially damaged a Cessna 150 during a hard landing, breaking the nose gear and nosing over inverted. The pilot received minor injuries.NTSB FTW87LA033Accident · No injuriesLimited investigationFinal reportCessna 150M · Cresson, TXAfter about 45 min of flt time, the instructor (CFI) & student plt entered the traffic pattern to practice touch-&-go landings. As they were taking off from the 1st touch-&-go, the eng lost power. Subsequently, they made a forced landing in an open area near…NTSB FTW87DQA01Accident · 1 fatalFinal reportBeggs Pitts S-1 · El Paso, TXCommercial pilot practicing aerobatics in pitts S1 experimental homebuilt aircraft entered spin. Pilot failed to recover control of aircraft during descent. Aircraft impacted terrain approximately 1/2 mile south of west Texas airport near El Paso, TX.NTSB DEN87IA032Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Billings, MTN124AV was operating as big sky airlines flt 3857, scheduled service from helena to Billings. The flt proceeded uneventfully until the apch into Billings. The flt crew stated after the incident that when the landing gear was extended, the left main gear…NTSB ATL87LA048Accident · No injuriesLimited investigationFinal reportBeech D-17-S · Louisville, KYFollowing a normal landing on runway 06 at bowman field, the acft nosed over while clearing the rwy. The plt reported applying brakes and recalled feeling the tailwheel lift off the ground. The plt did not report any system malfunction, and the investigation…NTSB ATL87FA045Accident · 2 fatalField investigationFinal reportCessna 170B · Asheville, NCDuring initial climb from a private grass airstrip, witnesses described the aircraft perform a 'wing-over' aerobatic maneuver at low altitude and impact the ground at a near vertical attitude. A ground fire consumed the wreckage. The pilot held a student…NTSB MIA87LA052Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Hollywood, FLThe plt stated that the acft tilted shortly after liftoff and he elected to abort the takeoff. While on roll out, when the brakes were applied, the acft veered to the left and ran off the rwy colliding with a fence. The plt reported no mechanical difficulties…NTSB LAX87FA065Accident · 1 fatalField investigationFinal reportRockwell 112TC · Gardena, CAThe pilot elected to return and land at his home airport when the aircraft's landing gear failed to retract after a night takeoff. After reentering the traffic pattern the pilot changed his fuel selector to the left tank for landing. As the aircraft turned…NTSB FTW87FA032Accident · 1 fatalField investigationFinal reportCessna 340A · Tomball, TXThe pilot took off in fog and light rain and climbed into clouds at about 300-400 feet above the ground while both landing lights were extended and illuminated. Also the airport's rotating beacon (located aobut a mile from the accident site) was flashing on…NTSB DEN87IA031Incident · No injuriesIncident investigationFinal reportBeech C-99 · Albuquerque, NMMesa airline flt 114 was on a scheduled flt from Albuquerque to clovis, NM. Upon touchdown at clovis, the left landing gear began to collapse and a go-around was successful. The crew elected to return to Albuquerque where emerg equipment could stand by. After…NTSB DCA87IA015Incident · No injuriesIncident investigationFinal reportATR ATR-42 · Detroit, MIDrg arr, the flt was vectored for an ILS rwy 3R apch. At that time, ATIS info indcd mod mixed icing in clds. The capt rprtd the acft entered the cloud tops at 5500', was in the clds aprx 5 min & accumulated abt 1.5' of rime ice. He statedice accumulation was…NTSB CHI87LA052Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Middleton, WIAt the completion of a period of instrument training and while returning to the airport of origin the CFI asked the private rated dual student to demonstrate a simulated forced landing to the runway. In an attempt to lose altitude on the final approach the…NTSB CHI87LA051Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Bloominton, INAccording to the pilot he was cleared for the ILS approach and followed his glideslope and localizer indications in a normal manner. He eventually saw the ground prior to reaching his decision height of approx 200 feet AGL. This sighting of the ground was the…NTSB SEA87LA037Accident · No injuriesLimited investigationFinal reportCessna T310Q · Medford, ORDuring turn off from the runway to the taxiway the left main gear collapsed. The runway and taxiway were icy and wet. Examination of the landing gear indicated an overload failure.NTSB MIA87LA050Accident · No injuriesLimited investigationFinal reportCessna 336 · Vero Beach, FLPlt stated the rear engine failed while in cruise flight and while making an emergency landing he approached the runway too fast. The aircraft touched down approximately two thirds of the way down the runway and when it could not be stopped the aircraft was…NTSB SEA87FA036Accident · No injuriesField investigationFinal reportSwearingen SA227AC · Salt Lake City, UTThe f/o was at the controls for the ILS apch to slc. Fog seeding was in progress, producing variable visibilities. The apch commenced with RVR well above cat I mins. At decision height(dh), the capt called 'lights in site'. The f/o continued the apch descent…NTSB MIA87LA051Accident · No injuriesLimited investigationFinal reportCessna 150L · Homestead, FLThe plt experienced a slow deceleration of eng RPM followed by a total loss of power. The eng could not be restarted and a forced landing was made. Post accident exam of the eng, eng accessories, and airframe fuel system revealed no evidence to indicate…NTSB ANC87FA021Accident · Serious injuriesField investigationFinal reportBoeing 727-222 · Anchorage, AKAbout 10 min before arrival, the acft suddenly encountered turbulence which one occupant described as a single tremendous jolt. The mishap occurred while the acft was aprx 39 miles east of Anchorage intl arpt and was descending thru 10,000 ft. the seat belt…NTSB LAX87LA064Accident · No injuriesLimited investigationFinal reportCessna P210N · Chandler, AZWhile the plt was receiving vectors for arrival at Chandler, AZ, the eng lost power. Subsequently, the plt made an emergency landing about 1 mi north of the arpt. He rprtd that he had filled the fuel tanks at Chandler & had flown to durango, co on 12/5/86. On…NTSB FTW87FA031Accident · 2 fatalField investigationFinal reportCessna 172K · El Reno, OKPrivate pilot of Cessna 172K attempted VFR flight in IFR flight conditions. Contacted okc approach control and requested special VFR approach during hours of darkness. Approach denied special VFR due to lack of instrument qualification of pilot. Pilot was…NTSB DEN87LA030Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Opheim, MTThe plt elected to take off downhill because he said the hill was too steep to try a takeoff uphill even into the wind. He said that just prior to lift off, he hit a snowbank which slowed the acft down. Deeper snow was then contacted and the acft flipped over.NTSB CHI87LA046Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Lake Village, INThe pilot stated that he gradually lost power while on final approach. He finally stalled the aircraft and pancaked it into the trees before the runway. The pilot also stated that he suspected carburetor ice was involved.NTSB CHI87FA050Accident · 1 fatalField investigationFinal reportCessna 182P · Durand, ILStudent pilot collided with terrain while attempting to remain in visual contact with the ground during very low light and in very heavy ground fog during a cross country flight. The pilot rushed his departure in an attempt to get home before dark and there…NTSB MKC87LA032Accident · No injuriesLimited investigationFinal reportCessna 172P · Pine Bluff, ARThe pilot stated he had flown over trees from the southeast and descended to 50 ft. upon seeing trees in front of the acft he turned left, away from the trees. The left wing touched the ground followed by the nose gear. The acft then flipped forward to the…NTSB MIA87LA049Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Gulfport, MSThe acft touched down at a high rate of speed with a left quartering tailwind at the halfway point on the 2700 ft rwy. The acft ran off of the right side of the rwy and the plt regained control getting the acft back onto the rwy. The acft then overran the end…NTSB DEN87LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, CODuring landing, directional control was not maintained. The acft veered left, the landing gear entered a snowbank, and the acft nosed over.NTSB CHI87LA049Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mcgrath, MNAfter descending to maintain VFR and accumulating clear ice on both the structure and windscreen, the plt decided to make a precautionary landing. During landing in an open area, the left wing struck two apple trees and the acft became airborne again. After…NTSB ATL87LA044Accident · No injuriesLimited investigationFinal reportHughes 269C · Bowling Green, KYWhile hovering in a grassy area near the hangar facility, the pilot experienced a complete loss of flight control. The helicopter struck the ground and sustained substantial damage. The helicopter component examination failed to disclose any system…NTSB ANC87LA020Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Willow, AKThe pilot stated that he had good ground visibility but suddenly flew into whiteout conditions losing ground reference. He stated that before realizing what had happened the acft struck the top of the mountian rigde.NTSB LAX87LA048Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · San Jose, CAA Piper pa 32R-300 landed short of the rwy after a loss of power. The plt reported during the climb that he turned on the heater and the windshield turned black obscuring outside vision. The plt also indicated that there was a 'pungent odor' at the same time.…NTSB LAX87DUJ03Accident · Minor injuriesFinal reportSolem KR-2 · Mesa, AZThe pilot said that shortly after takeoff the control stick shuddered and he felt 'back pressure' on the stick. The nose started pitching up so he pushed forward on the stick. He continued pushing the stick forward until it reached the forward stops. Despite…NTSB MIA87FA048Accident · Serious injuriesField investigationFinal reportCessna 182P · St. Cloud, FLThe private pilot stated that prior to takeoff she did not check the fuel supply, and initiated an IFR flight. About 20 minutes into the flight the engine failed at 5000 ft MSL. During the subsequent forced landing attempt the aircraft struck a fence and a…NTSB CHI87DEX04Accident · Serious injuriesFinal reportAero Commander 500B · Hagerstown, INThe pilot was on the fourth leg of a night cargo flight cruising at approximately 500' AGL enroute to Mt. Vernon, IL, when the aircraft struck some trees and subsequently collided with the ground. The engines and propellers were both torn down and tested and…NTSB ATL87LA043Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Morganton, NCPlt reptd doing LCL flying for about one hr after dept from pvt grass strip. Made apch and ldg at Morganton-lenoir apt. On touchdown plt reptd bouncing, and being unable to recover before lt main gear collapsed and lt wing dragged. Plt stated that he felt…NTSB NYC87LA012Accident · 1 fatalLimited investigationFinal reportEnstrom 280C · Newport, RIAircraft descended and collided with water when the pilot attempted to regain visual ground reference when weather deteriorated. No plt acc report was received. Plt time was not reported or available.NTSB MKC87LA031Accident · No injuriesLimited investigationFinal reportCessna 180 · Olathe, KSDuring landing airplane ballooned due to wind gust. After touchdown. Airplane veered left and duirng pilot's correction, the left main landing gear leg broke off. Metallurgical evaluation revealed a previous fatigue failure in the fracture surface.NTSB MKC87FA030Accident · Serious injuriesField investigationFinal reportPiper PA-28-151 · Grain Valley, MOThe pilot stated, after takeoff the engine sputtered and began losing power during initial climb. According to the pilot, he tried to land on a highway but there were numerous vehicles in transit and he decided to attempt an off-airport landing. On initial…NTSB LAX87LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Hayward, CAA Piper PA-28-235 collided with a dirt bank after a loss of power while on a night VFR pleasure flight. The plt indicated that aprx 3 min after takeoff while cruising at 1,400 ft MSL the engine RPM abruptly decreased to idle. The fuel selector control was…NTSB CHI87LA044Accident · No injuriesLimited investigationFinal reportCessna T303 · Benton Harbor, MIThe plt was flying to Benton Harbor to get work done on a continuing problem with the right eng throttle. On final apch, the plt did not get a gear down indication and tried to cycle the gear. Not sure that the gear was down, the plt choose to go-around. When…NTSB CHI87IA047Incident · No injuriesIncident investigationFinal reportFairchild SA226TC · Paducah, KYJust after the beginning of a descent for landing a rudder cable failed completely, rendering the rudder inoperative. The aircraft landed uneventfully. Metallurgical analysis revealed that the cable wore severely until it failed. Following an examination of…NTSB CHI87FA048Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · N. Manitou Isl., MIThe plt had recvd an unfavorable wx brief that included a SIGMET on flt icing. Enroute during flt over a large body of water he experienced power loss and was at too low a altitude to glide to shore. The plt attempted to ld on a island but crashed in a lake.