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 NYC91LA221Accident · No injuriesLimited investigationFinal reportGrumman AA5B · Hampton, NHThe pilot rotated the airplane prematurely, resulting in an inadvertent stall at too low an altitude to allow recovery. Factors related to the accident were, the pilot's complacency, failure to determine the airplane's performance capabilities prior to take…NTSB NYC91DNC04Accident · Minor injuriesFinal reportLaurent A. Cloutier BD-5B · Gilford, NHEngine failure due to a faulty oil pressure relief valve resulting in an emergency landing on unsuitable terrain.NTSB NYC91LA200Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Alton, NHThe pilot's improper use of carburetor heat, which resulted in a loss of engine power.NTSB NYC91LA177Accident · No injuriesLimited investigationFinal reportCessna L-19 · Franconia, NHThe failure of the pilot to maintain airspeed, which resulted in a stall/spin and in flight collision with trees. Factors related to the accident were the improper in-flight planning by the pilot and the pilot's failure to compensate for winds and downdraft.NTSB NYC91LA141Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Ossipee, NHAn inadequate annual inspection by the mechanic which resulted in the inflight failure of the elevator control cable.NTSB 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.NTSB 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.NTSB NYC91LA084Accident · Minor injuriesLimited investigationFinal reportCessna 210 · East Swanzey, NHThe pilot's lack of familiarity with this airplane and his inadequate preflight, which resulted in miscalculations of fuel consumption and subsequent fuel exhaustion. Factors related to this accident were: the leaking of fuel caps, the inaccurate fuel…NTSB 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.NTSB NYC91LA070Accident · No injuriesLimited investigationFinal reportCessna 172M · Nashua, NHFuel system contamination by other personnel which resulted in an inflight engine failure and a subsequent forced landing in unsuitable terrain.NTSB NYC91FA060Accident · 2 fatalField investigationFinal reportMooney M20J · Brookline, NHThe failure of the flight instructor (CFI) to attain remedial action after control of the airplane was lost for an unknown reason.NTSB NYC91LA052Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Concord, NHThe improper starting procedure used by the pilot.NTSB 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.NTSB NYC91DNC02Accident · Serious injuriesFinal reportMarier Early Bird Jenny · Concord, NHThe failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall spin. A factor related to the accident was: the pilot's lack of experience in the make and model of aircraft.NTSB 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.NTSB NYC90DNC01Accident · Serious injuriesFinal reportCessna 180E · Kingston, NHAn inflight collision with water while maneuvering for a forced landing. A factor to the accident was a power loss due to the pilot's improper use of the mixture control.NTSB NYC90LA228Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Franconia, NHThe landing of the airplane in unsuitable terrain, due to the mechanical failure of the engine center muffler baffle, which blocked the exhaust flow, resulting in a loss of power.NTSB NYC90LA202Accident · No injuriesLimited investigationFinal reportWaco DSO · Keene, NHAborted takeoff with insufficient room available to stop. The pilot's delayed decision to abort the takeoff was a factor.NTSB NYC90LA188Accident · No injuriesLimited investigationFinal reportCessna 150M · Rochester, NHUndetermined.NTSB NYC90LA069Accident · No injuriesLimited investigationFinal reportCessna 172P · Sunapee Lake, NHFailure of the pilot to maintain adequate altitude above the lake, which resulted in unplanned contact with its frozen surface.NTSB NYC89LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Sanbornton, NHVFR flight into instrument meteorological conditions (IMC) by the pilot, and his inadequate remedial action to correct the situation. The adverse weather conditions and darkness were related factors.NTSB 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.NTSB NYC89LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Wolfeboro, NHInadequate compensation for wind conditions by the owner/pilot-in-command (PIC), his failue to maintain proper altitude on the approach, and failure of the other pilot (owner's instructor pilot) to take remedial action. Factors related to the accident were:…NTSB NYC89LA180Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Plymouth, NHLoss of directional control during an aborted takeoff. The ditch was a related factor.NTSB NYC89LA181Accident · No injuriesLimited investigationFinal reportCessna 185D · Wolfeboro, NHLoss of engine power for an unknown reason. Factors related to the accident were: the obstructions (trees & boats) in the emergency landing area.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 NYC89LA048Accident · Serious injuriesLimited investigationFinal reportEnstrom F28F · Bradford, NHAn inflight contact with trees during takeoff after the student pilot experienced a loss of control due to his failure to adequately compensate for the winds.NTSB NYC89LA044Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Laconia, NHAircraft striking the road sign after the aircraft experienced a double power loss due to mismanagement of the fuel system by the pilot.NTSB NYC89FA003Accident · Serious injuriesField investigationFinal reportAeronca 11AC · Barnstead, NHThe Aeronca 11AC was maneuvering downwind for landing. The pilot made a left turn towards the runway to tighten the pattern. While in close proximity to a house and the runway, at a low altitude the pilot elected to make a steep left 270 degree turn, opposite…NTSB NYC89LA002Accident · Serious injuriesLimited investigationFinal reportBeech V35A · Derry, NHThe acft collided with trees after takeoff from a private airstrip with a rwy which has 1,200 feet useable length. The field elev is 425 ft and the plt EST the temp to be 60 deg f. the plt said the takeoff was made to the NE. The wind was reported to be out…NTSB NYC88LA243Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Keene, NHThe plt received a head inj and was not able to relate the details of the acdt. The acft crashed into trees about 3 mi short of the landing rwy at the conclusion of a cross country flt. An FAA insp examined the wreckage and reported that the fuel selector was…NTSB NYC88LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Georges Mills, NHWitnesses reported the wind was gusty and there were whitecaps on the lake when the acft attempted to takeoff. The plt said that when the acft had climbed to a sufficient altitude he began a left turn to climb over the lake. After the turn was started the…NTSB NYC88LA190Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Greenland, NHThe intention of the flight was to give people at an annual company picnic a ride in the aircraft. After takeoff and while starting a left turn the pilot stated that he encountered a 'sudden windshear/downdraft.' The aircraft never got above 200 feet and…NTSB NYC88LA179Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Plymouth, NHThe plt reported that the eng lost power during takeoff as the acft was climbing thru about 200 to 250 ft AGL. Unable to restore power, he turned to land in a corn field, but was unable to reach it. He then selected a smaller field, but during the landing,…NTSB NYC88LA177Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Laconia, NHThe plt stated that after pickup on a banner tow operation, the tow became twisted and he elected to return and release. On downwind, the acft began a rapid descent which the plt could not compensate for, even after releasing the banner and adding power.…NTSB NYC88LA161Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103A · Franconia, NHDuring takeoff, turbulence was encountered and the student pilot had a hard time controlling the glider. As the instructor took control, the student released the tow rope. The instructor pushed the nose down and turned in an attempt to level the wings, but…NTSB 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…NTSB NYC88LA154Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Kensington, NHUpon reaching the destination airport, the pilot decided to do a few touch and go landings. The aircraft touched down about 600 feet downfield at about 45-50 mph. The pilot reported that with application of full throttle, the engine hesitated. The aircraft…NTSB NYC88LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R · Manchester, NHA flight to burlington, Vermont was uneventful. While on the ground at burlington the aircraft was serviced; then the flight was continued. After about one hour of flight, high engine temperature and low oil pressure was experienced and the aircraft landed at…NTSB NYC88LA117Accident · No injuriesLimited investigationFinal reportMooney M20 · Manchester, NHMaintenance personnel improperly installed the number two connecting rod (p/n L-10646) causing it to separate, create a hole in the engine case, loss of engine oil and engine power. Due to the pilot's improper inflight decision, he performed a wheels up…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 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…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 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…NTSB 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…NTSB NYC87LA263Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Kingston, NHDuring flight, the pilot noticed the engine RPM was high. He was unable to control the RPM with the prop control. He reduced the throttle setting, but soon thereafter, the engine began running rough with a severe vibration. The pilot selected a field for an…NTSB 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,…NTSB NYC87LA218Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Newport, NHOn takeoff the aircraft failed to gain sufficient airspeed to maintain flight. The takeoff was aborted after reaching 200 feet altitude and the aircraft was landed on the runway. The aircraft continued off the end of the runway and collided with a sandbank.…NTSB NYC87DNC08Accident · 1 fatalFinal reportCessna R172K · Cantebury, NHA local CFI heard the plt transmit over the UNICOM freq that he was 'north of the airport at 1100 ft & out of gas, so I guess I'm going to crash.' Attempts to contact the plt were unsuccessful. The CFI flew north of the airport & located the plane where it…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…