NTSB investigations, NH
25 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 4 |
| 1987 | 3 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220) 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 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 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 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 NYC04LA212Accident · No injuriesLimited investigationFinal reportCessna 182H · Nashua, NHAn in flight collision with birds while landing. A factor was the night conditions.NTSB IAD01LA100Accident · 1 fatalLimited investigationFinal reportSocata TB-20 · Amherst, NHSuicide, when the pilot intentionally crashed his airplane into his house.NTSB NYC01LA103Accident · No injuriesLimited investigationFinal reportCessna 177 · Hampton, NHThe pilot's inadvertent encounter with a downdraft, which resulted in a collision with trees. A factor related to the accident were the downdraft wind conditions.NTSB NYC00LA186Accident · No injuriesLimited investigationFinal reportHelfer Flightstar II · Greenland, NHThe pilot-in-command's improper decision to takeoff uphill, on a short runway with 50-foot high utility wires at the end, at a high gross weight. Factors were the high weight and uphill terrain.NTSB NYC99LA004Accident · Minor injuriesLimited investigationFinal reportEnstrom F280 · Bow, NHThe pilot's inadequate visual lookout and his failure to maintain adequate obstacle clearance, which resulted in an in-flight collision with a tower. A factor in this accident was the gusty wind conditions.NTSB IAD96LA117Accident · No injuriesLimited investigationFinal reportBeech A100 · Manchester, NHThe pilots failure to maintain control of the aircraft during a coupled approach. A related factor was the unmonitored inoperative glide slope.NTSB BFO94LA153Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Wolfeboro, NHThe pilot's failure to maintain directional control during landing which resulted in inflight collission with trees.NTSB BFO93FA135Accident · 2 fatalField investigationFinal reportKrowell Christen Eagle II · Lebanon, NHInadequate crew/group coordination.NTSB BFO92LA099Accident · Serious injuriesLimited investigationFinal reportPiper PA28-161 · Brentwood, NHA delay by the pilot in aborting the landing which resulted in failure to clear the obstacles.NTSB NYC92LA010Accident · 1 fatalLimited investigationFinal reportBalloon Works Firefly 7 · Webster, NHFailure of the ground crewman (from another Balloon) to recognize the hazardous condition that existed, when the Balloon came in contact with a high voltage power line during a precautionary landing. Factors related to the accident were: the lack of suitable…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 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 NYC87LA137Accident · No injuriesLimited investigationFinal reportStearman PT-17 · Hampton, NHWhile on final approach, the plt stated that the acft encountered a moderate crosswind. At abt mid-field, the plt elected to make a go-around, however, due to windshear and/or downdrafts, the acft was unable to climb. The Stearman collided with several tall…NTSB NYC87LA060Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Randolph, NHStudent pilot on a cross country instructional flight became disoriented, decided to return to departure airport. However seeing that he was running low on fuel looked for an airport to land to refuel and find out his location. He decided to make a…NTSB ATL86FA240Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Hampton, NHThe acft was flying at low alt in the vicinity of interstate I-95 when the plt made a 360 deg, rgt turn. After the turn, the acft collided with pwr lines, which crossed I-95, then crashed & burned. A witness estimated the acft had dscndd to about 35 to 50 ft…NTSB NYC86FNC08Accident · 2 fatalFinal reportChampion 7HC · Epsom, NHA student pilot and passenger on a local flight collided with a tree, crashed and burned. No malfunction was found with the aircraft and engine. The plts flt time was not reported or available.NTSB NYC86LA168Accident · No injuriesLimited investigationFinal reportBell 206B III · Moultonboro, NHThe Bell jet ranger had just dropped off an external load and was returning downhill when the pilot reported hearing a growling noise in the aft portion of the aircraft. He autorotated to landing as control was lost. When the wreckage was examined after it…NTSB NYC86LA129Accident · Minor injuriesLimited investigationFinal reportCessna 150K · North Hampton, NHThe acft settled into trees during a landing apch. The plt reported that he added full power with the carburetor heat off and was still unable to stop the descent. When flt checked by the FAA, the plts slow flt and stall recovery procedures were found to be…NTSB NYC86DNC01Accident · Minor injuriesFinal reportBurkhart Grob 103 · Franconia, NHThe pilot flying a grob 103 was engaged in ridge soaring when the aircraft encountered down or sinking air. The aircraft was unable to recover prior to striking trees. The aircraft received substantial damage and the pilot received serious injuries while the…NTSB NYC85FNC02Accident · Serious injuriesFinal reportPiper PA-34-200T · Hopkinton, NHThe acft collided with a tree during an ILS approach in IMC wx. The acft was on a x-cty flt and the plt declared a missed approach at this pt but did not acknowledge hitting the tree. When the rt eng quit and directional control could not be maintained the…NTSB NYC84FNC03Accident · Serious injuriesFinal reportPiper PA-28-140 · Hampton, NHPurpose of flt was to obtain actual experience in short/soft field operations. Takeoff was initiated on a runway that was not only short and soft, but uphill and with a 70 degree left crosswind. Under these conditions, acft performance was inadequate to clear…NTSB NYC82DA168Accident · No injuriesFinal reportPiper PA-18S · Moultonboro, NHAccording to the pilot, he taxied to a takeoff point farther out than normal and it took longer to get the plane "on the step" due to very heavy air. When the pilot reached the abort point he used control back pressure to "pop off" the water. However, he was…