# NTSB investigations, NH: Enroute

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 3 · 133 cases

## Latest cases

- [NTSB ERA25LA265](https://openairdocs.org/ntsb/ERA25LA265.md): Moyes Liteflite PTY C Dragonfly · Charlestown, NH · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 13, 2025 · N4010E · Substantial damage
  > On July 13, 2025, about 1915 eastern daylight time, a Moyes Liteflite Model C Dragonfly airplane, N4010E, was substantially damaged when it was involved in an accident near Charleston, New Hampshire. The pilot was seriously injured. The airplane was operated…
- [NTSB ERA24LA276](https://openairdocs.org/ntsb/ERA24LA276.md): Snyder Searey · New Ipswich, NH · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 25, 2024 · N453TS · Substantial damage
  > A total loss of engine power due to the exhaust muffler and tailpipe assembly separating from its attach points and impacting the propeller.
- [NTSB ENG20IA006](https://openairdocs.org/ntsb/ENG20IA006.md): De Havilland DHC8 · Keene, NH · Incident · No injuries · Class 3 · Incident · Final report · Dec 9, 2019 · C-GNON · Minor damage
  > The arcing failure of the windshield heat L2 power wire on the right windshield due to unknown reasons.
- [NTSB GAA19CA168](https://openairdocs.org/ntsb/GAA19CA168.md): Hughes TH 55 · Keene, NH · Accident · No injuries · Data collection · Final report · Mar 13, 2019 · N8045H · Substantial damage
  > The helicopter’s collision with a bird during cruise flight.
- [NTSB ERA17FA241](https://openairdocs.org/ntsb/ERA17FA241.md): Extra Flugzeugbau EA 300/L · Winchester, NH · Accident · 1 fatal · Field investigation · Final report · Jul 13, 2017 · N210MX · Destroyed
  > The noninstrument-rated pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and collision with terrain. Contributing to the accident was the pilot's self-induced pressure to complete…
- [NTSB GAA16CA432](https://openairdocs.org/ntsb/GAA16CA432.md): Cessna 150 · North Conway, NH · Accident · No injuries · Data collection · Final report · Aug 15, 2016 · N7157X · Substantial damage
  > The pilot's improper fuel management, which resulted in fuel exhaustion, a total loss of engine power, a forced landing, and nose over.
- [NTSB GAA16CA016](https://openairdocs.org/ntsb/GAA16CA016.md): Central Missouri State Univ HP 14 · Jackson, NH · Accident · No injuries · Data collection · Final report · Oct 14, 2015 · N102MW · Substantial damage
  > The glider pilot's decision to descend into a broken to overcast cloud layer, which resulted in encountering instrument meteorological conditions and the pilot parachuting from the glider. Contributing to the accident was the pilot's lack of planning for an…
- [NTSB ERA15LA072](https://openairdocs.org/ntsb/ERA15LA072.md): Cessna 150J · Brookline, NH · Accident · Minor injuries · Limited investigation · Final report · Dec 5, 2014 · N50709 · Substantial damage
  > The student pilot’s failure to maintain clearance from a wire during an off-airport landing following a partial loss of engine power for reasons that could not be determined during postaccident examination.
- [NTSB ERA13LA327](https://openairdocs.org/ntsb/ERA13LA327.md): Univair 108-1 · Tuftonboro, NH · Accident · Minor injuries · Limited investigation · Final report · Jul 17, 2013 · N8721K · Substantial damage
  > Maintenance personnel’s failure to remove circumferential gouges in the aft radius of the R2 rod journal on the crankshaft during its last engine overhaul, which resulted in the fatigue failure of the crankshaft and a subsequent total loss of engine power.
- [NTSB ERA13FA039](https://openairdocs.org/ntsb/ERA13FA039.md): Beech A36 · Hooksett, NH · Accident · 2 fatal · Field investigation · Final report · Oct 25, 2012 · N4325W · Substantial damage
  > The pilot's total incapacitation in flight due to an acute heart attack.
- [NTSB ERA12LA332](https://openairdocs.org/ntsb/ERA12LA332.md): Stinson SR-7B · West Ossipee, NH · Accident · Serious injuries · Limited investigation · Final report · May 13, 2012 · N16122 · Substantial damage
  > The pilot's inadequate application of carburetor heat which resulted in the formation of carburetor ice and a partial loss of engine power.
- [NTSB ERA09LA511](https://openairdocs.org/ntsb/ERA09LA511.md): Air Creation 582SL · Strafford, NH · Accident · Minor injuries · Limited investigation · Final report · Sep 5, 2009 · N699AC · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB ERA09LA105](https://openairdocs.org/ntsb/ERA09LA105.md): Bell 407 · Bow, NH · Accident · Serious injuries · Limited investigation · Final report · Dec 22, 2008 · N407GB · Substantial damage
  > An interruption of fuel flow for undetermined reasons, which resulted in an engine flameout.
- [NTSB ERA09LA021](https://openairdocs.org/ntsb/ERA09LA021.md): Steele John J Acro Sport · Madison, NH · Accident · No injuries · Limited investigation · Final report · Oct 15, 2008 · N896JC · Substantial damage
  > The loss of engine power due to carburetor icing as a result of the pilot's failure to apply carburetor heat
- [NTSB NYC06FA027](https://openairdocs.org/ntsb/NYC06FA027.md): Embraer 110P1 · Manchester, NH · Accident · Serious injuries · Field investigation · Final report · Nov 8, 2005 · N7801Q · Destroyed
  > The pilot’s misapplication of flight controls following an engine failure. Contributing to the accident was the failure of the sun gear, which resulted in the loss of engine power. Contributing to the sun gear failure were the engine manufacturer’s…
- [NTSB NYC05LA130](https://openairdocs.org/ntsb/NYC05LA130.md): Raytheon A36 · Nashua, NH · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 2005 · N838DM · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion, and subsequent collision with trees during a forced landing.
- [NTSB IAD05LA114](https://openairdocs.org/ntsb/IAD05LA114.md): Convair BT-13A · Lyme, NH · Accident · 2 fatal · Limited investigation · Final report · Aug 3, 2005 · N49646 · Destroyed
  > The pilot's improper fuel management which resulted in an incorrect fuel selector position, fuel starvation, and subsequent loss of engine power. A factor in the accident was the pilot's failure to maintain adequate airspeed and inadvertent stall.
- [NTSB IAD05LA089](https://openairdocs.org/ntsb/IAD05LA089.md): Longtin Kitfox Model III · New London, NH · Accident · 1 fatal · Limited investigation · Final report · Jul 2, 2005 · N795JL · Substantial damage
  > The pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor in the accident was the tail wind condition.
- [NTSB NYC05FA042](https://openairdocs.org/ntsb/NYC05FA042.md): Embraer EMB-110P1 · Swanzey, NH · Accident · 1 fatal · Field investigation · Final report · Jan 14, 2005 · N49BA · Destroyed
  > The pilot's improper decision to attempt a single-engine missed approach with the airplane in a slow airspeed, full flap configuration, which resulted in a minimum control speed (Vmc) roll. Contributing factors included an inoperative engine for undetermined…
- [NTSB NYC04FA157](https://openairdocs.org/ntsb/NYC04FA157.md): Lake LA-4-200 · Wilmot, NH · Accident · 1 fatal · Field investigation · Final report · Jul 5, 2004 · N6248V · Substantial damage
  > The pilot's continued VFR flight into IMC conditions, and his failure to maintain terrain clearance, which resulted in a controlled flight into terrain. Factors in the accident were the low cloud ceiling and the pilot's lack of recent instrument time.
- [NTSB NYC02LA002](https://openairdocs.org/ntsb/NYC02LA002.md): Beech C-45H · Hudson, NH · Accident · Minor injuries · Limited investigation · Final report · Oct 2, 2001 · N8393H · Substantial damage
  > The pilot/owner's failure to properly identify the inoperative engine prior to feathering the wrong propeller, and his lack of familiarity with the required corrective procedures. A factor was the initial engine failure.
- [NTSB NYC01FA056](https://openairdocs.org/ntsb/NYC01FA056.md): Cessna 310Q · Chesterfield, NH · Accident · 1 fatal · Field investigation · Final report · Dec 14, 2000 · N55QS · Destroyed
  > The pilot's continued flight into icing conditions, and his failure to use alternate air. A factor was the icing conditions.
- [NTSB NYC99LA200](https://openairdocs.org/ntsb/NYC99LA200.md): Cessna 208 · Hillsborough, NH · Accident · Minor injuries · Limited investigation · Final report · Aug 13, 1999 · N193GE · Destroyed
  > an inadequate auxiliary fuel tank installation which resulted in a leak of undetermined origin.
- [NTSB NYC99LA068](https://openairdocs.org/ntsb/NYC99LA068.md): Piper PA-28-140 · Wolfeboro, NH · Accident · Serious injuries · Limited investigation · Final report · Feb 28, 1999 · N8790N · Substantial damage
  > The pilot's failure to attain a proper touchdown point. A factor in the accident was the pilot's failure to use a preflight briefing service, resulting in an in flight encounter with snow, and subsequent precautionary landing.
- [NTSB NYC99FA041](https://openairdocs.org/ntsb/NYC99FA041.md): Piper PA-28R-180 · Randolph, NH · Accident · 2 fatal · Field investigation · Final report · Dec 28, 1998 · N4591J · Destroyed
  > The pilot's continued VFR flight into instrument meteorological conditions which led to spatial disorientation and loss of aircraft control. Also causal was the pilot exceeded the design limits of the aircraft which resulted in an in-flight separation.…
- [NTSB IAD99LA002](https://openairdocs.org/ntsb/IAD99LA002.md): Navion A · Jaffrey, NH · Accident · No injuries · Limited investigation · Final report · Oct 3, 1998 · N4285K · Substantial damage
  > The pilot's inadequate aircraft preflight and subsequent failure to refuel the aircraft resulting in fuel exhaustion. A factor was the lack of suitable terrain to execute a forced landing.
- [NTSB NYC98LA152](https://openairdocs.org/ntsb/NYC98LA152.md): Piper PA-28-151 · Newport, NH · Accident · Minor injuries · Limited investigation · Final report · Jul 24, 1998 · N44438 · Destroyed
  > The seizure of the throttle shaft, due to the overhaul facilities' failure to insure all metal fragments had been removed from the carburetor before inserting the throttle shaft after reaming the throttle shaft bushings.
- [NTSB IAD97FA043](https://openairdocs.org/ntsb/IAD97FA043.md): Piper PA-28-236 · Alton, NH · Accident · 2 fatal · Field investigation · Final report · Jan 17, 1997 · N8263Y · Destroyed
  > An exhaust gas leak, due to inadequate maintenance, which resulted in carbon monoxide poisoning, and incapacitation of the pilot.
- [NTSB NYC95LA183](https://openairdocs.org/ntsb/NYC95LA183.md): Beech C23 · Dublin, NH · Accident · No injuries · Limited investigation · Final report · Aug 7, 1995 · N9310S · Substantial damage
  > The loss of engine power due to improper major overhaul of the engine by the reuse of worn piston pins. The rough/ uneven terrain in the emergency landing area was a factor.
- [NTSB NYC95LA055](https://openairdocs.org/ntsb/NYC95LA055.md): Beech C23 · Rochester, NH · Accident · No injuries · Limited investigation · Final report · Feb 15, 1995 · N812Y · Substantial damage
  > The pilot's inadequate inflight planning/decision and inadvertently turning the ignition switch to the off position. A factor was the ignition switch stuck in the off position.
- [NTSB NYC95LA051](https://openairdocs.org/ntsb/NYC95LA051.md): Cessna 152 · Belmont, NH · Accident · No injuries · Limited investigation · Final report · Feb 7, 1995 · N6182P · Substantial damage
  > The pilot's inadequate preflight of the airplane that failed to detect the ice clogged breather which resulted in the loss of oil and a subsequent emergency landing.
- [NTSB NYC95LA004](https://openairdocs.org/ntsb/NYC95LA004.md): Cessna 182N · New London, NH · Accident · No injuries · Limited investigation · Final report · Oct 8, 1994 · N8903G · Substantial damage
  > the failure of the number four push rod, which resulted in the complete loss of engine power and forced landing, and the subsequent nose over on soft terrain.
- [NTSB NYC94LA043](https://openairdocs.org/ntsb/NYC94LA043.md): Beech A-36-TC · Hillsboro, NH · Accident · No injuries · Limited investigation · Final report · Dec 26, 1993 · N3736F · Substantial damage
  > Loss of engine power for undetermined reasons.
- [NTSB BFO92LA110](https://openairdocs.org/ntsb/BFO92LA110.md): Cessna 152 · Belmont, NH · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 1992 · N93361 · Substantial damage
  > Inadequate in-flight planning/decision by the pilot.
- [NTSB BFO92FA094](https://openairdocs.org/ntsb/BFO92FA094.md): Mitsubishi MU-2B-40 · Concord, NH · Accident · 2 fatal · Field investigation · Final report · Jul 9, 1992 · N220MA · Destroyed
  > Loss of control during flight for undetermined reason(s).
- [NTSB NYC92LA045](https://openairdocs.org/ntsb/NYC92LA045.md): Cessna 152 · Orford, NH · Accident · No injuries · Limited investigation · Final report · Dec 11, 1991 · N48156 · Substantial damage
  > The student pilot became lost and disoriented.
- [NTSB NYC91LA200](https://openairdocs.org/ntsb/NYC91LA200.md): Piper PA-12 · Alton, NH · Accident · No injuries · Limited investigation · Final report · Aug 1, 1991 · N4436M · Substantial damage
  > The pilot's improper use of carburetor heat, which resulted in a loss of engine power.
- [NTSB BFO91FA049](https://openairdocs.org/ntsb/BFO91FA049.md): Cessna 172N · Lebanon, NH · Accident · 1 fatal · Field investigation · Final report · May 17, 1991 · N4650G · Destroyed
  > The pilot's failure to maintain adequate terrain clearance. Contributing was mountainous terrain, low clouds, and VFR flight into IMC.
- [NTSB NYC91LA084](https://openairdocs.org/ntsb/NYC91LA084.md): Cessna 210 · East Swanzey, NH · Accident · Minor injuries · Limited investigation · Final report · Mar 7, 1991 · N747IE · Substantial damage
  > The pilot's lack of familiarity with this airplane and his inadequate preflight, which resulted in miscalculations of fuel consumption and subsequent fuel exhaustion. Factors related to this accident were: the leaking of fuel caps, the inaccurate fuel…
- [NTSB NYC91LA029](https://openairdocs.org/ntsb/NYC91LA029.md): Piper PA-32-301R · Alton, NH · Accident · 1 fatal · Limited investigation · Final report · Nov 16, 1990 · N8473H · Substantial damage
  > The total loss of engine power for undetermined reasons. Contributing to the severity of the accident was the unsuitable terrain in which the forced landing was made.
- [NTSB NYC91FA001](https://openairdocs.org/ntsb/NYC91FA001.md): Cessna 172P · Gorham, NH · Accident · 3 fatal · Field investigation · Final report · Oct 2, 1990 · N98438 · Destroyed
  > Improper planning/decision by the pilot, and his failure to maintain proper altitude while flying over mountainous terrain. Factors related to the accident were: darkness, mountainous terrain, and pilot fatigue.
- [NTSB NYC90LA228](https://openairdocs.org/ntsb/NYC90LA228.md): Piper PA-12 · Franconia, NH · Accident · Minor injuries · Limited investigation · Final report · Sep 23, 1990 · N2770M · Substantial damage
  > The landing of the airplane in unsuitable terrain, due to the mechanical failure of the engine center muffler baffle, which blocked the exhaust flow, resulting in a loss of power.
- [NTSB NYC90LA069](https://openairdocs.org/ntsb/NYC90LA069.md): Cessna 172P · Sunapee Lake, NH · Accident · No injuries · Limited investigation · Final report · Feb 9, 1990 · N65057 · Substantial damage
  > Failure of the pilot to maintain adequate altitude above the lake, which resulted in unplanned contact with its frozen surface.
- [NTSB NYC89LA207](https://openairdocs.org/ntsb/NYC89LA207.md): Piper PA-28-180 · Sanbornton, NH · Accident · Minor injuries · Limited investigation · Final report · Sep 2, 1989 · N9334J · Substantial damage
  > VFR flight into instrument meteorological conditions (IMC) by the pilot, and his inadequate remedial action to correct the situation. The adverse weather conditions and darkness were related factors.
- [NTSB NYC89FA206](https://openairdocs.org/ntsb/NYC89FA206.md): Cessna 172P · Northfield, NH · Accident · 4 fatal · Field investigation · Final report · Sep 2, 1989 · N65595 · Destroyed
  > The pilot initiated flight into known adverse weather which resulted in a loss of control. Contributing factor(s) was: the pilot's overconfidence and the existing weather conditions.
- [NTSB NYC89LA181](https://openairdocs.org/ntsb/NYC89LA181.md): Cessna 185D · Wolfeboro, NH · Accident · No injuries · Limited investigation · Final report · Jul 31, 1989 · N1526F · Substantial damage
  > Loss of engine power for an unknown reason. Factors related to the accident were: the obstructions (trees & boats) in the emergency landing area.
- [NTSB NYC89LA044](https://openairdocs.org/ntsb/NYC89LA044.md): Piper PA-34-200 · Laconia, NH · Accident · No injuries · Limited investigation · Final report · Dec 7, 1988 · N16502 · Substantial damage
  > Aircraft striking the road sign after the aircraft experienced a double power loss due to mismanagement of the fuel system by the pilot.
- [NTSB NYC88LA117](https://openairdocs.org/ntsb/NYC88LA117.md): Mooney M20 · Manchester, NH · Accident · No injuries · Limited investigation · Final report · Mar 27, 1988 · N2746W · Substantial damage
  > Maintenance personnel improperly installed the number two connecting rod (p/n L-10646) causing it to separate, create a hole in the engine case, loss of engine oil and engine power. Due to the pilot's improper inflight decision, he performed a wheels up…
- [NTSB NYC88LA008](https://openairdocs.org/ntsb/NYC88LA008.md): Beech F-33A · Concord, NH · Accident · 1 fatal · Limited investigation · Final report · Oct 11, 1987 · N17985 · Destroyed
  > The plt obtained a telephone wx briefing then filed an IFR flt plan for a 1030 EDT departure fm Concord municipal airport. The plt rptd off Concord at 800 ft and climbing at 1047. Manchester departure control acknowledged, assigned a transponder code, and…
- [NTSB NYC87LA263](https://openairdocs.org/ntsb/NYC87LA263.md): Cessna 182 · Kingston, NH · Accident · Serious injuries · Limited investigation · Final report · Sep 29, 1987 · N7388S · Destroyed
  > During flight, the pilot noticed the engine RPM was high. He was unable to control the RPM with the prop control. He reduced the throttle setting, but soon thereafter, the engine began running rough with a severe vibration. The pilot selected a field for an…

Next page: https://openairdocs.org/ntsb-phases/400/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 = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/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.