NTSB investigations, NY
15 cases where the first occurrence was “Nose over”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 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\" = 'NY' 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\" = 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 c."eventStateOrRegion" = 'NY' 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" = 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 NYC05CA080Accident · No injuriesData collectionFinal reportPalen Sopwith Camel · Rhinebeck, NYThe pilot's failure to maintain aircraft control during the takeoff roll. A factor in the accident was the uneven runway, and the pilot's lack of total experience in make and model.NTSB NYC04LA046Accident · No injuriesLimited investigationFinal reportCessna 172E · Islip, NYThe pilot's failure to maintain aircraft control, which resulted in a nose over. A factor in this accident was the gusty wind conditions.NTSB IAD02LA010Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Millbrook, NYpilot's inadvertent activation of the right brake during landing roll-out , which caused the airplane to nose over. A factor was the crosswind.NTSB NYC00LA169Accident · No injuriesLimited investigationFinal reportRepublic RC3 · Speculator, NYThe pilot inadvertently lowering the landing gear of the amphibian airplane for a water landing.NTSB NYC97LA008Accident · No injuriesLimited investigationFinal reportCessna 172N · Hilton, NYthe pilot's improper soft field landing technique, which allowed a nose over during the landing rollout. Soft terrain was a related factor.NTSB NYC95LA062Accident · No injuriesLimited investigationFinal reportCessna 172L · Saratoga Spgs, NYThe pilot's poor judgment in attempting a flight under the existing wind conditions.NTSB NYC93LA083Accident · No injuriesLimited investigationFinal reportRobinson R22B · Ronkonkoma, NYThe lack of adequate supervision and delayed remedial action by the flight instructor. A factor related to the accident was the delay in adding power by the student pilot which resulted in a low rotor RPM condition.NTSB BFO92LA040Accident · No injuriesLimited investigationFinal reportCessna 180C · Clarence, NYThe pilot's inadequate inflight decision to land with a defective ski landing gear on unsuitable terrain, which resulted in a nose over.NTSB NYC88LA103Accident · No injuriesLimited investigationFinal reportCessna 140 · Schroon Lake, NYDuring landing roll on a frozen lake, the left landing gear dug into a soft spot. The aircraft nosed over and was substantially damaged. In his recommendation for prevention of this acc, the plt said 'by not lndg on ice.'NTSB NYC87LA269Accident · No injuriesLimited investigationFinal reportRyan ST-3RR · Hamburg, NYAccording to the plt, when he arrived at the arpt, the winds were from 280 deg at 20 gusting 25 KTS. He believed that with the strong x-wind & gusts, it would be safer to land on sod beside the rwy. During the landing, the main gear sank into the sod & the…NTSB NYC86LA063Accident · No injuriesLimited investigationFinal reportLuscombe 8B · Turin, NYThe personal flight from oswego, NY to Turin, NY was uneventful and without problems. However while landing in soft snow, the right ski dug into the soft snow. The landing gear failed and the aircraft nosed over onto its back and was substantially damaged.…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 NYC83LA243Accident · No injuriesLimited investigationFinal reportCessna 140 · Fishers Island, NYThe student plt stated that he had landed on rwy 07 & was taxing along the rwy to the tiedown area when he applied brakes & the acft nosed over.NTSB NYC82DA094Accident · No injuriesFinal reportCessna 150H · Weedsport, NYThe pilot attempted to contact the Weedsport airport on UNICOM; however, the radio had been shut down when the airport closed. Without the runway lights available the pilot elected to land on runway 28. The aircraft touched down in a plowed field…