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 MIA86IA018Incident · No injuriesIncident investigationFinal reportGrumman American AA-5 · Live Oak, FLThe acft made a downwind landing touching down long on the rwy. The acft could not be stopped & ran off the end of the rwy. The plt stated that he misread the windsock.NTSB MIA86IA017Incident · No injuriesIncident investigationFinal reportCessna 402C · Miami, FLThe plt stated that he made a normal apch to rwy 12 buy on landing rollout as the nose of the acft touched down the nose gear ass'y folded & the acft slid to a stop, post crash examination of the acft revealed that the green light for the nose gear remained…NTSB LAX86LA026Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Flagstaff, AZThe plt reported that while sight-seeing in the vicinity of the grand canyon, he became disoriented and lost. The fuel in the left tank was exhausted and the right fuel tank contained minimum fuel. The pilot negotiated a precautionary landing on the hard…NTSB LAX86FA025Accident · No injuriesField investigationFinal reportCessna 182P · Sacramento, CAAs the Cessna 182P pilot flew through a control zone without establishing communications at an altitude of 3,500 ft, a Piper PA28 was beginning its approach for landing. The Piper's pilot was practicing instrument flight using a hood and a safety pilot. The…NTSB FTW86LQG01Accident · No injuriesFinal reportPiper PA-36-300 · Fluvanna, TXThe acft contacted a cattle guard during an attempted takeoff for an aerial application flt. The plt reported the acft was overloaded for the length of rwy being used for the takeoff. He continued to report he was too late in dumping the chemical load. The…NTSB FTW86LPJ01Accident · No injuriesFinal reportCessna 172 · Kremlin, OKThe acft landed in a wheat field adjacent to the sod rwy. The acft nosed over in a small ditch during rollout. The plt said he mistook the green winter wheat for the sod rwy which was now brown dormant grass from a frost and not green as it was when the plt…NTSB DEN86LA014Accident · 1 fatalLimited investigationFinal reportGlobe GC-1B · Albuquerque, NMThe wife of the plt radioed her husband had become incapacitated. Two flt instructors departed in another acft to assist the non-rated wife, after being contacted by Albuquerque apch control. The flt instructors were able to assist the non-rated wife through…NTSB ATL86LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Marietta, GADuring an attempted touch and go landing the student plt lost directional control of the acft. The acft ballooned during touchdown, veered off the rwy and nosed over.NTSB NYC86LA018Accident · No injuriesLimited investigationFinal reportBeech BE-95-100 · Grove City, PAAfter turning on to final for rwy 270 transition/upgrade pilot observed he was high. Power was then reduced aircraft was then on short final a power adjustment was made causing aircraft to land 400/500 feet pass rwy threshold. On contact with rwy nose gear…NTSB NYC86IA019Incident · No injuriesIncident investigationFinal reportFokker F-28 · Flushing, NYThe F-28 acft was holding on taxiway bb. The B-767 acft was taxiing behind the F-28 on taxiway e which is perpendicular to taxiway bb. The r wing of the B-767 struck the rudder of the F-28.NTSB LAX86LA023Accident · No injuriesLimited investigationFinal reportPiper J3 · Green Valley, AZOn oct 24, 1985, a Piper J3 cub,N33461, made an emergency landing in rough, open terrain near Green Valley, AZ. After experiencing a loss of engine power the ac sustained substantial damage and the pvt plt was not injured. The investigation revealed that the…NTSB LAX86IA021Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Oakland, CAOn October 24, 1985, an American airlines 727 collided with a parked united airlines 727 during a power back operation at Oakland, CA. IMC existed at the time with visibility limited to 0 ft due to fog. The aa ac sustained minor damage to its left wing and…NTSB FTW86MA018Accident · 2 fatalMajor investigationFinal reportBell 222UT · East CameronThree pax rprtd that just prior to reaching the helipad, the helicopter's forward movement stopped and the helicopter wobbled or yawed from side to side. The pax's rprted that the pilot appeared to be trying to gain altitude and go forward when they heard a…NTSB FTW86FA019Accident · 1 fatalField investigationFinal reportGulfstream American AA-5B · Ozona, TXThe acft was observed apchg the destination while flying under a cloud cover of aprx 1000 ft AGL. When it reached the vicinity of the arpt, the plt made a turn & subsequently entered the clouds. A witness heard what he described as variations in eng power.…NTSB CHI86LA016Accident · Minor injuriesLimited investigationFinal reportBeech A23.19 · Decatur, INThe student pilot on an unauthorized xcountry flt was attempting to ld on a 2600'-115' sod strip. On his fifth approach the 90 deg xwind drifted him into a tree line on the downwind side of the strip.NTSB CHI86LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Cahokia, ILThe student pilot was practicing touch and go landings in preparation for a solo cross country. The pilot was compensating for a crosswind when he landed the aircraft on its nose resulting in substantial damage to the aircraft.NTSB SEA86MA018Accident · 4 fatalMajor investigationFinal reportGates Learjet 24D · Juneau, AKDrg arrival to pick up a med-evac patient, the flt was clrd for an LDA-1 rwy 8 apch via the asort transition. Thus, the plt should have contd se on J-541 twd the ssr VORTAC & intercepted the localizer (LOC) at asort; then track inbnd on theloc (062 deg),…NTSB NYC86LA026Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Block Island, RIThe floatplane experienced a pwr loss about 15 miles south of martha's vineyard VOR. The eng manifold pressure dropped and the RPM became erratic. The plt attempted to restart the eng using primary and emergency fuel pumps but the eng would not restart. The…NTSB NYC86FA027Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Landisburg, PAThe non-instrument rated pilot took off on a VFR crosscounty flight with no weather briefing. He flew into an area of adverse weather including low clouds, fog, drizzle & haze. The aircraft impacted near the top of a 2100 ft high hill in forested terrain.NTSB FTW86LRG01Accident · No injuriesFinal reportBell 206B · Port O'Conner, TXThe acft rolled over after a forced lndg due to loss of power. The eng lost about 60 percent of its power during cruise at about 250 ft AGL. Post acc inspection showed that fuel line p/n 685481 b-nut had backed off the fuel control end of line 250C20 ipc. The…NTSB DEN86LA013Accident · No injuriesLimited investigationFinal reportCessna 170B · Coloradosprings, COThe pilot took off on runway 17. The wind was reported to be from 130 degrees at 10 knots. After liftoff the left wing rose abruptly and the aircraft veered to the right. The pilot stated that because of his low altitude he could not regain control of the…NTSB CHI86LA014Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Toronto, OHThe acft touched down hard and bounced during the student plts second solo landing of the day. Recovery was made by initiating a go around. The acft touched down hard and bounced again on the third landing. Directional control of the acft was lost and it…NTSB ATL86FLQ03Accident · Minor injuriesFinal reportPiper PA-28RT-201T · Hopkinsvile, KYThe acft had electrical failure during an IFR flt and radio/radar contact was lost. The plt said he was in & out of the clouds during the final stages or the x-country flt. The cloud ceiling was about 800 ft where he finally descended & landed in a soybean…NTSB ATL86FA010Accident · 1 fatalField investigationFinal reportPiper PA-34-220T · Hamilton, ALAt 1450 CDT, while the plt was cruising at 11,000', ARTCC broadcast info concerning SIGMET 17C, warning plts of thunder-storms with tops to FL 450. At 1613, radar data showed the acft at 11,300'. When asked about his alt, the plt replied he was in a cell &…NTSB LAX86LA022Accident · No injuriesLimited investigationFinal reportCessna 210M · Oakdale, CAThe plt said that he made a 'fairly rapid descent' from a 10,500 ft MSL cruise alt to the airport pattern and experienced a 'painful pressure' in his ears. The plt said he was also wearing a headset. On entry into the pattern, theplt said he 'forgot to lower…NTSB LAX86FUM01Accident · Minor injuriesFinal reportBell 47 G-5 · Yuma, AZThe pilot was hovering after a night takeoff and collided with an electrical power line.NTSB ATL86FA009Accident · 2 fatalField investigationFinal reportCessna 172N · Clayton, GAThe pilot and his passenger showed up for the second day in a row and checked the weather for the return trip to Florida. They found the weather VFR at the airport. An employee of the FBO took the pilot outside and pointed out that the mountains to the south…NTSB MIA86LA016Accident · No injuriesLimited investigationFinal reportHughes 269A · Marco Island, FLThe plt stated that while on a photographic flt the eng lost pwr & he autorotated the acft into the water. After the acft was recovered & returned to it's home base, the fuel system was drained & purged of all fluids, the magnetos were cleaned, reinstalled &…NTSB LAX86LA020Accident · No injuriesLimited investigationFinal reportPiper PA28-181 · Palo Alto, CAThe plt said that after landing and turning onto the parallel taxiway, the engine quit. During an attempted re-start, fire was noticed coming from the engine compartment. The plt and his passenger evacuated the acft, and arpt personnel put out the fire. The…NTSB FTW86LA021Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Amite, LAThe plt reported a loss of brake effectiveness while landing on a dew-covered sod strip. Unable to stop, the acft slid through a fence, damaging the wings.NTSB ATL86LMG02Accident · Serious injuriesFinal reportAeronca 11AC · Wallace, NCThe acft collided with the terrain following a loss of control during initial takeoff climb. The plt reported that after clearing trees at an alt of aprx 200 ft the acft drifted to the right. The tail of the acft then rose pushing the nose down until the acft…NTSB ATL86FKG03Accident · No injuriesFinal reportCessna 182P · Hawkinsville, GAThe acft caught fire during a forced lndg after losing eng power during cruise. The plt approached a hi-way for landing and smoke filled the cockpit. During rollout fire came thru the firewall and the plt evacuated the moving acft. The unoccupied acft…NTSB SEA86LA016Accident · Serious injuriesLimited investigationFinal reportPiper PA-20 · Ely, NVThe consensus of witnesses was that the plt & 2 pax had been awake all or most of the previous night & had consumed alcoholic beverages until at least 0100 PDT. One witness stated that the plt was 'cut off' from alcoholic drinks at 0100, but the 3 men…NTSB NYC86LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Teterboro, NJThe acft collided with a large bird while in cruise flt. The leading edge of the ry wing was damaged. The acft was landed without further incident.NTSB MIA86FA015Accident · Serious injuriesField investigationFinal reportBeech BE 35 · Zellwood, FLThe private pilot landed at a turf strip utilizing full flaps and 6 units of nose up trim. The pilot stated that when preparing for departure he was in a hurry to avoid inclement weather at his destination and did not utilize a check list he never re-trimmed…NTSB DEN86LA012Accident · No injuriesLimited investigationFinal reportBeech D50A · T/C, NMA person identifying himself as leon taylor, notified the FAA in albuquerque, n.m., that the twin-bonanza acft he was piloting, overran the improvised airstrip where he was attemptting to land & crashed. Mr taylor was never heard from again. The n.m. state…NTSB NYC86FA015Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Tobyhanna, PAAt about the time N4298K was departing pocono mountains mun icipal airport, recorded radar information from new york ARTCC displayed an aircraft in that area. The aircraft flew eastward and then northward. The aircraft disappeared from the radar screen about…NTSB MKC86LA014Accident · No injuriesLimited investigationFinal reportPitts S1C · Goodland, KSThe acft rolled forward unrestrained after the plt hand started the eng. A tie down tied to the tailwheel pulled free from the ground tie down eye used to restrain the acft during the hand start procedure. The acft rolled forward striking several objects. The…NTSB MIA86MA013Incident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-9-51 · Tampa, FLShortly after lift-off, the flt crew heard a loud noise (similar, but louder than a tire blow-out) as the #1 eng failed. They secured the #1 eng, remained in the traffic pattern & landed on the same rwy. After landing, an exam revealed the combustion chamber…NTSB LAX86LUG01Accident · No injuriesFinal reportTexas Helicopter M74A · Daggett, CAThe plt stated he had just lifted off for a fertilizer spreading operation with an external load bucket, when the eng had a partial pwr loss at 100 ft AGL. A descent was started and the bucket was disengaged. However, while the plt was attempting to land the…NTSB LAX86LA019Accident · No injuriesLimited investigationFinal reportBeech 24R · San Diego, CAThe acft collided with a ditch during taxi to takeoff. The plt was taxiing into the sun and went into the ditch when the taxiway turned to the rt. The plt said he was blinded by the rising sun.NTSB LAX86LA018Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Turlock, CAThe acft made a forced lndg after a loss of power during a descent. The plt stated that the eng RPM decreased to 1100 with all other gauges in the green. He also said he could not get the fuel drain sumpt to drain as it was frozen shut during preflt. The plt…NTSB FTW86LA017Accident · Minor injuriesLimited investigationFinal reportCessna 310 · Tulsa, OKThe plt experienced fuel exhaustion while on final apch for landing on rwy 35L at Tulsa international arpt, OK. The acft undershot the rwy by 1/2 to 3/4 of a mile where it contacted railroad tracks.NTSB FTW86FRD01Accident · No injuriesFinal reportNorth American AT6G · Jennings, LAThe acft contacted a ditch and nosed down during an overrun landing. The acft was in a flt of 3 AT6'S landing at the arpt for a fly-in. N104DC touched down on the 2000 ft freshly mowed grass strip aprx 500 to 600 ft from the end. The plt stated the…NTSB FTW86FRA01Accident · Minor injuriesFinal reportCessna 172 M · Houston, TXThe acft made a forced landing on a golf course and nosed over after the engine quit during takeoff. Post accident investigation revealed that the gascolator was full of water and the carburetor contained 25 percent water. No other discrepancies in equipment…NTSB DCA86AA001Accident · Serious injuriesFinal reportVickers Viscount VC-810 · Bloomington, INDrg an ILS to rwy 35, the apch was normal until the acft was aprx 100' abv the decision height, except there was condensation on the windshield. Touchdown was hard. A witness said the acft lndd aprx 1/3 of the way down the 5200' rwy. After lndg, with the…NTSB CHI86FA013Accident · 1 fatalField investigationFinal reportCessna 170A · Murphysboro, ILThe plt took off in marginal VMC in an acft placarded for 'day VFR only'. Aprx 32 minutes after takeoff the acft collided with trees and descended to ground impact. A hunter in the local area at the time of the accident reported hearing the acft eng sound…NTSB BFO86LA004Accident · No injuriesLimited investigationFinal reportStinson 108-1 Voyager · The Plains, VAWhile flying straight and level at 3100 feet MSL, over Virginia route 66 and route 245, the engine began to vibrate to the extent that the plt thought that it might separate from the airframe. The plt selected a field and set up an approach. On final, the plt…NTSB ATL86LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-201T · Chattanooga, TNThe aircraft lost total power during takeoff initial climb and attempted an forced landing in a shopping center parking lot. During the landing attempt the aircraft collided with a utility pole and slid inverted approximately 250 ft before coming to rest.…NTSB NYC86LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Columbia, PAThe acft collided with 6 ft high poles during an overrun landing. The plt stated he was making a landing and noted on short final that the airspeed was excessive. The rwy was grass was freshly cut, wet and slippery. The acft landed long and ran off the end of…