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 MKC88LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Storm Lake, IAWhile practicing an approach to lndg stall, the stu plt stated that the eng failed to respond to throttle advancement. After unsuccessfully attempting emergency procs to include carb heat, fuel pump, and switching fuel tanks, he selected a fld. Prior to t/d,…NTSB MKC88FA003Accident · Serious injuriesField investigationFinal reportStinson 108-2 · Wakeeney, KSThe owner & his son, who were both plts, initiated a midfield takeoff from their pvt dirt airstrip which was on soft uneven terrain. The son rprtd that near the end of the strip, power was 'cut.' The acft contd about 200' beyond the dep end of the strip &…NTSB MIA88LA010Accident · Serious injuriesLimited investigationFinal reportBeech A-90 · Ft Lauderdale, FLAfter the plt placed the master switch on to start the engines the landing gear collapsed. He stated that the passenger, in the co-plt seat, bumped the landing gear handle into the up position. The passenger stated that he did not. Insp of the acft revealed…NTSB MIA88FA009Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · St. ThomasAfter departure, aprx 3 miles west of the arpt at St. Thomas, the plt reported to the tower that the flt was returning to land due to a loss of power from the left eng. He secured it, returned to land, & on short final, positioned the landing gear selector…NTSB MIA88FA007Accident · 2 fatalField investigationFinal reportRockwell 700 · Pompano Beach, FLWitnesses stated that just after takeoff, the left engine started to leave a trail of white smoke, the acft then turned left back towards the arpt & crashed into the street. Post crash examination revealed one of the left engine crankshaft counterweights…NTSB LAX88LA013Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Guam (Pacific Ocean)The pilot experienced a loss of engine power at 1500 feet MSL while on a flight in the marianas islands from saipan to Guam. The aircraft was ditched in ocean waters about 2 miles north of Guam and was not recovered. The occupants were rescued by a U.S. Navy…NTSB DEN88LA009Accident · No injuriesLimited investigationFinal reportCessna A185F · Glasgow, MTThe plt reported that he was landing on rwy 12 with the winds, as reported by UNICOM, 100 deg at 10 KTS. He said that shortly after touchdown the acft was hit by a strong gust from the rt. The rt wing lifted, the lt wing hit the ground, and the acft nosed…NTSB DEN88LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lordsburg, NMThe pilot said that he reduced the throttle during the descent to traffic pattern alt at the dusty acres arpt and when he pushed the throttle in, the throttle cable broke. The eng went to idle power and quit. The pilot executed an emergency landing on a…NTSB ATL88FA010Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Greenville, SCThe plts trip home had been delayed one day due to wx enrt. He had called the fss early for a briefing and had been advised that there should be no trouble for a noon depart time. He deptd clemson about 1000 and activated his VFR flt plan. He then contacted…NTSB ANC88LA007Accident · No injuriesLimited investigationFinal reportCessna 170 · King Salmon, AKThe plt rprtd there was frost on the acft & that a rope had been used to smooth it off. He then initiated a takeoff from a dry lake bed. After lift-off, the acft settled back to the ground & struck a berm at the end of the takeoff area.NTSB SEA88LA005Accident · No injuriesLimited investigationFinal reportCessna 340A · Tacoma, WAAs the plt was taxiing to the active rwy, the acft's right brake became inop due to a loss of hydraulic fluid. Subsequently, the acft went off the side of the taxiway, contd over an embankment & was damaged. The loss of hydraulic fluid was due to a leak in…NTSB NYC88LA008Accident · 1 fatalLimited investigationFinal reportBeech F-33A · Concord, NHThe plt obtained a telephone wx briefing then filed an IFR flt plan for a 1030 EDT departure fm Concord municipal airport. The plt rptd off Concord at 800 ft and climbing at 1047. Manchester departure control acknowledged, assigned a transponder code, and…NTSB LAX88LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Porterville, CADuring a normal descent, the engine lost all power. The pilot executed an emergency descent and force landed in a field. An examination of the aircraft wreckage revealed that there was no fuel in the fuel tanks. During a telephone interview, the pilot stated…NTSB LAX88FA014Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Mount Baldy, CABfr tkof, the plt filed a VFR flt plan & rcvd a wx briefing which included an AIRMET. The AIRMET contained precautionaryinfo abt instrument conds (IMC), icing & mtn obscuration in calif. When the plt opened his flt plan with the fss, he wasagain briefed on…NTSB FTW88DQG01Accident · No injuriesFinal reportBoeing A75N1 · Fort Stockton, TXThe pilot stated that during the flare for a full stall landing in the tail wheel equipped aircraft, a whirlwind was encountered. He said he applied full power & full left aileron & rudder, but could not recover. Subsequently, the aircraft struck an…NTSB DEN88LA007Accident · Serious injuriesLimited investigationFinal reportAerostar S-66A · Albuquerque, NMUpon landing, the balloon touched down on a gravel road and bounced over a small depression. The basket struck a small mound and threw three of the six passengers against the rail of the basket. The other passengers fell against them and the three were…NTSB CHI88LA004Accident · No injuriesLimited investigationFinal reportCessna 150H · Elroy, WIUpon attempting his tenth touch and go the student pilot noticed, prior to touchdown, that the aircraft was to the right of the runway. In an attempt to realign himself with the runway the pilot stated he 'lowered' the left wing. The left wing then struck the…NTSB ATL88DMG01Accident · 1 fatalFinal reportRogers-Gibson 1 · Bennettsville, SCThe homebuilt aerobatic airplane impacted flat terrain adjacent to the rwy shortly after takeoff. A pilot/witness who was in the arpt terminal lobby at the time rptd that he briefly observed the airplane pass by the terminal at a low level in a near…NTSB ATL88DKG05Accident · No injuriesFinal reportAmerican Falcon XP · Palmetto, GAThe pilot failed to properly flare the aircraft during a normal landing which resulted in a hard landing. The nose gear assembly failed from overload, and the pilot was not able to control the aircraft as it slid over the ground. The aircraft collided with a…NTSB NYC88LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Weston, MADrg a night arrival, when the acft was apchg the boston tca, the plt dscndd to 1000 ft. as he was leveling off, he noted a power loss & was unable to reach the destn arpt. He identified a field & initiated an emerg landing. Drg the apch, the acft struck power…NTSB MIA88FA006Accident · 1 fatalField investigationFinal reportRobinson R-22-B · Plymouth, FLThe private pilot, with an expired medical certificate and a license restricted to no carriage of passengers, took off and experienced an engine failure for undetermined causes. He did not execute an autorotation and the aircraft crashed. The pilot had also…NTSB LAX88LA011Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · San Luis Obispo, CAThe non-instrument rated pilot became disoriented when he inadvertently flew into a layer of fog while making an enroute descent for landing at his destination. The aircraft collided with trees while the pilot was attempting to execute a climbing course…NTSB FTW88DRG01Accident · No injuriesFinal reportNorth American P82-B · Harlingen, TXThe aircraft was engaged in a demonstration flight with the confederate air force at rio grande valley international airport. During the approach to runway 17L the pilot flared the aircraft too high resulting in a stall and an excessive rate of descent. At…NTSB BFO88LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Dares Beach, MDThe plt stated that after climbing about 2000' & proceeding aprx 3 to 4 mi out over the chesapeake bay, the oil temp began to rise & the oil pressure decreased. He turned toward land, but the eng lost power. Subsequently, he was forced to land in a swampy…NTSB BFO88DIG01Accident · Minor injuriesFinal reportCessna 177A · Stevensville, MDWhile practicing touch-and-go landings, the student plt made an approach at a higher than normal airspeed. Subsequently,the acft bounced three times on the runway before the plt elected to go around. The student stated that control was lost on the go-around…NTSB ATL88LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Cumming, GAThe student pilot was attempting to land on the 1550 foot runway. The aircraft touched down hard and bounced. The pilot pushed forward on the control column and the aircraft came down on the nose gear which collapsed.NTSB ANC88LA005Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Skwentna, AKThe acft collided with a tree stump during a short field landing. The plt stated that the stump was hidden by tall grass. No official information is published abt the johnson airstrip.NTSB MKC88LA006Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Creve Coeur, MOWhile practicing stop and go ldgs, plt lost control during rollout. Acft swerved and entered an inadvertent ground loop. The right main landing gear failed and the right lower wing contacted the ground.NTSB LAX88LA010Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · San Jose, CAThe pilot stated that during the landing roll he was distracted and looked downward. He said that when he looked back up the ground loop had started and it was too late to correct it. He did not report any mechanical problems prior to the accident.NTSB LAX88IA009Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Ontario, CAFailure of the general aviation aircraft to visually identify the transport aircraft. Factures contributing to the incident were: failure of the general aviaiton aircraft to establish communications with ATC prior to entering the arsa and maintaining a poor…NTSB FTW88LA002Accident · No injuriesLimited investigationFinal reportMooney M-20-J · Kerrville, TXAcft was substantially damaged when it collided with a road sign and the grnd during an off arpt emergency lndg following a complete eng failure during descent. Plt stated that about 20 mins out from his dest, the oil press decreased into the yellow arc, but…NTSB DEN88LA006Accident · No injuriesLimited investigationFinal reportCessna 182P · Monument Valley, UTThe private pilot was landing on a dirt runway and at touchdown a crosswind weathervaned the aircraft to the right. The pilot added full power to try to go around but the aircraft settled back to the ground left of the runway. The aircraft came to rest 300…NTSB BFO88FA002Accident · 1 fatalField investigationFinal reportCessna 172N · Lowmoor, VAThe acft was involved in powerline patrol over mountainous terrain at low altitude. The plt made a climbing right turn to avoid a ridge and went into a valley where he was boxed in by two ridges. He unsuccessfully tried to outclimb one of the ridges before he…NTSB ATL88LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sebring, OHWhile on final appch to land, a fire broke out in the airplane engine compartment. The commercial plt and his instructor evacuated the airplane after ldg and the airplane was destroyed by the fire. The acft was subsequently examined by an IA mechanic who…NTSB ATL88FA007Accident · 1 fatalField investigationFinal reportBeech HA-1 · Memphis, TNAfter t/o PIC was told by twr that tail stand, used to prevent acft from tipping on tail when loaded, was still attached to acft. PIC req teardrop turn back to departure rwy. Approach controller stated he saw mode c indication of 700'. A/p elev. Is 332'. Acft…NTSB SEA88LA004Accident · No injuriesLimited investigationFinal reportCessna 180C · Juneau, AKWhile landing onto a soft, sandy beach area the aircraft nosed over inverted. The plt failed to file an accident report.NTSB SEA88LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Canby, ORAt a reduced power setting, while maneuvering, a loss of power occurred. An inadvertent stall was then entered. The student pilot is legally deaf, but the stall warning system incorporated a red stall warning light. After the stall occurred the aircraft…NTSB MKC88LA011Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Warrensburg, MOThe plt indicated that on final app, when ovr the rwy threshold, he leveled the acft off at abt 10 ft and it dropped in. Subsequent inspection revealed that all four wing spars had longitudinal cracks. The plt had recently purchased the acft and had abt 14…NTSB LAX88LA008Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Fullerton, CADuring a pleasure flt, just after take-off, the acft was observed to climb out at an extremely high rate. The acft leveled off momentarily, and the left wing dropped. The acft began to descend and collided with the runway and two parked acft.NTSB FTW88LA003Accident · No injuriesLimited investigationFinal reportGrumman GA7 · Covington, LAThe pilot touched down with excessive speed, and due to the poor mechanical condition of the aircraft's brakes, was unable to stop before over-running the departure end of the runway. The aircraft's annual inspection was two months overdue. The pilot's…NTSB FTW88DRD01Accident · No injuriesFinal reportGrumman G-164A · Port Allen, LAThe pilot experienced a partial loss of power during pull-up from a swath run. He attempted to return to the field he was working in order to make an emergency landing but was unable to due to inadequate engine power. He landed in high vegetation and flipped…NTSB DEN88LA005Accident · Serious injuriesLimited investigationFinal reportRockwell 690B · Albuquerque, NMAcft was landing on rwy 17 at coronado airport, 9 NM n of Albuquerque, NM intl arpt. Plt said he brought props into reverse and acft went off right side of rwy. Plt brought props out of reverse, realigned acft on rwy, and reversed props again. Acft went off…NTSB ATL88LA006Accident · No injuriesLimited investigationFinal reportBeech H-18 · Sandersville, GAThe cockpit began to fill with smoke during initial climb after the plt raised the ldg gear. The plt returned to the arpt and made an emergency ldg. After evacuating the acft, the plt observed that the rt engine nacelle aft of the firewall was on fire.…NTSB ATL88LA005Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Collegedale, TNThe airplane touched down while the ldg gear were extending. A witness reported that the acft began the ldg flare with the gear completely retracted, and that the gear began to extend when the airplane was 3-4 ft above the rwy. The main ldg gear contacted the…NTSB SEA88LA002Accident · No injuriesLimited investigationFinal reportKlien Avid Flyer · Edwall, WAWhile on a VFR final apch for lndg, the plt was watching for pwr lines which had to be cleared & diverted his attention from his airspeed. After clearing the pwr lines, the acft stalled & crashed on a roadway. The acft was not equipped with a stall warning…NTSB SEA88LA001Accident · No injuriesLimited investigationFinal reportBritish Aerospace BA-3101 · Kennewick, WAWhile on a flight to pasco, WA. The pilot inadvertently landed at the Kennewick, WA. Vista airport, landed long, and overran the runway. The aircraft departed the end of the runway and impacted terrain.NTSB MIA88FA005Accident · 5 fatalField investigationFinal reportCessna 421B · Deland, FLThe acft was observed to be flying slowly, then roll steeply to the left and dive into an unoccupied house from about 300 ft shortly after takeoff. The plt had considerable flt time but he had not flown this model, except for a 35 min checkout that morning.…NTSB LAX88LA007Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Livermore, CAThe right engine ran rough during the initial climb phase of a personal flight. The pilot advised the tower controller of the aircrafts loss of power and entered the downwind leg of the traffic pattern for landing. The pilot stated that the aircraft was…NTSB FTW88LA004Accident · No injuriesLimited investigationFinal reportCessna L-19 · San Marcos, TXOn touchdown the aircraft's left main tire was flat. Control was lost when the pilot attempted to taxi off the active runway. The aircraft slid off the runway into some grass causing substantial damage to the aircraft.NTSB FTW88DPJ01Accident · Serious injuriesFinal reportWard Cassutt 3M · Yukon, OKDuring initial climb the engine failed and the pilot was unable to get a restart. The pilot, who was also the builder of the aircraft, was aware that in certain attitudes the engine would fail due to fuel starvation and that by changing the aircraft attitude…