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 ATL85LKG13Accident · No injuriesFinal reportCessna 182N · Panala, ALThe acft collided with a tree during lndg which pulled it to the left off the road chosen for landing. The plt applied pwr to clear a ditch and the acft came to rest in a row of small trees. The plt had said the eng had started missing after takeoff from the…NTSB ANC85LA179Accident · No injuriesLimited investigationFinal reportCessna 207 · Chuathbaluk, AKThe acft made an emergency landing in a river after an eng failure due to fuel exhaustion. The plt stated that he could not determine exact fuel quantity prior to takeoff due to a broken cap on right fuel tank. The operator told the plt to fly the acft…NTSB NYC85FA240Accident · Minor injuriesField investigationFinal reportPiper PA-31-350 · West Mifflin, PADuring an air taxi flight the pilot transmitted that the airplane was out of fuel and landing on a golf course. Less than one gallon of fuel was drained from the wreckage. The airplane was making an unplanned return trip to pick up passengers after a…NTSB MIA85LA258Accident · No injuriesLimited investigationFinal reportCessna 177RG · Ormond Beach, FLThe plt stated that he forgot to extend the landing gear prior to touchdown while on a test flight after maintainence work was performed on the acft.NTSB LAX85LA407Accident · Serious injuriesLimited investigationFinal reportBell 206B · Pacific Ocean (Pacific Ocean)The helicopter experienced a loss of pwr within 10 minutes after takeoff from a fishing vessel. The helicopter was ditched in the Ocean at coordinates 11.25'N and 103.37'W. Examination of fuel samples from the fishing vessel revealed both upper and lower fuel…NTSB LAX85LA405Accident · 2 fatalLimited investigationFinal reportPiper J3 C-65 · Grand Canyon, AZAfter departing pierce ferry, AZ the plt and his passenger flew east, up the Colorado river, at a low level towards kanab point. The plt's notes and charts show that the flt was to turn north for aprx 40 NM, with a refueling stop at kanab, UT. The bright…NTSB LAX85LA393Accident · 1 fatalLimited investigationFinal reportPitts S-2A · Carlsbad, CAAfter completing an upright spin over the pacific ocean during the filming of a movie viewed from the spinning acft, the plt climbed his acft back to the entry alt and entered a flat inverted spin. The acft was observed to spin through its recovery alt at…NTSB FTW85LAMS2Accident · 1 fatalFinal reportSwearingen SA-226T · MissingA distress message was received from the pilot stating he was 100 miles south of grand isle, LA, and had lost an eng andwas unable to maintain altitude. A second message was received shortly afterwards stating that the aircraft was at 1500 feet and the pilot…NTSB DEN85LA243Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Holyoke, COThe plt landed her a/c in a right xwind and was unable to prevent the a/c from veering off the r/w. the a/c struck a wind t and came to rest in a corn field. The plt was not injured.NTSB CHI85LA381Accident · No injuriesLimited investigationFinal reportCessna 182Q · West Lafayette, INThe plt reported the acft bounced twice on touchdown. The final touchdown was hard and the nose wheel separated. The nose gear strut dug into sod resulting in substantial damage to the acft.NTSB CHI85FA379Accident · 1 fatalField investigationFinal reportGulfstream 500-S · Cloquet, MNThe pilot expected the weather to be below minimums but flew the approach anyway. He did not have a second pilot on board per company rules. The aircraft collided with trees about 3 miles from the approach end of runway 17.NTSB SEA85LA215Accident · No injuriesLimited investigationFinal reportVarga 2150A · Vale, ORThe acft nosed down after the nose gear collapsed during a forced landing on a dirt road following a loss of pwr. The plt reported that aprx 1 hr into the x-country flt he noted the fuel gages indicated 1/2 full on each tank. A state trooper reported he…NTSB MKC85FA217Accident · Serious injuriesField investigationFinal reportPiper PA-28-181 · What Cheer, IAThe acft was observed flying through the top of a tree, then through a four strand high voltage pwr line. Final impact was relatively flat in a soy-bean field. The plt later stated that he had become disoriented in flt and hallucinated that he was in a Piper…NTSB MIA85LA257Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Leesburg, FLThe pilot stated he was taxiing on a smooth asphalt taxiway in preparation for takeoff when the landing gear collapsed. A post- accident examination of landing gear failed to reveal any malfunction or failure that would have precluded normal operation of the…NTSB LAX85FVA05Accident · No injuriesFinal reportBeech E-33 · Coalinga, CAThe acft dragged the tail and crashed in a plowed field about 1/4 mile east of the takeoff rwy. The plt said the acft became 'squirrely' on the rwy and went left off the rwydespite her application of rt rudder tracks showed that the acft left rwy after 250 ft…NTSB DEN85LA242Accident · Minor injuriesLimited investigationFinal reportCessna 172 M · Wray, COThe student pilot was on her first solo flight. She stated that she was attempted her first landing and while on approach to the runway shw decided that it 'wasn't quite right.' She executed a go-around but the aircraft struck the ground and cartwheeled.NTSB ANC85LAA04Accident · No injuriesFinal reportPiper PA-22-160 · Fairbanks, AKThe left wing tip contacted the rwy and the left horizontal stabilizer contacted a sign following a loss on control during lanidng. The plt reported being aware of the right quartering x-wind but the acft bounced during the initial touchdown. The left wing…NTSB NYC85LA237Accident · Serious injuriesLimited investigationFinal reportPiper J-3 · Chenango Bridge, NYAccording to the pax after takeoff the aircraft climbed to about 300 feet. The pilot then made a right turn. During the turn the pilot yelled out 'we're losing it, we're losing it.' Afterwards the aircraft descended and impacted the ground. The pax does not…NTSB NYC85LA236Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Danbury, CTThe plt stated that on touchdown the left main gear collapsed followed by the right main gear and nose gear. The acft slid aprx 600 to 700 ft before stopping. According to the plt he confirmed the gear was down and locked while on base. A gear cycle test…NTSB NYC85LA235Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Madison, CTWhile on the downwind leg for rwy 24, the instructor reduced power to idle for engine failure simulation. The student made a short approach and upon reaching 700 ft AGL the student headed directly toward the approach end of the rwy at a 30 deg angle from rwy…NTSB NYC85IA238Incident · No injuriesIncident investigationFinal reportBoeing 747-130 · Jamaica, NYThe acft was making a visual app to rwy 31R at Jamaica NY waen the bottom of the aft 60 ft of the fuselage made ground contact. The left outflow valve was scraped and the rear drain mast was separated. Part of the apr access door and several stringers &…NTSB MKC85LA216Accident · No injuriesLimited investigationFinal reportCessna 172M · Emporia, KSTwo plts were on board. The lt seat plt was making the landing when a gust of wind caused the acft to become misaligned with the rwy. The rt seat plt took control of the acft and attempted a go-around. The rt seat plt said he aimed for a clear spot btw trees…NTSB MIA85LA256Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Indiantown, FLThe acft attempted a take-off from an intermediate point of a damp, soft, turf rwy. A 70 deg. Left x-wind of approx 25 KTS existed at the time. The acft became airborne but was unable to clear trees at the end of the rwy. Thee acft was destroyed in the crash…NTSB MIA85LA255Accident · No injuriesLimited investigationFinal reportCessna 172P · Wesley Chapel, FLThe rated private plt was received a check out in the acft by a CFI. The plt was having difficulty on the rwy as the winds were reported as 070 degs at 13 knts. The rwy being used was rwy 32. A 20 deg right x-wind tailwind condition existed. On the 4th touch…NTSB LAX85LA391Accident · No injuriesLimited investigationFinal reportMooney M20K · Rosamond, CAWhile enroute to van nuys arpt at about 9500 ft, the plt reported to edwards afb apch control that he was experiencing a rough running eng. The plt requested and received a radar vector to wm j. fox arpt, lancaster, CA. Shortly thereafter the eng sustained a…NTSB CHI85LA377Accident · Minor injuriesLimited investigationFinal reportWippler Cassut III M · Randall, MNThe engine lost power when the pilot attempted to add power at the completion of a descent. The pilot did not use carburetor heat in the descent. The relative humidity was approximately 60%.NTSB BFO85LA076Accident · No injuriesLimited investigationFinal reportCessna 401 · Cheswold, DEAfter landing on runway 27, the pilot slowed the aircraft to approximately 30 mph. The aircraft had rolled out about 1000 feet when the gear horn sounded and all three landing gear collapsed. The pilot reached for the gear switch, which was in the up…NTSB ATL85LA277Accident · No injuriesLimited investigationFinal reportPiper PA-22-125 · Shinnston, WVThe plt reported that he initiated a normal apch to land on rwy 27. However, when he flared, he failed to stop the descent. Subsequently, the acft landed hard just short of the rwy. During the landing, the nose gear collapsed & the acft nosed over.NTSB ANC85LA178Accident · No injuriesLimited investigationFinal reportCessna 180 · Tutna Lake, AKThe plt elected to takeoff from a lake that was aprx 1/2 mi long & oriented on an east/west heading. During a x-wind takeoff, the plt had difficulty getting the acft to lift off, but elected to continue the takeoff. The acft finally lifted off, but failed to…NTSB ANC85LA177Accident · No injuriesLimited investigationFinal reportCessna A185F · Cordova, AKThe plt stated that prior to landing, the acft's right brake had no pressure. He reported that after he landed, the tail wheel began to shimmy & the acft pulled to the left. He applied full right rudder, but was unable to prevent the acft from ground looping…NTSB SEA85LA214Accident · Minor injuriesLimited investigationFinal reportBell 206BII · Atlanta, IDA loss of pwr occurred shortly before touchdown. The left skid struck a rock during touchdown causing the acft to roll onto its right side. Twenty-five flt hrs prior to this flt an identical situation occurred and a loose air line to the fuel control was…NTSB SEA85LA213Accident · Minor injuriesLimited investigationFinal reportTodd KR-II · Boise, IDThe acft settled back onto the rwy shortly after takeoff pushing both main gear up through the wings. The plt did not have any previous experience in this type acft.NTSB SEA85FA212Accident · Serious injuriesField investigationFinal reportLuscombe 8A · Renton, WAThe inexperienced, low time student pilot reported a gradual loss of power while operating his luscobe 8A aircraft on a personal, local flight. The aircraft was equipped with a stromberg carburetor whose mixture was permanently wired full open and power was…NTSB NYC85FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 172N · Block Island, RIThe acft departed long Island on a VFR flt plan for Block Island. The plt did not close the flt plan after arrival at Block Island and departed Block Island without refiling a flt plan. The flt departed Block Island at night to the east over the ocean and has…NTSB NYC85FA241Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Hamburg, NJThe acft contacted trees during an uncontrolled descent aprx 17 minutes after takeoff. One witness reported hearing the eng running at a high RPM. The acft wreckage was not discovered until 9-18-85. The airspeed indicator found at the accident site indicated…NTSB MIA85LLD03Accident · No injuriesFinal reportBrokaw Bullet · Eustis, FLThe acft contacted a ditch during an attempted takeoff on a taxiway. The plt reportedly decided to use the taxiway for takeoff rather than the rwy because of the soft rwy conditions which resulted from recent rains. During takeoff the leftmain gear contacted…NTSB MIA85FA254Accident · Serious injuriesField investigationFinal reportMooney M20F · Aripeka, FLThe student plt stated that after dinner, which included a small amount of wine, he went to the arpt to clean his acft, then elected to go for a short flt. He intended to stay within 25 mi of the arpt, but found himself over lakeland. He landed at a strip to…NTSB LAX85LA392Accident · No injuriesLimited investigationFinal reportNorth American P-51D · Reno, NVThe plt had completed a heat race as a participant in the Reno national championship air races and was landing in a gusty x-wind when the acft's left wing was lifted by the wind and the acft cartwheeled, resulting in substantial damage to the wings and to the…NTSB FTW85LRG02Accident · No injuriesFinal reportHomebuilt Tiger Bird · Kerrville, TXThe acft nosed over on landing following a loss of directional control. The plt reported touchdown was made on the first 100 ft of the rwy and as the acft slowed to aprx 10 mph directional control was lost. The acft traveled off the left side of the airstrip…NTSB FTW85LA349Accident · No injuriesLimited investigationFinal reportRyan Navion · Midland, TXThe plt experienced eng failure during climbout from sky ranch arpt at Midland, TX. He then turned into the wind and made a forced landing in a pasture. Subsequent investigation revealed a connecting rod had broken, however, the cause of the rod failure was…NTSB FTW85FA346Accident · 1 fatalField investigationFinal reportPitts SPL. S-1 · Mclean, TXThe plt had landed the Pitts special on the highway due to low fuel. After the fuel service the acft took off and the plt performed low altitude acrobatics then departed making slow rolls below a low overcast. A witness observed the acft flying low over the…NTSB DEN85FA241Accident · 1 fatalField investigationFinal reportAerospatiale SA315B · Craig, COThe helicopter was long-lining a 1280-pound air compressor to an 8500-foot MSL mountain drilling site. Witnesses heard a squealing sound and bang. They observed gray-white smoke and orange-blue flame emitting from the exhaust. The plt released the load and…NTSB CHI85LA380Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Bloomington, INThe piloted landed with an 80' left crosswind at 8 knots. During landing roll the wind picked up the left wing. The acft weathervaned into the wind & the right gear collapsed. The right wing was also damaged during the swerve.NTSB CHI85LA378Accident · Minor injuriesLimited investigationFinal reportSchweizer 134 · Hampshire, ILThe pilot reportedly failed to use spoilers on final. The approach was high so he attempted a 180 degree turn at the departure end of the runway. The glider stalled and collided with the ground.NTSB CHI85FET03Accident · 1 fatalFinal reportVanbenthuysen John Bede BD-5B · Elkhart, INThe acft rolled inverted & collided with the ground after an overtemperature reading, an RPM loss and loss of airspeed were recognized by the plt during the recording of the takeoff. The plt had a portable recorder on board and was using it during the…NTSB BFO85LA075Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Williamsburg, VAThe plt contacted the field on UNICOM frequency of 122.8 and was informed that the active rwy was 31, with wind from 040 degrees at 13 knots. The final approach was made with crab and power, but just prior to touchdown, the right wing lifted and the acft…NTSB ATL85FA276Accident · 1 fatalField investigationFinal reportLaux Pitts S-1S · Paducah, KYThe aircraft was observed in the local area for several minutes. It was perfoming aerobatic maneuvers. One witness reported that it was lower than it usually was when it was perfoming these maneuvers. It was observed to do an inside loop, roll inverted and…NTSB ANC85LA176Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Togiak, AKAcft crashed on mountainside after wx worsened. Marginal wx had been forecast & PIREP advised plt that VFR flt was not recommended.NTSB MKC85LA215Accident · No injuriesLimited investigationFinal reportCessna 421B · Olathe, KSDuring the takeoff roll on an IFR flt, the right eng lost pwr and the plt aborted the takeoff. The acft ran off the end of the rwy, across two ditches, one road, through a fence and struck a post in a fld. During post accident tests, the right eng would run…NTSB MIA85FA253Accident · No injuriesField investigationFinal reportCessna 152 · Panama City, FLThe plt of 757 hm stated that he understood he was second to land so he processed to turn final unknowningly cutting off threeother acft on final apch to twy 05. The tower told him 'break left there is two acft on final', he applied power to go around and…