# NTSB investigations, NH: Approach

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 2 · 91 cases

## Latest cases

- [NTSB ERA25LA115](https://openairdocs.org/ntsb/ERA25LA115.md): Luscombe 8A · Hampton, NH · Accident · No injuries · Class 3 · Limited · Final report · Feb 11, 2025 · N77989 · Substantial damage
  > The pilot’s failure to maintain adequate airspeed while maneuvering to land, which resulted in an exceedance of the airplane’s critical angle of attack and subsequent aerodynamic stall.
- [NTSB ERA23FA384](https://openairdocs.org/ntsb/ERA23FA384.md): Cessna 150K · Gilford, NH · Accident · 1 fatal · Class 3 · Field · Final report · Sep 30, 2023 · N6312G · Substantial damage
  > The pilot’s loss of control during visual flight rules flight in night instrument meteorological conditions due to spatial disorientation. Contributing to the accident was the pilot’s motivation to depart on the flight despite being made aware that conditions…
- [NTSB ERA23LA196](https://openairdocs.org/ntsb/ERA23LA196.md): ICP Savannah S · Gilford, NH · Accident · No injuries · Class 4 · Limited · Final report · Apr 15, 2023 · N5400S · Substantial damage
  > The pilot’s failure to maintain control of the airplane during an attempted go-around, which resulted in an aerodynamic stall and impact with the runway.
- [NTSB ERA23LA057](https://openairdocs.org/ntsb/ERA23LA057.md): Cessna 175 · Gilford, NH · Accident · Serious injuries · Class 4 · Limited · Final report · Nov 10, 2022 · N7223M · Destroyed
  > The pilot’s decision to continue the approach to land in conditions where he was unable to see in front of the airplane due to sun glare, which resulted in in a collision a building.
- [NTSB ERA22FA086](https://openairdocs.org/ntsb/ERA22FA086.md): Swearingen SA226 · Bedford, NH · Accident · 1 fatal · Class 3 · Field · Final report · Dec 11, 2021 · N54GP · Destroyed
  > The pilot’s failure to secure and feather the left engine and increase power on the right engine after a perceived loss of engine power in the left engine, which resulted in a loss of control and impact with terrain just short of the runway. Contributing to…
- [NTSB ERA21LA283](https://openairdocs.org/ntsb/ERA21LA283.md): Bailey N Moyes Dragonfly · Charlestown, NH · Accident · 1 fatal · Class 3 · Limited · Final report · Jul 10, 2021 · N346FL · Substantial damage
  > The passenger’s decision to continue an unstable approach while at low altitude and in proximity to a known obstacle, which resulted in a collision with power lines.
- [NTSB ERA21LA041](https://openairdocs.org/ntsb/ERA21LA041.md): Mooney M20C · Laconia, NH · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 9, 2020 · N3296F · Substantial damage
  > The pilot’s failure to maintain adequate clearance from trees during an approach in sun glare and hazy conditions.
- [NTSB GAA17CA087](https://openairdocs.org/ntsb/GAA17CA087.md): Jack Fehling Celebrity · North Hampton, NH · Accident · No injuries · Data collection · Final report · Dec 4, 2016 · N28JF · Substantial damage
  > The pilot’s unstabilized approach, which resulted in the biplane being low and striking trees.
- [NTSB ERA14CA037](https://openairdocs.org/ntsb/ERA14CA037.md): Piper PA 28-150 · Newport, NH · Accident · No injuries · Data collection · Final report · Oct 14, 2013 · N5873W · Substantial damage
  > The pilot's incorrect glide path, which resulted in a landing area overshoot and a runway excursion.
- [NTSB ERA12FA175](https://openairdocs.org/ntsb/ERA12FA175.md): Cessna T182T · Lebanon, NH · Accident · 1 fatal · Field investigation · Final report · Feb 9, 2012 · N6062E · Substantial damage
  > The pilot’s failure to maintain airspeed during a return to the airport after takeoff, which resulted in an aerodynamic stall and loss of airplane control.
- [NTSB ERA11CA319](https://openairdocs.org/ntsb/ERA11CA319.md): Aero AT SP Zoo AT-4 LSA · Concord, NH · Accident · Serious injuries · Data collection · Final report · May 31, 2011 · N709PR · Substantial damage
  > The student pilot's loss of aircraft control during a go-around maneuver following a bounced landing.
- [NTSB ERA10CA505](https://openairdocs.org/ntsb/ERA10CA505.md): Cessna 172S · Franconia, NH · Accident · No injuries · Data collection · Final report · Sep 25, 2010 · N5295Y · Substantial damage
  > The pilot’s delay in initiating a go-around, which resulted in an in-flight collision with a fence.
- [NTSB CHI08CA017](https://openairdocs.org/ntsb/CHI08CA017.md): Balloon Works Firefly 7 · East Hampstead, NH · Accident · Serious injuries · Data collection · Final report · Oct 15, 2007 · N7408G · No damage
  > The pilot's excessive descent rate on approach, which resulted in a hard landing. Contributing factors were the adverse winds encountered during the flight, and the presence of the trees and power lines near the landing area.
- [NTSB IAD03CA061](https://openairdocs.org/ntsb/IAD03CA061.md): Robinson R22 Beta · Nashua, NH · Accident · No injuries · Data collection · Final report · Jun 27, 2003 · N185MH · Substantial damage
  > The pilot's failure to determine the wind direction, which resulted in a hard, tailwind landing.
- [NTSB NYC01LA175](https://openairdocs.org/ntsb/NYC01LA175.md): Yakovlev 52 · Moultonboro, NH · Accident · Minor injuries · Limited investigation · Final report · Jul 14, 2001 · N48GA · Substantial damage
  > A clogged fuel vent line due to a mud dauber nest, and rough terrain, including a large hole, in the forced landing field.
- [NTSB NYC01LA103](https://openairdocs.org/ntsb/NYC01LA103.md): Cessna 177 · Hampton, NH · Accident · No injuries · Limited investigation · Final report · Apr 22, 2001 · N3117T · Substantial damage
  > The pilot's inadvertent encounter with a downdraft, which resulted in a collision with trees. A factor related to the accident were the downdraft wind conditions.
- [NTSB NYC99LA004](https://openairdocs.org/ntsb/NYC99LA004.md): Enstrom F280 · Bow, NH · Accident · Minor injuries · Limited investigation · Final report · Oct 5, 1998 · N8618N · Destroyed
  > The pilot's inadequate visual lookout and his failure to maintain adequate obstacle clearance, which resulted in an in-flight collision with a tower. A factor in this accident was the gusty wind conditions.
- [NTSB NYC98FA129](https://openairdocs.org/ntsb/NYC98FA129.md): Hawker Hunter T MK 8 · Manchester, NH · Accident · 1 fatal · Field investigation · Final report · Jun 18, 1998 · N745WT · Destroyed
  > Fuel exhaustion, resulting from the pilot's reliance on an inaccurate fuel quantity indicating system. A factor in the pilot's death was his intentional delay of the ejection sequence in order to avoid people and property on the ground.
- [NTSB IAD98LA053](https://openairdocs.org/ntsb/IAD98LA053.md): Cessna 310Q · Nashua, NH · Accident · Serious injuries · Limited investigation · Final report · May 11, 1998 · N7795Q · Destroyed
  > The pilot's improper fuel management which led to fuel starvation.
- [NTSB IAD97LA096](https://openairdocs.org/ntsb/IAD97LA096.md): Piper PA-23-160 · Hampton, NH · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 1997 · N4022P · Substantial damage
  > The pilot's poor judgement for intentionally shutting down an engine to perform a practice single engine landing, which led to a single engine go-around due to conflicting traffic.
- [NTSB NYC97LA044](https://openairdocs.org/ntsb/NYC97LA044.md): Mooney 20F · Jaffrey, NH · Accident · Serious injuries · Limited investigation · Final report · Jan 19, 1997 · N7112V · Destroyed
  > The pilot's failure to maintain aircraft control during a go around attempt, which resulted in a loss of control and collision with trees.
- [NTSB NYC97FA194](https://openairdocs.org/ntsb/NYC97FA194.md): Learjet 35A · Dorchester, NH · Accident · 2 fatal · Field investigation · Final report · Dec 24, 1996 · N388LS · Destroyed
  > The captain's failure to maintain situational awareness, which resulted in the airplane being outside the confines of the instrument approach; and the crew's misinterpretation of a step-down fix passage, which resulted in an early descent into rising terrain.…
- [NTSB NYC96LA172](https://openairdocs.org/ntsb/NYC96LA172.md): Pzl-Bielsko SZD-59 · Franconia, NH · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 1996 · N591SZ · Substantial damage
  > The pilot's misjudged altitude and distance which resulted in the collision with trees short of the runway.
- [NTSB IAD96LA117](https://openairdocs.org/ntsb/IAD96LA117.md): Beech A100 · Manchester, NH · Accident · No injuries · Limited investigation · Final report · Jul 15, 1996 · N4391W · Substantial damage
  > The pilots failure to maintain control of the aircraft during a coupled approach. A related factor was the unmonitored inoperative glide slope.
- [NTSB NYC96LA097](https://openairdocs.org/ntsb/NYC96LA097.md): Piper PA-22-150 · Chester, NH · Accident · Serious injuries · Limited investigation · Final report · May 3, 1996 · N2946P · Substantial damage
  > The pilot's misjudged distance and altitude during final approach.
- [NTSB NYC96LA050](https://openairdocs.org/ntsb/NYC96LA050.md): Cessna 172M · Nashua, NH · Accident · No injuries · Limited investigation · Final report · Jan 14, 1996 · N61765 · Substantial damage
  > the pilot's inadequate crosswind compensation during the go-around.
- [NTSB NYC95DNC01](https://openairdocs.org/ntsb/NYC95DNC01.md): Wyman Scorpion II · Cornish Flat, NH · Accident · No injuries · Final report · Dec 28, 1994 · N65562 · Destroyed
  > Partial failure and subsequent partial separation of skin on the underside of one main rotor blade, which resulted in a severe vibration, in-flight loss of aircraft control, and impact with the ground during an attempted autorotation.
- [NTSB BFO94LA081](https://openairdocs.org/ntsb/BFO94LA081.md): Cessna 150K · Hollis, NH · Accident · Serious injuries · Limited investigation · Final report · Apr 30, 1994 · N5907G · Substantial damage
  > The pilot's inadequate preflight inspection which failed to detect contaminated fuel which resulted in fuel starvation.
- [NTSB NYC93LA078](https://openairdocs.org/ntsb/NYC93LA078.md): Cessna 172 · Durham, NH · Accident · Serious injuries · Limited investigation · Final report · Apr 10, 1993 · N8228G · Substantial damage
  > Improper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power. Factors related to the accident were flight into adverse weather conditions, failure to obtain inflight weather information, and pilot fatigue.
- [NTSB NYC93LA041](https://openairdocs.org/ntsb/NYC93LA041.md): Cessna T210 · Londonderry, NH · Accident · Minor injuries · Limited investigation · Final report · Dec 13, 1992 · N210PQ · Substantial damage
  > The pilot's inadequate inflight decision which resulted in fuel exhaustion and the loss of engine power. Contributing was the pilot's inadequate preflight planning and preparation.
- [NTSB NYC92LA154](https://openairdocs.org/ntsb/NYC92LA154.md): Cessna 172N · Keene, NH · Accident · Minor injuries · Limited investigation · Final report · Aug 10, 1992 · N738FW · Substantial damage
  > An inadvertent stall during flap retraction, following an aborted landing.
- [NTSB NYC90DNC01](https://openairdocs.org/ntsb/NYC90DNC01.md): Cessna 180E · Kingston, NH · Accident · Serious injuries · Final report · Sep 26, 1990 · N2620Y · Destroyed
  > An inflight collision with water while maneuvering for a forced landing. A factor to the accident was a power loss due to the pilot's improper use of the mixture control.
- [NTSB NYC89LA208](https://openairdocs.org/ntsb/NYC89LA208.md): Piper PA-32RT-300T · Wolfeboro, NH · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 1989 · N21353 · Destroyed
  > Inadequate compensation for wind conditions by the owner/pilot-in-command (PIC), his failue to maintain proper altitude on the approach, and failure of the other pilot (owner's instructor pilot) to take remedial action. Factors related to the accident were:…
- [NTSB NYC88LA243](https://openairdocs.org/ntsb/NYC88LA243.md): Piper PA-28-181 · Keene, NH · Accident · Serious injuries · Limited investigation · Final report · Sep 26, 1988 · N8289T · Destroyed
  > The plt received a head inj and was not able to relate the details of the acdt. The acft crashed into trees about 3 mi short of the landing rwy at the conclusion of a cross country flt. An FAA insp examined the wreckage and reported that the fuel selector was…
- [NTSB NYC87DNC08](https://openairdocs.org/ntsb/NYC87DNC08.md): Cessna R172K · Cantebury, NH · Accident · 1 fatal · Final report · Jul 17, 1987 · N4673K · Destroyed
  > A local CFI heard the plt transmit over the UNICOM freq that he was 'north of the airport at 1100 ft & out of gas, so I guess I'm going to crash.' Attempts to contact the plt were unsuccessful. The CFI flew north of the airport & located the plane where it…
- [NTSB NYC87LA137](https://openairdocs.org/ntsb/NYC87LA137.md): Stearman PT-17 · Hampton, NH · Accident · No injuries · Limited investigation · Final report · May 1, 1987 · N3993P · Substantial damage
  > While on final approach, the plt stated that the acft encountered a moderate crosswind. At abt mid-field, the plt elected to make a go-around, however, due to windshear and/or downdrafts, the acft was unable to climb. The Stearman collided with several tall…
- [NTSB NYC86DNC06](https://openairdocs.org/ntsb/NYC86DNC06.md): Hansen Hawk 304 · Wolfeboro, NH · Accident · Minor injuries · Final report · Jul 22, 1986 · N13CH · Substantial damage
  > The experimental aircraft equipped with a buick V-8 aluminum block engine experienced power loss on approach for landing. The pilot decided that the distance and terrain was too great for a glide to the airport, and an emergency water landing in a nearby lake…
- [NTSB NYC86LA161](https://openairdocs.org/ntsb/NYC86LA161.md): Alon A2 · South Sutton, NH · Accident · Minor injuries · Limited investigation · Final report · Jun 28, 1986 · N5474E · Destroyed
  > The plt rprtd that during a landing, the flight encountered a severe downdraft and impacted the ground hard, collapsing the nose gear and incurring other damage to the aircraft.
- [NTSB NYC86LA129](https://openairdocs.org/ntsb/NYC86LA129.md): Cessna 150K · North Hampton, NH · Accident · Minor injuries · Limited investigation · Final report · May 18, 1986 · N5744G · Substantial damage
  > The acft settled into trees during a landing apch. The plt reported that he added full power with the carburetor heat off and was still unable to stop the descent. When flt checked by the FAA, the plts slow flt and stall recovery procedures were found to be…
- [NTSB NYC86FA023](https://openairdocs.org/ntsb/NYC86FA023.md): Cessna 172N · Rochester, NH · Accident · 2 fatal · Field investigation · Final report · Oct 27, 1985 · N734PX · Destroyed
  > During landing approach to runway 32, the aircraft started to porpoise over the runway. The aircraft continued in this manner until it neared the end of the runway. The aircraft then started a slow climbing right turn just clearing nearby trees. The…
- [NTSB NYC86LA004](https://openairdocs.org/ntsb/NYC86LA004.md): Cessna 140 · Newport, NH · Accident · No injuries · Limited investigation · Final report · Oct 7, 1985 · N77110 · Substantial damage
  > Acft 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 NYC85LA160](https://openairdocs.org/ntsb/NYC85LA160.md): Cessna 182P · Newport, NH · Accident · No injuries · Limited investigation · Final report · Jun 19, 1985 · N9977E · Substantial damage
  > The acft collided with trees during an attempted go-around following a loss of directional control. The plt was advised by UNICOM that a 'bit of a crosswind' existed at the arpt. The plt initiated a go-around after a gust of wind was misaligned the acft…
- [NTSB NYC85FA109](https://openairdocs.org/ntsb/NYC85FA109.md): Piper PA-28-140 · No. Hampton, NH · Accident · 2 fatal · Field investigation · Final report · Apr 20, 1985 · N95043 · Destroyed
  > On April 20, 1985, a Piper PA-28-140, flown by a student plt, crashed during an attempted go-around at north Hampton, NH, while on a pleasure flt. The wx was clear, winds were light and variable with unlimited visibility. The tough rwy is 2050 ft long and 300…
- [NTSB NYC85FA060](https://openairdocs.org/ntsb/NYC85FA060.md): Piper PA-31-350 · Whitefield, NH · Accident · 4 fatal · Field investigation · Final report · Feb 2, 1985 · N27522 · Destroyed
  > The acft crashed after executing a missed approach at Whitefield during IMC wx. The acft was seen at 300-400 ft AGL during some part of the maneuvering near the arpt. The acft seemed to be heading for the arpt when last seen by ground observers. The only…
- [NTSB NYC85FNC02](https://openairdocs.org/ntsb/NYC85FNC02.md): Piper PA-34-200T · Hopkinton, NH · Accident · Serious injuries · Final report · Jan 1, 1985 · N47364 · Destroyed
  > The acft collided with a tree during an ILS approach in IMC wx. The acft was on a x-cty flt and the plt declared a missed approach at this pt but did not acknowledge hitting the tree. When the rt eng quit and directional control could not be maintained the…
- [NTSB NYC84FA269](https://openairdocs.org/ntsb/NYC84FA269.md): Piper PA-46-310P · Richmond, NH · Accident · 1 fatal · Field investigation · Final report · Aug 13, 1984 · N4323G · Destroyed
  > The plt was flying inbound for the ILS rwy 02 apch via the gardner VOR transition. While on the transition, the acft descended below the 4000 ft MSL min alt to 2600 ft MSL. The plt was alerted by ATC. He responded that his chart read 3000 ft. the acft then…
- [NTSB NYC84LA261](https://openairdocs.org/ntsb/NYC84LA261.md): Teal TSC 1A · Moultonboro, NH · Accident · No injuries · Limited investigation · Final report · Aug 3, 1984 · N2002T · Substantial damage
  > The acft struck the tail of an acft as it was beginning to proceed in a go-around. The plt said he was unaware of the collision with the parked acft until the subsequent landing. The collision was the result of the acft in flt drifting downwind off the rwy…
- [NTSB NYC83LA159](https://openairdocs.org/ntsb/NYC83LA159.md): Cessna 150 · Nashua, NH · Accident · Minor injuries · Limited investigation · Final report · Jun 30, 1983 · N11394 · Substantial damage
  > The 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 NYC82FA181](https://openairdocs.org/ntsb/NYC82FA181.md): Piper PA-28-161 · Concord, NH · Accident · 2 fatal · Field investigation · Final report · Aug 4, 1982 · N81786 · Destroyed
  > The 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 NYC82DNC08](https://openairdocs.org/ntsb/NYC82DNC08.md): Schleicher ASW-19 · Moultonboro, NH · Accident · Serious injuries · Final report · Apr 25, 1982 · N79RC · Destroyed
  > Several 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…

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?state=NH&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?state=NH

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.