NTSB investigations, NH
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 NYC02LA002Accident · Minor injuriesLimited investigationFinal reportBeech C-45H · Hudson, NHThe pilot/owner's failure to properly identify the inoperative engine prior to feathering the wrong propeller, and his lack of familiarity with the required corrective procedures. A factor was the initial engine failure.NTSB IAD01LA100Accident · 1 fatalLimited investigationFinal reportSocata TB-20 · Amherst, NHSuicide, when the pilot intentionally crashed his airplane into his house.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 NYC01LA175Accident · Minor injuriesLimited investigationFinal reportYakovlev 52 · Moultonboro, NHA clogged fuel vent line due to a mud dauber nest, and rough terrain, including a large hole, in the forced landing field.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 NYC01LA139Accident · No injuriesLimited investigationFinal reportCessna 172M · Nashua, NHThe CFI's improper decision to abort the takeoff and his improper flare, which resulted in a hard landing.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 NYC01LA103Accident · No injuriesLimited investigationFinal reportCessna 177 · Hampton, NHThe pilot's inadvertent encounter with a downdraft, which resulted in a collision with trees. A factor related to the accident were the downdraft wind conditions.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 NYC01LA086Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Keene, NHinadequate 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 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 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.NTSB NYC01LA043Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Londonderry, NHThe pilot's failure to obtain the proper touchdown point.NTSB NYC00LA255Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Laconia, NHThe pilot's failure to maintain aircraft control. A factor in the accident was the large wave.NTSB NYC00LA244Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Windsor, NHthe pilot's improper preflight planning to make a takeoff toward obstacles, and his delayed decision to abort the takeoff, which resulted in an overrun into unsuitable terrain.NTSB NYC00LA186Accident · No injuriesLimited investigationFinal reportHelfer Flightstar II · Greenland, NHThe 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 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 NYC00LA113Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Lanconia, NHThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall.NTSB 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.NTSB NYC00LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Center Harbor, NHThe pilot-in-command attempted a low pass and misjudged his altitude.NTSB NYC00LA072Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Alton Bay, NHThe 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 NYC00LA022Accident · 1 fatalLimited investigationFinal reportGodbout Exec 162F · Milan, NHThe pilot's failure to maintain proper rotor rpm while maneuvering, which resulted in main rotor blade flapping, and its subsequent impact with the tail boom. A factor was the pilot's lack of experience in maneuvering flight.NTSB NYC00LA002Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wolfeboro, NHA total loss of engine power for undetermined reasons.NTSB NYC99LA200Accident · Minor injuriesLimited investigationFinal reportCessna 208 · Hillsborough, NHan inadequate auxiliary fuel tank installation which resulted in a leak of undetermined origin.NTSB 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.NTSB NYC99LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Wolfeboro, NHThe pilot's failure to attain a proper touchdown point. A factor in the accident was the pilot's failure to use a preflight briefing service, resulting in an in flight encounter with snow, and subsequent precautionary landing.NTSB IAD99FA025Accident · 1 fatalField investigationFinal reportLake LA-4-250 · Laconia, NHA loss of engine power during initial climb due to oil starvation. Contributing to the accident was the failure to perform an engine overhaul.NTSB 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.…NTSB NYC99LA004Accident · Minor injuriesLimited investigationFinal reportEnstrom F280 · Bow, NHThe pilot's inadequate visual lookout and his failure to maintain adequate obstacle clearance, which resulted in an in-flight collision with a tower. A factor in this accident was the gusty wind conditions.NTSB IAD99LA002Accident · No injuriesLimited investigationFinal reportNavion A · Jaffrey, NHThe pilot's inadequate aircraft preflight and subsequent failure to refuel the aircraft resulting in fuel exhaustion. A factor was the lack of suitable terrain to execute a forced landing.NTSB NYC98LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Newport, NHThe seizure of the throttle shaft, due to the overhaul facilities' failure to insure all metal fragments had been removed from the carburetor before inserting the throttle shaft after reaming the throttle shaft bushings.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 NYC98FA129Accident · 1 fatalField investigationFinal reportHawker Hunter T MK 8 · Manchester, NHFuel exhaustion, resulting from the pilot's reliance on an inaccurate fuel quantity indicating system. A factor in the pilot's death was his intentional delay of the ejection sequence in order to avoid people and property on the ground.NTSB IAD98LA053Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Nashua, NHThe pilot's improper fuel management which led to fuel starvation.NTSB NYC97LA163Accident · 1 fatalLimited investigationFinal reportElliot Monnett Moni · Hollis, NHThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall spin and collision with terrain.NTSB NYC97LA152Accident · Serious injuriesLimited investigationFinal reportKenneson Merlin GT · Kensington, NHthe pilot's inability to obtain and/or maintain control of the airplane after takeoff.NTSB IAD97LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Hampton, NHThe pilot's poor judgement for intentionally shutting down an engine to perform a practice single engine landing, which led to a single engine go-around due to conflicting traffic.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 IAD97LA077Accident · No injuriesLimited investigationFinal reportCessna 182P · Wentworth, NHPilot's inadequate preflight planning to determine the suitability of an unimproved field for landing.NTSB IAD97LA075Accident · No injuriesLimited investigationFinal reportCessna 180J · Lebanon, NHThe loss of engine power for undetermined reasons.NTSB NYC97LA070Accident · No injuriesLimited investigationFinal reportCessna 150E · Wolfeboro, NHThe 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 NYC97LA044Accident · Serious injuriesLimited investigationFinal reportMooney 20F · Jaffrey, NHThe pilot's failure to maintain aircraft control during a go around attempt, which resulted in a loss of control and collision with trees.NTSB 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.NTSB NYC97FA194Accident · 2 fatalField investigationFinal reportLearjet 35A · Dorchester, NHThe captain's failure to maintain situational awareness, which resulted in the airplane being outside the confines of the instrument approach; and the crew's misinterpretation of a step-down fix passage, which resulted in an early descent into rising terrain.…NTSB NYC96LA187Accident · No injuriesLimited investigationFinal reportCessna 180K · Derry, NHthe 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 NYC96LA172Accident · Minor injuriesLimited investigationFinal reportPzl-Bielsko SZD-59 · Franconia, NHThe pilot's misjudged altitude and distance which resulted in the collision with trees short of the runway.NTSB IAD96FA138Accident · 4 fatalField investigationFinal reportPiper PA-24-180 · Whitefield, NHthe 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 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 IAD96LA117Accident · No injuriesLimited investigationFinal reportBeech A100 · Manchester, NHThe pilots failure to maintain control of the aircraft during a coupled approach. A related factor was the unmonitored inoperative glide slope.