NTSB investigations, NH

247 cases where the phase of flight was Landing.

Cases, newest first

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 = 550)
  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 NYC86FA017Accident · 1 fatalField investigationFinal reportSchweizer SGS-1-35C · North Conway, NHDuring an off airport landing attempt in a cleared corn field, the glider was approaching a treeline at an altitude of 10 to 20 ft AGL. Witnesses observed the glider pull up and bank to the left before falling nose first into the ground. The pilot's log book…Oct 25, 1985 · N2565H · DestroyedNTSB NYC85LA129Accident · No injuriesLimited investigationFinal reportCessna 180J · Hooksett, NHThe plt was ferrying the acft to a fld where floats were to be installed. While on the apch, the acft encountered a crosswind and drifted 20 ft off the intended centerline. The acft touched down and rolled about 110 ft before colliding with a small bush and…May 19, 1985 · N52197 · Substantial damageNTSB NYC85LA030Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Antrim, NHPlt stated, a wind shift occurred on short final resulting in a sudden uncontrollable yaw to the left. Right aileron and full power was added, however, the acft contacted trees before recovery was made.Nov 19, 1984 · N4379N · Substantial damageNTSB NYC84LA167Accident · No injuriesLimited investigationFinal reportCessna 150 · Hampton, NHPilot stated that while landing, the aircraft bounced once possibly two times. On final touch down, the nose landing gear collapsed and the aircraft nosed over onto its back.May 10, 1984 · N11953 · Substantial damageNTSB NYC84LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · Laconia, NHThe acft ballooned during landing and came down hard on the nose gear which collapsed. The plt said a gust of wind had made the acft ascend about 20-50 ft after which it fell to the rwy. He reported the prevailing wind was variable from 270 to 290 deg a 12…Apr 28, 1984 · N5171B · Substantial damageNTSB NYC83FU012Accident · Serious injuriesFinal reportRobertson Bird · Milan, NHAccording to the plt, he had just purchased the ultralight on the previous day & had no previous training in ultralights. On his 2nd flt in the vehicle, he landed hard, the tubular structure to the right gear collapsed & the lower seat support contacted the…Sep 25, 1983 · UNREG · Minor damageNTSB NYC83LA219Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Wakefield, NHThe plt reported that he taxied out of a protected cove to takeoff on the main part of balch lake. After lift-off, he realized the wind was too gusty to be flying, & aborted from aprx 30 to 40 ft AGL. He saw telephone wires ahead that crossed the lake &…Aug 20, 1983 · N96755 · Substantial damageNTSB NYC83LA184Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Antrim, NHThe helicopter made a steep approach, settled with power and made a hard landing. This was a dual instructional flt. Thestudents total time amounted to 4 hours, all in type. According to the CFI, while on the fourth approach on short final at 75 ft AGL, the…Jul 19, 1983 · N8354Z · Substantial damageNTSB NYC83LA024Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-1D · North Conway, NHAfter a tow-release at about 2,000 ft the plt encountered a sink which eventually developed into about a 1,000 fpm sink. The acft struck a fence during the forced landing.Nov 6, 1982 · N81MP · DestroyedNTSB NYC82DA190Accident · No injuriesFinal reportCessna 152 · Lebanon, NHThe pilot landed at the uncontrolled airport to refuel. After receiving an in-person weather briefing, he filed a VFR flight plan. He contacted the fss on the airport advisory frequency and advised that he ws taxiing and would be making an intersection…Aug 10, 1982 · N89255 · 2 aircraft · Substantial damageNTSB NYC82DA139Accident · No injuriesFinal reportCessna 150M · Laconia, NHWhen the student pilot was landing, the aircraft veered left after touchdown. It continued down an embankment, ran into a swamp, and was substantially damaged.Jul 4, 1982 · N63221 · Substantial damageNTSB NYC82DA086Accident · No injuriesFinal reportChampion 7GCAA · New London, NHAfter towing a glider, the pilot returned to an unimproved airstrip and landed. During the landing roll, the aircraft became mired in soft sand and nosed over.May 2, 1982 · N8309V · Substantial damageNTSB NYC82DA043Accident · No injuriesFinal reportBeech C-24R · Manchester, NHThe tower controller advised the flight while on base leg that the winds were from 300 degrees at 15 knots. This information was given at 1045 EST and was the last wind information given to the pilot before landing. According to the pilot moderate turbulence…Mar 5, 1982 · N6135S · Substantial damageNTSB NYC81FNC19Accident · No injuriesClosedBellanca 7GCAA · Bath, NHAug 30, 1981 · N6364N · Substantial damageNTSB NYC81FNC03Accident · No injuriesClosedBellanca 8GCBC · Manchester, NHOct 12, 1980 · N50402 · Substantial damageNTSB NYC80DNC46Accident · No injuriesClosedGrum-Amer AA-5 · Manchester, NHSep 19, 1980 · N1337R · Substantial damageNTSB NYC80DA078Accident · No injuriesClosedBeech A23-24 · Wolfeboro, NHAug 28, 1980 · N247DK · DestroyedNTSB NYC80FNC27Accident · No injuriesClosedCessna 210 · Wolfebore, NHJun 13, 1980 · N510PE · Substantial damageNTSB NYC80FNC26Accident · No injuriesClosedPiper PA-28 · Antrim, NHJun 11, 1980 · N55817 · Substantial damageNTSB NYC80FNC22Accident · Serious injuriesClosedLake 4-200 · Laconia, NHApr 22, 1980 · N1063L · Substantial damageNTSB NYC80DNC21Accident · No injuriesClosedEnstrom 280C · Jackson, NHApr 20, 1980 · N51791 · Substantial damageNTSB NYC80FNC12Accident · No injuriesClosedBeech C50 · Manchester, NHFeb 22, 1980 · N4900B · Substantial damageNTSB NYC79DNC32Accident · Minor injuriesClosedLake LA-4 · Wolfeboro, NHJun 27, 1979 · N2832P · DestroyedNTSB NYC79FNC28Accident · No injuriesClosedCessna 150 · Mt Vernon, NHMay 11, 1979 · N19435 · Substantial damageNTSB NYC79FNC26Accident · No injuriesClosedLake 4-200 · Whitefield, NHMay 6, 1979 · N6181V · Substantial damageNTSB NYC79FA042Accident · 1 fatalClosedPiper PA-18 · Lebanon, NHApr 21, 1979 · N2344J · DestroyedNTSB NYC79FNC16Accident · No injuriesClosedPiper PA-31 · Laconia, NHJan 31, 1979 · N2ZM · Substantial damageNTSB NYC79FA020Accident · Minor injuriesClosedLockheed L-1329 · Concord, NHJan 22, 1979 · N5541L · Substantial damageNTSB NYC79FNC11Accident · No injuriesClosedCessna 172N · Hampton, NHDec 5, 1978 · N5172E · Substantial damageNTSB NYC79DNC07Accident · No injuriesClosedAeronca 7AC · N.Hampton, NHOct 22, 1978 · N3613E · Substantial damageNTSB NYC79DNC06Accident · No injuriesClosedCessna 305A · Rochester, NHOct 22, 1978 · N5306G · Substantial damageNTSB NYC78FNC05Accident · No injuriesClosedCessna 172N · Brookline, NHOct 20, 1978 · N737MP · Substantial damageNTSB NYC78DNC39Accident · No injuriesClosedMolina PIK-20 · Pelham, NHJul 12, 1978 · N20WW · Substantial damageNTSB NYC78FNC31Accident · Serious injuriesClosedPiper PA-28 · Jaffrey, NHJun 17, 1978 · N7279F · Substantial damageNTSB NYC78FNC26Accident · No injuriesClosedPiper PA-24 · Barnstead, NHMay 14, 1978 · N6465P · Substantial damageNTSB NYC78DNC22Accident · No injuriesClosedPiper PA-28 · Antrim, NHApr 12, 1978 · N8262N · Substantial damageNTSB NYC78DNC07Accident · No injuriesClosedCessna 140 · Jaffey, NHDec 24, 1977 · N90019 · Substantial damageNTSB NYC78DNC06Accident · Minor injuriesClosedCessna 177 · Jaffrey, NHDec 23, 1977 · N29319 · Substantial damageNTSB NYC78DNC05Accident · No injuriesClosedCessna 172M · Nashua, NHDec 23, 1977 · N13599 · Substantial damageNTSB NYC78DNC02Accident · No injuriesClosedChampion 7GCBC · South Swanzey, NHOct 19, 1977 · N9095L · Substantial damageNTSB NYC77DNC48Accident · No injuriesClosedEnstrom F-28C · Manchester, NHAug 19, 1977 · N642H · Substantial damageNTSB NYC77DNC35Accident · No injuriesClosedCessna 170B · Tilton, NHJun 5, 1977 · N2238D · Substantial damageNTSB NYC77DNC34Accident · Minor injuriesClosedCessna 182 · Exeter, NHMay 30, 1977 · N6436A · Substantial damageNTSB NYC77DNC29Accident · No injuriesClosedBellanca 8GCBC · Cntr Strafford, NHMay 6, 1977 · N88183 · Substantial damageNTSB NYC77DNC25Accident · No injuriesClosedCessna 140 · Center Ossipee, NHApr 17, 1977 · CF-VIW · Substantial damageNTSB NYC77DNC22Accident · No injuriesClosedGrum Amer AA5 · Rochester, NHMar 9, 1977 · N6050L · Substantial damageNTSB NYC77DNC19Accident · Minor injuriesClosedStinson 108-1 · Salem, NHJan 23, 1977 · N8874K · Substantial damageNTSB NYC77FNC04Accident · Serious injuriesClosedSchleicher AS-K14 · North Conway, NHOct 22, 1976 · N11RT · Substantial damageNTSB NYC77FNC02Accident · Serious injuriesClosedPiper PA-28 · Portsmouth, NHOct 16, 1976 · N41738 · Substantial damageNTSB NYC76FNC61Accident · Minor injuriesClosedCessna A185E · Wolfeboro, NHAug 4, 1976 · N185HC · Substantial damage