Skip to content

NTSB investigations, ME

24 cases where the first occurrence was “Hard landing”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19832026

Where

Latest cases

Query with SQL

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" = 200) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 200)
  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" = 200)
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 NYC06CA069Accident · No injuriesData collectionFinal reportCessna 152 · Augusta, METhe pilot's improper flare, which resulted in a hard landing.Feb 15, 2006 · N47105 · Substantial damage NTSB IAD04CA038Accident · No injuriesData collectionFinal reportPiper PA-28R-180 · Eliot, METhe pilot's failure to maintain airspeed above stall which resulted in a hard landing and collapse of the landing gear. Also causal was the flight instructor's inadequate supervision.Aug 17, 2004 · N4631J · Substantial damage NTSB NYC03LA210Accident · No injuriesLimited investigationFinal reportSimoneau Kitfox Classic IV · Limington, METhe pilot's improper flare, which resulted in a hard landing. A factor in this accident was the pilot's lack of experience in make and model.Sep 14, 2003 · N10224 · Substantial damage NTSB IAD01LA105Accident · No injuriesLimited investigationFinal reportBeech 19 · Augusta, METhe student pilot's improper flare, which resulted in a hard landing.Aug 25, 2001 · N2009A · Substantial damage NTSB NYC99LA227Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, MEImproper recovery from a bounced landing.Sep 13, 1999 · N5337L · Substantial damage NTSB NYC96LA180Accident · No injuriesLimited investigationFinal reportBeech 19 · Augusta, MEthe student pilot's improper flare, which resulted in at hard landing.Sep 1, 1996 · N2009A · Substantial damage NTSB NYC95LA198Accident · Minor injuriesLimited investigationFinal reportBell 206B · Bingham, MEthe pilot's inadequate landing flare resulting in a hard landing and roll over, and a subsequent collision with trees.Aug 18, 1995 · N16915 · Destroyed NTSB NYC95LA093Accident · No injuriesLimited investigationFinal reportCessna 185 · Bangor, MEthe pilot's improper flare, which resulted in a hard landing and collapse of the right main gear.Apr 24, 1995 · N62EC · Substantial damage NTSB BFO94LA115Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Orrington, METhe pilot misjudged his altitude and airspeed which resulted in a hard landing. Related factors were the soft, and upslope field.Jun 18, 1994 · N2000U · Substantial damage NTSB NYC93LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Fryeburg, METhe student pilot's improper recovery from a bounced landing resulting in the collapse of the nose gear and the subsequent nose over. A factor was an improper flare.Aug 8, 1993 · N25211 · Substantial damage NTSB NYC93LA134Accident · No injuriesLimited investigationFinal reportCessna 150E · Oxford, METhe pilot's improper landing flare which resulted in a hard landing. A factor was the pilot's lack of experience.Jun 30, 1993 · N3023J · Substantial damage NTSB BFO92LA138Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Greenville, METhe pilot's inadequate flare resulting in a hard landing.Sep 13, 1992 · N4319A · Substantial damage NTSB BFO92LA071Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Turner, METhe pilot's inadequate flare which resulted in a hard landing. Contributing to the accident was the soft terrain.May 21, 1992 · N9446G · Substantial damage NTSB BFO92LA045Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Brewer, METhe pilot's failure to correct an excessive descent rate during flare. Contributing to the accident was the pilots improper compensation for wind conditions.Mar 19, 1992 · N62951 · Substantial damage NTSB NYC89LA210Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · South Harpswell, MEA delay by the pilot in aborting a late go-around. Factors related to the accident were: the pilot's improper flare for landing, his improper recovery from the subsequent bounced landing, and tree(s) near the runway.Sep 4, 1989 · N4554L · Substantial damage NTSB NYC88LA171Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Steep Falls, METhe Ercoupe 415C took off to practice touch and go's with a student pilot in the left seat and on the controls. In the right seat was a private pilot who was listed as a pilot rated passenger. Both occupants were co-owners of the aircraft. The student pilot…Jun 18, 1988 · N94037 · Substantial damage NTSB NYC87LA214Accident · No injuriesLimited investigationFinal reportBeech B19 · Augusta, METhe student plt rprtd that during a practice landing, he rounded out too high. Subsequently, the acft bounced hard & the nose gear collapsed. After coming to rest, the plt exited the acft, but a fire erupted & the acft was destroyed.Aug 4, 1987 · N23838 · Destroyed NTSB NYC85LA192Accident · No injuriesLimited investigationFinal reportCessna P206D · Limerick, MEDuring the short field approach, as the aircraft passed over the tree line, the sink rate suddenly increased. The pilot applied power and increased the pitch but the aircraft touching down hard and bounced. A second touch down was made and as the nosewheel…Jul 23, 1985 · N8789Z · Substantial damage NTSB NYC85LA146Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Old Town, MEDuring a pwr off landing, the instructor noticed that the airspeed was low. The instructor applied full pwr; however, the acft stalled and the plt was unable to recover the acft prior to coming in contact with the water.Jun 12, 1985 · N82126 · Substantial damage NTSB NYC84FNC05Accident · Serious injuriesFinal reportRaven RX 6 · North Lebannon, MEStudent balloon pilot was on third supervised solo flt with his flt instructor acting as member of the chase crew. Plt was controlling descent with short bursts of propane burner. Ground contact was hard enough to cause the balloon skirt to continue downward…Jul 3, 1984 · N5568A · Destroyed NTSB NYC84DNC04Accident · No injuriesFinal reportMaule M-5-235C · Millinocket Lke, METhe acft was landed hard on the glassy smooth surface of a lake. The plt admitted that the landing was hard and that after the touchdown the left float split open and the acft sank in 40 ft of water. Witnesses stated that the lake surface was calm and smooth…Jun 30, 1984 · N4468P · Destroyed NTSB NYC84IA164Incident · Minor injuriesIncident investigationFinal reportBarnes Firefly 7 · Gorham, MEDuring touch and go landings the balloon encountered increased winds. The balloon touched down hard tilting the basket onto its side. A passengers arm became caught between the basket and the ground.May 7, 1984 · N3613D · No damage NTSB NYC83LA191Accident · No injuriesLimited investigationFinal reportCessna 152 · Millinocket, MEAfter a solo x-country flt, the plt misjudged the landing flare & landed on the nose wheel. The acft bounced at least twice. The prop, nosewheel & crankshaft was damaged.Jul 26, 1983 · N5357P · Substantial damage NTSB NYC83FNC08Accident · Minor injuriesFinal reportCessna 172L · Moose River, METhe plt reported that he encountered wind shear & stalled on final approach, which resulted in a bounced landing, then the plane settled and bounced again. He reported that he attempted to go around, but could not get the acft to accelerate to climb speed.…Jul 14, 1983 · N3821Q · Destroyed