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 ERA09FA343Accident · 1 fatalField investigationFinal reportCessna 177 RG · Gilford, NHA loss of engine power due to oil exhaustion from the fracture of the nipple for the engine oil cooler return line. Contributing to the accident was the mechanic's signoff and release of the airplane without performing the required engine run-up following an…NTSB ERA09CA337Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Meredith, NHThe pilot’s failure to maintain control during landing.NTSB ERA09CA177Accident · Serious injuriesData collectionFinal reportHI-Max 1700R · Windham, NHThe non-certificated pilot's failure to maintain clearance from houses while flying an unregistered experimental, amateur-built airplane.NTSB ERA09LA105Accident · Serious injuriesLimited investigationFinal reportBell 407 · Bow, NHAn interruption of fuel flow for undetermined reasons, which resulted in an engine flameout.NTSB ERA09LA021Accident · No injuriesLimited investigationFinal reportSteele John J Acro Sport · Madison, NHThe loss of engine power due to carburetor icing as a result of the pilot's failure to apply carburetor heatNTSB ERA09CA014Accident · Serious injuriesData collectionFinal reportPiper J3C-50 · Epping, NHThe pilot's improper preflight inspection and his decision to fly an unairworthy airplane.NTSB MIA08CA193Accident · Serious injuriesData collectionFinal reportCameron Balloons Z-150 · Sandown, NHThe pilot’s encounter with high winds during approach. Contributing to the severity of injuries was the passengers' improper landing preparation.NTSB NYC08LA293Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Bristol, NHThe pilot's failure to clear the trees during takeoff due to a partial loss of engine power for undetermined reasons.NTSB NYC08CA285Accident · Serious injuriesData collectionFinal reportHaines Searey · Sunapee, NHThe pilot's failure to ensure that the landing gear was retracted for the water landing.NTSB NYC08CA068Accident · No injuriesData collectionFinal reportCessna 170B · Alton, NHThe pilot's failure to maintain clearance above a frozen lake while maneuvering. Factors contributing to the accident were the pilot's attempt of the low altitude maneuver, and unfavorable lighting conditions.NTSB NYC08CA032Accident · No injuriesData collectionFinal reportBrand, Richard Bateleur 2000 · West Ossipee, NHThe pilot's failure to maintain aircraft control, while practicing aerobatics.NTSB CHI08CA017Accident · Serious injuriesData collectionFinal reportBalloon Works Firefly 7 · East Hampstead, NHThe pilot's excessive descent rate on approach, which resulted in a hard landing. Contributing factors were the adverse winds encountered during the flight, and the presence of the trees and power lines near the landing area.NTSB NYC07CA230Accident · No injuriesData collectionFinal reportGrenier Kitfox IV · Moultonboro, NHThe failure of both spark plugs in the number 3 cylinder which resulted in a partial loss of engine power.NTSB NYC07CA128Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Nashua, NHThe flight instructor's inadvertent entry into a vortex ring state (settling with power). Factors to the accident was the tailwind.NTSB NYC07CA118Accident · Minor injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 · Franconia, NHThe pilot's failure to obtain the proper touchdown point. A factor in the accident was an encounter with an updraft while on approach.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 NYC07CA103Accident · No injuriesData collectionFinal reportChampion 7ECA · Nashua, NHThe pilot's misjudged altitude while maneuvering for a banner pickup, which resulted in the banner rope becoming entangled in the airplane's landing gear, and a hard landing, during the ensuing emergency off airport landing.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 NYC07LA030Accident · No injuriesLimited investigationFinal reportStump Rotorway Exec 90 · Manchester, NHAn improperly installed oil line, which resulted in oil line fatigue failure and a subsequent loss of oil to the engine. A contributing factor was the sloping terrain at the forced landing site.NTSB NYC06LA216Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Hampton, NHThe pilot's failure to maintain directional control during takeoff.NTSB NYC06CA196Accident · No injuriesData collectionFinal reportCessna 172N · Windsor, NHThe pilot's delay in aborting the takeoff, which resulted in an overrun and subsequent collision with trees. A factor in the accident was the tailwind.NTSB NYC06CA105Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Laconia, NHThe pilot's failure to maintain directional control during the landing.NTSB 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.NTSB NYC06CA047Accident · Minor injuriesData collectionFinal reportCessna 180H · Greenville, NHThe pilot's inadequate pre-flight inspection, which resulted in water-contaminated fuel in the engine and subsequent engine failure.NTSB NYC06CA041Accident · No injuriesData collectionFinal reportRobinson R-22B · Rochester, NHThe flight instructor's failure to maintain adequate clearance while providing hovering instruction, which resulted in tail rotor ground contact. A factor in this accident was the gusty wind conditions.NTSB NYC06FA027Accident · Serious injuriesField investigationFinal reportEmbraer 110P1 · Manchester, NHThe pilot’s misapplication of flight controls following an engine failure. Contributing to the accident was the failure of the sun gear, which resulted in the loss of engine power. Contributing to the sun gear failure were the engine manufacturer’s…NTSB 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.NTSB NYC05LA130Accident · Minor injuriesLimited investigationFinal reportRaytheon A36 · Nashua, NHThe pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion, and subsequent collision with trees during a forced landing.NTSB IAD05LA114Accident · 2 fatalLimited investigationFinal reportConvair BT-13A · Lyme, NHThe pilot's improper fuel management which resulted in an incorrect fuel selector position, fuel starvation, and subsequent loss of engine power. A factor in the accident was the pilot's failure to maintain adequate airspeed and inadvertent stall.NTSB IAD05LA108Accident · No injuriesLimited investigationFinal reportRobinson R22 · Nashua, NHThe flight instructor's failure to maintain aircraft control during a introductory flight and his inadequate remedial actions.NTSB IAD05LA091Accident · No injuriesLimited investigationFinal reportCessna 152 · Concord, NHThe student pilot's failure to maintain airspeed, and the flight instructor's inadequate remedial action, which resulted in an inadvertant stall and uncontrolled descent into terrain.NTSB IAD05LA089Accident · 1 fatalLimited investigationFinal reportLongtin Kitfox Model III · New London, NHThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor in the accident was the tail wind condition.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 IAD05LA057Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Hampton, NHThe pilot's improper decision to depart with a tailwind, and his failure to perform preflight performance calculations.NTSB NYC05FA042Accident · 1 fatalField investigationFinal reportEmbraer EMB-110P1 · Swanzey, NHThe pilot's improper decision to attempt a single-engine missed approach with the airplane in a slow airspeed, full flap configuration, which resulted in a minimum control speed (Vmc) roll. Contributing factors included an inoperative engine for undetermined…NTSB 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.NTSB NYC05CA004Accident · Minor injuriesData collectionFinal reportBoeing Stearman B75-N1 · Jaffery, NHThe pilots inadvertent encounter with a downdraft wind condition and the airplane's inability to climb, which resulted in a forced landing. A factor related to the accident was the downdraft wind conditions.NTSB NYC04LA212Accident · No injuriesLimited investigationFinal reportCessna 182H · Nashua, NHAn in flight collision with birds while landing. A factor was the night conditions.NTSB NYC04LA193Accident · Minor injuriesLimited investigationFinal reportGlobe Swift GC-1B · Wolfeboro, NHThe pilot's inadequate compensation for wind condition. The windshear was a contributing factor.NTSB NYC04LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Jaffrey, NHThe loss of engine power for undetermined reasons.NTSB NYC04FA157Accident · 1 fatalField investigationFinal reportLake LA-4-200 · Wilmot, NHThe pilot's continued VFR flight into IMC conditions, and his failure to maintain terrain clearance, which resulted in a controlled flight into terrain. Factors in the accident were the low cloud ceiling and the pilot's lack of recent instrument time.NTSB NYC04IA152Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-114 · Manchester, NHThe Airbus captain's misjudged clearance, which resulted the left wing of the Airbus contacting the rudder of the stationary Canadair.NTSB 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.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 IAD03CA061Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Nashua, NHThe pilot's failure to determine the wind direction, which resulted in a hard, tailwind landing.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 NYC02FA196Accident · 2 fatalField investigationFinal reportPiper PA-30 · Gilford, NHThe flight instructor's failure to maintain airplane control, which resulted in an uncontrolled collision with water.NTSB NYC02FA178Accident · 7 fatalField investigationFinal reportBeechcraft 58P · Swanzey, NH**This report was modified on 2/24/2016. Refer to the public docket for this accident for additional information.** the pilot's improper preflight planning and his decision to depart with known landing gear system mechanical deficiencies, which resulted in a…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.