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 FTW86LA022Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Houston, TXThe student was instructed to follow through with his left hand on the controls during the takeoff. After liftoff the CFI felt that the acft was climbting too steeply. He told the student to get off the controls, thinking that he was applying too much back…NTSB BFO86LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Stevensville, MDAccording to the student plt, approximately one-third down the rwy he flared too high, and the acft bounced and became airborne again. The plt decided to not attempt a go-around, and the acft contacted the rwy again. On the final bounce, the nose gear…NTSB ANC86LA002Accident · No injuriesLimited investigationFinal reportArtic S-1B2 · Anchorage, AKThe engine failure was due to a line cap loose in the baffled portion of the tank near the outlet lines. The pilot stated the aircraft engine quit at 1000 feet he then attempted an emergency landing in a school yard.NTSB NYC86LA007Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-D · Sterling, MAThe acft contacted trees while making an apch to rwy 34 at Sterling, Massachusetts. The acft crashed about 100 ft short of the rwy. The plt stated that a severe downdraft was encountered and then a rapid rate of descent followed. The left main gear struck…NTSB NYC86LA005Accident · No injuriesLimited investigationFinal reportBeech BE-99 · Albany, NYA Beech BE-99 N336PL experienced a landing gear collapse while landing on runway 01 at Albany county airport and was substantially damaged. On initial approach to the airport the gear selector was put in the down position, only two green gear lights were…NTSB MKC86FA008Accident · 2 fatalField investigationFinal reportPiper PA-24 · Salina, KSAfter departing the airport under very poor IFR weather conditions, the plt rpt autopilot problems of an unspecified nature. This was followed by reports of instrument troubles. Radar controllers gave the plt a no-gyro turn to the left. After the instructions…NTSB FTW86LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Houston, TXThe passengers stated that the pilot was unable to obtain higher power settings on a go-around from a low approach to an airport, and elected to land on a rural street. An examination of the engine revealed insect nests in the intake manifold and water in the…NTSB FTW86LA009Accident · No injuriesLimited investigationFinal reportCessna A185E · Intracoastalcty, LAThe plt was spraying for mosquito control during the hours of darkness. He turned to reverse course and then turned on the acft's landing light to check his altitude. He observed power lines but it was too late for evasive action. After the prop impacted the…NTSB DEN86FA009Accident · 4 fatalField investigationFinal reportCessna 180 · Eagle, COThe plt departed Eagle arpt with 3 pax to fly them to the white owl lake area for the reported purpose of looking for a possible camping site for hunting activities. The plt encountered IMC and lost control of the acft. He was not instrument rated. All…NTSB DEN86FA008Accident · 2 fatalField investigationFinal reportCessna 175A · Jal, NMA witness watched the acft takeoff and disappear in the darkness. The plt had intended to make 3 takeoffs and landings to regain currency for night flying. The acft never returned. The wreckage was found 2 miles north of the arpt the following morning. Wx was…NTSB CHI86LA012Accident · No injuriesLimited investigationFinal reportCessna 421C · Wooster, OHThe plt stated that the right eng manifold pressure decreased to 22 inches just after liftoff. He aborted the takeoff and put the acft back on the rwy. The acft ran off the end of the rwy, crossed a road and hit a ditch shearing the landing gear. Post…NTSB NYC86FA030Accident · 2 fatalField investigationFinal reportCessna C-182N · Winterport, METhe acft departed bangor under special VFR dur to low ceilings. A witness saw the acft fly under powerlines that crossed a river and disappear behind trees. There was no indication of an accident. 22 day later, the acft was located 150 ft south from the…NTSB FTW86LA014Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Rosharon, TXThe plt stated he was on a local flt and at about 200 ft above the surface the acft stalled and collided with the surface before recovery could be accomplished. He said he failed to maintain flying speed.NTSB FTW86FA008Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Pecos, TXThe non-instrument rated pvt plt departed on a night flt with wx reported as 300 and 2 in fog and drizzle. Acft impacted terrain shortly thereafter in a 60 degree nose down attitude. The plt had told a friend that after depature he would acquire and then…NTSB DEN86LA007Accident · Serious injuriesLimited investigationFinal reportBell BH 206BII · Kremmling, COWhile maneuvering to observe wildlife, the pilot attempted to hover out of gnd effect in steep mtns terrain at 9800 ft MSL at 2550 lbs gw with a 7-10KT tailwind. According to acft hoge charts in the POH, the acft was not capable of hoge in the conditions of…NTSB CHI86FA007Accident · 2 fatalField investigationFinal reportGulfstream 690A · Cadillac, MIThe acft was cleared for an NDB approach to Cadillac. The wkwas 300 ft ovcst, 1 mile vis. Shortly after cancelling IFR the acft crashed on the opposite side of the arpt from the approach end of the rwy. The pilot activated rwy lights were never turned on…NTSB ATL86LA005Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Chapman, ALDuring an attempted takeoff from a field adjacent to a grove of trees the aircraft was unable to climb over the trees and crashed into them. The engine was test run and although it ran rough during initial start up it later operated normally and the reason…NTSB ATL86LA004Accident · No injuriesLimited investigationFinal reportCessna 305A(0-1A) · Marietta, GAAircraft was on touch and go landing. Pilot allowed aircraft to become airborne prematurely. Flaps were not raised during go around and pilot stated he lost it. Aircraft veered to left after initial lift off for go around touched down repeatedly,with second…NTSB SEA86FA007Accident · 3 fatalField investigationFinal reportCessna 172 M · Callville Bay, NVNew pvt plt with two pax on board was observed making several low level passes over road in a canyon in dark. On last pass acft wing tip hit power pole below cross-bar, rolled inverted, crashed and burned.NTSB DEN86LA005Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Fillmore, UTThe plt departed delta, UT on a VFR x-c flt after being advised by fss that VFR was not recommended due to IMC conditions on the proposed route of flt. He flew into an area of rising terrain, encountered IMC wx conditions, attempted to reverse course and…NTSB ATL86LLT01Accident · No injuriesFinal reportCessna 150 · Livingston, TNThe plt made a forced landing in rugged tree covered terrain following a loss of pwr due to fuel exhaustion while on a x-country flt. The plt decame lost near Livingston, TN, and contacted the crossville and london fss for assistance. The acft was located 5…NTSB ATL86FA003Accident · 2 fatalField investigationFinal reportCessna C-172M · Luxora, ARAfter a day of work,the plt and two friends made a LCL flt around he area. Near the end of the flt,a fire was spotted on the west bank of a miss. River channel. The plt decided to go down and take a look at the fire. After passing over the fire, flt down the…NTSB LAX86LA010Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Paradise, CAThe acft touched dwn tail first during lndging to the rt of the rwy. The plt indicated he was lndging in a gusting x-wind which drifted him during a nose high hard lndg. No mechanical difficulties were reported by the plt.NTSB LAX86FA007Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Payson, AZThe passenger had a 10:00 medical appointment at the destination arot on the day of the accident. The non-instrument rated, recently certificated pvt plt, requested and received a weather briefing for a proposed VFR flt at 7500 ft MSL from mesa to holbrook,…NTSB CHI86FEX02Accident · 1 fatalFinal reportHodson Midget Mustang · Evansville, INWitnesses reported seeing the plt performing aerobatics and flying low in an area near his parent's home. The acft was then seen to enter a steep right bank during which, witnesses stated, the eng sputtered and quit. The acft then pitched down and impacted…NTSB ANC86LAG02Accident · No injuriesFinal reportMaule M5-235C · King Salmon, AKThe plt stated he misjudged the x-wind and water current during landing. The acft floats dug into the water and the acft nosed over and sank.NTSB ANC86LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Heiden, AKThe acft cartwheeled after dragging the right wing during an attempted takeoff from a gravel strip. The plt reported the takeoff was attempted to the west with a 10 to 15 mph left x-wind. Another person in the area when the accident occurred stated the wind…NTSB SEA86LA003Accident · No injuriesLimited investigationFinal reportCessna 150 · Burton Lake, ORThe acft failed to become airborne on the soft, short, rough cinder covered airstrip probably due to a combination of density altitude and poor plt technique. The acft struck a berm at the end of the runway where it nosed over. The plt was also departing…NTSB NYC86LA004Accident · No injuriesLimited investigationFinal reportCessna 140 · Newport, NHAcft collided with trees while executing a go-around. The acft lost power, the plt lowered the nose in an attempt to restart the eng while turning right in an effort to return to the rwy. The acft stalled and collided with trees.NTSB MKC86LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Salina, KSThe pilot did not top off the fuel tanks before departing lincoln, NE for pratt, KS. Enroute winds necessitated a fuel stop at Salina, KS. These same winds flipped over the airplane as it was turning off the runway to taxi in.NTSB MIA86LA008Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Opa Locka, FLThe plt stated that on final apch after lowering the landing gear he got an unsafe gear light. He then flew by the twr & the controller stated that the gear appeared to be down. He then recycled the landing gear & received a normal gear down indication. Upon…NTSB FTW86LA006Accident · No injuriesLimited investigationFinal reportFairchild F-27 · Houston, TXAcft veered left off the runway shortly after touchdown, collapsing the nose gear. Winds at the time would have resulted in direct crosswind of 9 kns. The crew that was contracted to ferry the acft noted, when they picked it up, that there were several open…NTSB FTW86FA007Accident · No injuriesField investigationFinal reportBell 206L-1 · Tomball, TXAcft was substantially damaged as a result of a hard landing during an emergency autorotation following a complete power loss. The power loss occurred as a result of an uncontained failure of the no. 1 turbine wheel. The wheel burst as a result of a fatigue…NTSB CHI86FA006Accident · No injuriesField investigationFinal reportCessna P210N · Grayslake, ILDuring descent the engine stopped running. The aircraft was landed in a soft field & nosed over. Only 4 gallons of fuel was found in the left fuel system with no evidence of leakage. The pilot only used the left system during the 2 hour flight. Fuel tanks…NTSB SEA86LA005Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Medford, ORThe acft collided with rocky terrain during an attempted forced landing following a loss of pwr. A witness reported seeing the acft in a steep descending left turn at an alt of aprx 100 ft AGL. The descent continued until the left wing contacted the terrain.…NTSB SEA86FA004Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Oakley, IDLow time private pilot had borrowed aircraft for personal trip to nearby airport. On arrival, pilot made fly by of friend's ranch to signal for pick up at airport. Friend got into auto and headed for airport,stated he was driving 60 mph and saw aircraft in…NTSB NYC86LA003Accident · Serious injuriesLimited investigationFinal reportCessna C206 · West Dover, VTCessna aircraft, N9861Z overran runway 1, at West Dover, Vermont and landed on a golf course. The pilot stated that when the flight was about 50 feet above the runway and about 100 ft down the runway windshear was encountered, pulling the aircraft to the left…NTSB MIA86LA007Accident · No injuriesLimited investigationFinal reportCessna C-182P · Lake City, FLThe plt stated that while on a VFR flt from west palm beach FL to atlnata ga the acft lost power. While making forced landing on interstate 75 the left main wheel struck a car, & on landing rollout the right wing struck a utility pole. Investigation revealed…NTSB MIA86LA005Accident · No injuriesLimited investigationFinal reportCessna 172 · St.Petersburg, FLThe plt stated that while attempting a landing he realized his rate of descent was too high. He then applied power, the nose pitched up and the acft stalled, resulting in a hard landing.NTSB LAX86LA009Accident · No injuriesLimited investigationFinal reportCessna 182N · Palm Springs, CADuring arrival, the plt entered the traffic pattern behind other acft to land on rwy 12. At that time, a Boeing 727 was waiting to takeoff on the same rwy. At 1914:52, the plt (of N92259) was instructed to start a left turn to the base leg. At 1915:04, the…NTSB LAX86LA006Accident · No injuriesLimited investigationFinal reportLeslie Quickie II · Porterville, CAThe acft received substantial damage during a landing at Porterville while on a local pleasure flt. According to the plt, he bounced the acft several times and it began to porpoise. During the porpoise motion, the propeller and left canard contacted the rwy.…NTSB LAX86FA004Accident · 4 fatalField investigationFinal reportCessna T210L · Lebec, CAThe acft contacted trees and the terrain in an uncontrolled descent and was destroyed by impact and an ensuing fire. The acft's left elevator was not located during the post accident inspection. Witnesses reported seeing the acft flying low (50 ft AGL) and…NTSB LAX86FA003Accident · 3 fatalField investigationFinal reportGulfstream AA-5B · Orinda, CAThe acft collided with rising terrain on a southerly heading. A VFR flt plan was filed. A witness near the accident site reported low ceilings and a forward ground visibility of 50 ft. aprx 15 minutes prior to the accident the acft was seen flying southeast…NTSB LAX86FA002Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Paradise, CAAfter takeoff, for an aflight orentation, the high time (over 2 4000 flt hours) pilot descended to an altitude of approx. 300 over a lake. The pilot was then flying up a twisting arm of the lake, in mountainous terrain into unmarked electrical transmission…NTSB DEN86LA006Accident · Minor injuriesLimited investigationFinal reportSkypower GBN-41-100 · Pecos, NMFlt was participation in the 1985 balloon fiesta, a night helium-filled balloon race from albuquerque, new Mexico, to elkhart, Kansas. One hr after launch plt encountered small wind shear, causing loss of altitude, ballast, and helium. Plt then encountered…NTSB DEN86LA004Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Aspen, COAfter departure from glenwood springs county arpt the plt initiated a cruise climb to fly over a 12,093 ft high mountain pass. He entered the narrow pass at an alt lower than the summit, encountered downdraft wind currents and was unable to climb fast enough…NTSB DEN86LA003Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Sawyer, NDThe plt allowed the airspeed to decrease to the extent of activating the acft stall warning system on final apch at 100 ft above the ground and 200 ft from the end of the rwy. He corrected the low airspeed condition by lowering the nose, resulting in a high…NTSB CHI86LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Lake Geneva, WIAfter touchdown & about 600 ft from the approach end of runway 23 the aircraft collided with a moped crossing the runway. The 11 yr old operator of the moped was seriously injured.NTSB CHI86LA005Accident · No injuriesLimited investigationFinal reportTodd Pitts · Hartford, WIN2032 had taken off, remained in the traffic pattern, & landed. N14JK had taken off, obtained a radio check at altitude,descended and entered the traffic pattern. Immediately afterlanding N14JK ran into N2032. N14JK reportedly made two radio calls in the…NTSB ATL86FKG04Accident · Serious injuriesFinal reportMooney M20J · Americus, GAThe acft contacted a tree and came to rest inverted during a forced landing following a loss of pwr. The loss of pwr occurred aprx 5 miles west of the destination arpt. Post accident inspection of the airframe and powerplant failed to disclose any mechanical…