NTSB investigations, NH
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 WHERE c.\"eventStateOrRegion\" = 'NH' AND c.\"eventCountry\" = 'USA' 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 WHERE c."eventStateOrRegion" = 'NH' AND c."eventCountry" = 'USA' 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 NYC84LA208Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Laconia, NHThe acft stalled and collided with the ground shortly after takeoff from Laconia airport. The initial climb was 'ok' according to the plt until the aircraft reached tree top level at 70 to 100 ft AGL at which time the airspeed seemed to level off and the…NTSB NYC84FNC03Accident · Serious injuriesFinal reportPiper PA-28-140 · Hampton, NHPurpose of flt was to obtain actual experience in short/soft field operations. Takeoff was initiated on a runway that was not only short and soft, but uphill and with a 70 degree left crosswind. Under these conditions, acft performance was inadequate to clear…NTSB NYC84LA167Accident · No injuriesLimited investigationFinal reportCessna 150 · Hampton, NHPilot stated that while landing, the aircraft bounced once possibly two times. On final touch down, the nose landing gear collapsed and the aircraft nosed over onto its back.NTSB NYC84LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · Laconia, NHThe acft ballooned during landing and came down hard on the nose gear which collapsed. The plt said a gust of wind had made the acft ascend about 20-50 ft after which it fell to the rwy. He reported the prevailing wind was variable from 270 to 290 deg a 12…NTSB NYC84FA081Accident · 2 fatalField investigationFinal reportCessna 402 · Jaffrey, NHThe plt had filed an IFR flt plan; however, he took off in VFR conditions & did not activate the flt plan. Radar data showed that the latter part of the flt was flown at 6300 ft, then at 1712:39 EST, a descent was begun. One minute later, the flt was last…NTSB NYC84LA076Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Nashua, NHThe helicopter left skid hooked on the guard rail as takeoff began from a trailer. As the plt continued to increase power to lift, the acft rolled over and the main rotor hit the hood of the tractor.NTSB NYC84FA057Accident · 1 fatalField investigationFinal reportPiper J3C-65 · North Hampton, NHThe acft stalled at about 100 ft of alt after takeoff during an instructional flt. One witness said the acft turned through 180 degrees before it collided with the ground in a nose low and right bank attitude. Another witness said he thought the acft was…NTSB NYC84LA045Accident · Minor injuriesLimited investigationFinal reportMaule M-5 · Somersworth, NHThe acft was damaged in a forced landing after the engine quit during a descent. The plt had been cruising at 2500 ft. upon descending to 800 ft in the skyhaven area the plt applied power but the engine did not respond. An airstart attemptwas unsuccessful and…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 NYC84FA009Accident · 1 fatalField investigationFinal reportBell 206B III · Hudson, NHThe plt was on a flt to pick up film for a tv station. While en route, he made a mayday call to the manchester control tower. According to witnesses, the acft was proceeding in a northerly direction at about 700 to 1000 ft AGL when they heard a 'muffled pop.'…NTSB NYC84LA001Accident · No injuriesLimited investigationFinal reportCessna 172 · Eppingham, NHThe pilot stated that while enroute to north conway, NH with about 10 gal. Of fuel on board he had to alter course to the southeast to find a hole to drop under clouds and avoid the mountains. He could not identify and land marks and lost contact with the…NTSB NYC83FU012Accident · Serious injuriesFinal reportRobertson Bird · Milan, NHAccording to the plt, he had just purchased the ultralight on the previous day & had no previous training in ultralights. On his 2nd flt in the vehicle, he landed hard, the tubular structure to the right gear collapsed & the lower seat support contacted the…NTSB NYC83LA240Accident · No injuriesLimited investigationFinal reportBeech 58P · Lebanon, NHAccording to the plt there was a sudden power fluctuation at(rotation speed). The plt then aborted the takeoff but couldnot stop the acft before departing the rwy.NTSB NYC83LA239Accident · No injuriesLimited investigationFinal reportBeech A23 · Manchester, NHThe acft collided with VASI lights during an emergency landing. The pilot was making touch & go landings. On the 4th takeoff the engine lost power at 150 ft. the pilot switched the fuel selector to left tank and the engine regained power. In maneuvering at…NTSB NYC83LA233Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Windham, NHThe eng quit during takeoff & the acft crashed into trees. The plt admitted having used 87 octane automotive no-lead gasoline in the acft.NTSB NYC83FA221Accident · Serious injuriesField investigationFinal reportRobinson R-22 · Nashua, NHAs the instructor watched the third liftoff from in front of the hangar, he observed the helicopter lift off the ground rapidly, its nose swinging quickly to the right as it did. During the yaw, the helicopter lost altitude rapidly until the right skid hit…NTSB NYC83LA219Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Wakefield, NHThe plt reported that he taxied out of a protected cove to takeoff on the main part of balch lake. After lift-off, he realized the wind was too gusty to be flying, & aborted from aprx 30 to 40 ft AGL. He saw telephone wires ahead that crossed the lake &…NTSB NYC83LA185Accident · No injuriesLimited investigationFinal reportLake LA 4-200 · Jaffrey, NHThe acft collided with brush, trees and rocks off the end of the rwy during an aborted takeoff. According to the pilot rotation was initiated once flying speed was attained but the acft failed to respond properly. The pilot elected to abort the takeoff and…NTSB NYC83LA184Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Antrim, NHThe helicopter made a steep approach, settled with power and made a hard landing. This was a dual instructional flt. Thestudents total time amounted to 4 hours, all in type. According to the CFI, while on the fourth approach on short final at 75 ft AGL, the…NTSB NYC83LA159Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Nashua, NHThe student plt was practicing full flap landings during a solo flt. While on a final approach to land, she observed another acft taxiing on the end of the rwy. So she elected to go around. At that time, the acft was about 25 to 30 ft AGL. Reportedly, she…NTSB NYC83FA160Accident · 1 fatalField investigationFinal reportCessna 172N · Jaffrey, NHAt 0555 EDT, the non-instrument rated plt obtained a wx briefing for a flt from limington, me to pawling, NY. At that time, he stated he was unsure when he would depart, the decision depended on the wx. The briefer advised that at that time, VFR flt was not…NTSB NYC83FA144Accident · 1 fatalField investigationFinal reportBeech 76 · Moultonboro, NHAfter making an instrument acph to laconia, NH, the plt landed, phoned his wife & advised her of his intention to fly to Moultonboro, NH. After taking off, he advised Moultonboro UNICOM that he had departed laconia & was over a nearby lake, but was having a…NTSB NYC83FNC05Accident · Minor injuriesFinal reportEnstrom 280C · New Market, NHAfter completing a normal run-up & mag check, the plt hovered in ground effect. A normal takeoff was then made in groundeffect. At about 200 ft AGL the plt noticed the RPM dropping from 2900 to about 2700. He tried to restore by dropping collective &…NTSB NYC83FNC04Accident · Serious injuriesFinal reportMcdonald Steen Skybolt · Milan, NHThe purpose of the flt was preparation of an act for some planned air shows. The pilot maneuvered the acft into an inverted spin at an alt of 2000 AGL. After 3 revolutions of the spin he was unable to recover and the acft impacted the ground inverted.NTSB NYC83FU003Accident · Serious injuriesFinal reportUltralight Flight Phantom · Jaffrey, NHSeveral days prior to the accident, the plt was advised by others that the eng on his newly assembled Ultralight did not'sound right.' After checking he noted that full power could not be obtained from the eng. However, enough power was available to fly a…NTSB NYC83LA024Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-1D · North Conway, NHAfter a tow-release at about 2,000 ft the plt encountered a sink which eventually developed into about a 1,000 fpm sink. The acft struck a fence during the forced landing.NTSB NYC83FA005Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Sanbornton, NHThe plt was advised during his wx briefing that VFR flt was not recommended for his proposed route of flt and destination. The plt, whose business concern was in the glens falls area, commuted almost daily to his home in gilford, NH. The wreckage was located…NTSB NYC82DA222Accident · No injuriesFinal reportChampion 7GCBC · Enfield, NHThe pilot experienced a partial power loss after takeoff and in trying for better landing terrain collided with power lines, a camp and a car.NTSB NYC82DA190Accident · No injuriesFinal reportCessna 152 · Lebanon, NHThe pilot landed at the uncontrolled airport to refuel. After receiving an in-person weather briefing, he filed a VFR flight plan. He contacted the fss on the airport advisory frequency and advised that he ws taxiing and would be making an intersection…NTSB NYC82DA186Accident · No injuriesFinal reportPiper PA-22-160 · Barnstead, NHThe pilot stated he lost power during takeoff and landed in trees off the end of the runway.NTSB NYC82FA181Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Concord, NHThe plt was advised during the 0028 & 0203 wx briefings that VFR flt was not recommended. At 0304 the plt called fss to activate his flt plan & was again advised VFR flt was not recommended. At 0403 the flt was given Concord wx & at 0406WAS cleared into the…NTSB NYC82FNC13Accident · 1 fatalFinal reportPiper PA-28-140 · Beans Purchase, NHThe acft impacted an obscured mountain. An observation log & a pilot-certificated witness confirmed that IFR conditions existed at the time of the accident.NTSB NYC82DA168Accident · No injuriesFinal reportPiper PA-18S · Moultonboro, NHAccording to the pilot, he taxied to a takeoff point farther out than normal and it took longer to get the plane "on the step" due to very heavy air. When the pilot reached the abort point he used control back pressure to "pop off" the water. However, he was…NTSB NYC82DA140Accident · No injuriesFinal reportCessna U206 · Nelson, NHThe pilot of the float equipped aircraft stated that during takeoff, there was a loss of power and lift. He tried to turn and land; however, the plane crashed into the lake and was destroyed. The pilot and passengers evacuated without injury.NTSB NYC82DA139Accident · No injuriesFinal reportCessna 150M · Laconia, NHWhen the student pilot was landing, the aircraft veered left after touchdown. It continued down an embankment, ran into a swamp, and was substantially damaged.NTSB NYC82DA153Accident · No injuriesFinal reportSchweizer SGS-1-36 · New London, NHWhile being towed during takeoff, the weak link on the tow rope failed when the glider was about 125 ft AGL. The pilot started to land on a golf course ahead, but spotted golfers in his intended landing area. The glider stalled while he was in a steep turn.…NTSB NYC82DA086Accident · No injuriesFinal reportChampion 7GCAA · New London, NHAfter towing a glider, the pilot returned to an unimproved airstrip and landed. During the landing roll, the aircraft became mired in soft sand and nosed over.NTSB NYC82DNC08Accident · Serious injuriesFinal reportSchleicher ASW-19 · Moultonboro, NHSeveral witnesses saw the glider circle over the airport before it crashed. One of the witnesses reported that the glider was about 50 to 100 ft high and was coming in normally when it suddenly nose-dived and headed almost vertically toward the ground. The…NTSB NYC82FNC06Accident · 1 fatalFinal reportCessna 172 · Hampstead, NHSeveral witnesses observed the plane circling at low altitude before it crashed. A friend of the pilot reported that thepilot waved, gunned his engine a couple of times and waggled his tail. Witnesses stated that after making several circles at an altitude of…NTSB NYC82FA060Accident · 2 fatalField investigationFinal reportCessna U206G · Stratford, NHBefore takeoff, the pilot received a partial weather briefing by telephone. He was advised of reported icing conditions and was told that snow and rain showers were moving through the area causing marginal VFR conditions. Before terminating the conversation,…NTSB NYC82DA047Accident · No injuriesFinal reportPiper PA-28-181 · Jaffrey, NHDuring takeoff, the engine lost power at about 40 to 50 ft AGL. The aircraft was landed back on the runway with about 400 ft remaining. It hit a snowbank at the end of the runway at about 40 to 50 knots. The plane bounced and came to rest after traveling…NTSB NYC82DA043Accident · No injuriesFinal reportBeech C-24R · Manchester, NHThe tower controller advised the flight while on base leg that the winds were from 300 degrees at 15 knots. This information was given at 1045 EST and was the last wind information given to the pilot before landing. According to the pilot moderate turbulence…NTSB NYC82DA024Accident · No injuriesFinal reportCessna 152 · Enfield, NHWhile the student pilot was on a solo cross-country flight, the engine lost power and then ran intermittently. The power loss occurred while the plane was over a snow covered lake at 6500 ft MSL. The pilot elected to land on the lake. After touchdown, the…NTSB NYC81FA082Accident · 2 fatalClosedGulf Amer AA-1B · Richmond, NHNTSB NYC81FNC19Accident · No injuriesClosedBellanca 7GCAA · Bath, NHNTSB NYC81FA071Accident · 1 fatalClosedTaylorcraft BC-85 · Durham, NHNTSB NYC81FA063Accident · Serious injuriesClosedDouglas DC-3 · West Deering, NHNTSB NYC81FNC09Accident · No injuriesClosedCessna 140 · Enfield, NHNTSB NYC81FNC06Accident · No injuriesClosedBeech A23-24 · Manchester, NHNTSB NYC81DNC02Accident · No injuriesClosedStinson 108-2 · Winchester, NH