NTSB investigations, NH
52 cases where the phase of flight was Maneuvering.
Cases per year
| 1967 | 3 |
|---|---|
| 1968 | 2 |
| 1971 | 2 |
| 1979 | 1 |
| 1982 | 1 |
| 1983 | 2 |
| 1984 | 1 |
| 1986 | 6 |
| 1987 | 1 |
| 1988 | 2 |
| 1991 | 3 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 3 |
| 1996 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 3 |
| 2009 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2022 | 1 |
| 2024 | 2 |
| 2025 | 3 |
Where
Latest cases
Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
current_codes AS (
SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
),
phases AS (
SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
FROM current_codes WHERE n = 1
UNION ALL
SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
),
case_phases AS (
SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
)
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'
AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 450)
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.
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
current_codes AS (
SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
),
phases AS (
SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
FROM current_codes WHERE n = 1
UNION ALL
SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
),
case_phases AS (
SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
)
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'
AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ERA26LA070Accident · Minor injuriesClass 3 · LimitedPreliminary reportHoltaway Robert F Velocity V-TWIN · Nashua, NHOn December 17, 2025, at 1410 eastern standard time, an experimental amateur-built Velocity V-Twin airplane, N22EU, was substantially damaged when it was involved in an accident near Nashua, New Hampshire. The pilot received minor injuries. The airplane was…NTSB ERA25LA287Accident · No injuriesClass 4 · LimitedFinal reportGrob-Werke Twin Astir · Franconia, NHThe pilot’s failure to detect the inadvertent deployment of the spoilers, which resulted in a prolonged, excessive descent rate. Contributing to the accident was the pilot’s decision to conduct a downwind approach versus a straight in approach to the…NTSB ERA25LA237Accident · Minor injuriesClass 3 · LimitedFinal reportGyro Technic GT-VX2 · Swanzey, NHThe pilot’s failure to maintain rotor rpm of the gyroplane during a low approach, while distracted by other aircraft in the airport traffic pattern, which resulted in the pilot’s decision to perform an off-runway landing.NTSB ERA24LA291Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G102 Astir CS · Benton, NHAn encounter with atmospheric conditions where the lift was not sufficient to maintain flight, resulting in collision with trees.NTSB ERA24FA097Accident · Serious injuriesClass 3 · FieldFinal reportBeech C99 · Londonderry, NHThe pilot’s failure to ensure that the cockpit door was secured before flight, which resulted in its separation during initial climb and a subsequent loss of control.NTSB ERA22LA283Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-18A · Charlestown, NHThe pilot’s failure to see and avoid power lines while maneuvering at low altitude.NTSB ERA18LA204Accident · Serious injuriesLimited investigationFinal reportProgressive Aerodyne Searey · Haverhill, NHThe pilot's failure to maintain clearance from trees while maneuvering the airplane at a very low altitude in a confined area while attempting to land on a river.NTSB ERA16CA197Accident · Serious injuriesData collectionFinal reportAmerican Champion 7GCBC · Warner, NHAn encounter with instrument meteorological conditions, which resulted in the pilot's spatial disorientation and a loss of airplane control.NTSB ERA15LA339Accident · 1 fatalLimited investigationFinal reportEvolution Revo · Laconia, NHThe sport pilot’s improper decision to operate the weight-shift-control aircraft at low altitude and his subsequent failure to maintain control of the aircraft, which resulted in a subsequent collision with terrain.NTSB ERA09CA177Accident · Serious injuriesData collectionFinal reportHI-Max 1700R · Windham, NHThe non-certificated pilot's failure to maintain clearance from houses while flying an unregistered experimental, amateur-built airplane.NTSB NYC08CA068Accident · No injuriesData collectionFinal reportCessna 170B · Alton, NHThe pilot's failure to maintain clearance above a frozen lake while maneuvering. Factors contributing to the accident were the pilot's attempt of the low altitude maneuver, and unfavorable lighting conditions.NTSB NYC08CA032Accident · No injuriesData collectionFinal reportBrand, Richard Bateleur 2000 · West Ossipee, NHThe pilot's failure to maintain aircraft control, while practicing aerobatics.NTSB NYC07CA103Accident · No injuriesData collectionFinal reportChampion 7ECA · Nashua, NHThe pilot's misjudged altitude while maneuvering for a banner pickup, which resulted in the banner rope becoming entangled in the airplane's landing gear, and a hard landing, during the ensuing emergency off airport landing.NTSB NYC07LA030Accident · No injuriesLimited investigationFinal reportStump Rotorway Exec 90 · Manchester, NHAn improperly installed oil line, which resulted in oil line fatigue failure and a subsequent loss of oil to the engine. A contributing factor was the sloping terrain at the forced landing site.NTSB NYC06CA041Accident · No injuriesData collectionFinal reportRobinson R-22B · Rochester, NHThe flight instructor's failure to maintain adequate clearance while providing hovering instruction, which resulted in tail rotor ground contact. A factor in this accident was the gusty wind conditions.NTSB IAD05LA108Accident · No injuriesLimited investigationFinal reportRobinson R22 · Nashua, NHThe flight instructor's failure to maintain aircraft control during a introductory flight and his inadequate remedial actions.NTSB NYC02FA196Accident · 2 fatalField investigationFinal reportPiper PA-30 · Gilford, NHThe flight instructor's failure to maintain airplane control, which resulted in an uncontrolled collision with water.NTSB IAD01LA100Accident · 1 fatalLimited investigationFinal reportSocata TB-20 · Amherst, NHSuicide, when the pilot intentionally crashed his airplane into his house.NTSB NYC00LA113Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Lanconia, NHThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall.NTSB NYC00LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Center Harbor, NHThe pilot-in-command attempted a low pass and misjudged his altitude.NTSB NYC00LA022Accident · 1 fatalLimited investigationFinal reportGodbout Exec 162F · Milan, NHThe pilot's failure to maintain proper rotor rpm while maneuvering, which resulted in main rotor blade flapping, and its subsequent impact with the tail boom. A factor was the pilot's lack of experience in maneuvering flight.NTSB IAD96LA073Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BCS-65 · Wolfeboro, NHthe pilot's failure to maintain control and altitude of the seaplane while circling to draw attention before landing on the lake. A related factor was that the aircraft was not equipped with a radio.NTSB NYC94LA155Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4A · Cannan, NHThe pilot's failure to maintain airspeed which resulted in an inadvertent stall and inflight collision with terrain. Factors were a loss of lift and the pilot's in-flight decision to maneuver too close to the ridge.NTSB NYC94LA108Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bristol, NHthe failure of maintenance personnel to remove an object from the carburetor heat duct during annual inspection which blocked induction air and resulted in the loss of engine power, and the subsequent collision with the terrain during a forced landing.NTSB NYC94LA073Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G109B · Nashua, NHThe certified flight instructor's delay in taking remedial action, which resulted in the motor-glider colliding with trees.NTSB BFO93FA135Accident · 2 fatalField investigationFinal reportKrowell Christen Eagle II · Lebanon, NHInadequate crew/group coordination.NTSB NYC93FA127Accident · 2 fatalField investigationFinal reportBoeing Stearman PT-17 · Concord, NHLoss of airplane control as the result of incapacitation.NTSB NYC92LA121Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Bedford, NHPhysical impairment of the pilot as the result of alcohol consumption, resulting in his failure or inability to maintain control of the airplane. Factors which contributed to the accident were: the pilot's poor judgement in buzzing residences and his failure…NTSB NYC91LA177Accident · No injuriesLimited investigationFinal reportCessna L-19 · Franconia, NHThe failure of the pilot to maintain airspeed, which resulted in a stall/spin and in flight collision with trees. Factors related to the accident were the improper in-flight planning by the pilot and the pilot's failure to compensate for winds and downdraft.NTSB NYC91LA141Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Ossipee, NHAn inadequate annual inspection by the mechanic which resulted in the inflight failure of the elevator control cable.NTSB NYC91FA060Accident · 2 fatalField investigationFinal reportMooney M20J · Brookline, NHThe failure of the flight instructor (CFI) to attain remedial action after control of the airplane was lost for an unknown reason.NTSB NYC89FA003Accident · Serious injuriesField investigationFinal reportAeronca 11AC · Barnstead, NHThe Aeronca 11AC was maneuvering downwind for landing. The pilot made a left turn towards the runway to tighten the pattern. While in close proximity to a house and the runway, at a low altitude the pilot elected to make a steep left 270 degree turn, opposite…NTSB NYC88LA177Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Laconia, NHThe plt stated that after pickup on a banner tow operation, the tow became twisted and he elected to return and release. On downwind, the acft began a rapid descent which the plt could not compensate for, even after releasing the banner and adding power.…NTSB NYC87LA069Accident · No injuriesLimited investigationFinal reportHughes 269D · Antrim, NHDuring a practice hover, the pilot lost directional control and the helicopter pitched up at an angle of about 20-25 degrees causing the tail rotor to contact the snow. The aircraft was substantially damaged, but there were no injuries. The CFI stated that…NTSB NYC86LA239Accident · No injuriesLimited investigationFinal reportHiller UH12C · E.Conway, NHPilot lost control of the helicopter while at hover then decided to land. However the pilot set the aircraft down hard. The main rotor blade severed the tail.NTSB NYC86FNC09Accident · Minor injuriesFinal reportCessna 205 · Twin Mountain, NHDuring a 'bomb drop' contest at an organized 'fly-in', the pilot was maneuvering at low airspeed so his passenger could drop a water-filled balloon on a target which had been placed on runway 27. The acft suddenly banked to the right and pitched down striking…NTSB ATL86FA240Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Hampton, NHThe acft was flying at low alt in the vicinity of interstate I-95 when the plt made a 360 deg, rgt turn. After the turn, the acft collided with pwr lines, which crossed I-95, then crashed & burned. A witness estimated the acft had dscndd to about 35 to 50 ft…NTSB NYC86FNC08Accident · 2 fatalFinal reportChampion 7HC · Epsom, NHA student pilot and passenger on a local flight collided with a tree, crashed and burned. No malfunction was found with the aircraft and engine. The plts flt time was not reported or available.NTSB NYC86FNC03Accident · 1 fatalFinal reportPiper J-3 · Milan, NHThe pilot was flying a 'drunken farmer' routine at a airshow. He was observed in the air to begin a descent from which he did not recover. The pilot was fatally injured in the crash and the aircraft destroyed. No mechanical or physical reason for the crash…NTSB NYC86LA061Accident · No injuriesLimited investigationFinal reportBell 47J2A · Atkinson, NHPilot stated he was attempting to position the Bell 47 helicopter on a small pad. This pad was too narrow to accommodate this acft and the right skid slipped off the platform. The pilot then requested his passenger to deplane. After the pilot determined that…NTSB NYC84FA306Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Wilmot, NHWitnesses saw a rt wing section separate when the acft was in a loop. The acft descended and crashed afterwards. The investigation disclosed the pilot had previous aerobatic experience in gliders. No records were disclosed revealing pilot flight time in…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 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 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 NYC79FA091Accident · 3 fatalClosedPiper PA-28 · Charlestown, NHNTSB NYC72FNC13Accident · No injuriesClosedCessna 182 · Penacook, NHNTSB NYC71DFG10Accident · No injuriesClosedCessna 140 · Pelham, NHNTSB NYC69F0144Accident · 1 fatalClosedCessna 150E · Freedom, NHNTSB NYC68A0099Accident · 2 fatalClosedCessna 172H · New Boston, NHNTSB NYC68A0030Accident · 1 fatalClosedBell 47G-5 · Kingston, NH