NTSB investigations, NH
17 cases where the sequence of events included Off-field or emergency landing.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 2 |
| 2010 | 1 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA25LA287Accident · No injuriesClass 4 · LimitedFinal reportGrob-Werke Twin Astir · Franconia, NHThe pilot’s failure to detect the inadvertent deployment of the spoilers, which resulted in a prolonged, excessive descent rate. Contributing to the accident was the pilot’s decision to conduct a downwind approach versus a straight in approach to the…NTSB ERA25LA237Accident · Minor injuriesClass 3 · LimitedFinal reportGyro Technic GT-VX2 · Swanzey, NHThe pilot’s failure to maintain rotor rpm of the gyroplane during a low approach, while distracted by other aircraft in the airport traffic pattern, which resulted in the pilot’s decision to perform an off-runway landing.NTSB ERA24LA276Accident · Minor injuriesClass 3 · LimitedFinal reportSnyder Searey · New Ipswich, NHA total loss of engine power due to the exhaust muffler and tailpipe assembly separating from its attach points and impacting the propeller.NTSB ERA23LA360Accident · No injuriesClass 3 · LimitedFinal reportBrown Benjamin C Challenger II · Moultonborough, NHA loss of engine power due to a loss of compression in one of the engine’s two cylinders.NTSB ERA23FA033Accident · 2 fatalClass 3 · FieldFinal reportBeech A24 · Keene, NHImproper maintenance of the fuel injector nozzles and the pilots’ failure to abort the takeoff during the takeoff roll. Contributing to the accident was the mechanic’s decision to return the airplane to service with the engine unable to attain its full rated…NTSB ERA21LA290Accident · 1 fatalClass 3 · LimitedFinal reportCameron 0-105 · Piermont, NHThe balloon pilot’s delay in relighting the burner, which resulted in a hard landing and his ejection from the balloon.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 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 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 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 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 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 ERA09LA511Accident · Minor injuriesLimited investigationFinal reportAir Creation 582SL · Strafford, NHA loss of engine power for undetermined reasons.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 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 heat