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 NYC85LA255Accident · No injuriesLimited investigationFinal reportCessna 152 · Dansville, NYCessna 152,N6135P,on flight plan batavia, new york, landed hard at Dansville county airport and collapsed the nose gear. The aircraft was destroyed by fire, the pilot and one passenger were unjured.NTSB NYC85LA254Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Preble, NYA Schweizer N33920, collided with a utility pole while executing a go around at Preble airport, NY. The acft was destroyed. The plt and passenger received minor injuries. The plt stated that the first two flights were uneventful, but noticed the stall speed…NTSB NYC85LA252Accident · No injuriesLimited investigationFinal reportBeech C35 · Wexford, PAAircraft was landing on private grass strip and during landing roll struck a deer with the right wing tip. The grass was wet and the pilot lost directional control. The aircraft impacted trees that bordered the airstrip and was destroyed.NTSB NYC85LA251Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Pittstown, NJDuring an attempted takeoff on a 2439 ft rwy, the plt was unable to apply back elevator pressure thus the acft was prevented from becoming airborne. The acft traveled off the end of the rwy where it contacted a fence and trees. Inspection of the acft…NTSB NYC85LA250Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Galway, NYStudent plt was practicing maneuvers at 3000 ft when acft eng failed. The plt made a forced landing in a field. The tallgrass in field caused the landing gear to fail and substantially damaged the acft during the landing roll. NTSB metallurgist report shows…NTSB FTW85LA360Accident · Serious injuriesLimited investigationFinal reportBell 206B · North Padre 967The helicoter was attempting to take off with a rope still attached to the forward fuselage tiedown. A witness stated that the nose of the aircraft rotated down as the tail lifted to a near vertical attitude. The pilot inflated the floatsbut the aircraft…NTSB FTW85LA359Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-R · Mount Vernon, TXThe pilot reported he ran out of gas maneuvering under an overcast to find a suitable landing site. He had attempted to circumnavigate a large area of severe weather but exhausted his fuel supply. He stated that the engine quit and he stalled the aircraft at…NTSB CHI85LA389Accident · No injuriesLimited investigationFinal reportDouglas Maselink XTC · Caledonia, MIThe acft struck power lines while on apch for landing. The plt stated that he did not see the power lines; however, witnesses reported they warned the plt of the electrical lines prior to the accident.NTSB CHI85LA388Accident · No injuriesLimited investigationFinal reportCessna 152 · Delta, OHThe plt was performing a soft fld landing. When the nose wheel settled onto the airstrip it dug into the soft terrain, collapsed and the acft nosed over.NTSB ATL85MA286Accident · 17 fatalMajor investigationFinal reportCessna 208 · Jenkinsburg, GAAs the plt & 16 jumpers deptd on a skydiving flt, the eng lost pwr at aprx 300' AGL. The acft then banked steeply left, spiraled in a steep nose dwn attitude & crashed. An exam revealed fuel in the tanks was contaminated with wtr & foreign material with the…NTSB ANC85LA185Accident · No injuriesLimited investigationFinal reportCessna 180A · Glennallen, AKThe pilot stated the aircraft left wing was raised by a gust of wind. The aircraft accelerated rapidly in a si deways attitude to the right. The wind gust encountered and the fact the landing roll was almost completed CA used a situation that was beyond the…NTSB NYC85LA253Accident · No injuriesLimited investigationFinal reportCessna C-170A · Marathon, NYDuring an approach to land on a 1600 ft private grass airstrip the plt noticed the acft was too high. The landing attempt was continued until the plt thought there would not be sufficient runway to stop the acft. A go around was initiated and the tail wheel…NTSB NYC85LA249Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5B · Manchester, MAPlt stated that during cruise flight at an altitude of 1200 ft the engine RPM decreaseed from cruise setting to between 900-1100 RPM. The acft was overwater and 2 miles from the coastline. He was unable to maintain altitude and he started a descent toward…NTSB FTW85LA361Accident · No injuriesLimited investigationFinal reportCessna 182G · Maypearl, TXPlt stated that shortly after takeoff, the engine failed completely without warning. He set up for and executed a forced landing in a field. During the flare, one wing tip struck the top of a tree and during the landing roll the acft crossed several terraces,…NTSB CHI85LA387Accident · No injuriesLimited investigationFinal reportCessna 150 · Hastings, MIThe pilot was competing in a spot landing contest. The aircraft was reportedly observed about 4 to 5 feet AGL and slow just before it contacted the grass runway. The nosegear failed, dug into the ground, resulting in a nose over.NTSB ATL85LA287Accident · No injuriesLimited investigationFinal reportHughes 269A · Winchester, KYThe accident occurred as the student pilot was attempting to takeoff for hover training. As the pilot was applying collective torque, the student said, he lost control and crashed. There were no system malfunctions or failures reported.NTSB ATL85FLT14Accident · Minor injuriesFinal reportCessna 150H · Lebanon, TNThe acft crashed during a forced lndg after a power loss during takeoff. According to reports the plt took off on a check ride with an instructor. At 150 ft AGL pwr dropped to 2000 RPM. The CFI took over and shortly thereafter the pwr dropped to 1800 RPM. In…NTSB ANC85LA186Accident · No injuriesLimited investigationFinal reportCessna A185F · Port Alsworth, AKThe pilot took off in turbulent wind conditions and lost control of the airplane; striking ground and upending.NTSB SEA85LA229Accident · No injuriesLimited investigationFinal reportCessna 185 · San Juan Island, WAThe pilot was attempting to depart his private airstrip to the north with trees bordering the north end of the airstrip. The wind was from 360 at 20 knots gusting to 30 knots. The pilot was unable to arrest his rate of sink and made a right turn to avoid…NTSB FTW85FA358Accident · No injuriesField investigationFinal reportCessna 177RG · Ennis, TXThe plt could not lower the landing gear through use of the normal gear extension system. He was able to partially lower it through the use of the emergency extension system. Next he made an emergency landing at the departure airport during the hours of…NTSB DEN85LA249Accident · Serious injuriesLimited investigationFinal reportCessna TU206G · Evanston, WYThe plt said the eng quit as he was turning from base leg to final apch for rwy 24 at Evanston (WY) arpt. The acft crashed as the plt maneuvered for an emerg landing. Disassembly and examination of the eng disclosed no reason on why the engine failed. The…NTSB ATL85FLQ01Accident · Minor injuriesFinal reportPiper PA-28-181 · Bowling Green, KYThe acft was substantially damaged during a forced landing in a corn field following a loss of pwr 5 miles from the destination arpt. The plt reported to Bowling Green fss that he was 'out of gas' at an alt of 3000 ft. post accident examination disclosed a…NTSB ATL85FA285Accident · 2 fatalField investigationFinal reportBeech A36 · Lafayette, GAThe acft crashed in a trailer parking lot after a steep left turn & uncontrolled descent. The acft impacted the ground in a nose low attitude. The rt wing had struck a parked trailer prior to the nose striking the ground. The acc occurred about 1/4 mile from…NTSB SEA85LA227Accident · No injuriesLimited investigationFinal reportBeech J35 · Ontario, ORThe plt was flying the acft at a low alt for the purpose of spotting game. The eng ceased operating shortly after switching fuel tanks. The plt stated during a telephone interview that he inadvertently switched the fuel selector to the off position. The acft…NTSB LAX85FA402Accident · 1 fatalField investigationFinal reportAerospatiale AS350D · Kula, HIThe helicopter collided with terrain while on a sightseeing tour. The plt stated that the helicopter lost alt as he attempted to cross power lines. Directional control was lost during the ensuing down wind emergency landing. The helicopter contacted the…NTSB ATL85LA284Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Holly Springs, MSThe stu plt on his fourth solo flt elected to make a touch-and-go lng prior to going to the practice area. After turning base on the closed VFR traffic pattern, he states that he could not find the runway and allosed the airspeed to decrease too low. When he…NTSB ATL85FLT13Accident · No injuriesFinal reportPiper PA-38-112 · Springfield, TNThe acft was substantially damaged after contacting thres during a landing following a loss of pwr on takeoff. Post accident inspection revealed the carburetor valve ass'y had separated from the lever ass'y allowing the valve to seat flat against the…NTSB ANC85FA184Accident · 3 fatalField investigationFinal reportde Havilland DHC-2 · Merrill Pass, AKThe acft collided with terrain in a mountain Pass at an elevation of 3600 ft MSL. The plt obtained a wx briefing at 1329 gmt on 9/26/86 at which time Merrill Pass was forecast to be closed by 1100 adt due to deteriorating wx. The last radio communication with…NTSB SEA85LA226Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Fernly, NVThe acft's windscreen was struck by a bird and was blown out injuring the plt. The plt had difficulty keeping the acft airborne and a forced landing was made. The acft nosed over during the landing rollout on soft terrain.NTSB NYC85LA257Accident · No injuriesLimited investigationFinal reportCessna 172P · Canada Falls Lk, MECessna 172, a floatplane encountered a wind gust while landing on water. In an attempt to compensate for the wind. One of the wings contacted the water surface.NTSB NYC85LA248Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Hamburg, NYThe plt stated that he started a maneuver at 2700 ft. the maneuver was a dive after reducing pwr followed by a climb with a left turn at the top followed by a descending left turn. The turn 'at the top' was uncoordinated and g forces occurred. Throttle…NTSB LAX85LA406Accident · No injuriesLimited investigationFinal reportCessna 152 · Concord, CAThe acft was observed to turn to the left during the takoeff ground roll on rwy 32R at buchanan airport, Concord, California and exit the rwy environment. The certificated private plt reported that shortly after applying full power the acft 'swerved' to the…NTSB LAX85LA403Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Porterville, CAAfter climbing to a cruise alt of 13500 ft MSL to cross the sierra Nevada mountains, south of mt whitney, the plt entered cruise flt at an indicated airspeed of aprx 120 to 130 KTS. The plt's flt manual lists 110 KTS as the velocity velocity to never exceed…NTSB FTW85LA356Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Sanderson, TXOn landing, the plt noticed a quantity of brush on the rwy, however, he did not think it would be an obstacle to his intended takeoff and therefore did not remove it. During takeoff, the left main gear struck the brush causing the plt to lose control of the…NTSB ATL85FA283Accident · 1 fatalField investigationFinal reportBeech D18S · Huntington, WVThe acft contacted the terrain with the left wing tip, cartwheeled and came to rest inverted during an ILS rwy 12 apch at Huntington (hts). Minimum apch visibility for the ILS is 3/4 of a mile. While en route the plt was informed the hts visibility was 1/8 of…NTSB ANC85MA183Accident · Minor injuriesMajor investigationFinal reportBoeing 737-2X6C · Unalaska, AKAcft was dispatched to rstrctd arpt with a 3900' rwy & notamed: 3' stndg wtr on north end of rwy. SIGMET was in effect for mod to svr turbc blo 10,000' due to strong low lvl wnd & assoc wndshear. Capt made a shallow ovrwtr apch to rwy 12, which had a nr vert…NTSB SEA85LA230Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Burlington, WADuring initial climb, the plt smelled smoke & heard a backfire, then the eng lost power. A forced landing was made in a field on rough/uneven terrain. During the landing roll, the acft struck a ditch & was damaged. A visual inspection revealed that the left…NTSB MIA85LA263Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Pahokee, FLThe plt stated that he was flaring for landing when a gust of wind raised the acft causing it to crash into the rwy.NTSB MIA85LA262Accident · No injuriesLimited investigationFinal reportCessna 172N · Hollywood, FLThe plt stated that shortly after takeoff from ft. lauderdale, he felt a severe vibration and shut down the eng and made a emerg landing in an open field. Post crash investigation revealed that one propeller blade separated aprx one foot from the hub.…NTSB LAX85LA401Accident · No injuriesLimited investigationFinal reportBeech P60 · San Jose, CADuring the landing roll, the acft veered off the right side of the rnwy and made contact with a taxiway marker which was then thrown against the acft, puncturing the pressure bulkhead compartment. Examination of the left brake assembly revealed evidence of…NTSB FTW85LA357Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Ruston, LAThis 110 hour private pilot lost directional control of the aircraft while landing in a 90 degree cross wind and veered into a pickup truck spraying herbicide on the runway edge lights. Two city employees saw the aircraft coming towards them and escaped…NTSB DEN85LA248Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Deming, NMWhile practicing touch and go landings the plt added pwr for takeoff and the eng quit. The plt veered the acft to the left to avoid hitting farm machinery and collided with a tree stump. Post accident exam of the eng revealed the eng mostlikely failed as a…NTSB CHI85FEV04Accident · No injuriesFinal reportHiller UH-12D · Breese, ILThe plt reported that the eng began losing power while he was en route at an alt of aprx 200 ft AGL. He turned & initiated an autorotation to a road construction site. The helicopter landed tail low. Subsequently, the tail boom was chopped off & the…NTSB SEA85LA223Accident · No injuriesLimited investigationFinal reportCessna A185F · Eastsound, WADuring takeoff roll the acft veered right and the plt overcorrected to the left. The acft then departed the rwy to the left striking VASI lights.NTSB NYC85LA247Accident · No injuriesLimited investigationFinal reportCessna P210N · Marlboro, NJThe plt made a VOR apch to the arpt and circled to land while simultaneously determining wind condition. It was raining at the time. A landing was made on rwy 27. On touchdown, the plt stated, his brakes were ineffective. He described the rwy as wet. Since it…NTSB MIA85FA261Accident · Serious injuriesField investigationFinal reportAerofab Lake LA-4-250 · Medley, FLThe non seaplane rated plt whose airman certificate was under suspension. Attempted a downwind take-off from an intermediate point on the lake's surface. The plt stated he thought the non seaplane rated plt/pax attempted to abort the take-off by closing the…NTSB MIA85FA260Accident · No injuriesField investigationFinal reportCessna 402C · Fort Lauderdale, FLPilot ditched aircraft in atlantic ocean after losing power in both engines. The three occupants escaped ininjuried and were picked up by a nearby boat. The aircraft sank in approximately 800 feet of water about 5 minutes after ditching. Post accident…NTSB DCA85AA037Accident · 14 fatalFinal reportBeech B99 · Grottoes, VAAcft arr fm the NE, crossed ovr the arpt in IMC conds & contd twd the sw to the initial apch fix (iaf) for an ILS rwy 4 apch. The iaf was ovr the outer marker (om), 4.2 mi sw of the arpt. As the acft deptd the iaf, it contd outbnd twd the sw on an imprecise…NTSB CHI85FA385Accident · No injuriesField investigationFinal reportDassault-Breguet 10 · West Chicago, ILThe falcon 10 touched down long and fst on a wet runway, experienced hydroplanning and went off the end of the runway,struck a drainage ditch and collapsed the landing gear. The nose gear came back and bent the throttle quadrant bracket, pulled the fuel…NTSB ATL85FAMS2Accident · 3 fatalMissing aircraftFinal reportPiper PA-28-140 · Gulfport, MSPlt contacted apch control for advisories. Asked about wx onroute of ELT. Was told that lines of showers existed across path. Plt advised he thought he had found a gap and that he thought he could get over wx. Later radioed that ride was bouncy and he was in…