# NTSB investigations, NH: Initial climb

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 · 98 cases

## Latest cases

- [NTSB ERA24FA003](https://openairdocs.org/ntsb/ERA24FA003.md): Bell Helicopter Textron Canada 407 · Croydon, NH · Accident · 1 fatal · Class 3 · Field · Final report · Oct 8, 2023 · N802JR · Substantial damage
  > The pilot’s loss of control during the initial climb in dark night conditions due to spatial disorientation, which resulted in a steep banking descent into trees and terrain. Contributing to the accident was the pilot’s lack of recent night flight experience,…
- [NTSB ERA21LA008](https://openairdocs.org/ntsb/ERA21LA008.md): Experimental Quad City Challenger II · Northfield, NH · Accident · No injuries · Class 3 · Limited · Final report · Oct 3, 2020 · N129AY · Substantial damage
  > A total loss of engine power due to oil starvation of the No. 1 cylinder. Contributing to the accident was the pinched No. 1 cylinder oil injection line.
- [NTSB ERA16LA330](https://openairdocs.org/ntsb/ERA16LA330.md): Tatkovsky James G Safari · Andover, NH · Accident · Serious injuries · Limited investigation · Final report · Sep 27, 2016 · N330JT · Destroyed
  > The noncertificated pilot’s failure to maintain helicopter control during initial climb.
- [NTSB ERA16LA220](https://openairdocs.org/ntsb/ERA16LA220.md): Champion 7AC · Gorham, NH · Accident · No injuries · Class 3 · Limited · Final report · Jun 16, 2016 · N83578 · Substantial damage
  > The partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s failure to abort the takeoff after the airplane’s initial failure to climb.
- [NTSB ERA15FA241](https://openairdocs.org/ntsb/ERA15FA241.md): Piper PA-22 · Laconia, NH · Accident · Serious injuries · Field investigation · Final report · Jun 18, 2015 · N2569P · Substantial damage
  > A total loss of engine power for reasons that could not be determined because of insufficient evidence found during postaccident examination of the airframe and engine.
- [NTSB ERA14FA417](https://openairdocs.org/ntsb/ERA14FA417.md): Cessna 180 · North Hampton, NH · Accident · 2 fatal · Field investigation · Final report · Sep 1, 2014 · N6510A · Substantial damage
  > The pilot’s failure to ensure the airplane maintained adequate airspeed during the initial climb and the subsequent exceedance of its critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident were the pilot’s impairment…
- [NTSB ERA13CA350](https://openairdocs.org/ntsb/ERA13CA350.md): Cessna 172S · Portsmouth, NH · Accident · No injuries · Data collection · Final report · Aug 3, 2013 · N645PD · Substantial damage
  > The pilot’s inadequate preflight inspection resulting in his failure to remove the pin he used to lock the flight controls in place of the approved control lock.
- [NTSB ERA09FA343](https://openairdocs.org/ntsb/ERA09FA343.md): Cessna 177 RG · Gilford, NH · Accident · 1 fatal · Field investigation · Final report · Jun 13, 2009 · N52670 · Substantial damage
  > A loss of engine power due to oil exhaustion from the fracture of the nipple for the engine oil cooler return line. Contributing to the accident was the mechanic's signoff and release of the airplane without performing the required engine run-up following an…
- [NTSB ERA09CA014](https://openairdocs.org/ntsb/ERA09CA014.md): Piper J3C-50 · Epping, NH · Accident · Serious injuries · Data collection · Final report · Oct 12, 2008 · N23267 · Substantial damage
  > The pilot's improper preflight inspection and his decision to fly an unairworthy airplane.
- [NTSB NYC07CA230](https://openairdocs.org/ntsb/NYC07CA230.md): Grenier Kitfox IV · Moultonboro, NH · Accident · No injuries · Data collection · Final report · Sep 16, 2007 · N20577 · Substantial damage
  > The failure of both spark plugs in the number 3 cylinder which resulted in a partial loss of engine power.
- [NTSB NYC06CA047](https://openairdocs.org/ntsb/NYC06CA047.md): Cessna 180H · Greenville, NH · Accident · Minor injuries · Data collection · Final report · Dec 28, 2005 · N2869U · Substantial damage
  > The pilot's inadequate pre-flight inspection, which resulted in water-contaminated fuel in the engine and subsequent engine failure.
- [NTSB NYC05CA004](https://openairdocs.org/ntsb/NYC05CA004.md): Boeing Stearman B75-N1 · Jaffery, NH · Accident · Minor injuries · Data collection · Final report · Oct 9, 2004 · N49738 · Substantial damage
  > The pilots inadvertent encounter with a downdraft wind condition and the airplane's inability to climb, which resulted in a forced landing. A factor related to the accident was the downdraft wind conditions.
- [NTSB NYC04LA160](https://openairdocs.org/ntsb/NYC04LA160.md): Piper PA-12 · Jaffrey, NH · Accident · Serious injuries · Limited investigation · Final report · Jul 7, 2004 · N2489M · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB NYC02FA178](https://openairdocs.org/ntsb/NYC02FA178.md): Beechcraft 58P · Swanzey, NH · Accident · 7 fatal · Field investigation · Final report · Sep 2, 2002 · N6688D · Destroyed
  > **This report was modified on 2/24/2016. Refer to the public docket for this accident for additional information.** the pilot's improper preflight planning and his decision to depart with known landing gear system mechanical deficiencies, which resulted in a…
- [NTSB NYC01LA139](https://openairdocs.org/ntsb/NYC01LA139.md): Cessna 172M · Nashua, NH · Accident · No injuries · Limited investigation · Final report · Jun 7, 2001 · N6863H · Substantial damage
  > The CFI's improper decision to abort the takeoff and his improper flare, which resulted in a hard landing.
- [NTSB NYC01LA086](https://openairdocs.org/ntsb/NYC01LA086.md): Robinson R-22B · Keene, NH · Accident · Minor injuries · Limited investigation · Final report · Feb 19, 2001 · N910SM · Substantial damage
  > inadequate visual lookout by the flight instructor on the helicopter's proximity to the snowbank, and subsequent lift off, which resulted in a dynamic rollover.
- [NTSB NYC00LA186](https://openairdocs.org/ntsb/NYC00LA186.md): Helfer Flightstar II · Greenland, NH · Accident · No injuries · Limited investigation · Final report · Jul 9, 2000 · N6057U · Substantial damage
  > The pilot-in-command's improper decision to takeoff uphill, on a short runway with 50-foot high utility wires at the end, at a high gross weight. Factors were the high weight and uphill terrain.
- [NTSB NYC00LA072](https://openairdocs.org/ntsb/NYC00LA072.md): Piper PA-24 · Alton Bay, NH · Accident · No injuries · Limited investigation · Final report · Feb 5, 2000 · N6577P · Substantial damage
  > The pilot's failure to maintain control of the airplane during takeoff which resulted in an inadvertent stall. A factor in the accident was the pilot's inadequate compensation for the wind conditions.
- [NTSB NYC00LA002](https://openairdocs.org/ntsb/NYC00LA002.md): Cessna 172 · Wolfeboro, NH · Accident · Minor injuries · Limited investigation · Final report · Oct 2, 1999 · N6921X · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB IAD99FA025](https://openairdocs.org/ntsb/IAD99FA025.md): Lake LA-4-250 · Laconia, NH · Accident · 1 fatal · Field investigation · Final report · Jan 4, 1999 · N14001 · Destroyed
  > A loss of engine power during initial climb due to oil starvation. Contributing to the accident was the failure to perform an engine overhaul.
- [NTSB NYC97LA163](https://openairdocs.org/ntsb/NYC97LA163.md): Elliot Monnett Moni · Hollis, NH · Accident · 1 fatal · Limited investigation · Final report · Aug 9, 1997 · N2400M · Destroyed
  > The pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall spin and collision with terrain.
- [NTSB NYC97LA152](https://openairdocs.org/ntsb/NYC97LA152.md): Kenneson Merlin GT · Kensington, NH · Accident · Serious injuries · Limited investigation · Final report · Jul 23, 1997 · N912AK · Substantial damage
  > the pilot's inability to obtain and/or maintain control of the airplane after takeoff.
- [NTSB IAD97LA075](https://openairdocs.org/ntsb/IAD97LA075.md): Cessna 180J · Lebanon, NH · Accident · No injuries · Limited investigation · Final report · May 14, 1997 · N4992V · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB NYC97LA070](https://openairdocs.org/ntsb/NYC97LA070.md): Cessna 150E · Wolfeboro, NH · Accident · No injuries · Limited investigation · Final report · Apr 5, 1997 · N6106T · Substantial damage
  > The pilot's improper preflight, and failure to refuel the airplane, which resulted in fuel exhaustion during the initial climb after takeoff, and the subsequent forced landing and collision with a mound of dirt.
- [NTSB NYC96LA187](https://openairdocs.org/ntsb/NYC96LA187.md): Cessna 180K · Derry, NH · Accident · No injuries · Limited investigation · Final report · Sep 20, 1996 · N2738K · Substantial damage
  > the pilot's inadequate preflight inspection, which failed to detect water contaminated fuel, and resulted in a loss of engine power. A factor relating to the accident was: the pilot's operation of the aircraft with a known deficiency that consisted of a fuel…
- [NTSB IAD96FA138](https://openairdocs.org/ntsb/IAD96FA138.md): Piper PA-24-180 · Whitefield, NH · Accident · 4 fatal · Field investigation · Final report · Aug 20, 1996 · N7635P · Destroyed
  > the pilot's failure to adequately preflight the aircraft which led to the loss of engine power due to fuel exhaustion, and the pilot's attempt to return to the airport by executing a steep left turn which led to a stall and subsequent loss of control of the…
- [NTSB NYC96LA001](https://openairdocs.org/ntsb/NYC96LA001.md): Cheney Avid Flyer · Newton, NH · Accident · No injuries · Limited investigation · Final report · Oct 2, 1995 · N29GC · Substantial damage
  > The seizure of a piston during the takeoff climb, resulting in a loss of engine power, forced landing, and subsequent collision with trees.
- [NTSB NYC95LA028](https://openairdocs.org/ntsb/NYC95LA028.md): Rans/Hine S-10 · Hampton, NH · Accident · No injuries · Limited investigation · Final report · Oct 15, 1994 · N104AH · Substantial damage
  > a seized piston in the foward cylinder due to a lean mixture.
- [NTSB BFO94LA146](https://openairdocs.org/ntsb/BFO94LA146.md): Advanced Acft Waco 10 GXE · Rochester, NH · Accident · Serious injuries · Limited investigation · Final report · Aug 24, 1994 · NC5852 · Destroyed
  > the partial loss of engine power for undetermined reasons. Related factors were unsuitable terrain (trees) and the inadvertent stall.
- [NTSB NYC94FA029](https://openairdocs.org/ntsb/NYC94FA029.md): Aerospatiale TB-21 · Lebanon, NH · Accident · 2 fatal · Field investigation · Final report · Dec 2, 1993 · N28163 · Destroyed
  > The pilot's failure to maintain adequate terrain clearance which resulted in an inflight collision with the terrain. A factor was a dark night condition.
- [NTSB BFO93FA103](https://openairdocs.org/ntsb/BFO93FA103.md): Cessna 180K · Webster, NH · Accident · 2 fatal · Field investigation · Final report · Jul 1, 1993 · N2880K · Destroyed
  > The pilot's inadequate preflight planning/preparation, his failure to assure proper weight and balance of the aircraft for takeoff, and his failure to obtain and/or maintain adequate airspeed, which resulted in a stall. A possible factor related to the…
- [NTSB BFO93LA020](https://openairdocs.org/ntsb/BFO93LA020.md): Dornier DO-228-202 · Manchester, NH · Accident · No injuries · Limited investigation · Final report · Jan 10, 1993 · N245RP · Substantial damage
  > Incorrect installation of the seals in the nose gear assembly, which prevented the nose gear from locking in the down position.
- [NTSB BFO92LA099](https://openairdocs.org/ntsb/BFO92LA099.md): Piper PA28-161 · Brentwood, NH · Accident · Serious injuries · Limited investigation · Final report · Jul 12, 1992 · N31683 · Destroyed
  > A delay by the pilot in aborting the landing which resulted in failure to clear the obstacles.
- [NTSB NYC91DNC05](https://openairdocs.org/ntsb/NYC91DNC05.md): Homebuilt Avid Flyer · Keene, NH · Accident · No injuries · Final report · Sep 6, 1991 · N91JK · Substantial damage
  > A loss of control due to improper use of the flight controls. Factors related to the accident were the pilot's lack of experience in make and model.
- [NTSB NYC91LA221](https://openairdocs.org/ntsb/NYC91LA221.md): Grumman AA5B · Hampton, NH · Accident · No injuries · Limited investigation · Final report · Aug 25, 1991 · N4518B · Substantial damage
  > The pilot rotated the airplane prematurely, resulting in an inadvertent stall at too low an altitude to allow recovery. Factors related to the accident were, the pilot's complacency, failure to determine the airplane's performance capabilities prior to take…
- [NTSB NYC91DNC04](https://openairdocs.org/ntsb/NYC91DNC04.md): Laurent A. Cloutier BD-5B · Gilford, NH · Accident · Minor injuries · Final report · Aug 3, 1991 · N245BD · Substantial damage
  > Engine failure due to a faulty oil pressure relief valve resulting in an emergency landing on unsuitable terrain.
- [NTSB NYC91LA070](https://openairdocs.org/ntsb/NYC91LA070.md): Cessna 172M · Nashua, NH · Accident · No injuries · Limited investigation · Final report · Feb 2, 1991 · N13341 · Substantial damage
  > Fuel system contamination by other personnel which resulted in an inflight engine failure and a subsequent forced landing in unsuitable terrain.
- [NTSB NYC91DNC02](https://openairdocs.org/ntsb/NYC91DNC02.md): Marier Early Bird Jenny · Concord, NH · Accident · Serious injuries · Final report · Nov 3, 1990 · N7165Y · Destroyed
  > The failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall spin. A factor related to the accident was: the pilot's lack of experience in the make and model of aircraft.
- [NTSB NYC89LA048](https://openairdocs.org/ntsb/NYC89LA048.md): Enstrom F28F · Bradford, NH · Accident · Serious injuries · Limited investigation · Final report · Dec 12, 1988 · N5699M · Substantial damage
  > An inflight contact with trees during takeoff after the student pilot experienced a loss of control due to his failure to adequately compensate for the winds.
- [NTSB NYC89LA002](https://openairdocs.org/ntsb/NYC89LA002.md): Beech V35A · Derry, NH · Accident · Serious injuries · Limited investigation · Final report · Oct 2, 1988 · N2715A · Destroyed
  > The acft collided with trees after takeoff from a private airstrip with a rwy which has 1,200 feet useable length. The field elev is 425 ft and the plt EST the temp to be 60 deg f. the plt said the takeoff was made to the NE. The wind was reported to be out…
- [NTSB NYC88LA219](https://openairdocs.org/ntsb/NYC88LA219.md): Piper PA-12 · Georges Mills, NH · Accident · Minor injuries · Limited investigation · Final report · Aug 16, 1988 · N2906M · Substantial damage
  > Witnesses reported the wind was gusty and there were whitecaps on the lake when the acft attempted to takeoff. The plt said that when the acft had climbed to a sufficient altitude he began a left turn to climb over the lake. After the turn was started the…
- [NTSB NYC88LA190](https://openairdocs.org/ntsb/NYC88LA190.md): Waco UPF-7 · Greenland, NH · Accident · No injuries · Limited investigation · Final report · Jul 21, 1988 · N20973 · Substantial damage
  > The intention of the flight was to give people at an annual company picnic a ride in the aircraft. After takeoff and while starting a left turn the pilot stated that he encountered a 'sudden windshear/downdraft.' The aircraft never got above 200 feet and…
- [NTSB NYC88LA179](https://openairdocs.org/ntsb/NYC88LA179.md): Waco UPF-7 · Plymouth, NH · Accident · No injuries · Limited investigation · Final report · Jul 9, 1988 · N32126 · Substantial damage
  > The plt reported that the eng lost power during takeoff as the acft was climbing thru about 200 to 250 ft AGL. Unable to restore power, he turned to land in a corn field, but was unable to reach it. He then selected a smaller field, but during the landing,…
- [NTSB NYC88LA161](https://openairdocs.org/ntsb/NYC88LA161.md): Burkhart Grob G-103A · Franconia, NH · Accident · No injuries · Limited investigation · Final report · Jun 5, 1988 · N49443 · Substantial damage
  > During takeoff, turbulence was encountered and the student pilot had a hard time controlling the glider. As the instructor took control, the student released the tow rope. The instructor pushed the nose down and turned in an attempt to level the wings, but…
- [NTSB NYC88LA154](https://openairdocs.org/ntsb/NYC88LA154.md): Bellanca 8GCBC · Kensington, NH · Accident · No injuries · Limited investigation · Final report · May 28, 1988 · N7672S · Substantial damage
  > Upon reaching the destination airport, the pilot decided to do a few touch and go landings. The aircraft touched down about 600 feet downfield at about 45-50 mph. The pilot reported that with application of full throttle, the engine hesitated. The aircraft…
- [NTSB NYC88LA120](https://openairdocs.org/ntsb/NYC88LA120.md): Piper PA-28R · Manchester, NH · Accident · Serious injuries · Limited investigation · Final report · Apr 1, 1988 · CFQQW · Destroyed
  > A flight to burlington, Vermont was uneventful. While on the ground at burlington the aircraft was serviced; then the flight was continued. After about one hour of flight, high engine temperature and low oil pressure was experienced and the aircraft landed at…
- [NTSB NYC86LA211](https://openairdocs.org/ntsb/NYC86LA211.md): Grumman AA-1B · Moultonboro, NH · Accident · No injuries · Limited investigation · Final report · Aug 16, 1986 · N9909L · Substantial damage
  > The plt rprtd that he departed the Moultonboro arpt at about 2200 EDT. During departure, the acft stalled & crashed into trees about 1/2 mi northwest of the arpt.
- [NTSB NYC85LA234](https://openairdocs.org/ntsb/NYC85LA234.md): Piper PA-32-260 · East Swanzey, NH · Accident · No injuries · Limited investigation · Final report · Sep 12, 1985 · N42722 · Destroyed
  > The acft was preflighted & determined to have 10 qts of oil in the eng. While climbing thru about 1000 ft MSL after takeoff, the propeller RPM began rising to the redline. The plt reduced power & proceeded to make an emerg landing. During a turn toward the…
- [NTSB NYC85FNC06](https://openairdocs.org/ntsb/NYC85FNC06.md): Piper PA-11 · Moultonboro, NH · Accident · Serious injuries · Final report · Jul 21, 1985 · N4810M · Destroyed
  > The 65 HP acft took off from a cove and during a turn at about 150 ft AGL the acft nosed dwn after rolling rt. The acft struck the water in a steep nose down attitude. According to witnesses, the bng was running normally during the climb and descent. No…
- [NTSB NYC85LA018](https://openairdocs.org/ntsb/NYC85LA018.md): Beech G18S · Laconia, NH · Accident · Minor injuries · Limited investigation · Final report · Nov 2, 1984 · N32809 · Destroyed
  > According to the plt, shortly after takeoff the acft began to pitch up, decelerate, and roll right. He reduced power and lowered the nose in an unsuccessfull attempt to regain control. There were no mechanical malfunctions reported.

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

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