NTSB investigations, NH
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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 GAA18CA033Accident · No injuriesData collectionFinal reportEvolution Revo · Berlin, NHThe pilot’s failure to center the ground steering before landing, which resulted in a loss of directional control.NTSB ERA17LA290Accident · No injuriesLimited investigationFinal reportCessna 180 · Newport, NHA leak in the right brake slave cylinder, which led to no fluid in the reservoir and subsequent asymmetric braking.NTSB ERA17FA241Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau EA 300/L · Winchester, NHThe noninstrument-rated pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and collision with terrain. Contributing to the accident was the pilot's self-induced pressure to complete…NTSB GAA17CA392Accident · No injuriesData collectionFinal reportPiper PA22 · Berlin, NHThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA17CA245Accident · No injuriesData collectionFinal reportCessna 180 · Nashua, NHThe pilot's failure to maintain directional control during the landing roll.NTSB GAA17CA087Accident · No injuriesData collectionFinal reportJack Fehling Celebrity · North Hampton, NHThe pilot’s unstabilized approach, which resulted in the biplane being low and striking trees.NTSB GAA17CA067Accident · No injuriesData collectionFinal reportCessna 172 · Concord, NHThe pilot's improper landing flare, which resulted in a hard landing.NTSB GAA17CA052Accident · No injuriesData collectionFinal reportChaudoin George S RV 10 · Portsmouth, NHThe pilot’s failure to go around after recognizing that the airplane was high and fast, which resulted in a long landing on a wet runway and a runway excursion.NTSB GAA17CA005Accident · No injuriesData collectionFinal reportCessna Ector 305 · Concord, NHThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB ERA16LA330Accident · Serious injuriesLimited investigationFinal reportTatkovsky James G Safari · Andover, NHThe noncertificated pilot’s failure to maintain helicopter control during initial climb.NTSB GAA16CA432Accident · No injuriesData collectionFinal reportCessna 150 · North Conway, NHThe pilot's improper fuel management, which resulted in fuel exhaustion, a total loss of engine power, a forced landing, and nose over.NTSB ERA16LA284Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY8 · Northwood, NHThe balloon pilot’s inadequate weather planning and improper decision to depart in reported increasing variable winds with nearby thunderstorms, which resulted in a subsequent hard landing and a serious passenger injury.NTSB GAA16CA377Accident · No injuriesData collectionFinal reportPiper PA 44 · Keene, NHThe flight instructor’s failure to use carburetor heat during the approach while operating in atmospheric conditions that were conducive to carburetor icing, which resulted in a loss of engine power due to carburetor icing.NTSB GAA16CA370Accident · No injuriesData collectionFinal reportCessna 180 · New Durham, NHThe pilot's failure to maintain directional control during landing after encountering a boat wake, which resulted in the airplane veering left, impacting the water's surface, and subsequently becoming submerged.NTSB ERA16LA220Accident · No injuriesClass 3 · LimitedFinal reportChampion 7AC · Gorham, NHThe partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s failure to abort the takeoff after the airplane’s initial failure to climb.NTSB ERA16CA197Accident · Serious injuriesData collectionFinal reportAmerican Champion 7GCBC · Warner, NHAn encounter with instrument meteorological conditions, which resulted in the pilot's spatial disorientation and a loss of airplane control.NTSB GAA16CA230Accident · Minor injuriesData collectionFinal reportGrenier Raymond Vans Aircraft · Keene, NHThe airplane striking a deer during the landing roll, resulting in a loss of directional control, runway excursion, and subsequent nose over.NTSB ERA16LA174Accident · No injuriesLimited investigationFinal reportAmerican Champion 7AC · Keene, NHThe disengagement of the tailwheel locking mechanism during the landing roll due to wear, and a subsequent loss of directional control. Contributing was the pilot's inadequate remedial action, which resulted in a runway excursion.NTSB GAA16CA016Accident · No injuriesData collectionFinal reportCentral Missouri State Univ HP 14 · Jackson, NHThe glider pilot's decision to descend into a broken to overcast cloud layer, which resulted in encountering instrument meteorological conditions and the pilot parachuting from the glider. Contributing to the accident was the pilot's lack of planning for an…NTSB ERA15LA339Accident · 1 fatalLimited investigationFinal reportEvolution Revo · Laconia, NHThe sport pilot’s improper decision to operate the weight-shift-control aircraft at low altitude and his subsequent failure to maintain control of the aircraft, which resulted in a subsequent collision with terrain.NTSB GAA15CA127Accident · No injuriesData collectionFinal reportPaquin Michael A A · Concord, NHThe pilot's inability to maintain directional control during takeoff, which resulted in a roll over. Contributing to the loss of control was the pilot's failure to disengage the main rotor brake prior to takeoff.NTSB ERA15FA241Accident · Serious injuriesField investigationFinal reportPiper PA-22 · Laconia, NHA total loss of engine power for reasons that could not be determined because of insufficient evidence found during postaccident examination of the airframe and engine.NTSB ERA15LA237Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Hampton, NHThe pilot’s failure to properly set the stabilator trim prior to takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.NTSB ERA15CA113Accident · No injuriesData collectionFinal reportCessna 172I · Nashua, NHThe student pilot's lack of vigilance during taxi, which resulted in a collision with a parked truck. A factor in the accident was the truck operator's decision to park on the edge of an active taxiway.NTSB ERA15CA079Accident · No injuriesData collectionFinal reportRobinson Helicopter R66 · Henniker, NHThe pilot's failure to maintain aircraft control while landing, which resulted in a collision with a snow bank. Contributing to the accident was ice that covered the landing surface.NTSB ERA15LA072Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Brookline, NHThe student pilot’s failure to maintain clearance from a wire during an off-airport landing following a partial loss of engine power for reasons that could not be determined during postaccident examination.NTSB ERA14FA417Accident · 2 fatalField investigationFinal reportCessna 180 · North Hampton, NHThe pilot’s failure to ensure the airplane maintained adequate airspeed during the initial climb and the subsequent exceedance of its critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident were the pilot’s impairment…NTSB ERA14CA209Accident · No injuriesData collectionFinal reportCessna T206H · Gilford, NHThe pilot misjudged the float equipped airplane's altitude while maneuvering above the surface of a lake, which resulted in a float inadvertently contacting the water. Contributing to the accident were the glassy water conditions and pilot's lack of recent…NTSB ERA14CA203Accident · Minor injuriesData collectionFinal reportEvolution Revo · Concord, NHThe student pilot's failure to maintain control during a go around, which resulted in a collision with terrain.NTSB ERA14CA195Accident · No injuriesData collectionFinal reportCessna 140 · Colebrook, NHThe pilot's decision to power out of soft snow with a gusty quartering tailwind which resulted in the tail of the airplane rising and the airplane nosing over.NTSB ERA14CA037Accident · No injuriesData collectionFinal reportPiper PA 28-150 · Newport, NHThe pilot's incorrect glide path, which resulted in a landing area overshoot and a runway excursion.NTSB ERA13CA416Accident · No injuriesData collectionFinal reportCessna U206F · Rumney, NHThe pilot's failure to ensure that the amphibious airplane's landing gear was properly configured for a landing on water and his failure to properly configure the airplane during the attempted go-around.NTSB ERA13CA350Accident · No injuriesData collectionFinal reportCessna 172S · Portsmouth, NHThe pilot’s inadequate preflight inspection resulting in his failure to remove the pin he used to lock the flight controls in place of the approved control lock.NTSB ERA13LA327Accident · Minor injuriesLimited investigationFinal reportUnivair 108-1 · Tuftonboro, NHMaintenance personnel’s failure to remove circumferential gouges in the aft radius of the R2 rod journal on the crankshaft during its last engine overhaul, which resulted in the fatigue failure of the crankshaft and a subsequent total loss of engine power.NTSB ERA13CA271Accident · No injuriesData collectionFinal reportFlight Design Ctls · Concord, NHThe pilot's improper landing flare, which resulted in a hard landing and subsequent main landing gear collapse.NTSB ERA13CA265Accident · No injuriesData collectionFinal reportCessna 180 · Concord, NHThe pilot’s delayed remedial action following a loss of directional control during the landing roll.NTSB ERA13FA039Accident · 2 fatalField investigationFinal reportBeech A36 · Hooksett, NHThe pilot's total incapacitation in flight due to an acute heart attack.NTSB ERA13CA040Accident · No injuriesData collectionFinal reportAeronca 7CCM · Hampton, NHThe student pilot's improper landing flare and touchdown, which resulted in a hard landing.NTSB ERA12LA332Accident · Serious injuriesLimited investigationFinal reportStinson SR-7B · West Ossipee, NHThe pilot's inadequate application of carburetor heat which resulted in the formation of carburetor ice and a partial loss of engine power.NTSB ERA12FA175Accident · 1 fatalField investigationFinal reportCessna T182T · Lebanon, NHThe pilot’s failure to maintain airspeed during a return to the airport after takeoff, which resulted in an aerodynamic stall and loss of airplane control.NTSB ERA12LA069Accident · No injuriesLimited investigationFinal reportGrenier Raymond Vans Aircraft RV-8 · Nashua, NHThe right main landing gear collapse due to the overload fracture of the hardware for reasons that could not be determined during postaccident testing and examination.NTSB ERA12CA064Accident · No injuriesData collectionFinal reportStinson 108-3 · Whitefield, NHThe student pilot did not maintain directional control during the landing flare.NTSB ERA11CA384Accident · No injuriesData collectionFinal reportAeronca 7DC · Greenland, NHThe pilot's improper flare, which resulted in a bounced landing, and subsequent loss of control during an attempted go-around maneuver.NTSB ERA11CA319Accident · Serious injuriesData collectionFinal reportAero AT SP Zoo AT-4 LSA · Concord, NHThe student pilot's loss of aircraft control during a go-around maneuver following a bounced landing.NTSB ERA11CA303Accident · No injuriesData collectionFinal reportChampion 7EC-703 · Moultonboro, NHThe pilot’s loss of directional control during the landing rollout, which resulted in a collision with trees.NTSB ERA11LA084Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Rochester, NHThe out-of-rig condition of the tailwheel lock, which resulted in a loss of directional control on landing.NTSB ERA10CA505Accident · No injuriesData collectionFinal reportCessna 172S · Franconia, NHThe pilot’s delay in initiating a go-around, which resulted in an in-flight collision with a fence.NTSB ERA10CA462Accident · Serious injuriesData collectionFinal reportHead Balloons AX9 118 · Hanover, NHThe balloon's encounter with an updraft, resulting in an immediate landing and an intentional collision with a tree.NTSB ERA10CA144Accident · No injuriesData collectionFinal reportPiper PA-28-236 · Alton Bay, NHThe pilot’s failure to maintain directional control while landing on an ice runway.NTSB ERA09LA511Accident · Minor injuriesLimited investigationFinal reportAir Creation 582SL · Strafford, NHA loss of engine power for undetermined reasons.