NTSB investigations, NH
5 cases where the sequence of events included Other weather encounter.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2016 | 1 |
| 2019 | 1 |
| 2020 | 1 |
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\" = '400' 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" = '400' 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 ERA20CA098Accident · No injuriesData collectionFinal reportMaule M7 · Manchester, NHThe pilot's improper landing flare in crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a ground-loop.NTSB GAA19CA524Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Manchester, NHThe student pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with approach lights.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 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 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.