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 FTW85LA348Accident · 1 fatalLimited investigationFinal reportCessna A185F · Catahoula, LAThe plt took off from a bayou with inadequate distance to climb above the trees growing along each side before the bayou made an aprx 120-DEG right turn. In order to avoid collision with the trees the plt entered a steep banked right turn to follow the bayou.…NTSB CHI85LA376Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Eden Prairie, MNThe student landed on rwy 9R with tower winds reported from 150 degrees at 15 knots. During the landing roll in the tailwheel equipped acft, control was lost and the acft tipped up on its left wing and nose.NTSB CHI85LA374Accident · No injuriesLimited investigationFinal reportCessna T210N · Minocqua, WIThe PIC attempted to start the engine. The engine started but in about 3 seconds stopped. During a second start attempt a fire started in the engine compartment. The PIC thought he had extinguished the fire when flames were seen in the copilot pedal area. The…NTSB ATL85MA275Accident · 6 fatalMajor investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Eva, ALDrg an IFR arrival/dscnt, the plt stated he 'had to feather 1 eng, I have an oil leak & I'm just trying to dscnd . . .' He then said he was dscndg thru 5300'. As he contd the apch, he informed the controller he would be unable to go around since the hydr sys…NTSB NYC85LA234Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · East Swanzey, NHThe acft was preflighted & determined to have 10 qts of oil in the eng. While climbing thru about 1000 ft MSL after takeoff, the propeller RPM began rising to the redline. The plt reduced power & proceeded to make an emerg landing. During a turn toward the…NTSB MKC85LA214Accident · No injuriesLimited investigationFinal reportCessna 152 · Olathe, KSThe student plt lost directional control of the acft while practicing touch & go landings. Winds in the local area were reported by fss as being from 110 degs at 12 KTS, gusting to 17 KTS. The plt lost control of the acft during a landing roll, ran off the…NTSB LAX85IA396Incident · No injuriesIncident investigationFinal reportNorth American SNJ-4 · Reno, NVThe pilot experienced a 'severe vibration' and made an emergency landing during a heat race at the national championship air races. Subsequent examination revealed that a propeller blade pitch change bolt, p/n 53546, had failed, allowing one propeller blade…NTSB DEN85FA240Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Fort Collins, COThe plt was operating his acft under the rules of 14 CFR 135, I.e., a scheduled domestic cargo flt. He made a normal departure and climb en route to salt lake city, Utah. Normal communications and radar flt following was established with denver ARTCC.…NTSB MKC85FA213Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hoskins, NEThis accident occurred on a telephone cable patrl flt. The acft would normally fly along the route of the buried cable at 200 to 300 ft AGL. When construction activity was sighted the plt would first record the sighting on a portable tape recorder and then…NTSB MIA85FA251Accident · 1 fatalField investigationFinal reportJodel D-9 · Okeechobee, FLThe plt had flown only 4 has in the last 6 months in a Cessna 150 type acft & had never flown a Jodel 09 before. The plt boarded the acft, declined a cockpit check by the owner & made an immediate take off. The plt took off from the grass strip without…NTSB LAX85LA390Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Coalinga, CAThe pilot stated that he turned onto the final approach for landing on rwy 36 as the sun set on his unlighted ag strip. He said that he lost sight of the strip during the landing flare, and driftd of the right side of the runway into high vegetation. The drag…NTSB LAX85LA389Accident · No injuriesLimited investigationFinal reportCessna 150E · Apple Valley, CAWhile practicing stop and go takeoffs and landings, the solo student plt flared too high on the second landing and lost directional control. The plt applied power to negotiate a go around. The nose ptiched up and the acft stalled. The acft contacted the gnd…NTSB FTW85LA347Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Angleton, TXThe plt had descended to very low alt (10-15 feet above ground level) during VFR weather conditions while still several miles from his destination arpt and impacted an electrical power line. He made a precautionary landing and rendered first aid to his…NTSB DEN85LA239Accident · No injuriesLimited investigationFinal reportCessna T210L · Gallup, NMThe student plt was returning from a solo x-country flt. Prior to landing, he called the fss & was advised that the wind was from 190 deg & was gusty. As he landed on rwy 6, the acft veered to the left, went off the rwy, hit a rwy light & was damaged.NTSB CHI85LA373Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Irwin, OHAt an alt of aprx 20 ft AGL after takeoff, the #1 cylinder failed. A straight ahead landing was made in a corn field during which the acft was destroyed. The eng had under gone a major overhaul 197 hrs prior to this accident.NTSB ATL85LA274Accident · No injuriesLimited investigationFinal reportCessna 150G · Dalton, GADuring arrival, the student plt elected to land on a taxiway since the rwy was closed for constuction. He stated that he made a normal pattern, but was a little high on final apch. He reported that he flared about 20 ft above the taxiway, then the acft landed…NTSB ATL85LA273Accident · 1 fatalLimited investigationFinal reportCessna 404 · Hayesville, NCFisherman heard an aircraft overhead but did not see any sign of it in the night sky. Shortly thereafter they saw a flash and fire on the side of a mountain, then they heard the explosion. The sheriff was called and an investigation revealed a crashed…NTSB ANC85LAA05Accident · No injuriesFinal reportde Havilland DHC-3 · Cape Douglas, AKThe acft nosed over during a forced landing on a tundra following a loss of pwr. The plt reported he made a low pass over a downed acft on a beach and as he advanced the throttle, a rapid decrease in pwr occurred. The acft and eng were not recovered from the…NTSB SEA85LA210Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Winnemucca, NVThe student had recently purchased the acft. On 9/5/85, an instructor plt, who had delivered the acft to the Winnemucca arpt, gave the student a total of 0.4 hr dual instruction, which included 2 landings. The instructor then indorsed the student's log book…NTSB SEA85LA209Accident · No injuriesLimited investigationFinal reportCessna 180 · Issaquah, WAThe acft landed nose down short of the rwy during a forced landing following fuel starvation. Investigation disclosed the main fuel line was blocked by pieces of the primer valve piston 'o' ring which had deteriorated due to the continuouuse of automotive…NTSB MIA85LKG06Accident · Serious injuriesFinal reportCessna A188B · Bascom, FLThe acft collided with a pecan tree during a spray operation the plt said he should have been more attentive to the operation of the acft and the environment.NTSB LAX85LA388Accident · No injuriesLimited investigationFinal reportCessna 152 · Modesto, CAThe student plt reptd the final approach angle was too shallow. He added power and as the acft arrived over the threshold he reduced the power. The acft landed hard and bounced. When the acft became airborne the plt added power to execute a go-around. The…NTSB FTW85LA344Accident · 1 fatalLimited investigationFinal reportMooney M20J · Kraemer, LAAcft was descending from cruise alt when it entered a radar lvl 3 thunderstorm and control was lost during a night VFR flt. The acft impacted a swamp in a vertical attitude with the rt wing leading slightly. The lft wing was found about 10' south of the main…NTSB ANC85LA174Accident · No injuriesLimited investigationFinal reportCessna C-206 · Big River, AKThe pilot-in-command was attempting to taxi through shallow water to reach the takeoff point. As the airplane's floats came up on step a gust of wind from the left rear caused the airplane to weather vance and struck the streams bank. The stream was very…NTSB SEA85FA211Accident · 1 fatalField investigationFinal reportBell 206B · Emmett, IDNewly-licensed plt departed into mountainous terrain in thunderstrom conditions despite warnings from friends. The acft wreckagewas located two days later in rising terrain below power 11 miles from pt of departure. Investigation revealed high speed vertical…NTSB MKC85LA223Accident · No injuriesLimited investigationFinal reportBeech 58 · Greenfield, MOThe plt reports that he extended the landing gear and wing flaps at the same time and the landing gear circuit breaker tripped. The plt was not aware that the gear had not extended and the acft landed with the gear retracted.NTSB MIA85LA250Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa Locka, FLThe plt stated that while attempting a touch & go landing he lost control of the acft & landed in a muddy area on the north side of the rwy.NTSB MIA85LA249Accident · 2 fatalLimited investigationFinal reportPiper PA-28-160 · Key West, FLThe acft failed to arrive at its intended destination on a flt plan from ft. lauderdale FL. To Key West FL. Navy Key West apch was providing VFR flt following, radar & radiocontact was lost with the acft 20 NE of Key West. The whereabouts of the occupants are…NTSB MIA85FA248Accident · Minor injuriesField investigationFinal reportAero Commander 100 · Oak Hill, FLThe plt was making his first flt in his recently purchased acft. The plt stated that both fuel tanks were full prior to take-off. Approximately 20 mins after take-off, an attempt was made to switch from the right fuel tank to the left fuel tank. Seconds…NTSB FTW85LA345Accident · Serious injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Caddo Mills, TXThe CFI PIC stated the eng lost power with the acft about 400 to 500 ft AGL. He couldn't return to the arpt due to lack of altitude. He elected to land in the plowed field. The acft touched down and flipped inverted. The air induction duct was found…NTSB CHI85IA369Incident · No injuriesIncident investigationFinal reportFokker F27-500 · Chicago, ILAt about the time full power was obtained the heard a loud bang followed by a fire warning for the left engine. The takeoff was aborted and the crew shut down the engine. The passengers were deplaned on the taxiway after it was determined the fire was out &…NTSB ATL85FA272Accident · Serious injuriesField investigationFinal reportMBB BK-117A-1 · Aiken, SCPlt was maneuvering helicopter at low alt and into rising terrain. On 3rd right turn racetrack pattern, witnesses observed acft descend slightly, roll into a 45 deg or greater bank and contact trees. The acft started a yawing rotation to the right and…NTSB ANC85LA175Accident · No injuriesLimited investigationFinal reportCessna 180 · Farewell, AKAcft failed to gain alt & crashed on takeoff from gravel bar weight & balance. CG, & winds were questionable.NTSB ANC85LA173Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Rainey Pass, AKThe plt was taking off on a strip of tundra about 1000 ft long in calm wind conditions. During the takeoff roll, he lost directional control & the acft ground looped & was damaged. No mechanical problems were reported.NTSB NYC85LA259Accident · No injuriesLimited investigationFinal reportVolksplane VP-1 · Sharpsville, PAThe plt experienced a loss of eng RPM during cruise flt. He applied carb heat and lowered the nose of the acft in an attempt to regain eng RPM however, the eng continued to loose speed. The eng was below 2000 RPM and dropping when the plt elected to make a…NTSB MKC85LA219Accident · No injuriesLimited investigationFinal reportCessna A185F · Lincoln, NEShortly after takeoff in an acft with amphibious landing gear. The plt cancelled his flt plan and had the twr check the landing gear. He then made a precautionary landing in a lake with the wheels retracted. One wheel was not fully retracted at touchdown and…NTSB MKC85LA212Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Charles, MOStudent plt on first solo takeoff experienced left yaw after liftoff. While plt attempted to correct for the yaw the acft touched down beside the rwy, traveled a short distance, collided with a dirt bank and nosed over. The plt said there was a left crosswind…NTSB MKC85LA211Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bridgeport, NEN2920E was taking off on a 2,800 ft long, turf rwy. There was a lt crosswind of 12 KTS and the density alt was 5,000 ft. the plt said the acft encountered a dip in the rwy and swerved to the lt momentarily. He said he regained directional control but then…NTSB MKC85LA210Accident · No injuriesLimited investigationFinal reportCessna 150K · Bee Branch, ARThe airplane was on a local flight when the engine failed. During the forced landing, the airplane ran through a fence row of trees. Inspection revelaed that the rocker arm bosses on the number one cylinder had failed. Cylinder had been installed 50 hours…NTSB MKC85FCD02Accident · Serious injuriesFinal reportCessna 172 M · Emmetsburg, IAThe acft crashed in a turkey farm field after losing alt during takeoff. A witness said the acft settled as though the plt was raising the flaps after takeoff. The acft lost alt in a rt turn, and landed 1 mile south of the arpt post acc investigation showed…NTSB MIA85IA246Incident · No injuriesIncident investigationFinal reportDouglas DC-8-71 · West Palm Bch, FLDuring take off roll the #4 engine failed causing catostrophic destruction of the engine. During subsequent examination the left vgv actuator pin was found to be missing. Without this pin the vgv ARM8 are aysemetrically driven. The vgv arms were found broken…NTSB LAX85LA386Accident · No injuriesLimited investigationFinal reportPeterson J-4 · Tucson, AZThe student pilot stated that he observed a tow airplane and a glider on the runway as he turned onto the final aproach to land. He said that he continued his approach and when the tow aircraft and glider failed to take off he attempted to turn off the…NTSB LAX85FA385Accident · 1 fatalField investigationFinal reportJonas Humming Bird · Tucson, AZThe experimental homebuilt acft was designed by the plt and incorporated a lifting body symetrical airfoil shaped fuselage. Pitch control was to be accomplished with a narrow chord canard. Witnesses saw the acft lift off briefly to about 10 ft AGL during the…NTSB FTW85LA354Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 1-26C · Rockdale, TXThe pilot observed and cleared serveral obstructions in the approach path of his intended landing area. However, he did not see one small and unmarked electrical power line until too late to take evasive action. This line was about 30 feet above ground level…NTSB CHI85FEV03Accident · 1 fatalFinal reportCessna 172 · Sweetwater, ILThe acft was observed flying at low alt parallel to a hiway before colliding with a tree before impacting the ground. The plts wife said that the plt had been under extreme stress for a few months and had not been to bed for 2 days preceding the accident. She…NTSB BFO85IA074Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Washington, DCNorthwest flight 78 (NW78), a B-757, was parked at gate 17 facing east with mobile passenger lounge (mpl) docked at L1 door. United 52, a DC-10, taxied in easterly direction by left side of NW78, then turned right to southeasterly heading to follow lead-in…NTSB ANC85LAG03Accident · No injuriesFinal reportTaylorcraft 19 · Anchorage, AKThe pilot stated that after he recovered from the spiral theaircraft struck the tree tops. At the time of the accident the weather was below VFR.NTSB SEA85FA208Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Wenatchee, WAAfter two application runs, plt apparently attempted to shorten the race-track pattern by initiating the inbound turn into a canyon. Acft was observed to climb clear of the canyon wall near completion of turn, but load was jettisoned at this point and the…NTSB MKC85LA209Accident · No injuriesLimited investigationFinal reportCessna 150L · Morrilton, ARThe airplane was on a night flight when the engine failed. During the forced landing, the airplane struck and remained attached to high voltage powerlines. Inspection of the engine revealed number three cylinder cracked and the top compression ring on number…NTSB MKC85LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Oxford, IAThe eng quit abruptly while the acft was cruising at 3,500 feet. The acft collided with standing corn during the night forced landing. After the acdt the fuel selector was found on the lt fuel tank, the lt tank was empty and the rt fuel tank was full. The plt…