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 MIA88FA138Accident · Serious injuriesField investigationFinal reportBoeing 727-224 · Sarasota, FLThe captain of the Boeing 727 aircraft was aware that a refueler was utilizing known quantity refueling procedures due to an inoperative fuel guage. He allowed the flight engineer to activate the b hydraulic system and the ground interconnect switch, without…NTSB LAX88FA150Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Ukiah, CAThe pilot failed to maintain control of his aircraft. Contributing factors were the pilot's lack of recent IFR experience, spatial disorientation and his failure to perform remedial action.NTSB FTW88LA088Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Bonham, TXOne airplane was taxiing out for departure at the same time two others were coming in to land. The first airplane landed and did a 180 on the runway to taxi back to the parking area. This required the second airplane to go-around. The airplane taxiing in…NTSB FTW88LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Leona, TXThe plt planned his apch to land about 1000 ft down the 3400 ft dirt rwy because the first 1000 ft was wet and soft. The last 400 ft was also wet and soft. The wind was calm and the apch speed was high. During the flare, the acft ballooned and floated past…NTSB FTW88DRG08Accident · No injuriesFinal reportBoeing Stearman E-75 · Fisher, TXAfter touchdown, the pilot stated that he lost directional control and the right main gear ran off the right side of the runway. During attempted recovery, the airplane rolled off the left side of the runway, collided with a drainage ditch and nosed over to…NTSB DEN88FA090Accident · 4 fatalField investigationFinal reportBeech A36 · Colorado Spring, COAfter takeoff the acft failed to climb sufficiently to clear a utility pole one-half mile off the end of the runway. The acft collided with the pole and crashed in a residential street. The plt and three pax were fatally injured and the acft was consumed by…NTSB DCA88WA049Accident · No injuriesForeign investigationCessna CE-206 · Schwennigen, GermanyNTSB BFO88LA033Accident · No injuriesLimited investigationFinal reportCessna 150M · Chesterfield, VAThe student pilot lost directional control of the acft during landing roll. The acft traveled off the left side of the rwy and contacted a ditch. The landing was being made on rwy 15. Winds were from 190 degrees at 7 knots.NTSB ATL88FA136Accident · 7 fatalField investigationFinal reportPiper PA-32R-301T · Middlesboro, KYThe plt received preflt wx briefing that stated VFR flt was not recommended due to low pressure system affecting proposed flt path. Wx forecast included tornadoes, hail, thunderstorms to 42,000', moderate rime icing, moderate turbulence, wind gusts to 70 KTS,…NTSB NYC88LA124Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Warwick, NYDuring takeoff and landing practice, the aircraft veered left off of the runway despite reported full right rudder application by the pilot. The aircraft continued to roll across the grass and came to rest after colliding with a construction ditch.NTSB NYC88LA119Accident · Serious injuriesLimited investigationFinal reportStinson 108-1 · Poland, NYAfter several takeoffs in a southwesterly direction from a farm field, the student pilot attempted a takeoff downwind in an easterly direction and failed to clear the trees at the end of the field. The airplane crashed into the trees and terrain, and was…NTSB NYC88LA118Accident · No injuriesLimited investigationFinal reportCessna 150 · Downingtown, PADuring takeoff from shannon airport, the flight experienced an engine power loss and crashed. Pilot stated that water was found in the carburetor. The plt said after the acc that after the power loss he noticed powerlines and houses in front and made a sharp…NTSB MKC88LA073Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Cedar Rapids, IADuring a night cross country trip, PIC experienced a total power loss. An emergency ldg was attempted and the accident aircraft collided with the terrain. Post accident inspection revealed no mechanical or fuel starvation problems. The pilot reported that the…NTSB LAX88LA152Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lone Pine, CAAt the beginning of the flight, just after rotation, at approximately 10 feet AGL, the pilot retracted one notch of flaps. The aircraft settled to the runway and the pilot lost control and collided with the terrain. There were no mechanical failures or…NTSB LAX88LA151Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Palo Alto, CADuring a local flight in the pattern, the engine experienced a loss of power and a forced landing was made short of the runway. Inspection of the engine revealed that water was in the fuel pump bowl and rust was present on the cylinders.NTSB LAX88FA149Accident · Serious injuriesField investigationFinal reportCessna 152 · Chandler, AZNTSB LAX88DVA03Accident · No injuriesFinal reportCessna 188B · Gustine, CADuring an aerial application maneuver, at 70 ft. a.g.l., the engine lost all power. The pilot leveled the wings and dumped the remaining load. The engine regained full power, backfired, then lost power again. The aircraft collided with almond trees. An…NTSB FTW88LA086Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Grand Prairie, TXThe student pilot lost directional control on the takeoff ground run and the aircraft was damaged after it ran off the runway. The reported weather showed a 90 degree left crosswind at 12 knots velocity with gusts to 20 knots. The plt did not file an acc…NTSB FTW88DRA08Accident · No injuriesFinal reportGrumman G-164 · Palacios, TXThe plt stated that following a normal landing, he applied too much brake, causing the wheels to lock up. This, in turn, caused dead grass and mud to accumulate in front of the wheels. The acft subsequently flipped over and slid to a stop inverted.NTSB FTW88DPA03Accident · No injuriesFinal reportAir Tractor AT-502 · Olney, TXThe pilot was familiarizing himself with this type of aircraft and was making a full flap landing. He allowed the aircraft to drift left during the landing roll in a slight crosswind. He then attempted to abort the landing roll with the application of takeoff…NTSB DEN88FA091Accident · No injuriesField investigationFinal reportAerospatiale SA316B · Silver Plume, CONTSB DEN88FA089Accident · 2 fatalField investigationFinal reportBurkhart Grob G103A · Boulder, CONTSB CHI88FA090Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Quincy, ILDescent below the dh by the pilot in command during an instrument approach into known adverse weather rather then proceeding to a suitable alternate destination.NTSB ATL88LA130Accident · No injuriesLimited investigationFinal reportBeech A-36 · Nashville, TNThe pilot aborted a takeoff after he felt that the aircraft was not performing properly. The pilot had four passengers on board which put the aircraft near its gross weight. The runway was 4300 feet long and the pilot needed about 1100 feet of runway for the…NTSB ATL88LA129Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Stockbridge, GAThe airplane landed with the left wheel locked, and subsequently nosed over during the ldg roll. Post-crash exam revealed that the left wheel could not be rotated in the fwd direction by hand, and that it could be rotated aft by hand only with considerable…NTSB NYC88LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R · Manchester, NHA flight to burlington, Vermont was uneventful. While on the ground at burlington the aircraft was serviced; then the flight was continued. After about one hour of flight, high engine temperature and low oil pressure was experienced and the aircraft landed at…NTSB MKC88FA072Accident · 1 fatalField investigationFinal reportBeech H18 · Kansas City, MOThe cargo flt dptd cincinnati enrt to wichita, KS with an intermediate stop at Kansas City dtwn arpt. The flt progressed nrmly to a VOR rwy 03 instrument apch, circling to rwy 01. The PIC had been clrd to commence the apch. Twr pers subsequently advised the…NTSB MKC88FA070Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Springfield, MOWhile enroute to a vehicle accident the pilot encountered instrument flight conditions. As a result of flying into fog and turning on his night scanner light, the pilot experienced spatial disorientation and failed to maintain aircraft control. The pilot…NTSB MIA88LA137Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wayside, MSWhile on an aerial application flt on short final, the plt pulled the throttle lever to reduce airspeed but it broke at the power control quadrant. The apch was continued & after acft traveled aprx 1/2 the length of the rwy, he turned the magneto switch off.…NTSB LAX88LA155Accident · No injuriesLimited investigationFinal reportCessna 182RG · Davis, CANTSB LAX88LA147Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Apple Valley, CADrg a flt from hawthorne to delano, CA, the plt became lost, saw an arpt & landed. After landing, she learned she was at the depue arpt, lenwood, CA. No fuel was available, so she elected to fly to Apple Valley, a distance of about 17 mi. However, before…NTSB LAX88FA146Accident · 1 fatalField investigationFinal reportCessna 172N · Saticoy, CAA certificated private pilot and his instructor, conducting training in a 172P, were turning left to a southeasterly heading at 3,400 feet MSL, near an uncontrolled airport. A Cessna 172N on a pleasure flight in the vicinity was climbing on a southwesterly…NTSB FTW88FA085Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Henrietta, TXThe plt was given a pre-flt wx briefing by a fss briefer. He rcvd a full & thorough briefing, except the briefer did not have an opnl wx radar set available. The plt was adzd of a line of thunderstorms (tstms) to the southwest, moving east at 20 KTS. He was…NTSB ATL88LA128Accident · No injuriesLimited investigationFinal reportBeech B19 · Albany, KYThe plt reported that he touched down about midfield on the 1,800 ft usable portion of the rwy. A light rain was falling at the time, and the rwy was wet. Braking action was poor, and the airplane subsequently overran the runway. The airplane traveled down an…NTSB ATL88LA127Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Guntersville, ALThe seaplane collided with the water shortly after takeoff. The plt rptd that a large spider dropped in front of him and distracted him. The airplane was in a gradual right turn about 100 ft above the water at the time. He attempted to swat the spider with…NTSB ATL88LA126Accident · No injuriesLimited investigationFinal reportCessna 152 · Charleston, SCThe student plt rptd that the airplane was low on final appch, and that he applied pwr to maintain altitude. After crossing the rwy threshold, he reduced the pwr to idle & lowered the nose to maintain airspeed. He initiated a flare prior to touchdown, but the…NTSB ATL88FA131Accident · 1 fatalField investigationFinal reportMooney M20G · Jasper, GABefore depg blairsville, the plt reqd the current atlanta wx for the dekalb-peachtree arpt & for an afternoon outlook. He told the briefer that he had received a previous wx briefing. He was informed that the forecast was for instrument conds until noon with…NTSB MIA88WA136Accident · No injuriesForeign investigationBeech D18S · St Maarten Isl., British Virgin IslandsNTSB MIA88LA143Accident · No injuriesLimited investigationFinal reportCessna 152 · San Juan, PRThe student plt completed 5 touch & go's with his instructor before dropping her off for first supervised solo flight. On the first touch & go landing , the acft bounced after touchdown on the main landing gear. The student plt added power, lowered the nose…NTSB LAX88FA144Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Torrance, CAJust after takeoff, the plt noticed that the airspeed indicator was inoperative. The plt notified the tower that he was returning for landing and stated the problem. During the turn from base to final approach, the pilot overshot both the right and left rwys.…NTSB FTW88FA084Accident · 1 fatalField investigationFinal reportCessna 172M · Hope, ARThe non-instrument rated pilot initiated the flight into known adverse weather after being advised during a preflight weather briefing that VFR flight was not recommended. About 40 minutes before the crash, he called el dorado (Arkansas) radio and requested…NTSB CHI88FA087Accident · 2 fatalField investigationFinal reportBeech 35-C33A · Onamia, MNPilot's poor judgement in continuing VFR flight into IMC conditions, and his subsequent disorientation and failure to maintain aircraft control.NTSB MIA88LA135Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Captiva, FLThe pilot allowed the aircraft to descend below the normal approach angle and failed to correct the situation timely. The aircraft struck a seawall severing first the nose gear and then the main gear. The aircraft slid to a stop.NTSB MIA88LA133Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · St Petersburg, FLThe acft was climbing thru 1600 ft when the upper half of the main entry door opened & separated from the acft. The physician plt stated that he was reasonably sure that he had secured the door prior to departure. He stated that although the cabin had not yet…NTSB MIA88FA134Accident · Minor injuriesField investigationFinal reportBellanca 17-30 · Daytona Beach, FLThe plt stated that he had filled the main tanks and nearly filled the two aux tanks earlier and had flown for about 1 hr using one of the aux tanks for cruise. He had just taken off using the mains & when he leveled at 2600 ft, he switched to one of the aux…NTSB DCA88IA044Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Boston, MAThe improper installation of the battery ground connection that resulted in premature loosening of the connection and electrical arc ignition of pooled fuel in the cac bilge. The fuel was not drained overboard due to inoperative cac bilge area drain valves.…NTSB NYC88LA116Accident · No injuriesLimited investigationFinal reportBell 206L · Allentown, PADuring an FAA flight check an autorotational descent was made with a planned power recovery, the helicopter fell through the maneuver and collided with the ground. The main rotor blades flexed downward, striking the horizontal fin winglets and the tail boom.NTSB NYC88LA114Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Erie, PAThe pilot failed to maintain flying speed and the airplane settled back onto the runway and ran off the end.NTSB MIA88FA132Accident · No injuriesField investigationFinal reportSwearingen SA-227-TT · Miami, FLThe plt stated that during his attempt to taxi around N30042, he thought he had enough clearance to get by, but misjudged the distance & the rudder of the merlin acft was struck by the DC6B'S left wing tip.NTSB LAX88LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Payson, AZThe pilot reported that during the landing roll a dust devil (whirlwind) pushed the aircraft off the runway, colliding with the terrain resulting in substantial damage. The pilot reported that the wind velocity was 25 knots gusting to 30 as a quartering…