NTSB investigations, NH
25 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1985 | 2 |
| 1987 | 2 |
| 1988 | 2 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 3 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2005 | 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\" = 353)
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" = 353) 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 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 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 NYC00LA002Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wolfeboro, NHA total loss of engine power for undetermined reasons.NTSB IAD99LA002Accident · No injuriesLimited investigationFinal reportNavion A · Jaffrey, NHThe pilot's inadequate aircraft preflight and subsequent failure to refuel the aircraft resulting in fuel exhaustion. A factor was the lack of suitable terrain to execute a forced landing.NTSB NYC98FA129Accident · 1 fatalField investigationFinal reportHawker Hunter T MK 8 · Manchester, NHFuel exhaustion, resulting from the pilot's reliance on an inaccurate fuel quantity indicating system. A factor in the pilot's death was his intentional delay of the ejection sequence in order to avoid people and property on the ground.NTSB NYC97LA070Accident · No injuriesLimited investigationFinal reportCessna 150E · Wolfeboro, NHThe pilot's improper preflight, and failure to refuel the airplane, which resulted in fuel exhaustion during the initial climb after takeoff, and the subsequent forced landing and collision with a mound of dirt.NTSB NYC96LA187Accident · No injuriesLimited investigationFinal reportCessna 180K · Derry, NHthe pilot's inadequate preflight inspection, which failed to detect water contaminated fuel, and resulted in a loss of engine power. A factor relating to the accident was: the pilot's operation of the aircraft with a known deficiency that consisted of a fuel…NTSB IAD96FA138Accident · 4 fatalField investigationFinal reportPiper PA-24-180 · Whitefield, NHthe pilot's failure to adequately preflight the aircraft which led to the loss of engine power due to fuel exhaustion, and the pilot's attempt to return to the airport by executing a steep left turn which led to a stall and subsequent loss of control of the…NTSB NYC95LA055Accident · No injuriesLimited investigationFinal reportBeech C23 · Rochester, NHThe pilot's inadequate inflight planning/decision and inadvertently turning the ignition switch to the off position. A factor was the ignition switch stuck in the off position.NTSB NYC93LA078Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Durham, NHImproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power. Factors related to the accident were flight into adverse weather conditions, failure to obtain inflight weather information, and pilot fatigue.NTSB NYC93LA041Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Londonderry, NHThe pilot's inadequate inflight decision which resulted in fuel exhaustion and the loss of engine power. Contributing was the pilot's inadequate preflight planning and preparation.NTSB NYC93LA008Accident · No injuriesLimited investigationFinal reportCessna 152 II · Milford, NHThe instructor pilots improper in-flight planning, and his failure to maintain a proper glide path to the forced landing area. A factor in this accident was the instructor's decision to shut down the engine during a 'simulated' engine failure .NTSB BFO92LA110Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Belmont, NHInadequate in-flight planning/decision by the pilot.NTSB NYC92LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Orford, NHThe student pilot became lost and disoriented.NTSB NYC91LA084Accident · Minor injuriesLimited investigationFinal reportCessna 210 · East Swanzey, NHThe pilot's lack of familiarity with this airplane and his inadequate preflight, which resulted in miscalculations of fuel consumption and subsequent fuel exhaustion. Factors related to this accident were: the leaking of fuel caps, the inaccurate fuel…NTSB NYC90DNC01Accident · Serious injuriesFinal reportCessna 180E · Kingston, NHAn inflight collision with water while maneuvering for a forced landing. A factor to the accident was a power loss due to the pilot's improper use of the mixture control.NTSB NYC89LA044Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Laconia, NHAircraft striking the road sign after the aircraft experienced a double power loss due to mismanagement of the fuel system by the pilot.NTSB NYC88LA243Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Keene, NHThe plt received a head inj and was not able to relate the details of the acdt. The acft crashed into trees about 3 mi short of the landing rwy at the conclusion of a cross country flt. An FAA insp examined the wreckage and reported that the fuel selector was…NTSB NYC87DNC08Accident · 1 fatalFinal reportCessna R172K · Cantebury, NHA local CFI heard the plt transmit over the UNICOM freq that he was 'north of the airport at 1100 ft & out of gas, so I guess I'm going to crash.' Attempts to contact the plt were unsuccessful. The CFI flew north of the airport & located the plane where it…NTSB NYC87LA194Accident · Serious injuriesLimited investigationFinal reportChampion 7GCB · Sullivan, NHThe pilot of the float equipped citabria 7GCBC experienced a power loss when he added power and raised his nose for a cruise climb from 3500 ft. he set up for a forced landing in a pond. As he neared touchdown, the engine regained power and responded to the…NTSB NYC86LA004Accident · No injuriesLimited investigationFinal reportCessna 140 · Newport, NHAcft collided with trees while executing a go-around. The acft lost power, the plt lowered the nose in an attempt to restart the eng while turning right in an effort to return to the rwy. The acft stalled and collided with trees.NTSB NYC85FA060Accident · 4 fatalField investigationFinal reportPiper PA-31-350 · Whitefield, NHThe acft crashed after executing a missed approach at Whitefield during IMC wx. The acft was seen at 300-400 ft AGL during some part of the maneuvering near the arpt. The acft seemed to be heading for the arpt when last seen by ground observers. The only…NTSB NYC84FNC10Accident · Serious injuriesFinal reportBell 47G-3B1 · Lincoln, NHThe acft was being used in a passenger sightseeing operation when shortly after takeoff the eng ceased to operate & the acft crashed into trees. Both passengers aboard the helicopter observed that the fuel gage indicated empty prior to the eng stopage. Exam…NTSB NYC83LA239Accident · No injuriesLimited investigationFinal reportBeech A23 · Manchester, NHThe acft collided with VASI lights during an emergency landing. The pilot was making touch & go landings. On the 4th takeoff the engine lost power at 150 ft. the pilot switched the fuel selector to left tank and the engine regained power. In maneuvering at…NTSB NYC83LA233Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Windham, NHThe eng quit during takeoff & the acft crashed into trees. The plt admitted having used 87 octane automotive no-lead gasoline in the acft.