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 ATL84FKJ02Accident · 1 fatalFinal reportCessna A188B · Hazel Green, ALThe acft collided with the ground while the plt was flying near his rural home. No preimpact, mechanical malfunction or failure was found. According to the medical examiner, the plt had severe & extensive coronary arterioscleroses; however, the relationship…NTSB ATL84FA031Accident · Minor injuriesField investigationFinal reportEmbraer EMB110-P1 · Blountville, TNThe acft was landed with the landing gear up. Post accident tests of the landing gear extension system showed that all operations were normal except for the main gear down-lock indications. When the crew lowered the gear for landing the nose gear and right…NTSB NYC84LA015Accident · 1 fatalLimited investigationFinal reportShort Brothers SD3-30 · Middletown, PAAfter takeoff on a flt to Washington, DC, the aircraft was climbing thru about 3500 ft when a person (riding as a passenger) moved to the right rear door, opened it & departed the acft. Prior to the flt, an associate, who was an acft refueler, saw the person…NTSB NYC84FA016Accident · 2 fatalField investigationFinal reportBellanca 17-31 ATC · Littleton, MAGround witnesses observed the right wing separate in flight, the acft bank sharply to the right entered a spiral dive and crashed into a wooded lot in a residential area. Investigation revealed that the right wing separation occurred when the front spar lower…NTSB MIA84LA022Accident · No injuriesLimited investigationFinal reportCessna 152 · Milton, FLThe acft was obsvd during a touch and go lndg to be high and fast. Aft bouncing on initial touchdown the plt lowered the nose and during the second touchdown the gear collapsed.NTSB DEN84FA017Accident · No injuriesField investigationFinal reportAerospatiale SE 3180 · Salt Lake City, UTThe helicopter crashed during a landing on the crest of a mountain. The french helicopter unlike American helicopters has a main rotor that rotates clockwise. To compensate for increased torque the plt must use right pedal instead of leftpedal. The plt in…NTSB CHI84LA034Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Port Huron, MIThe plt stated that shortly after touchdown several deer came out of the nearby woods & stopped on the left side of the rwy. He attempted to slow the acft down while staying on the right side of the rwy but went off the rwy & collided with a raised concrete…NTSB CHI84LA030Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Warsaw, INThe acft collapsed the landing gear during a forced landing following eng failure. The acft had been flown 5.5 hours before landing 3 miles NE of the intended refueling stop. The pilot had passed ft wayne at flt time of 5+ hours with about 10 gallons of fuel…NTSB NYC84LA014Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · North Conway, NHAccording to the pilot, the glider was towed to 2000 feet and released, in lift. Flt was in lift for about 30 minutes when a strong sink was suddenly encountered. The glider crashed into trees.NTSB MKC84LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Augusta, KSThe acft collided with a truck while taxiing out for takeoff. The plt said that when he saw the truck coming from the opposite direction along the side of the rwy he slowed down and steered to the opposite side of the taxiway. The driver of the truck made no…NTSB MIA84LA020Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Ormond Beach, FLThe acft is a twin-engine conversion of the Grumman G-164B. The plt was on a local test flt with the hopper filled with water to simulate flt conditions near the operating gross weight of the acft. After lift-off a partial power loss was experienced on the #2…NTSB FTW84FA032Accident · 1 fatalField investigationFinal reportCessna 182Q · Columbus, NMThe non-instrument rated plt departed imperial, CA, at 2010 PDT, & shortly thereafter, was identified & followed by a U.S. Customs special mission acft. The acft was followed to demming, NM. During that portion of the flt, its altitude varied from about 500…NTSB DEN84LA018Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Parker, CODuring the takeoff portion of a touch & go, the eng went to idle 15 ft AGL. The plt made a left turn & landed in a fieldcollapsing the landing gear. Investigation of the wreckage revealed that the carburetor was hanging in place by the throttle & mixture…NTSB CHI84FEE01Accident · No injuriesFinal reportPopelka BD-5 · Sugar Grove, ILThe acft had received an inspection on 9/8/83, before it was disassembled & transported from California to Illinois. On 10/27/83, the plt took off on a flt from sandwich to aurora, IL. While on a final apch to land at aurora, after a throttle reduction, the…NTSB ATL84FLT01Accident · Serious injuriesFinal reportCessna 152 · Clifton, TNAccording to the plt, he was descending from 8500 ft to 2500 ft when the eng quit without warning at aprx 4500 ft. he stated that he made a 'mayday' call & attempted to make an emergency landing in a field. However, the acft hit some trees at the edge of the…NTSB MKC84FA010Accident · No injuriesField investigationFinal reportConvair 340 · St. Louis, MOWhile in a climb after takeoff, the aircrew encountered an eng problem (which was reported as detonation) & requested clearance to return to the departure arpt. The flt was vectored for a right traffic pattern to rwy 24. The plt reported he was at 2000 ft MSL…NTSB MIA84LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe acft nosed over after the nose gear collapsed during a hard landing. The student pilot was making touch and go practice landings. This touchdown was hard and on the nose gear. The weather was VMC but the wind was from 330 degrees at 12 KTS. The landing…NTSB LAX84LA109Accident · No injuriesLimited investigationFinal reportCessna 210E · El Monte, CAA relatively inexperienced plt made a hard landing and reported that the 'front' tire blew upon landing. He pulled up & the acft ballooned and landed very hard on the nose wheel. Control tower personnel stated that the acft flew into the rwy in a nose low…NTSB LAX84LA035Accident · No injuriesLimited investigationFinal reportEnstrom F28F · Chino, CAThe acft experienced an in-flt fire on the downwind leg of the traffic pattern during a flt test following routine maintenance. The plt stated that while flying at 500 ft AGL in the traffic pattern smoke began entering the cockpit. Allgauges and systems…NTSB LAX84LA033Accident · 1 fatalLimited investigationFinal reportCessna 401 · San Diego, CAAfter touchdown during a night landing, the plt was lowering the nosewheel to the rwy when he saw a mexican national crossing the rwy. The plt swerved to the left in an attempt to avoid a collision; however, the right wing struck the person which resulted in…NTSB LAX84IA036Incident · No injuriesIncident investigationFinal reportBeech 200 · San Francisco, CADuring taxi after landing the right wingtip hit a steel awning support.NTSB LAX84FA032Accident · No injuriesField investigationFinal reportBell 206L-3 · Grand Canyon, AZWhile on a non-revenue business flt, the plt noted a partial loss of power with the N1 dropping to 70% RPM & the torque decreasing to 10%. He was unable to restore power & subsequently made a forced landing in the Grand Canyon. The landing was made on an…NTSB FTW84LA031Accident · No injuriesLimited investigationFinal reportCessna 172RG · Monticello, ARDuring flt, the plt detected smoke in the cabin. Thinking that an electrical malfunction was the source, he secured the electrical master switch & used the battery. A precautionary landing was made at Monticello, AR. During the landing, the right main gear…NTSB DEN84LA015Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Oakes, NDAfter a brief stop at oaks, ND, for fuel, the plt took off to fly about 5 mi to his private strip in an alfalfa field. During the landing roll, the gear hit a gopher mound & the acft nosed over.NTSB DCA84AA005Accident · No injuriesFinal reportDouglas DC-8-63F · Norfolk, VADuring arrival at nas Norfolk, the aircrew were vectored for a gca apch to rwy 10. They were advised that the wx was 200 ft scattered, 600 ft overcast, visibility 1 mi with rain, wind was from 360 deg at 20 KTS. Also, they were given a PIREP of 'heavy…NTSB ANC84LA011Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Kenai, AKThe eng quit & the plt ditched in skilak lake. The plt later stated that during the repair work after the accident he found the mixture contol dislodged from the carburetor.NTSB NYC84LA013Accident · No injuriesLimited investigationFinal reportBeech G18S · Syracuse, NYShortly after lift-off, at 25-50 ft AGL & the gear extended, the acft began a gradual roll to the right. The plt appliedfull left aileron but was unable to correct the roll. The plt sensed a rapidly deteriorating situation & decided to abort the takeoff. The…NTSB NYC84FU002Accident · 1 fatalFinal reportHighcraft Buccaneer · Mountville, PAThe amphibian ultralight vehicle was being flown on a series of flt tests after being assembled. At aprx 1615 EDT, the plt took off & was followed by another plt in another ultralight vehicle for observation purposes. No undesirable flt characteristic was…NTSB MKC84LA006Accident · No injuriesLimited investigationFinal reportPiper PA31-350 · Chillicothe, MODuring arrival, the plt attempted to lower the gear, but only 2 of the 3 would indicate down & safe. The plt was unable to extend the left gear, so he continued flying for aprx 1 hr to burn down fuel, then intentionally landed with the gear up. The landing…NTSB MIA84FA017Accident · 2 fatalField investigationFinal reportHight Smaragd CP-301-S · St Augustine, FLThe owner/builder/plt of the home built acft & a passenger (a foreign visitor) were on a local flt along a beach area. The purpose of the flt was for the visitor to take some video tape footage with the video camera that he took along. Witnesses, including a…NTSB LAX84LA031Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · New River, AZThe tow pilot reported that during a takeoff tow with both acft still on the ground, he started to drift right as a gust of wind caught him. The glider pilot decided to release. The tow acft then went 100 yards off the rwy and collided with a parked glider.…NTSB DEN84LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Englewood, COThe plt reported that during arrival, he was receiving vectors for an ILS when he entered a descent from 9000 to 8500 ft MSL. He entered clouds during the descent & applied carburetor (carb) heat immediately before entering the clouds. He said that the acft…NTSB CHI84FA028Accident · 1 fatalField investigationFinal reportBeech BE90C · Fort Wayne, INAt 1604 EST, the acft departed Fort Wayne on a ferry flt. IFR conditions prevailed & the plt had filed an IFR flt plan. While climbing after takeoff, the plt passed his assigned alt of 2500 ft MSL & flew to 4200 ft. also, he failed to turn to his initial…NTSB CHI84FA027Accident · 2 fatalField investigationFinal reportMooney M20E · Newark, INThe acft had been recently purchased by the plt & this was the 2nd leg of a 3 leg trip which had originally departed hickory, NC. Two witnesses located about 5 mi sse of the accident site observed the acft. One witness stated the visibility was less than 1 mi…NTSB ANC84LA010Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Anchorage, AKThe eng quit during takeoff. The plt stated the fuel selector was initially on the left tank which was found empty. The right tank was 1/8/ full.NTSB SEA84FA011Accident · Serious injuriesField investigationFinal reportBoeing A75N1 · Brewster, WAThe plt was positioning the acft for swath runs when it crashed into rising terrain on the side of a hill next to a valley. The plt had planned to make swath runs over an orchard in the valley. During impact, he received serious head injuries & could not…NTSB NYC84LA011Accident · No injuriesLimited investigationFinal reportCessna 172 · Reading, PAThe plt reported that during the flt, then he lost use of his radio & navigation equipment. Reportedly, he was forced to land about 1 mi from the Reading airport due to bad wx. The acft electrical system was checked, but no reason for the electrical failure…NTSB LAX84LA037Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · New River, AZThe student plt was on his 9th solo landing when he landed on rwy 27 with a x-wing from 200 deg at 10 KTS. During the landing, the glider drifted to the north into some bushes, then swerved into a tree. The plt reported that upon landing, he lower the wrong…NTSB LAX84LA030Accident · No injuriesLimited investigationFinal reportCessna 402B · Twentynine Palm, CAThe acft was landed in a westerly direction on a state highway. During the landing roll, the acft's right main gear went off the pavement onto a soft, sandy shoulder area. Subsequently, the plt lost control, the acft hit a berm & the gear collapsed. The plt…NTSB LAX84LA027Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · San Diego, CAAfter departing north island nas (naval air station), the plt attempted to change frequencies, but the megahertz (mhz) tuning knob came off at a setting of 122.1 mhz. He could still use the knob for tuning tenths of a mhz, so he contacted San Diego fss on…NTSB LAX84FA029Accident · No injuriesField investigationFinal reportMooney M20F · Indian Springs, NVAt 5,500 ft altitude the eng began slowly losing power. Unable to maintain altitude, the plt made a gear up landing in rough terrain. Examination of the eng revealed no discrepaniies.NTSB LAX84FA028Accident · 1 fatalField investigationFinal reportErcoupe 415-CD · Compton, CAThe acft experienced a total power loss on takeoff & was demolished in the impact sequence & post crash fire. According to several interviewees the pilot had performed extensive non-stc'd modifications to the acft including the fuel system. An 'automotive…NTSB FTW84LU001Accident · Serious injuriesFinal reportPterodactyl Ascender II · Manvel, TXThe plt reported that during takeoff, the eng began to lose power, just after he passed the end of the rwy. He turned back toward the rwy & the eng stopped. Shortly after that the ultralight vehicle struck a strand of barbed wire which was mounted about 30 ft…NTSB FTW84LA030Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33 · Norman, OKThe acft made a hard landing & cartwheeled.NTSB FTW84LA029Accident · Minor injuriesLimited investigationFinal reportMooney M20D · Ama, LAAfter takeoff the plt made two low passes over the rwy, & was turning to make a third when the acft struck trees.NTSB DEN84FA016Accident · No injuriesField investigationFinal reportCessna TU-206A · Loveland, COThe acft lost part of one blade of the propeller during the climb to cruise phase of operation. The passengers were skydivers so they used their parachutes in an exit of the acft as the airframe started to vibrate. The plt made a successful landing on the…NTSB DEN84FA012Accident · Serious injuriesField investigationFinal reportCessna T210G · Bountiful, UTDuring flt at 11,000 ft, the plt noted that the fuel flow gage was 'wiggling' & the eng 'didn't sound real healthy.' He increased the mixture slightly & turned the aux fuel pump to 'low boost.' The fuel flow then stabilized 'pretty good.' The plt said that a…NTSB ATL84IA029Incident · No injuriesIncident investigationFinal reportCessna 150M · Mobile, ALThe acft collided with a light pole while taxiing. The instructor pilot was preoccupied with locating a tie down spot.NTSB ATL84FA028Accident · 2 fatalField investigationFinal reportCessna TU206G · Brentwood, TNThe acft crashed while the plts were attempting an ILS approach to nashville. One plt was not instrument rated. The other was rated but was limited in experience. The instructions for radar vectoring to the approach were not followed and disorientation with…NTSB NYC84LA012Accident · No injuriesLimited investigationFinal reportPiper PA-25 · West Mifflin, PAThe pilot said that prior to departure he visually checked the tanks, found fuel in the tanks and the fuel indicator working properly. On final aprch at destination, the engine stopped and the acft landed in trees aprx 2 miles short of the rwy. During post…