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 CHI85LA367Accident · Serious injuriesLimited investigationFinal reportRaven AX-9 · Blaine, MNThe one hour balloon sightseeing flight was uneventful. During his approach to land in a clear area he decided that his forward velocity was too high to land without hitting houses or powerlines below the balloon. According to him he burned fuel to attempt a…NTSB CHI85LA365Accident · No injuriesLimited investigationFinal reportCessna 177 · Glandorf, OHThe plt reported that during cruise flt the prop pitch began to vary, oil pressure dropped to zero and the eng began to overheat. A forced landing ensued during which the acft contacted a ditch. Post accident examination of the eng disclosed the #3 cylinder…NTSB ATL85LA267Accident · No injuriesLimited investigationFinal reportBryan HP-14 · Aiken, SCPlt reported that sailplane was positioned for a tow in tall grass beside the rwy. He said that during the takeoff the left wing was slowed by the tall grass allowing the right wing to accelerate. The sailplane yawed left and rolled left until 90 degrees to…NTSB ANC85LA169Accident · No injuriesLimited investigationFinal reportMaule M-5 · Anchorage, AKDuring takeoff, the eng lost power as the acft was climbing thru aprx 400 ft. the plt made a 180 deg turn to land back on the arpt. However, he then realized that the acft would not reach the rwy, so he turned & landed in a swamp area. An exam of the eng…NTSB ANC85LA168Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mcgrath, AKWhile en route & about 15 mi from his destination, the plt noted that both the eng RPM & the oil pressure were decreasing. Subsequently, he made an emerg landing in an area of small trees & brush next to a swamp. An exam of the eng was made, but no mechanical…NTSB NYC85FA227Accident · 2 fatalField investigationFinal reportCessna 150M · Danby, VTThe pilot of N66190 received a weather briefing from lebanon flight service station and was advised of low ceilings and also advised that visual flight rules flight was not recommended. At about the time N66190 was departing rutland, Vermont, a helicopter…NTSB MKC85LA205Accident · No injuriesLimited investigationFinal reportCessna 150-L · Stuttgart, ARThe pilot stated that just after takeoff, he lost engine power and when the airplane was landed in a rough soy-bean field, it nosed over to the inverted position. The engine and fuel systems were inspected by an FAA inspector. No reason for the power loss…NTSB MKC85LA203Accident · No injuriesLimited investigationFinal reportCessna 172G · Deepwater, MOThe acft was crusing at 2,000 ft, 50 min after takeoff when the eng began running rough, lost RPM, and then quit. The plt made a forced landing in a small fld and the collided with trees during the landing roll. The investigation, which included running the…NTSB LAX85LA378Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Carpinteria, CADuring a x-c pleasure flt all eng pwr was suddenly lost when the plt heard a 'loud bang.' The plt made an emergency ldg on a polo field. During ldg flare the plt stalled the acft. The resulting hard touchdown substantially damaged the acft. Exam of the acft's…NTSB FTW85LA339Accident · Minor injuriesLimited investigationFinal reportCessna 150B · Drumright, OKThe pilot's landing approach was long and fast. The aircraft touched down but the pilot decided he would be unable to stop on the remaining runway and intiated a go-around. He then realized he would not be able to clear trees beyond the end of the runway. He…NTSB DEN85LA234Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Littleton, COThe plt attempted to land his Balloon in high winds resulting a hard ldg which threw him out of the basket the Balloon then began an immediate asent until a pax pulled the vent line and the Balloon settled rapidly until it hit the grd. Injuries to passengers…NTSB CHI85LA362Accident · No injuriesLimited investigationFinal reportBeech A36 · Mankato, MNThe plt of this acft attempted to start the eng twice with acft battery and a ground pwr unit without success. He then tied the tail down with a rope and had started the eng. After the eng started, the tie down rope broke and the acft taxied by itself into…NTSB ATL85LA265Accident · No injuriesLimited investigationFinal reportBellanca Champion 7GCAA · Alabaster, ALThe plt lost directional control of the acft during a landing. The acft nosed over coming to rest inverted. The plt related that a gust of wind caused the loss of control.NTSB ATL85LA264Accident · No injuriesLimited investigationFinal reportPiper PA-18 105 · Hendersonville, NCDuring the takeoff phase of a touch & go landing, the CFR and private pilot lost directional control and ran off the side of the runway.NTSB ATL85FA266Accident · 4 fatalField investigationFinal reportPiper PA-28-235-B · Rion, SCThe acft had been cruising at 10,500 ft for several min and then informed ATC that they were climbing to 12,500 ft due to VFR. Shortly there after the acft disappeared from the radar scope. Witnesses heard the engine making an unusual sound and looked up and…NTSB ANC85LA166Accident · No injuriesLimited investigationFinal reportMaule M-5 · Cape Yakataga, AKThe plt reported that he started to depart from a gravel strip, then elected to abort the takeoff. While rolling on the ground, the acft hit a 'wash-out' which bent a structural tube on the landing gear assembly.NTSB MKC85LA206Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Montgomery City, MON39061 collided with trees at the edge of the arpt after takeoff from a 2,380 ft long, turf & gravel rwy. There was on 80' left crosswind at 10 KTS and the density alt was 3,000 ft. the arpt operator said the acft became airborne at a slower than normal speed…NTSB MKC85LA202Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Kahoka, MOThe plt stated that as he turned final, the airspeed increased and he could not slow down so the acft touched down fast. When he attempted a last minute go-around, the acft hit a concrete filled metal pole, went off the end of the rwy, across a street and…NTSB MKC85LA201Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Weskan, KSThe plt rptd a high eng oil temperature & low oil pressure while maneuvering over a siesmic operation site in west Kansas. The acft was substantially damaged when it contacted a ditch during a forced landing. Post accident inspection failed to disclose any…NTSB MKC85LA200Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Fredericktown, MOThe plt reports that he lost directional control during the landing roll. The acft swerved off the side of the rwy, down an embankment and collided with a fence. The landing and brake system were examined by a mechanic after the accident and no evidence of a…NTSB MKC85FA199Accident · 1 fatalField investigationFinal reportAeronca 7AC · Bridgeton, MOA witness observed the acft flying in an easterly direction at an alt of 200 to 300 ft AGL. The acft then made a 180 deg turn to a westerly heading. After flying a distance of aprx 2000 ft, the acft entered a left turn and dove into a squash fld. Post…NTSB LAX85LA377Accident · No injuriesLimited investigationFinal reportCessna A150K · Avalon, CAThe plt said the operation was about 4 and 1/2 hours into a commercial fish spotting flt when the engine 'began to run rough, then quit altogether.' Attempts to restart the engine were unsuccessful and the plt completed a power-off ditching at sea. He and the…NTSB LAX85FA376Accident · Serious injuriesField investigationFinal reportCessna T303 · Simi Valley, CAThe acft collided with trees during a forced landing following a loss of pwr. The student plt stated the flt was normal until a 'violent right yaw' developed when the trottles were advanced to recover from a practice stall. As the CFI took over the controls…NTSB DEN85LA238Accident · No injuriesLimited investigationFinal reportCessna 182D · Monument Valley, UTThe pilot said that during app to ldg he encountered unfavorable winds in sheer or wind direction change causing the a/c to drop 4-5 ft onto the r/w resulting in substantial damage to the a/c.NTSB DEN85LA232Accident · No injuriesLimited investigationFinal reportCessna P210N · Hayden, COPlt said eng began surging during descent from curise alt. After adjusting boost pump, throttle, and mixture, surging ceased. Plt said he dropped flaps and lowered landing gear at 2000 ft AGL and 5 mi from arpt. Eng began to surge again. Adjustment of…NTSB DEN85LA231Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Englewood, COThe pilot stated after the accident that he had approximately 1/2 full tanks of fuel when he departed the airport on a local night flight. He stated that he flew burning fuel from the left fuel tank. The pilot was returning to the airport after a flight of…NTSB DEN85FA229Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Peyton, COThe two experienced pilots took off from high alt airstrip under high density alt conditions. Witnesses said acft entered a 60-degree left banking turn. When acft had completed 120-degrees of turn, the nose dropped. Witnesses said the acft side-slipped to the…NTSB CHI85LA364Accident · No injuriesLimited investigationFinal reportThornhill Replica TS-1 · Marengo, ILThis aircraft is powered by a rotary engine. Thrust is varied by shorting out one magneto and varying the firing order of the cylinders via an electrical cam arrangement. The mixture control is limited to only a few settings. One of which is level flight.…NTSB CHI85LA361Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Wabash, INThe student plt was on a planned 3 leg x-country. On the second leg, he became ill and was lost for about one hour. He did not refuel as he though enough fuel remained to return to Wabash. The eng stopped about 7 miles from Wabash. The acft nosed down in a…NTSB CHI85FEP04Accident · Serious injuriesFinal reportPZL-Bielsko SZD-45A Ogar · Ft. Atkinson, WIWitnesses reported seeing the acft shortly after takeoff at an alt of aprx 40 to 50 ft AGL. At this time, according to witnesses, the eng slowed down, the acft turned left and dove into the terrain. No mechanical failure/malfunction was discovered during an…NTSB ANC85LA167Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Cape Yakataga, AKThe plt elected to land on a sandy/gravel area about 600 ft long & 100 ft wide which was located between hills that were 100 to 150 ft high. During a x-wind apch, the acft's rate of descent began increasing. The plt applied full power to arrest the descent,…NTSB ANC85LA165Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Gold King Creek, AKThe plt stated that when he landed, the acft was rolling out on its main gear in a tail low attitude, when he applied braking action. A moment later, the acft began to pitch nose down. He compensated with full up elevator, but the acft nosed over.NTSB SEA85LA205Accident · Minor injuriesLimited investigationFinal reportCessna T210-M · Camano Island, WAThe plt failed to visually verify the fuel on board prior to takeoff and he was aware that one fuel gage was inaccurate.a total loss of pwr occurred over water aprx 30 miles from the intended destination arpt. The plt was able to reach land during the…NTSB NYC85LA256Accident · No injuriesLimited investigationFinal reportSwearingen 226T · Hamilton, NYThe aircraft was on approach for landing at Hamilton, new york when the cross power levers were pulled back to flight idle. The left prop went into beta mode stalling the left wing at about 8 feet above the runway. The aircraft rolled about 20 degrees to the…NTSB MKC85LA198Accident · No injuriesLimited investigationFinal reportCessna 150G · Camdenton, MOThe pilot and son were on a personal cross-country flight when the engine quit. The airplane nosed forward to the inverted position during the landing roll. The reason for the engine failure could not be determined.NTSB MIA85IA242Incident · No injuriesIncident investigationFinal reportSmith, Ted Aerostar PA-600 · Sarasota, FLWhile on takeoff initial climb the right engine hydraulic pump shaft failed and the pilot did not receive a positive uplock. The pilot then selected gear down and did obtain a gear down indication. On landing the nose gear collapsed. Nose gear down locks were…NTSB LAX85LA375Accident · No injuriesLimited investigationFinal reportCessna T210 · Bishop, CAThe plt reptd the landing gear collapsed during the landing roll and that the lnd gear down light was illuminated while on final approach. Examination of the aircraft disclosed the lnd gear doors were damaged by the side loads and that both main lnd gears…NTSB FTW85LRA04Accident · Minor injuriesFinal reportRockwell S2R-600 · Rosharon, TXThe plt reported the acft contacted the ground after the left boom caught weeds during a spray run.NTSB FTW85LA340Accident · 1 fatalLimited investigationFinal reportCessna L-19E · Palo Pinto, TXThe acft was reported by witnesses to have been flying very low over a lake just prior to accident. The acft collided with pwr lines after passing over a dam and was destroyed on ground impact. The plt reported a loss pwr was experienced. The eng was test run…NTSB DEN85LQA05Accident · No injuriesFinal reportCessna 150M · Santa Fe, NMThe plt experienced a hard landing while on a solo x-country flt. The plt reported the flt had been delayed until mid-afternoon because of mechanical problems at by that time the winds had picked up. The student plt also reported having little dual experience…NTSB CHI85LA363Accident · No injuriesLimited investigationFinal reportCallair A-9 · Hollandale, MNDuring a maneuvering turn while crop dusting the pilot experienced a muffler failure and engine fire. He landed successfully and abandoned the aircraft. Subsequent investigation revealed that the bracket that holds the muffler/ exhaust pipe to the aircraft…NTSB ATL85FA278Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Proctor, WVThe acft was artd msg and was the object of a search from 9-1-85 to 9-12-85. Acft found in remote area of mtns and dense woods by man on foot hunting ginseng on 9-16-85.ND witnesses found. Residents in area reported rain all day on 8-30-85 and it was heavy at…NTSB NYC85LA229Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Danville, PADuring an apch, the acft was configured with full flaps & was trimmed for 65 KTS. At about 150 feet from the desired touchdown point, the plt reduced power to land. Momentarily after that, the stall warning horn sounded & the acft fell 10 to 20 ft, impacting…NTSB NYC85LA228Accident · No injuriesLimited investigationFinal reportCessna 182L · Blairstown, NJDuring a normal night landing, a deer darted onto the runway and struck the tail section of the aircraft causing major structural damage. The deer was not located.NTSB MKC85LA197Accident · No injuriesLimited investigationFinal reportCessna 310 · Cotton Plant, ARDuring the landing roll at an airstrip, the plt allowed the acft to drift. The drift continued until the acft struck a ditch bordering the rwy. The ensuing impact with the ditch substantially damaged the acft. The pilot stated the wind conditions were light &…NTSB MKC85LA196Accident · No injuriesLimited investigationFinal reportCessna 172 M · Gravois Mills, MOThe plt reports that he began his takeoff on rwy 07 which is 2550 ft long, has an asphalt surface and a downhill slope. Plt said the rwy is rough. He said the acft did not achieve the speed desired and he reduced power to abort. He then decided to attempt the…NTSB MIA85LA240Accident · No injuriesLimited investigationFinal reportCessna 310B · Hawthorne, FLWhile on a x-country flt the plt stated that the autoplt was erratic, hot and smoking. The plt further stated that he continued to use the autoplt. At about 1000 ft on final apch the autoplt failed for unknown reasons and the acft nosed down. The acft crashed…NTSB MIA85FA241Accident · Serious injuriesField investigationFinal reportGrumman AA-1B · Daytona Beach, FLPilot did not know how to turn on the instrument panel lights nor did he have a flash light available. He continued flight into darkness of night at which time he became disoriented and lost. He continued to fly until he exhausted all fuel on the aircraft and…NTSB FTW85FQG03Accident · 1 fatalFinal reportPiper PA-25-235 · Morton, TXAfter the plt completed a swath run, the acft entered a rgt climbing maneuver, then rolled wings level. After that, it reportedly began an abrupt climb for aprx 50 to 60 ft, then nosed down & crashed in a steep descent. After impact, the acft was destroyed by…NTSB CHI85LA366Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Germantown, OHOn return to the airfield, the acft lost pwr in the turn to final apch. The plt turned to an unprepared fld in order to avoid obstacles. During the landing roll the acft struck a fence post and fence. The plt stated the accident could have been avoided by…