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 NYC06CA105Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Laconia, NHThe pilot's failure to maintain directional control during the landing.May 23, 2006 · N412PM · Substantial damageNTSB NYC06CA096Accident · No injuriesData collectionFinal reportAeronca 7AC · Haverhill, NHThe flight instructor's inadequate preflight planning, which resulted in a forced landing and subsequent impact with a sign.Apr 15, 2006 · N82320 · Substantial damageNTSB NYC06CA001Accident · No injuriesData collectionFinal reportWaco YMF · Kensington, NHAn overload fracture of the right main landing gear during the landing roll, which resulted in a nose over.Oct 2, 2005 · N89B · Substantial damageNTSB IAD05CA086Accident · Minor injuriesData collectionFinal reportPorterfield CP-65 · Jaffrey, NHThe student pilot's inadequate compensation for wind conditions and his failure to maintain directional control. A factor in the accident was the drop off/descending embankment at the runway's edge.Jun 24, 2005 · N37709 · Substantial damageNTSB IAD05LA010Accident · No injuriesLimited investigationFinal reportCessna 172 · Wolfeboro, NHA jammed control wheel during landing. A contributing factor to the accident was the inadequate maintenance inspection of the airplane's flight control system.Nov 4, 2004 · N8803B · Substantial damageNTSB NYC04LA212Accident · No injuriesLimited investigationFinal reportCessna 182H · Nashua, NHAn in flight collision with birds while landing. A factor was the night conditions.Sep 9, 2004 · N8463S · Substantial damageNTSB IAD04CA010Accident · No injuriesData collectionFinal reportPiper PA-20 · West Ossipee, NHThe pilot's inability to maintain runway alignment during the landing rollout. Factors included the night lighting conditions and the snow banks that prevented visual reference to the runway lights.Feb 11, 2004 · N2634A · Substantial damageNTSB NYC04LA048Accident · No injuriesLimited investigationFinal reportBeech 35 · Laconia, NHThe pilot's failure to maintain directional control after experiencing a brake failure. A factor related to the accident was the failure of the brake master cylinder.Dec 13, 2003 · N3116V · Substantial damageNTSB IAD03LA028Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Laconia, NHThe pilot's loss of directional control during landing, which resulted in an impact with a snowbank, and overstress fracture of the nose gear actuator and engine mount foot attachment. A factor in the accident was the icy runway conditions.Jan 18, 2003 · N9170X · Substantial damageNTSB IAD02LA083Accident · No injuriesLimited investigationFinal reportMenzies Glassair II · Laconia, NHThe pilot's improper recovery from a bounced landing and his failure to maintain directional control.Aug 11, 2002 · N55RK · Substantial damageNTSB IAD01LA085Accident · No injuriesLimited investigationFinal reportCessna 195 · Moultonboro, NHThe pilot's failure to maintain directional control of the airplane. A factor was the crosswind.Jul 24, 2001 · N4352V · Substantial damageNTSB NYC01LA137Accident · No injuriesLimited investigationFinal reportGraham Acro Sport · Hampton, NHA soft area in the turf runway, which resulted in a loss of directional control during the landing rollout.Jun 5, 2001 · N877CG · Substantial damageNTSB NYC01LA083Accident · No injuriesLimited investigationFinal reportCessna 172S · Keene, NHThe pilot's failure to maintain directional control during the landing roll. A factor included the patchy snow on the runway.Mar 7, 2001 · N574SP · Substantial damageNTSB IAD01LA024Accident · No injuriesLimited investigationFinal reportCessna 172P · Concord, NHThe flight instructor's improper decision to land downwind on the snow and ice covered runway with a tailwind, and his failure to perform a go-around. Factors in the accident were the tailwind and the snow and ice on the runway.Jan 7, 2001 · N54931 · Substantial damageNTSB NYC01LA043Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Londonderry, NHThe pilot's failure to obtain the proper touchdown point.Nov 21, 2000 · N8117Y · Substantial damageNTSB NYC00LA173Accident · No injuriesLimited investigationFinal reportFleet 16B · Rochester, NHThe pilot's failure to maintain directional control. A factor in the accident was the pilot's lack of experience in the accident airplane make and model.Jun 19, 2000 · N162V · Substantial damageNTSB NYC00LA105Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Keene, NHThe CFI's failure to perform remedial action in a timely manner which resulted in a hard landing during the practice autorotation. A factor in this accident was the CFI's lack of total experience as a flight instructor.Mar 27, 2000 · N2260W · Substantial damageNTSB NYC99LA132Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Jaffrey, NHThe pilot's failure to maintain sufficient rotor rpm. A factor in this accident was the crosswind condition.Jun 3, 1999 · N221DD · Substantial damageNTSB NYC98LA148Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Whitefield, NHThe instructor pilot's failure to maintain control of the aircraft during landing roll. Contributing factors were the instructor pilot's improper in-flight decision, tailwind and gusty conditions, and wet (standing water) runway conditions.Jul 20, 1998 · N8182A · Substantial damageNTSB IAD97LA077Accident · No injuriesLimited investigationFinal reportCessna 182P · Wentworth, NHPilot's inadequate preflight planning to determine the suitability of an unimproved field for landing.May 24, 1997 · N20892 · Substantial damageNTSB NYC96LA151Accident · No injuriesLimited investigationFinal reportAmerican Champion 7EC · Rochester, NHthe pilot's inadequate compensation for winds and his failure to maintain directional control, which resulted in a ground loop and dragging of the wing on the runway.Jul 17, 1996 · N8910R · Substantial damageNTSB NYC96LA138Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Wolfeboro, NHThe pilot's improper flare, which resulted in a hard landing and nose over. The glassy water condition was a related factor.Jul 2, 1996 · N51DG · Substantial damageNTSB IAD96FA074Accident · 1 fatalField investigationFinal reportLake LA-4-200 · Sunapee, NHthe pilot's failure to maintain control of the airplane. Factors in this accident were: the pilot's lack of currency in type and model airplane, and not following the requirement for the pilot to have a flight instructor onboard during water landings.May 9, 1996 · N5040L · DestroyedNTSB NYC96LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Moultonboro, NHfailure of the pilot to maintain directional control of the airplane during the landing, which allowed the plane to depart the runway and collide with a snowbank. A factor relating to the accident was: the icy runway condition.Dec 8, 1995 · N45625 · Substantial damageNTSB NYC95LA026Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Nashua, NHThe pilot's improper touchdown which resulted in a rollover.Oct 29, 1994 · N4070S · No damageNTSB NYC95LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Center Harbor, NHThe pilot's inadequate compensation for a crosswind condition.Oct 9, 1994 · N733MV · Substantial damageNTSB BFO94LA156Accident · No injuriesLimited investigationFinal reportCessna 195B · Ossipee, NHSeparation of the left main landing gear due to fatigue failure.Aug 27, 1994 · N9885A · Substantial damageNTSB BFO94LA153Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Wolfeboro, NHThe pilot's failure to maintain directional control during landing which resulted in inflight collission with trees.Aug 27, 1994 · N8541Y · Substantial damageNTSB BFO94LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Wolfeboro, NHThe pilot's inadequate inflight decision, which resulted in a downwnind landing and overrun of the runway.Aug 10, 1994 · N3372M · Substantial damageNTSB NYC94LA024Accident · No injuriesLimited investigationFinal reportPiper J3 · Greenland, NHThe pilot's improper landing flare which resulted in a hard landing.Oct 28, 1993 · N24524 · Substantial damageNTSB NYC93LA143Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-15 · Milford, NHUnfavorable winds during landing which resulted in a hard landing and one passenger sustaining a broken angle.Aug 1, 1993 · N2574M · No damageNTSB BFO93LA099Accident · No injuriesLimited investigationFinal reportCessna 177 · Newport, NHThe pilot's failure to properly recover from a bounced landing, and his failure to maintain directional control during the aborted landing.May 31, 1993 · N30041 · Substantial damageNTSB NYC93LA004Accident · 1 fatalLimited investigationFinal reportLake LA-250 · Franklin, NHThe pilot's misjudged touchdown on the water which resulted in a porpoised landing. Also causal to the accident was his improper recovery from the porpoise, resulting in a loss of airplane control and collision with the water. Factors related to the accident…Oct 3, 1992 · N8549Z · Substantial damageNTSB NYC92LA010Accident · 1 fatalLimited investigationFinal reportBalloon Works Firefly 7 · Webster, NHFailure of the ground crewman (from another Balloon) to recognize the hazardous condition that existed, when the Balloon came in contact with a high voltage power line during a precautionary landing. Factors related to the accident were: the lack of suitable…Oct 19, 1991 · N4051L · Substantial damageNTSB NYC91LA253Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Manchester, NHThe pilot's failure to maintain control. A factor was the unforecasted strong cross winds.Sep 29, 1991 · N3167G · Substantial damageNTSB NYC91LA117Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Whitefield, NHInadequate compensation for wind conditions by the pilot which resulted in a loss of directional control. A factor contributing to the accident was the gusty wind conditions.Apr 16, 1991 · N1303E · Substantial damageNTSB NYC91LA081Accident · No injuriesLimited investigationFinal reportCessna 172P · Nashua, NHThe failure of the pilot to compensate for wind conditions during landing, resulting in a loss of control and collision with a tree.Mar 1, 1991 · N97313 · Substantial damageNTSB NYC88LA155Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Franconia, NHThe pilot landed the aircraft long on a grass runway with a tailwind. The pilot reported that she touched down longer than anticipated, but she thought she would have had adequate stopping distance. She was unable to stop the acft on the remaining runway and…May 29, 1988 · N6115B · Substantial damageNTSB NYC88LA089Accident · No injuriesLimited investigationFinal reportCessna 172 · Rochester, NHDuring landing, the flight encountered a crosswind from the left and almost immediately the aircraft became airborne again. The pilot flared for landing, landed hard, bounced and at this time the pilot decided to abort and go around. The aircraft drifted to…Feb 22, 1988 · N1061F · Substantial damageNTSB NYC88LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Concord, NHThe student pilot was attempting a landing at Concord municipal airport. The aircraft touched down hard, bounced and at this time the pilot applied full throttle in an attempt to abort the landing and go around. However the aircraft veered left and struck…Feb 18, 1988 · N6341H · Substantial damageNTSB NYC88LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Concord, NHThe aircraft was landing at Concord municipal airport, and during landing roll, the aircraft veered to the left leaving the runway surface and nosed over in the field between the taxiway and runway 35.Dec 31, 1987 · N5383R · Substantial damageNTSB NYC88LA018Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Laconia, NHThe plt rprtd he was demonstrating a full touchdown autorotation in winds that were from 290 deg at 15 gusting 20 KTS. He stated the touchdown was soft with a lot of pitch pulled in; however, as he lowered the collective after touchdown, the retreating blade…Oct 25, 1987 · N51699 · Substantial damageNTSB NYC87LA248Accident · No injuriesLimited investigationFinal reportCessna 150J · Brookline, NHDuring an approach to land at night, the pilot saw deer on the runway that were facing his direction and moving to the right. He didn't see the deer until he had reached a point were a go-around would be unsafe for this runway. In an effort to avoid the deer,…Sep 14, 1987 · N51085 · DestroyedNTSB NYC87LA132Accident · No injuriesLimited investigationFinal reportDornier DO-228-201 · Manchester, NHVibration was experienced shortly after touchdown caused by the failure of the propeller blade as a result of fatigue cracking which was initiated from a linear area in a defect free portion of the camber face of the blade. Propagation was through 60% of the…Apr 21, 1987 · N232RP · Substantial damageNTSB NYC87LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Manchester, NHThe Cessna 152 was making a touch and go on rwy 35 with the winds reported to be 170 degrees at 11 knots. The pilot lost control after touchdown and veered off the runway to the left. The aircraft struck a runway light and flipped over receiving substantial…Apr 15, 1987 · N24784 · Substantial damageNTSB NYC87LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Colebrook, NHThe plt rprtd that after arriving, the wind shifted to the NE, but he elected to land on rwy 21 'because of a frost heave.' Subsequently, he landed long to avoid the frost heave, but was unable to stop on the icy rwy. The acft contd off the departure end &…Feb 22, 1987 · N3967R · Substantial damageNTSB NYC87LA060Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Randolph, NHStudent pilot on a cross country instructional flight became disoriented, decided to return to departure airport. However seeing that he was running low on fuel looked for an airport to land to refuel and find out his location. He decided to make a…Jan 17, 1987 · N2430G · DestroyedNTSB NYC87LA053Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Goffstown, NHThe Cessna 180 made a touch and go on a 2100 ft long runway. The touchdown was described as past the first third of the runway. There were two rated pilots and a passenger in the aircraft. The co-pilot thought the aircraft would be unable to clear powerlines…Jan 1, 1987 · N9388C · Substantial damageNTSB NYC86LA220Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Rochester, NHPilot made a steep descent and lost directional control. The aircraft collided with the ground while still turning causing the helicopter to roll over.Aug 21, 1986 · N2276X · Substantial damageNTSB NYC86LA192Accident · No injuriesLimited investigationFinal reportMaule M-5-235 · Wolfeboro, NHWhile landing, the aircraft bounced slightly & the plt lost directional control. The aircraft veered left over the runway edge onto a soft shoulder, nosed over & was damaged.Jul 28, 1986 · N396X · Substantial damage