NTSB investigations, NH
34 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 2 |
|---|---|
| 1984 | 1 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 1 |
| 1989 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 2 |
| 2001 | 5 |
| 2002 | 1 |
| 2003 | 3 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 2 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260)
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.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB NYC07CA110Accident · No injuriesData collectionFinal reportLuscombe 8A · Whitefield, NHThe pilot's failure to maintain directional control while landing. A factor in this accident was the crosswind condition.NTSB NYC07CA066Accident · No injuriesData collectionFinal reportMaule MXT-7-180A · Alton, NHThe pilot's failure to maintain control of the airplane during the takeoff roll. Factors were the slick condition of the runway, and the lack of markings to denote the runway safety area.NTSB NYC06LA216Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Hampton, NHThe pilot's failure to maintain directional control during takeoff.NTSB NYC06CA105Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Laconia, NHThe pilot's failure to maintain directional control during the landing.NTSB 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.NTSB 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.NTSB NYC04CA002Accident · No injuriesData collectionFinal reportLake LA250 · Laconia, NHThe pilot's improper starting procedure. A factor in the accident was the pilot's lack of recent experience in make and model airplane.NTSB 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.NTSB IAD02LA083Accident · No injuriesLimited investigationFinal reportMenzies Glassair II · Laconia, NHThe pilot's improper recovery from a bounced landing and his failure to maintain directional control.NTSB IAD01LA085Accident · No injuriesLimited investigationFinal reportCessna 195 · Moultonboro, NHThe pilot's failure to maintain directional control of the airplane. A factor was the crosswind.NTSB IAD01LA078Accident · 1 fatalLimited investigationFinal reportPatalivo Dominator · Laconia, NHThe non-certificated pilot's inability to maintain control of the gyrocopter after inadvertently allowing it to become airborne. A factor was the pilot's lack of flight experience.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB NYC00LA170Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · Nashua, NHThe flight instructor's delayed corrective action.NTSB 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.NTSB IAD97LA091Accident · No injuriesLimited investigationFinal reportAeronca S15AC · Laconia, NHThe pilot's inadequate compensation for a crosswind, which resulted in the loss of aircraft control. A factor in the accident was the gusting winds.NTSB 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.NTSB 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.NTSB 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.NTSB NYC93LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-301T · Jaffrey, NHAn improper weld by other maintenance personnel which resulted in the nose gear collapsing, and a loss of directional control on takeoff.NTSB NYC91LA253Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Manchester, NHThe pilot's failure to maintain control. A factor was the unforecasted strong cross winds.NTSB NYC89LA180Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Plymouth, NHLoss of directional control during an aborted takeoff. The ditch was a related factor.NTSB NYC89LA112Accident · No injuriesLimited investigationFinal reportChampion 8KCAB · Manchester, NHThe loss of control and collision with a parked aircraft due to the inadvertent application of the throttle that took place as the pilot was fastening the over the shoulder safety harness while warming the engine in preparation for departure.NTSB 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…NTSB 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.NTSB NYC87LA198Accident · No injuriesLimited investigationFinal reportLake LA-250 · Alton Bay, NHThe Lake renegade 250 was making a water takeoff when it started a sharp left turn. The aircraft stopped in the water and the pilot exited without injuries prior to the aircraft turning over. Examination of the aircraft showed that the engine pylon had…NTSB 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…NTSB 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.NTSB NYC86LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Nashua, NHThe student pilot was performing touch and go landings at boire field when he applied power to takeoff, he was distracted by the flap control setting. During this distraction the aircraft drifted to the left. Full right rudder was used in an attempt to…NTSB NYC84LA282Accident · No injuriesLimited investigationFinal reportCessna 150M · Claremont, NHAfter a dual instructional flt, practicing landings, the student tookoff on a solo flt. He made 2 takeoffs & landings without incident. On his 3rd takeoff, the acft began drifting to the left. The student said he applied right rudder to correct the situation,…NTSB 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.NTSB 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…