NTSB investigations, NY
214 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 8 |
| 1984 | 11 |
| 1985 | 10 |
| 1986 | 6 |
| 1987 | 12 |
| 1988 | 13 |
| 1989 | 4 |
| 1990 | 16 |
| 1991 | 14 |
| 1992 | 7 |
| 1993 | 6 |
| 1994 | 9 |
| 1995 | 6 |
| 1996 | 10 |
| 1997 | 2 |
| 1998 | 9 |
| 1999 | 6 |
| 2000 | 9 |
| 2001 | 8 |
| 2002 | 5 |
| 2003 | 7 |
| 2004 | 6 |
| 2005 | 8 |
| 2006 | 5 |
| 2007 | 10 |
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\" = 250)
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" = 250) 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 NYC08FA039Accident · 1 fatalField investigationFinal reportMooney M20K · Maine, NYThe pilot's spatial disorientation, which resulted in a loss of control and subsequent collision with trees.NTSB NYC08CA025Accident · Serious injuriesData collectionFinal reportBurkhart Grob G 103 Twin II · Windham, NYAn inadvertent encounter with a wind gust while maneuvering.NTSB MIA07CA139Accident · Minor injuriesData collectionFinal reportTrinidad TB-20 · White Plains, NYThe pilot's failure to obtain adequate airspeed for takeoff which resulted in a stall, runway overrun down an embankment, and collision with a fence. A factor in accident was the pilot not utilizing the full length of the runway for takeoff.NTSB NYC07FA193Accident · 2 fatalField investigationFinal reportCessna 172N · Rochester, NYThe pilot's failuire to maitain adequate airspeed during a turning maneuver which resulted in an inadvertent stall.NTSB ATL07CA108Accident · No injuriesData collectionFinal reportEvektor Aerotechnic Sportstar · Shirley, NYThe student pilot's failure to maintain adequate airspeed resulting in a stall. Contributing to the accident was the student pilots failure to relinquish the flight controls when instructed to do so.NTSB NYC07FA173Accident · 1 fatalField investigationFinal reportCessna 150L · Hammondsport, NYThe pilot's inadequate in flight decision and failure to maintain aircraft control during cruise flight. Contributing to the accident were inadequate preflight planning, dark night and poor weather conditions.NTSB NYC07LA148Accident · 2 fatalLimited investigationFinal reportSyracuse Vans RV-4 · Wallkill, NYThe pilot's improper decision to attempt low altitude aerobatics, and his failure to maintain airspeed during the aerobatics, which resulted in an inadvertent stall while maneuvering.NTSB NYC07CA111Accident · Minor injuriesData collectionFinal reportCessna 172S · Montgomery, NYThe pilot's improper flare while landing, which resulted in a loss of directional control and collision with terrain.NTSB DFW07LA105Accident · Serious injuriesLimited investigationFinal reportAviat A-1A · Farmingdale, NYThe pilot's failure to maintain control of the airplane during a short-field takeoff, which resulted in an inadvertent stall.NTSB NYC07FA096Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Saranac Lake, NYThe pilot's failure to maintain adequate airspeed during initial climb after takeoff, which resulted in an inadvertent stall.NTSB NYC07FA047Accident · 1 fatalField investigationFinal reportCessna 310Q · Montgomery, NYImproper maintenance performed on the airplane by maintenance personnel, and the failure of the mechanic with an inspection authorization (IA) to verify the maintenance work performed, which resulted in a reverse elevator trim system, and subsequent loss of…NTSB NYC06FA205Accident · 1 fatalField investigationFinal reportScheibe SF-28A · Canandaigua, NYThe private pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and impact with trees. Factors were the FAA inspector's delayed remedial action, and his lack of experience in the make and model motorglider.NTSB NYC06CA172Accident · No injuriesData collectionFinal reportRotorway 162-F · Brookhaven, NYThe student pilot inadvertently allowing the skids to contact the ground resulting in dynamic rollover.NTSB NYC06LA144Accident · 1 fatalLimited investigationFinal reportTaylorcraft BC12-D · Mayville, NYThe flight instructor's improper decision to attempt a simulated engine failure at a low altitude and her failure to maintain clearance from trees and wires, while maneuvering. Also causal was the flight instructor's impairment from prescription medication.NTSB NYC06LA136Accident · 1 fatalLimited investigationFinal reportHowe/Wilmer Lancair 360 · Montgomery, NYA loss of control during approach for undetermined reasons.NTSB IAD05FA146Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · Dunkirk, NYLoss of control for undetermined reasons.NTSB NYC05CA115Accident · Minor injuriesData collectionFinal reportWagner Kitfox II · Albion, NYThe pilot's loss of airplane control after inadvertently taking off while conducting high-speed taxi runs. A factor related to the accident was the pilot's lack of experience in the airplane.NTSB IAD05LA094Accident · Serious injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Conesus, NYThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and collision with terrain.NTSB IAD05CA081Accident · Minor injuriesData collectionFinal reportPZL Swidnik PW-5 · Bloomingburg, NYThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall, and subsequent impact with terrain.NTSB IAD05MA078Accident · Serious injuriesMajor investigationFinal reportSikorsky S-76C · New York, NYAn inadvertent encounter with a left quartering tailwind. Factors in the accident were settling with power, the high gross weight of the helicopter, and the crew's failure to accurately assess the winds in the area.NTSB IAD05LA072Accident · Serious injuriesLimited investigationFinal reportWeiss Vans RV-8 · Canandaigua, NYPartial blocking of the flight controls by unsecured items in the cockpit, which resulted in a loss of control during takeoff.NTSB IAD05FA067Accident · 4 fatalField investigationFinal reportCessna 172S · Brooklyn, NYThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and subsequent impact with terrain.NTSB IAD05LA038Accident · Minor injuriesLimited investigationFinal reportGrumman G-21A · Penn Yan, NYThe flight instructor's inadequate planning/decision and his remedial action to conduct or recover from a simulated emergency procedure.NTSB NYC05CA018Accident · No injuriesData collectionFinal reportKinner Sportster · Millbrook, NYThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. A factor was the crosswind.NTSB IAD04LA046Accident · 1 fatalLimited investigationFinal reportScott Rans S-12 · Seneca, NYThe student pilot's failure to maintain airspeed above stall speed, which resulted in an inadvertant stall/spin. A factor in the accident was the pilot's lack of pilot certification.NTSB NYC04LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Cooperstown, NYThe pilot's failure to maintain adequate airspeed and her premature rotation which resulted in an inadvertent stall/mush and subsequent impact with the ground.NTSB NYC04LA178Accident · 1 fatalLimited investigationFinal reportGarrett Stephens Akro · Westport, NYThe pilot's loss of aircraft control while maneuvering, due to incapacitation, which resulted in a collision with terrain.NTSB NYC04LA130Accident · Minor injuriesLimited investigationFinal reportHigh Craft Buccaneer · Glasco, NYThe pilot's failure to maintain airspeed during landing, which resulted in an inadvertent stall and subsequent impact with the water. A factor was the pilot's lack of experience in the airplane and his diverted attention.NTSB NYC04LA088Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Utica, NYThe copilot's failure to maintain airspeed, and the captain's delayed remedial action, which resulted in an inadvertent stall and the subsequent hard landing.NTSB NYC03CA194Accident · Minor injuriesData collectionFinal reportunknown Avid Flyer · Covington, NYThe pilot's failure to abort the takeoff.NTSB NYC03FA153Accident · 3 fatalField investigationFinal reportPiper PA-34-200T · Montauk, NYA loss of control during climb for undetermined reasons.NTSB NYC03LA151Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Manorville, NYThe pilot's failure to obtain the proper airspeed and his delayed remedial action to jettison the banner.NTSB NYC03LA130Accident · No injuriesLimited investigationFinal reportMooney M20J · Montauk, NYThe pilot's failure to maintain directional control. A factor in this accident was the crosswind condition.NTSB NYC03LA103Accident · Serious injuriesLimited investigationFinal reportFrancis Giroux Moni-Motorglider 032 · Glens Falls, NYThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Contributing factors were the excessive taxi speed, and the inadvertent lift off.NTSB NYC03LA097Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Buffalo, NYThe pilot's failure to maintain sufficient airspeed to prevent an inadvertent stall. Factors were the variable and gusty winds.NTSB NYC03FA082Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Conesus, NYThe flight instructor's failure to maintain adequate airspeed which resulted in an inadvertent spin.NTSB NYC02LA129Accident · 1 fatalLimited investigationFinal reportPank KitFox · Sprakers, NYThe pilot's failure to maintain aircraft control. A factor in the accident was the pilot's lack of experience in category of aircraft.NTSB NYC02LA124Accident · No injuriesLimited investigationFinal reportHunter A-28 Victor · Shelter Island, NYThe pilot's failure to maintain directional control during the takeoff, which resulted in a collision with trees.NTSB NYC02LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Middleville, NYThe pilot's failure to maintain proper alignment with the runway after being struck by a gust of wind. Factors were the gusty winds and the berm struck by the airplane.NTSB NYC02FA089Accident · 2 fatalField investigationFinal reportCirrus SR-22 · Parish, NYThe pilots' failure to maintain airspeed, which resulted in an inadvertent stall/spin. The continued spin to the ground was a result of the pilots' failure to deploy the onboard parachute recovery system, for undetermined reasons.NTSB IAD02LA030Accident · Minor injuriesLimited investigationFinal reportKorsch Classic IV · East Moriches, NYThe pilot's improper recovery from a bounced landing, which resulted in a loss of directional control. A contributing factor was the pilot's lack of experience in aircraft type.NTSB NYC02FA044Accident · 1 fatalField investigationFinal reportRaytheon BE-23-B24R · Armonk, NYThe pilot's failure to maintain aircraft control.NTSB NYC02LA034Accident · Serious injuriesLimited investigationFinal reportGillette Baby Ace · Spencerport, NYThe pilot's failure to maintain aircraft control during approach to the airport, which resulted in an inadvertent stall.NTSB NYC01FA212Accident · 1 fatalField investigationFinal reportPitts S-2B · Shirley, NYThe pilot under instruction's failure to maintain adequate airspeed, and the flight instructor's inadequate remedial action during a simulated engine-out approach, which resulted in an inadvertent stall, and subsequent ground impact.NTSB NYC01LA208Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Gasport, NYThe pilot's failure to obtain a proper climb airspeed which resulted in an inadvertent stall and subsequent impact with a hangar.NTSB NYC01LA206Accident · Minor injuriesLimited investigationFinal reportSchweizer 300C · Cicero, NYThe pilot's failure to maintain directional control while hovering, and the CFI's delayed remedial action.NTSB IAD01LA074Accident · No injuriesLimited investigationFinal reportCessna 182S · Montgomery, NYThe pilot's improper flare, and improper recovery from a bounced landing.NTSB IAD01LA061Accident · Serious injuriesLimited investigationFinal reportStampe ET Renard SV-4 · Rhinebeck, NYThe pilot's failure to maintain climb, and his failure to maintain adequate airspeed.NTSB NYC01FA071Accident · 1 fatalField investigationFinal reportSchempp-Hirth Discus CS · Wurtsboro, NYThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin while on base leg.NTSB NYC01LA019Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1A · White Plains, NYAn improperly planned approach which resulted in an inadvertent stall.