Fatal NTSB investigations, NH

50 cases where the phase of flight was Enroute.

Cases per year

19642026
Fatal NTSB investigations, NH per year, 1964–2026: 50 cases
19641
19662
19672
19682
19692
19701
19714
19723
19731
19742
19752
19771
19781
19801
19811
19823
19833
19841
19873
19891
19902
19911
19921
19971
19981
20001
20041
20053
20121
20171

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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
  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.

NTSB ERA17FA241Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau EA 300/L · Winchester, NHThe 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…Jul 13, 2017 · N210MX · DestroyedNTSB ERA13FA039Accident · 2 fatalField investigationFinal reportBeech A36 · Hooksett, NHThe pilot's total incapacitation in flight due to an acute heart attack.Oct 25, 2012 · N4325W · Substantial damageNTSB IAD05LA114Accident · 2 fatalLimited investigationFinal reportConvair BT-13A · Lyme, NHThe 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.Aug 3, 2005 · N49646 · DestroyedNTSB IAD05LA089Accident · 1 fatalLimited investigationFinal reportLongtin Kitfox Model III · New London, NHThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor in the accident was the tail wind condition.Jul 2, 2005 · N795JL · Substantial damageNTSB NYC05FA042Accident · 1 fatalField investigationFinal reportEmbraer EMB-110P1 · Swanzey, NHThe 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…Jan 14, 2005 · N49BA · DestroyedNTSB NYC04FA157Accident · 1 fatalField investigationFinal reportLake LA-4-200 · Wilmot, NHThe 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.Jul 5, 2004 · N6248V · Substantial damageNTSB NYC01FA056Accident · 1 fatalField investigationFinal reportCessna 310Q · Chesterfield, NHThe pilot's continued flight into icing conditions, and his failure to use alternate air. A factor was the icing conditions.Dec 14, 2000 · N55QS · DestroyedNTSB NYC99FA041Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Randolph, NHThe 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.…Dec 28, 1998 · N4591J · DestroyedNTSB IAD97FA043Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Alton, NHAn exhaust gas leak, due to inadequate maintenance, which resulted in carbon monoxide poisoning, and incapacitation of the pilot.Jan 17, 1997 · N8263Y · DestroyedNTSB BFO92FA094Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-40 · Concord, NHLoss of control during flight for undetermined reason(s).Jul 9, 1992 · N220MA · DestroyedNTSB BFO91FA049Accident · 1 fatalField investigationFinal reportCessna 172N · Lebanon, NHThe pilot's failure to maintain adequate terrain clearance. Contributing was mountainous terrain, low clouds, and VFR flight into IMC.May 17, 1991 · N4650G · DestroyedNTSB NYC91LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-32-301R · Alton, NHThe 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.Nov 16, 1990 · N8473H · Substantial damageNTSB NYC91FA001Accident · 3 fatalField investigationFinal reportCessna 172P · Gorham, NHImproper 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.Oct 2, 1990 · N98438 · DestroyedNTSB NYC89FA206Accident · 4 fatalField investigationFinal reportCessna 172P · Northfield, NHThe 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.Sep 2, 1989 · N65595 · DestroyedNTSB NYC88LA008Accident · 1 fatalLimited investigationFinal reportBeech F-33A · Concord, NHThe 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…Oct 11, 1987 · N17985 · DestroyedNTSB NYC87DNC06Accident · 1 fatalFinal reportEnstrom F-28A · Mason, NHThe loss of aircraft control after the tail rotor struck the trees and departed the aircraft. The pilot's poor judgement in flying in weather conditions beyond his capabilities was a factor.Jul 3, 1987 · N9271 · DestroyedNTSB NYC87DNC10Accident · 1 fatalFinal reportHuffman Quickie Q2 · Peterborough, NHAt 0939 EDT, the acft departed syracuse, NY, on a flt to nashua, NH. Subsequently, it was rprtd missing. A search was initiated, but the acft was not found until it was discovered by a hiker aprx 2 months later. The acft had crashed below a mtn top near…May 23, 1987 · N22QT · DestroyedNTSB NYC84FA081Accident · 2 fatalField investigationFinal reportCessna 402 · Jaffrey, NHThe plt had filed an IFR flt plan; however, he took off in VFR conditions & did not activate the flt plan. Radar data showed that the latter part of the flt was flown at 6300 ft, then at 1712:39 EST, a descent was begun. One minute later, the flt was last…Feb 3, 1984 · N6814G · DestroyedNTSB NYC84FA009Accident · 1 fatalField investigationFinal reportBell 206B III · Hudson, NHThe plt was on a flt to pick up film for a tv station. While en route, he made a mayday call to the manchester control tower. According to witnesses, the acft was proceeding in a northerly direction at about 700 to 1000 ft AGL when they heard a 'muffled pop.'…Oct 18, 1983 · N5011N · DestroyedNTSB NYC83FA160Accident · 1 fatalField investigationFinal reportCessna 172N · Jaffrey, NHAt 0555 EDT, the non-instrument rated plt obtained a wx briefing for a flt from limington, me to pawling, NY. At that time, he stated he was unsure when he would depart, the decision depended on the wx. The briefer advised that at that time, VFR flt was not…Jun 28, 1983 · N738SF · DestroyedNTSB NYC83FA144Accident · 1 fatalField investigationFinal reportBeech 76 · Moultonboro, NHAfter making an instrument acph to laconia, NH, the plt landed, phoned his wife & advised her of his intention to fly to Moultonboro, NH. After taking off, he advised Moultonboro UNICOM that he had departed laconia & was over a nearby lake, but was having a…Jun 16, 1983 · N794Y · DestroyedNTSB NYC83FA005Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Sanbornton, NHThe plt was advised during his wx briefing that VFR flt was not recommended for his proposed route of flt and destination. The plt, whose business concern was in the glens falls area, commuted almost daily to his home in gilford, NH. The wreckage was located…Oct 9, 1982 · N9535C · DestroyedNTSB NYC82FNC13Accident · 1 fatalFinal reportPiper PA-28-140 · Beans Purchase, NHThe acft impacted an obscured mountain. An observation log & a pilot-certificated witness confirmed that IFR conditions existed at the time of the accident.Aug 2, 1982 · N5566F · DestroyedNTSB NYC82FA060Accident · 2 fatalField investigationFinal reportCessna U206G · Stratford, NHBefore takeoff, the pilot received a partial weather briefing by telephone. He was advised of reported icing conditions and was told that snow and rain showers were moving through the area causing marginal VFR conditions. Before terminating the conversation,…Mar 21, 1982 · N734KJ · DestroyedNTSB NYC81FA082Accident · 2 fatalClosedGulf Amer AA-1B · Richmond, NHSep 7, 1981 · N1446R · DestroyedNTSB NYC80FA038Accident · 3 fatalClosedCessna 177RG · Peterborough, NHMay 1, 1980 · N8030G · DestroyedNTSB NYC78FA066Accident · 1 fatalClosedGrum Amer AA1-C · Tamsworth, NHJun 25, 1978 · N9544U · DestroyedNTSB NYC77FA052Accident · 1 fatalClosedPiper PA-28 · Nashua, NHApr 15, 1977 · N75042 · Substantial damageNTSB NYC75AN090Accident · 2 fatalClosedCessna 150F · Mason, NHMar 12, 1975 · N8273S · DestroyedNTSB NYC75AN085Accident · 1 fatalClosedPiper PA-28 · Rummey, NHFeb 8, 1975 · N8827N · Substantial damageNTSB NYC75AN063Accident · 2 fatalClosedPiper L-4B · Rochester, NHNov 16, 1974 · N142H · Substantial damageNTSB NYC75AN023Accident · 2 fatalClosedCessna 340 · Whitefield, NHAug 24, 1974 · N5AM · DestroyedNTSB NYC74AN036Accident · 1 fatalClosedAmer Avco AA1 · Temple, NHOct 25, 1973 · N5700L · DestroyedNTSB NYC73AN064Accident · 1 fatalClosedMooney A2-A · Gilmanton, NHNov 7, 1972 · N5490F · DestroyedNTSB NYC72AN158Accident · 2 fatalClosedPiper PA-28R · Gilford, NHJun 18, 1972 · N5291T · DestroyedNTSB NYC72AN135Accident · 3 fatalClosedBeech P35 · Kingston, NHApr 26, 1972 · N8900M · Substantial damageNTSB NYC72AN067Accident · 1 fatalClosedBay Avn. Superv · Keene, NHNov 16, 1971 · N430MD · DestroyedNTSB NYC72AN056Accident · 1 fatalClosedCessna 150 · Henniker, NHOct 15, 1971 · N6749G · DestroyedNTSB NYC72AN003Accident · 1 fatalClosedPiper PA-28R · Madison, NHJul 3, 1971 · N2965R · DestroyedNTSB NYC71AN095Accident · 2 fatalClosedPiper PA-23 · Gorham, NHMar 21, 1971 · N4841P · DestroyedNTSB NYC71AN049Accident · 1 fatalClosedSchweizer SGS1 · Jackson, NHOct 18, 1970 · N3899A · Substantial damageNTSB NYC70A0057Accident · 3 fatalClosedCessna 172 · Gorham, NHNov 29, 1969 · N6416E · DestroyedNTSB NYC69A0077Accident · 1 fatalClosedPiper PA-23 · Windham, NHFeb 1, 1969 · N777M · DestroyedNTSB DCA69A0004Accident · 32 fatalClosedFairchild FH227C · Hanover, NHOct 25, 1968 · N380NE · DestroyedNTSB NYC69F0114Accident · 1 fatalClosedPiper PA-18A · Derry, NHAug 16, 1968 · N1866A · DestroyedNTSB NYC68A0074Accident · 1 fatalClosedCessna 401 · Whitefield, NHNov 26, 1967 · N3280Q · DestroyedNTSB NYC68A0036Accident · 1 fatalClosedMaule M4 · Marlborough, NHAug 31, 1967 · N9869M · DestroyedNTSB NYC67A0027Accident · 2 fatalClosedNavion NAV-4 · Ashuelot, NHAug 15, 1966 · N4364K · DestroyedNTSB NYC66A0103Accident · 1 fatalClosedCessna 182 · Campton, NHMar 19, 1966 · N8958T · DestroyedNTSB UNK64X3908Accident · 2 fatalClosedPiper PA-22 · Hancock, NHSep 10, 1964 · N5646Z · Substantial damage