NTSB investigations, 1990, FL
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1962 | 7 |
|---|---|
| 1963 | 6 |
| 1964 | 199 |
| 1965 | 231 |
| 1966 | 227 |
| 1967 | 258 |
| 1968 | 206 |
| 1969 | 197 |
| 1970 | 214 |
| 1971 | 205 |
| 1972 | 234 |
| 1973 | 254 |
| 1974 | 238 |
| 1975 | 218 |
| 1976 | 203 |
| 1977 | 220 |
| 1978 | 250 |
| 1979 | 242 |
| 1980 | 261 |
| 1981 | 208 |
| 1982 | 190 |
| 1983 | 219 |
| 1984 | 230 |
| 1985 | 212 |
| 1986 | 217 |
| 1987 | 200 |
| 1988 | 187 |
| 1989 | 183 |
| 1990 | 147 |
| 1991 | 158 |
| 1992 | 131 |
| 1993 | 147 |
| 1994 | 175 |
| 1995 | 136 |
| 1996 | 137 |
| 1997 | 146 |
| 1998 | 162 |
| 1999 | 143 |
| 2000 | 138 |
| 2001 | 120 |
| 2002 | 134 |
| 2003 | 136 |
| 2004 | 120 |
| 2005 | 150 |
| 2006 | 133 |
| 2007 | 150 |
| 2008 | 133 |
| 2009 | 103 |
| 2010 | 103 |
| 2011 | 110 |
| 2012 | 101 |
| 2013 | 91 |
| 2014 | 101 |
| 2015 | 99 |
| 2016 | 96 |
| 2017 | 97 |
| 2018 | 120 |
| 2019 | 113 |
| 2020 | 92 |
| 2021 | 97 |
| 2022 | 82 |
| 2023 | 83 |
| 2024 | 103 |
| 2025 | 105 |
| 2026 | 82 |
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\") = 1990
AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
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") = 1990 AND c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' 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 MIA91IA059Incident · No injuriesIncident investigationFinal reportCessna 402C · Marathon, FLFatigue failure of a nose landing gear drag brace assembly which caused the nose landing gear to collapse during the landing roll. Contributing to the accident was an inadequate inspection of the airplane approximately 7 hours earlier by company maintenance…NTSB MIA91FA058Accident · Serious injuriesField investigationFinal reportCessna 310 · New Smyrna Bch, FLThe pilot-in-command/mechanic reversal of the aileron control cables on the sprocket during installation. This resulted in an in flight loss of control on takeoff, uncontrolled descent, and in flight collision with terrain.NTSB MIA91FA057Accident · 1 fatalField investigationFinal reportMooney M20C · Pensacola, FLThe pilot's failure to use carburetor heat resulting in loss of engine power due to carburetor ice. A factor in the accident was the pilot's medical condition.NTSB MIA91LA052Accident · Serious injuriesLimited investigationFinal reportAeronca L-3C · Brooksville, FLTotal loss of engine power due to undetermined reasons.NTSB MIA91GA050Accident · Minor injuriesFinal reportBell 206 B3 · St. Marks, FLThe pilot in command's failure to maintain safe altitude while descending over a coastline, at night, in visual meteorological conditions. Contributing to the accident was the pilot in command's failure to obtain a full weather briefing prior to departure…NTSB MIA91LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · Deland, FLFailure of the instructor pilot to utilize carburetor heat in icing conditions.NTSB MIA91IA048Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · Sanford, FLCollapse of the nose landing gear during the landing roll due to inadequate nose gear assembly and failure of the nose landing gear drag link bolt.NTSB MIA91LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Palmetto, FLPoor preflight planning by the pilot due to his failure to purchase fuel before departure resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident was the inaccurate fuel gauges.NTSB MIA91LA044Accident · No injuriesLimited investigationFinal reportBeech F33A · Lakeland, FLTotal loss of engine power due to oil exhaustion for undetermined reasons. This caused the pistons to seize in the cylinders.NTSB MIA91LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Jupiter, FLPartial loss of engine power due to failure of an exhaust valve, due to a valve guide that was worn beyond specifications.NTSB MIA91LA042Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Jacksonville, FLFailure to maintain aircraft control after intentional flight into known adverse weather conditions.NTSB MIA91LA041Accident · No injuriesLimited investigationFinal reportCessna 182RG · Orlando, FLFailure of the pilot to maintain directional control during the landing roll.NTSB MIA91TF#01Accident · Serious injuriesClass 3Final reportBell 206B · Boca Grande, FLNTSB MIA91LA040Accident · No injuriesLimited investigationFinal reportBell 206B · Fort Pierce, FLThe incorrect cyclic control input by the student during the touchdown autorotation landing and failure of the CFI to correct this before the helicopter touched down.NTSB MIA91LA038Accident · No injuriesLimited investigationFinal reportCessna 172N · Vero Beach, FLThe failure of the pilot to perfrom a proper landing flare and touchdown resulting in a hard landing.NTSB MIA91LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Fort White, FLThe downwind landing with excessive airspeed.NTSB MIA91LA036Accident · No injuriesLimited investigationFinal reportCessna 550 · Sebring, FLThe pilot's delayed go-around after encountering a fog bank on short final. The fog and the dark night were factors.NTSB MIA91FA035Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Bunnell, FLFailure of the pilot to maintain altitude, while maneuvering at night over an unlighted area, which resulted in a collision with trees. Factors related to the accident were: darkness and possible spatial disorientation of the pilot due to lack of visual ques.NTSB MIA91GA034Accident · No injuriesFinal reportAsta N22S · Homestead Afb, FLThe bending overstress failure of the left main landing screwjack at an undetermined time during flight for undetermined reasons.NTSB MIA91LA033Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT401 · Belle Glade, FLThe pilot failed to maintain airspeed, and stalled the airplane, resulting in a uncontrolled descent, and collision with the terrain.NTSB MIA91LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa Locka, FLThe pilot's failure to maintain a positive rate of climb while maneuvering to avoid a flock of birds, resulting in an in flight collision with trees. Factor(s) included: attention diverted.NTSB MIA91FA029Accident · 1 fatalField investigationFinal reportCessna 172M · Homestead, FLThe failure of the pilot to insure adequate fuel was present in the aircraft for the flight resulting in loss of engine power due to fuel exhaustion.NTSB MIA91LA026Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fort Pierce, FLImproper preflight decision of the instructor pilot to allow the student to takeoff from the soft grass runway and his failure to abort the takeoff.NTSB MIA91GA025Accident · 3 fatalFinal reportBeech A-90 · Crestview, FLThe pilot-in-command/cfi improper supervision of the dual student. This resulted in an in flight loss of control, and collision with terrain for failure to maintain minimum control airspeed (VMC) while conducting a simulated emergency procedure.NTSB MIA91LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · West Palm Beach, FLPilot-in-command's failure to land on a runway that was more aligned with the wind. Factors were: crosswind and lack of total experience.NTSB MIA91FA023Accident · 3 fatalField investigationFinal reportCessna 421B · Flamingo, FLAn undetermined airframe/component/system failure/malfunction, which resulted in a fuel fed fire in the left wing.NTSB MIA91FA020Accident · 2 fatalField investigationFinal reportAero Commander 680V · Fort Lauderdale, FLThe pilot-in-command's decision to continue takeoff with a known deficiency in the airplane - low power on both engines which resulted from open compressor surge valves. The pilot subsequently failed to maintain airspeed while maneuvering in a turn resulting…NTSB MIA91LA018Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Osteen, FLTotal loss of engine power, for an undetermined reason.NTSB MIA91FA017Accident · 1 fatalField investigationFinal reportCessna 150G · Marathon, FLThe pilot-in-command's failure to maintain airspeed, while attempting to make a forced landing following a partial loss of engine power. Fatigue failure of the center rocker boss on the #3 cylinder was a related factor.NTSB MIA91LA016Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Orlando, FLInadequate planning by the pilot.NTSB MIA91LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fort Myers, FLThe failure of the pilot to maintain directional control while landing with shifting gusty winds.NTSB MIA91LA019Accident · No injuriesLimited investigationFinal reportCessna 182Q · Ormond Beach, FLFailure of the pilot to maintain proper airspeed during the approach to land.NTSB MIA91LA013Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Miami, FLInadequate preflight of the airplane by the pilot-in-command.NTSB ATL91FA005Accident · 1 fatalField investigationFinal reportPitts Special S-1 · Ocala, FLThe pilot experiencced spatial disorientation, lost control of the airplane during a spin maneuver and collided with the ground.NTSB MIA91FA011Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Everglades City, FLThe pilot's failure to maintain altitude and his spatial disorientation during a night takeoff over water.NTSB MIA91LA010Accident · No injuriesLimited investigationFinal reportAmerican AA-5 · Cape Coral, FLA partial loss of engine power, caused by mechanical failure of the number 3 cylinder engine exhaust valve, for an undetermined reason.NTSB MIA91LA009Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · De Funiak Spgs, FLThe loose fuel cap and failure of the pilot to assure the aircraft was properly preflighted, which resulted in fuel siphoning and subsequent fuel exhaustion. Factors related to the accident were: faulty fuel quantity gages, the pilot's decision to fly with…NTSB MIA91FA008Accident · Serious injuriesField investigationFinal reportMooney M20C · Kissimmee, FLMalfunction of both magnetos due to deterioration of the coils, failure of maintenance personnel to comply with an airworthiness directive, and failure of the pilot to maintain adequate visual lookout while on an approach for an emergency landing. Factors…NTSB MIA91LA006Accident · No injuriesLimited investigationFinal reportCessna 150M · Tampa, FLThe pilot's decision to fly an airplane with known deficiencies. This resulted in a partial loss of engine power, and a ground collision with a fixed object.NTSB MIA91LA005Accident · 1 fatalLimited investigationFinal reportMcdonnell Douglas DC-9-31 · Cape Canaveral, FLFailure of the captain to follow procedures, his improper in-flight planning/decision by allowing the aircraft to continue into the overhang (anvil) of a thunderstorm, failure of the passengers to abide by procedures/instructions concerning use of seat belts,…NTSB MIA91LA004Accident · No injuriesLimited investigationFinal reportRobinson R22 B · Opa Locka, FLFailure to use carburetor heat.NTSB MIA91LA003Accident · No injuriesLimited investigationFinal reportBeech C-90 · Tampa, FLThe lack of lubrication by maintenance personnel of the nose landing gear actuator.NTSB MIA91LA002Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa Locka, FLPartial loss of engine power for undetermined reasons resulting in a forced landing.NTSB MIA91FA001Accident · 1 fatalField investigationFinal reportErik K. Van Der Kaay Marco J-5 · Clearwater, FLThe pilot's inadvertent deployment of the air brakes at a low altitude.NTSB MIA90FA191Accident · Serious injuriesField investigationFinal reportErco 415 · Titusville, FLWas partial loss of engine power due to foreign object obstruction of the inlet of the carburetor.NTSB MIA90LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · Cedar Key, FLThe failure of the pilot to execute a go-around after landing long.NTSB MIA90LA188Accident · No injuriesLimited investigationFinal reportCessna 150M · Florida City, FLLoss of control during the take off roll from the dirt road followed by an on ground collision with shrubs.NTSB MIA90LA187Accident · Serious injuriesLimited investigationFinal reportRepublic RC-3 · Mulberry, FLAn engine failure which required an emergency landing off airport.NTSB MIA90LA186Accident · No injuriesLimited investigationFinal reportCessna 421B · Pompano Beach, FLThe failure of the pilot to initiate a go-around due to being high on final approach and as a result, failure to attain the correct point of touchdown and his excessive application of brakes which resulted in failure of the right main tire and loss of…NTSB MIA90LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Orlando, FLFailure of the pilot to follow proper procedures.