NTSB investigations, ME
19 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 4 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 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\" = 'ME' 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\" = 240)
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" = 'ME' 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" = 240) 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 NYC05CA078Accident · No injuriesData collectionFinal reportCessna 150F · China, METhe pilot's improper inflight decision to land in a field instead of a nearby airport, after encountering deteriorating weather conditions. A factor was the deteriorating weather conditions.NTSB IAD04LA036Accident · 1 fatalLimited investigationFinal reportCessna 172M · Brownville Junc, METhe pilot's continued visual flight into instrument meteorological conditions, which resulted in the airplane's controlled flight into rising terrain. Factors included the instrument meteorological conditions and the rising terrain.NTSB NYC04IA023Incident · No injuriesIncident investigationFinal reportCessna 208B · Bangor, METhe pilot's inability to see through the windshield, which was obscured due to icing conditions. This resulted in the pilot's inadequate flare, and a subsequent hard landing. A factor contributing to the accident was the wing icing.NTSB IAD97FA095Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Penobscot, METhe pilot's flight into adverse weather conditions, which resulted in the loss of control. Factors relating to the accident were the fog and the pilot's lack of an instrument rating.NTSB IAD96FA090Accident · 1 fatalField investigationFinal reportCessna 320C · Winslow, MEthe pilot's continued flight into known adverse weather conditions, and his loss of aircraft control, which resulted in an uncontrolled descent into terrain (river). The known icing condition was a related factor.NTSB NYC96LA041Accident · No injuriesLimited investigationFinal reportCessna U206G · Bangor, MEthe pilot's improper inflight planning/decision, and his failure to properly plan his approach for landing, so that the airplane would not stall or touchdown hard. Factors relating to the accident were: the adverse weather (icing) condition, the accumulation…NTSB BFO94FA013Accident · 3 fatalField investigationFinal reportBell 206L-1 · Portland, METhe pilot's continued VFR flight into instrument meteorological conditions, and his failure to assure that adequate fuel was available to complete the flight, resulting in a loss of engine power due to fuel exhaustion. Factors which contributed to the…NTSB NYC92DNC02Accident · 1 fatalFinal reportCraig Morehead Bushby Mustang II · Buxton, METhe failure of the pilot to maintain airspeed while maneuvering which resulted in an inadvertent stall with insufficent altitude for recovery. Factors related to the accident were the low clouds and fog, and the pilot's failure to obtain a weather briefing.NTSB NYC90LA131Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Augusta, MEPoor judgement of the pilot, his decision to attempt VFR flight in instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation. Factors related to the accident were: the pilot's lack of proper certification…NTSB NYC89LA189Accident · Minor injuriesLimited investigationFinal reportConvair CV-600-240D · Augusta, METhe failure of the propeller control system for undetermined reasons during a precautionary landing after encountering deteriorating weather conditions during a VFR ferry flight. Contributing factor(s) was: the adverse weather conditions, inadequate…NTSB NYC88FA235Accident · 3 fatalField investigationFinal reportCessna 182RG · Greenville, METhe non-instrument rated pilot apparently could not locate the destination airport because of low ceilings and ground fog. Before the pilot started his trip he was advised by the fss that VFR flight to his destination was not recommended. It appears that the…NTSB NYC87LA239Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Bingham, METhe plt rprtd he was taking off from a lake & was climbing thru about 200-300 ft AGL when the acft enctrd a severe downdraft. Subsequently, the float plane collided with rising terrain. No preimpact part failure or malfunction was rprtd. The plt rprtd the…NTSB NYC87LA205Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Spencer Lake, METhe flight originated at Spencer Lake and flew north then south to baker lake. South of hedgehog mountain the flight encountered downdrafts and a loss of altitude at 500-600 feet per minute. Upon turning right to return to Spencer Lake the aircraft continued…NTSB NYC87FA204Accident · 4 fatalField investigationFinal reportPiper PA-30 · Lincolnville, METhe plt was making an approach to knox county arpt, rockland me and after receiving a wx report from UNICOM that the local wx was below approach minimums he indicated that he would make a missed approach. There was no further communications from the acft. A…NTSB NYC87LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Portland, METhe pilot of the PA-23 was attempting an NDB approach into the Portland, ME. Int'l jetport. The wx was rpt'd as moderate turbulence and moderate or greater icing, the icing level was rpt'd from the surface to 16000 ft. prior to this NDB approach the pilot had…NTSB NYC87FA015Accident · 1 fatalField investigationFinal reportCessna 185 · Greenville, METh plt stated that the acft encountered crosswinds of 20 KTS gusting to 30 KTS as the acft was coming off the step during liftoff in the open lake. The acft's right wing was forced down, the right float struck the water which resulted in the right wing…NTSB NYC84LA067Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Monson, MEOn a crosscountry VFR flight the pilot inadvertently encountered instrument conditions. During a climb to clear surrounding mountains the acft struck trees and crashed. The pilot had been briefed on the deteriorating weather prior to the flight. The pilot and…NTSB NYC83FA204Accident · 2 fatalField investigationFinal reportBeech S35 · Wiscasset, METhe acft was observed taking off on a foggy night with a low overcast sky condition. Shortly after taking off, the plane was observed to turn at low alt, then enter a nose down attitude. The acft crashed & the non-instrument rated plt & passenger were fatally…NTSB NYC83LA123Accident · No injuriesLimited investigationFinal reportCessna 180H · Greenville, METhe wx was estimated at 2,000 to 2,500 ft overcast when the flt departed Greenville at 1820. Horseshoe pond is 1,500 ft MSL & surrounded by 2,700 ft mountains. As the acft approached the pass the pond was visible. However a south wind prevailed & fog had…