NTSB investigations, ME
31 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1987 | 1 |
| 1988 | 3 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 5 |
| 1993 | 2 |
| 1995 | 1 |
| 1997 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 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\" = 260)
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" = 260) 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 NYC07CA097Accident · No injuriesData collectionFinal reportCessna A185F · Ashland, METhe pilot's failure to maintain aircraft control while taxiing, which resulted in a nose over. A factor in this accident was the frozen, slush covered lake.NTSB NYC07LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Livermore Falls, METhe pilot's failure to maintain directional control during landing, which resulted in a groundloop.NTSB IAD05CA128Accident · No injuriesData collectionFinal reportPresley RV-4 · Biddeford, METhe pilot's failure to maintain directional control. Contributing to the accident was the wind gusts.NTSB NYC04CA190Accident · Serious injuriesData collectionFinal reportClassic Waco YMF · Bar Harbor, METhe pilot's inadequate compensation for wind conditions. A factor was the crosswind.NTSB IAD02LA073Accident · No injuriesLimited investigationFinal reportPiper PA-11S · Palermo, MEpilot's failure to maintain directional control and his inadequate compensation for wind. A factor was the crosswind.NTSB IAD02LA027Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Waterville, METhe pilot's improper decision to attempt a takeoff from a snow-covered runway with a quartering tailwind.NTSB IAD01LA030Accident · No injuriesLimited investigationFinal reportCessna 120 · Trenton, METhe pilot's improper touchdown in the snow after the airplane became prematurely airborne during an attempted takeoff. A factor was the pilot's inadequate training.NTSB NYC00LA168Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Turner, METhe pilot's failure to maintain directional control after landing. A factor in this accident was the high grass along the runway edge which disguised an embankment.NTSB NYC99LA176Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Sanford, METhe pilot's failure to maintain control of the airplaneNTSB IAD99LA073Accident · No injuriesLimited investigationFinal reportMonocoupe 110 · Limington, MEPilot's failure to maintain directional control during the landing rollout.NTSB NYC97LA153Accident · No injuriesLimited investigationFinal reportCessna 185 · Norway, METhe pilot's failure to maintain control of the airplane while maneuvering to avoid an obstacle.NTSB NYC96LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · Sanford, MEthe pilot's failure to adequately compensate for a crosswind during the landing roll, which resulted in a collision with a snowbank. Factors relating to the accident were: ice on the runway and the gusty crosswind condition.NTSB BFO93LA111Accident · No injuriesLimited investigationFinal reportCessna 150 · Pittsfield, MELoss of the tail wheel steering due to undetermined reason(s).NTSB NYC93LA070Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Norridgewock, METhe pilot at the controls failed to maintain directional control of the airplane, and the flight instructor provided inadequate supervision. A related factor was the pilot at the controls had no flight experience in the make and model of airplane being flown.NTSB BFO92LA122Accident · No injuriesLimited investigationFinal reportCessna 185 · Dover Foxcroft, MEInadequate servicing of the aircraft which resulted in the lack of hydraulic fluid and the consequent loss of brake presure.NTSB NYC92LA116Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Greenville, METhe pilots decision to initiate a step turn into the wind. Factors related to the accident were the crosswind and gusts.NTSB NYC92LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Dexter, MEA failure of the top torque link bolt on the nose landing gear which resulted in a landing with a flat strut and misaligned wheel.NTSB BFO92LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · Brewer, METhe pilot's decision to land on an icy runway and then attempt to take off. Contributing to the accident was the pilot's decision to completely raise the flaps after the balked landing.NTSB NYC92LA091Accident · No injuriesLimited investigationFinal reportBeech 99 · Bangor, METhe pilot's failure to maintain aircraft control while taxiing on an icy surface. Factors related to the accident were the unfavorable winds and the icy ramp conditions.NTSB NYC91LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Greenville, MEInadequate compensation for gusting winds by the pilot-in-command.NTSB NYC91LA156Accident · No injuriesLimited investigationFinal reportBoeing PT-17A75N1 · Limington, METhe improper handling of the airplane while taxiing, which resulted in a loss of control. A factor was the limited experience of the pilot in this model.NTSB NYC90LA160Accident · 1 fatalLimited investigationFinal reportCessna U206F · Augusta, MEImproper planning/decision by the pilot, and his failure to compensate for wind conditions. The unfavorable wind conditions and rough water were related factors.NTSB NYC89LA055Accident · No injuriesLimited investigationFinal reportCessna 172 · Wiscasset, METhe plt lost control during an attempted go-around, and collided with trees off the side of the runway. The pilot said that a gust of wind turned the acft 45 degrees to the runway on landing roll, and during the attempted go-around he hit tree tops off to the…NTSB NYC88LA244Accident · No injuriesLimited investigationFinal reportCessna 177 · Machias, METhe plt was practicing night takeoffs and landings. He stated that he had successfully accomplished two full stop landings. After the third landing, he applied full power to execute a go-around. The pilot said the airplane pulled to the left so he reduced the…NTSB NYC88LA106Accident · No injuriesLimited investigationFinal reportCessna 172 · Old Town, MEFollowing rollout from a normal landing in strong winds, and during a left turn onto the taxiway, the wing of the aircraft was lifted up by a quartering tailwind and flipped over.NTSB NYC87DNC09Accident · No injuriesFinal reportDubois Beta Bird · Biddeford, METhe pilot was practicing takeoffs and landings in his homebuilt aircraft. Directional control of the aircraft was lost after it touched down during a landing. Subsequently, it swerved off the side of the runway, went in an area of tall grass & hit a ditch,…NTSB NYC85LA188Accident · No injuriesLimited investigationFinal reportLake LA-4 · Sidney, MEAccording to the plt, the acft was on step and in indicating about 45 KTS airspeed. It then encountered a boat wake and began flying. The acft porpoised 2 or 3 times and then collided with the water in an estimated 10 to 15 deg nose down attitude. The pwr was…NTSB NYC85FNC05Accident · Serious injuriesFinal reportBarnes AX7 · Gorham, METhe pilot took off with three passengers in a hot air balloon. There was an unforecast wind change with an increase in velocity. This change in wind direction and velocity precluded the ability to make a landing and keep the basket upright. When the basket…NTSB NYC85LA038Accident · No injuriesLimited investigationFinal reportGulfstream 690B · Millinocket, MEPlt stated that after touchdown, acft began a left drift. As plt applied corrective input, he noted the left wheel was in a snow windrow, so additional input was made to break wheel free of window. Left wheel crossed windrow as acft swerved right but plt was…NTSB NYC83LA119Accident · No injuriesLimited investigationFinal reportBeech Sport · Bangor, METhe acft ran off the runway and collapsed the landing gear during landing. The student pilot had made 7 successful landings. On this final landing a gust of wind blew the acft across the runway and the pilot lost direction control. The acft went off the left…NTSB NYC82DA233Accident · Serious injuriesFinal reportCessna 205A · Augusta, MEOn landing, a severe drag on the left landing gear overcame pilot's attempted corrections. The aircraft went off the runway, down an embankment and overturned. The left brake locked, due to corrosion of carrier pins.