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 SEA86LA094Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Aberdeen, IDThe student plt was attempting to land on rwy 25 with a light x-wind form 040 degs at 5 KTS. The plt allowed the acft to drift to the left of the narrow rwy. As full pwr was added in an attempt to go-around, the acft struck the ground, veered left through a…NTSB MIA86LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Umatilla, FLThe plt reported that he flared the acft too high while landing. The acft stalled too soon and a hard landing resulted.NTSB MIA86FA113Accident · Serious injuriesField investigationFinal reportBeech 65-90 · Fort Pierce, FLFlt experienced loss of power in both engines due to fuel starvation. The pilots failed to operate fuel transfer switches to transfer fuel from the wing tanks into the nacelle tanks which feed the engines. The pilot in command had 16 total hours in the king…NTSB FTW86FA060Accident · No injuriesField investigationFinal reportDouglas DC-3C · El Paso, TXThe pilot reported that he was leveling off from climb when he experienced a prop runaway. He observed oil streaming from the left engine, but could not feather. Unable to maintain altitude with a windmilling prop, he performed a gear up emergency landing in…NTSB DEN86LA110Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Falcon, COThe plt stated the acft contacted a powerline pole during a go-around. The powerline pole is located aprx one-half mile off the departure end of rwy 33. According to the plt, the pole is unmarked and unlighted. The accident occurred during night hrs with no…NTSB CHI86LA116Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Seneca, ILThe plt was landing on a 2300 ft rwy with a 80 degree x-wind. The acft bounced hard on touchdown and the plt attempted a go-around with 25 degrees of flaps extended. The airspeed was deteriorating so the plt elected to re-land. During the roll-out the acft…NTSB CHI86FEM04Accident · No injuriesFinal reportPerkins Viking Dragonfly · Lansing, MIOn his first flight in this type of homebuilt the pilot encountered what he said was windshear on final approach for his first landing. He added power and the aircraft pitched up 30 degrees. He pushed down on the stick and the aircraft pitched down violently.…NTSB ANC86LA043Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Fairbanks, AKThe pilot stated that during the takeoff on a public road the aircraft struck the road side with the right wing.NTSB SEA86FA092Accident · 4 fatalField investigationFinal reportCessna 172P · Seattle, WAN99034 departed kenmore air harbor on a short local solo flight. Witnesses reported observing the aircraft takeoff and initiate a climb to the south. N65783 was returning from a recurrency check flight and was approaching from a southerly direction in a climb…NTSB NYC86LA100Accident · No injuriesLimited investigationFinal reportAerospatiale SA316B · Pittsburgh, PAThe pilot-in-command lifted off the helipad vertically to an altitude of 30 feet at which time he experienced a power loss. He backed up the helicopter 20 feet and allowed it to yaw to the right as it descended to the helipad. He landed on the helipad hard…NTSB NYC86LA099Accident · No injuriesLimited investigationFinal reportSikorsky S-76 · Safe Harbor, PAThe helicopter was maneuvering at low altitude, low airspeed, while on a search and rescue mission at night, looking for a capsized boat, when it impacted the water.NTSB MKC86FA080Accident · Serious injuriesField investigationFinal reportCessna 150F · Hannibal, MOThe student plt was attempting to land with a right crosswind component in excess of 15 knots. He used a crab angle on final but as the acft apch the rwy he applied rudder. He said, with full rudder the acft was still not aligned with the rwy and he decided…NTSB LAX86LA168Accident · No injuriesLimited investigationFinal reportCessna 140 · Palo Alto, CAThe purpose of the dual instructional flight was for the instructor pilot to check out a private pilot in the conventional gear Cessna 140 aircraft. After a series of uneventful full stop & touch & go landings, the student was directed to land. The CFI & a…NTSB LAX86DVA05Accident · No injuriesFinal reportGrumman G164A · Snelling, CAThe plt stated he had just lifted off during takeoff when the eng quit. The acft then stalled, hitting a canal and shearing off the main landing gear. The plt stated that a broken fuel line is suspect due to the sudden stoppage and intense ground fire. The…NTSB FTW86MA058Accident · 7 fatalMajor investigationFinal reportIsrael Aircraft Industries 1124A · Redwater, TXAirplane crashed during a uncontrolled descent, following a turbulence upset at FL370. The upset occurred as a result of clr air turb associated with a vip lvl 6 thunderstorm located within 7 miles of the last pos of the airplane. After the upset, the…NTSB FTW86LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Springtown, TXThe pilot reported colliding with a fence at the end of the runway when he landed short while on final approach into kezer airport near Springtown, TX. His aircraft sustained substanial damage to the left wing, nose gear and propeller after travelling 200 ft.…NTSB FTW86FA059Accident · 1 fatalField investigationFinal reportBeech 65 · Montague, TXThe pilot was observed in the area for several minutes while he was performing steep climbs and descents, low passes, and buzzing. Witnesses reported power was removed from both engines simultaneously, as if the throttles were retarded, followed by a loud…NTSB CHI86LA118Accident · No injuriesLimited investigationFinal reportCessna 411 · Bloomington, INThe plt rprtd that while while on final apch to rwy 35, the acft encountered 'extreme wind-shift' & was blown about 550' rgt of course with a 30 kt loss of airspeed (fm 130 to 100 KTS). He stated the acft lost about 300', then was blown back on course with an…NTSB ATL86LA106Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Hamilton, OHThe plt made a low pass over the drag strip to check the wind. He climbed, made a 180 deg turn and attempted a normal landing. On roll out a wind gust was encountered which tipped the acft up on the right wheel. It veered off the hard surface into a guard…NTSB ATL86LA105Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Moultrie, GAA deputy sheriff rented an acft to assist the sheriff's dept with a ground search for an escaped prisoner. Witnesses observed the acft flying low and slow over the area when it made a partial turn and pitch down into the trees. There were no indications of…NTSB MKC86LA079Accident · No injuriesLimited investigationFinal reportCessna 172 · Ness City, KSThe pilot was landing to the north with a wind from the west-northwest at 15 knots, gusting to 20 knots. The pilot stated that he had full aileron into the wind and despite this action, the wing raised up by a strong gust and airplane flipped over to the…NTSB MIA86LA111Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Boca Raton, FLThe flt experienced a failure of the acft's eng while flying parallel to the beach and the acft was ditched in the atlantic ocean. Inspection of the acft after recovery revealed the foam air cleaner had been drawn into the carburetor air box and was blocking…NTSB MIA86FA112Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Homestead, FLThe flt was nearing completion of a 4.2 hr x-country flt & was aprx 7 miles from the dest when both engs quit due to fuel exhaustion. A forced ldg was performed. The plt stated the acft had departed with a full fuel load of 182 gals. The acft owner stated…NTSB MIA86FA110Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Ocklawaha, FLThe pvt plt refueled his acft the night before the flt and was observed to drain only the firewall strainer. The morning of the flt he did not drain any drains. About half way to his destination an eng pwr loss was experienced, he declared an emergency and…NTSB LAX86LA165Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Novato, CAA PA-38 lost directional control during a takeoff with both the student and instructor pilot at the controls. The aircraft sustained substantial damage but both pilots were uninjured. The wind was 90 degrees crosswind at 10 knots gusting to 15 knots. The…NTSB FTW86LA057Accident · No injuriesLimited investigationFinal reportCessna 185F · Point Aufer, LAThe pilot reported losing control of his aircraft, during takeoff from a canal at Point Aufer island, LA, when gusty wind conditions lifted a wing, causing the aircraft to collide with a bank. After the collision, the aircraft continued up onto the canal…NTSB LAX86LA164Accident · No injuriesLimited investigationFinal reportCessna 150H · Tucson, AZThe pilot stated that after lowering the nosewheel during the landing, he heard a 'popping sound' and immediately raised the nosewheel off the runway. After the aircraft slowed and the pilot could no longer hold the nosewheel off, the aircraft veered to the…NTSB LAX86LA163Accident · No injuriesLimited investigationFinal reportCessna 150M · Glendale, AZThe student's CFI said that a dual session was flown earlier in the morning and that the accident session was the student's first supervised solo. The CFI said that on the first landing of the accident flight, the aircraft touched down on the left main gear…NTSB LAX86LA150Accident · No injuriesLimited investigationFinal reportCessna 172M · Rosamond, CAThe plt reported that he successfully touched down during conditions of a right, 90 deg. Crosswind. The plt stated that a gust was then encountered which 'weather cocked' his acft. As he attempted to realign the acft with the rwy the downwind wing contacted…NTSB CHI86IA115Incident · No injuriesIncident investigationFinal reportBoeing 757-251 · Minneapolis, MNN508US was operating as nwa flt 150. The captain stated after the incident that the flt was uneventful until landing. Upon landing and spoiler deployment, the acft pitched up abruptly, to an attitude of 10 degrees. The landing was completed without incident.…NTSB ATL86LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNDuring landing roll the student pilot lost directional control of the aircraft and collided with a tree adjacent to the runway.NTSB ANC86LA042Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Anchorage, AKThe student helicopter pilot stated that the helicopter nosed over and rolled to the right during the hover. The pilot encountered a roll to the right due to low rotor RPM.NTSB NYC86FNC02Accident · Serious injuriesFinal reportPiper PA-11 · Brewer, METhe plt had been using auto gas in this acft, however, he experienced water contamination problems and discontinued its use. He then found himself at an arpt needing fuel. The arpt only had auto gas available so the plt refueled the acft with auto gas. While…NTSB MKC86LA078Accident · No injuriesLimited investigationFinal reportCessna 172 · Ava, MOThe plt reports that the eng began to run rough and lose RPM while the acft was cruising at 2500 ft. he said he attempted emerg proc but the loss of RPM continued and he decided on an off-arpt landing. During the apch to the landing area the eng RPM dropped…NTSB LAX86LA162Accident · No injuriesLimited investigationFinal reportCessna 182J · Saint Johns, AZThe plt said his wx briefing indcd VFR conds along the route with ocnl thunderstorm (tstm) activity that might require diversion. As he was apchg the st Johns arpt, the plt saw tstms & ovrcst clds ahead & decided to land & wait for the wx to improve. The…NTSB LAX86FJA01Accident · No injuriesFinal reportSchweizer 2-32 · Dillingham Fld, HIThe glider collided with a power line as the plt maneuvered down a valley to recover some airspeed that had been lost along a ridgeline. The vertical fin and rudder were damaged along the top 18 inches but the acft was landed without further incident.NTSB DCA86RA023Accident · 4 fatalForeign investigationBoeing 727-231 · Athens, GreeceNTSB CHI86FEC02Accident · Minor injuriesFinal reportCessna T210M · Highland, MIThe aircraft was in cruise when the engine started sputtering. According to the pilot, he switched tanks and the engine would start to run then miss, start to run then-miss, over and over again. The pilot stated that while this was happening he was losing…NTSB MKC86FPG02Accident · Serious injuriesFinal reportCessna 150H · Lonoke, ARAfter the plt changed a tire & performed maintenance on the carb heat control, he elected to reposition the acft to adams field at little rock, AR. Shortly after lifting off from his private strip, the acft crashed. There was virtually no movement after it…NTSB FTW86LA056Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · West, TXThe pilot reported having an engine failure at 2,500 feet while enroute to dallas, TX from mcallen, TX. He was unable to restart the engine and had to make an emergency landing in a field three miles West of West, TX. The aircraft received substantial damage…NTSB CHI86FEC01Accident · Minor injuriesFinal reportTaylorcraft BC12-D · Leslie, MIThe acft was damaged during a forced lndg following a loss of power after a low pass over an off arpt intended landing area. The plt was overflying a field belonging to a friend in preparation for a possible landing when a loud clunk was heard from the eng…NTSB SEA86LA091Accident · No injuriesLimited investigationFinal reportCessna T210C · Boise, IDWhile attempting to land on a parallel runway, the aircraft encountered wake turbulence from a landing transport aircraft. The aircraft rolled and struck the ground hard. A successful go around was then made with an uneventful landing. The pilot was aware of…NTSB SEA86LA090Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Fallon, NVWhile on final apch to the arpt, the acft's eng ceased operating due to fuel exhaustion. The acft was damaged during a hard forced landing on a baseball fld.NTSB SEA86LA088Accident · Minor injuriesLimited investigationFinal reportBeech E-35 · Couger, WAWhile at cruise, the pilot intentionally ran one fuel tank dry. When the pilot attempted a restart by use of the wobble pump, the aircraft's engine would not start. The pilot made a forced landing into trees for lack of a more suitable landing site. The…NTSB NYC86FA096Accident · 5 fatalField investigationFinal reportPiper PA-24-180 · Somers, CTThe acft, on a night flt, was seen flying about 1 mi west of ellington arpt. A witness saw the acft flying north and just above the 800 ft high terrain. The acft was in a gradual descent and it appeared that it would not clear terrain ahead. Afterwards the…NTSB MKC86FA077Accident · 1 fatalField investigationFinal reportDonald R. Casper Skyote · St. Louis, MOThe pilot built the homebuilt airplane from data obtained from skyote aeromarine ltd. at the time of the accident, the airplane had 51 hours on it and the pilot/builder had flown all of the 51 hours. On this flight he was observed to depart on runway 16, fly…NTSB LAX86MA161Incident · No injuriesMajor investigationFinal reportBoeing 767-222 · San Fransisco, CAWhile climbing through 3000 feet AGL, during the initial climb phase of the flight, both engines flamed out. The crew was able to restart both engines and return to the airport of departure for an uneventful landing.NTSB LAX86LA159Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Pheonix, AZThe Balloon collided with the terrain during a sight seeing tour. The plt noticed the dust signature of ground turbulent wx phenomena known as rotors or dust devils arpx 3 miles ahead. He elected to make an immediate precautionary landing and descended to an…NTSB LAX86LA157Accident · No injuriesLimited investigationFinal reportCessna 310D · Yermo, CAThe acft collided with rough terrain after an eng failure on takeoff from a private dirt airstrip. The plt indicated that the left eng failed just after liftoff. The acft yawed uncontrolled to the left and drifted off the 30 ft wide strip. The plt aborted the…NTSB FTW86LA055Accident · No injuriesLimited investigationFinal reportCessna 172H · Bristow, OKThe pilot reported encountering strong gusty winds while taxiing for departure at jones memorial airport, Bristow, OK. As a result his aircraft was flipped upside down and substantially damaged. The pilot was not injured.