NTSB investigations, 1985
27 cases where the first occurrence was “Nose over”.
Cases per year
| 1982 | 62 |
|---|---|
| 1983 | 41 |
| 1984 | 42 |
| 1985 | 27 |
| 1986 | 31 |
| 1987 | 25 |
| 1988 | 20 |
| 1989 | 29 |
| 1990 | 25 |
| 1991 | 29 |
| 1992 | 29 |
| 1993 | 25 |
| 1994 | 31 |
| 1995 | 29 |
| 1996 | 24 |
| 1997 | 17 |
| 1998 | 24 |
| 1999 | 16 |
| 2000 | 28 |
| 2001 | 23 |
| 2002 | 22 |
| 2003 | 13 |
| 2004 | 11 |
| 2005 | 11 |
| 2006 | 12 |
| 2007 | 19 |
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 year(c.\"eventDate\") = 1985
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\" = 300)
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 year(c."eventDate") = 1985 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" = 300) 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 ANC86LA011Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fishtrap Lake, AKPilot attempted to land his wheel equipped aircraft on frozen lake with water overflow and 12 to 18 inches snow. Acft broke through top layer of thin ice and nosed over upon touchdown.NTSB DEN86LA024Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Berthoud, COThe plt stated that he made 7-9 high speed taxies to pack the snow on the grass strip, aborting mid-strip when flying speed was not attained. On the final run, the plt said the acft again failed to reach flying speed and decided to abort mid-strip. The plt…NTSB ANC86LA008Accident · No injuriesLimited investigationFinal reportCessna 150 · Rainbow Lake, AKThe plt reported that after the acft touched down on a snow covered, frozen lake, he was unable to hold the nose gear up, due to the depth of the snow. When the nose came down, the nose gear buckled under & the acft nosed over.NTSB SEA86LA019Accident · No injuriesLimited investigationFinal reportCessna C206 · Funter Bay, AKThe left main gear did not retract and during water landing caused the aircraft to nose over. The link pin rod was found to be broken and the cylinder assembly main retract link and pin down latch were found to be bent.NTSB ATL85LA281Accident · No injuriesLimited investigationFinal reportCessna A188B · Baxley, GAPlt attempted ldg in cultivated field after sowing load of rye grass seed. Grnd was soft and wheel dug in and acft nosed over. Plt was not injured.NTSB ATL85LA265Accident · No injuriesLimited investigationFinal reportBellanca Champion 7GCAA · Alabaster, ALThe plt lost directional control of the acft during a landing. The acft nosed over coming to rest inverted. The plt related that a gust of wind caused the loss of control.NTSB ANC85LA165Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Gold King Creek, AKThe plt stated that when he landed, the acft was rolling out on its main gear in a tail low attitude, when he applied braking action. A moment later, the acft began to pitch nose down. He compensated with full up elevator, but the acft nosed over.NTSB MIA85IA238Incident · No injuriesIncident investigationFinal reportAeronca 7AC · Ft. Lauderdale, FLThe plt stated that while taxing for takeoff the acft encountered a gust of wind. Nosed over & the propeller & right wing tip struck the ground.NTSB ANC85LA155Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Fairbanks, AKDuring landing the plt applied hard braking to avoid an airplane and rolled over.NTSB DEN85LA223Accident · No injuriesLimited investigationFinal reportCessna 120 · Erie, COThe plt stated after the accident that she had landed and the acft rolled aprx 600 ft when she attempted to turn off onto the taxiway while the acft was traveling at a moderate speed. A witness stated that he saw the trees 'lock up' as the acft approached the…NTSB CHI85LA313Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Valparaiso, INThe acft nosed over during landing. The plt said that he made a wheel lndg and after the acft slowed to 20 mph the tail lifted and the acft nosed over.NTSB ANC85LA127Accident · No injuriesLimited investigationFinal reportPiper J-3 · Tyrone Creek, AKThe plt delayed initiating an aborted landing, and the acft rolled into water at the end of the rwy where it nosed over.NTSB MKC85LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Corning, ARThe student plt became disoriented while on a solo cross country flt. When the acft became low on fuel the plt decided to land on a plowed fld. The fld was soft and the acft nosed over shortly after touchdown.NTSB CHI85LA248Accident · No injuriesLimited investigationFinal reportCessna 172 · East Alton, ILThe acft was blown inverted by wind gusts shortly after landing. The plt stated the wx was fine until after touchdown when the wind began gusting to 35 KTS. The plt turned the acft left off the rwy, contacted ground control and initiated a right turn onto the…NTSB NYC85LA149Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Champlain, NYDuring the landing in a pasture with tall grass, the main wheels contacted the grass, the acft slowed rapidly and nosed over.NTSB NYC85LA148Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Peru, NYThe acft nosed over while landing on a private sod airstrip. The plt reported touchdown was made on an unmowed portion of the airstrip. The acft slowed quickly and nosed over just prior to coming to a stop.NTSB CHI85LA217Accident · No injuriesLimited investigationFinal reportCessna 150M · Merrill, WIThe plt was performing touch-and-go's when on the landing roll she allowed the acft to drift off the rwy into soft terrain. The acft nosed over. The plt stated that she was looking inside to raise the flaps.NTSB NYC85LA130Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Pittsburgh, PAThe personal transportation flight took off from allegheny co. ariport and made one landing back at the airport. The flight then departed the airport and made a landing on the water with the wheels down causing the aircraft to tip o ver onto its back.NTSB ANC85LA068Accident · No injuriesLimited investigationFinal reportCessna A152AEROBAT · Whittier, AKThe pilot in command failed to perform an adequate reconnaisance of the airport prior to landing and did not avail himself of all information concerning the runway conditions.NTSB NYC85LA102Accident · No injuriesLimited investigationFinal reportCessna 172 · Kintnersville, PAThe pilot decided to abort the takeoff when he realized that too much runway was being used. During the rollout, the pilot began to turn the aircraft to the right. The wind lifted the tail of the aircraft until it nosed over onto its back.NTSB SEA85LA087Accident · No injuriesLimited investigationFinal reportCessna 182 · Walla Walla, WADuring taxi from landing a gust of wind pushed the acft from behind onto soft ground where it nosed over.NTSB FTW85LA136Accident · No injuriesLimited investigationFinal reportCessna 180 · Houma, LAThe plt was attempting to takeoff from a short muddy strip near Houma, LA. He elected to abort the takeoff & applied brakes. The acft then rolled over a dry area on the strip, where braking action became effective & the aircraft nosed over. No mechanical…NTSB MIA85LA103Accident · No injuriesLimited investigationFinal reportCessna 182M · Davie, FLPlt stated he intended to land at opa-locka and he was in a hurry to do so because a passenger had become air sick. Instead, the plt unintentionally landed on an ultralight airstrip. The landing gear dug into soft terrain during the landing roll and the acft…NTSB MKC85LA058Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Waldron, MOThe acft nosed over inverted after the left landing gear wheel contacted snow alongside the rwy during a touch and go.NTSB ANC85FA042Accident · No injuriesField investigationFinal reportPiper PA-18 · Minto, AKThe plt had landed the ski equipped acft on the shore of a lake that was covered with grassy tundra & snow. For a subsequent takeoff, he elected to continue straight ahead rather than back taxi to where he had a known surface condition. During the takeoff,…NTSB SEA85LA047Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Wenatchee, WAThe plt elected to make a precautionary landing onto a snow covered grain field. He stated his artifical horizon was inoperative & darkness was approaching. Also, he said he saw a needle flicker & he was not sure if it was a fuel gage or his oil pressure…NTSB DEN85LA054Accident · No injuriesLimited investigationFinal reportCessna 180 · Marion, MTThe acft nosed over onto its back after the plt landed in snow 6 to 8 inches in depth.