NTSB investigations, 1990, MD
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 | 2 |
|---|---|
| 1963 | 1 |
| 1964 | 76 |
| 1965 | 81 |
| 1966 | 68 |
| 1967 | 72 |
| 1968 | 52 |
| 1969 | 69 |
| 1970 | 56 |
| 1971 | 39 |
| 1972 | 36 |
| 1973 | 35 |
| 1974 | 35 |
| 1975 | 32 |
| 1976 | 40 |
| 1977 | 41 |
| 1978 | 31 |
| 1979 | 29 |
| 1980 | 25 |
| 1981 | 22 |
| 1982 | 29 |
| 1983 | 34 |
| 1984 | 28 |
| 1985 | 30 |
| 1986 | 26 |
| 1987 | 32 |
| 1988 | 25 |
| 1989 | 33 |
| 1990 | 29 |
| 1991 | 21 |
| 1992 | 25 |
| 1993 | 16 |
| 1994 | 18 |
| 1995 | 24 |
| 1996 | 27 |
| 1997 | 25 |
| 1998 | 20 |
| 1999 | 24 |
| 2000 | 18 |
| 2001 | 19 |
| 2002 | 12 |
| 2003 | 12 |
| 2004 | 11 |
| 2005 | 11 |
| 2006 | 19 |
| 2007 | 13 |
| 2008 | 20 |
| 2009 | 13 |
| 2010 | 21 |
| 2011 | 23 |
| 2012 | 10 |
| 2013 | 15 |
| 2014 | 13 |
| 2015 | 20 |
| 2016 | 10 |
| 2017 | 14 |
| 2018 | 12 |
| 2019 | 17 |
| 2020 | 12 |
| 2021 | 10 |
| 2022 | 17 |
| 2023 | 8 |
| 2024 | 7 |
| 2025 | 5 |
| 2026 | 9 |
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\" = 'MD' 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" = 'MD' 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 BFO91LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Mitchellville, MDPilot failure to maintain altitude clearance above an obstacle after the aircraft encountered a downdraft.NTSB BFO91LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Mitchellville, MDFailure of the student pilot to maintain control of the aircraft, and inadequate supervision by the instructor pilot (CFI). Factors related to the accident were: inadequate preflight of the aircraft by the pilot(s) and in-flight opening of the door.NTSB NYC91LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Indian Head, MDThe flight instructors decision to land with insufficient runway remaining to stop the airplane which resulted in an overrun.NTSB BFO91FA008Accident · Serious injuriesField investigationFinal reportPiper PA-28-181 · Elkton, MDLoss of engine power for an undetermined reason, and the pilot's failure to maintain adequate airspeed, which resulted in a stall and an inflight collision with the terrain.NTSB BFO91LA007Accident · No injuriesLimited investigationFinal reportCessna 185 · Ridgely, MDThe loss of engine power for undetermined reasons.NTSB BFO91LA002Accident · No injuriesLimited investigationFinal reportCessna 150 · Indian Head, MDThe student pilot's failure to maintain adequate aircraft control during the landing flare/touchdown. Contributing factors are his lack of total flight experience and his improper technique when raising flaps during an attempted go-around.NTSB BFO91LA001Accident · No injuriesLimited investigationFinal reportBeech B23 · Westminster, MDThe pilot's failure to maintain positive directional control during the landing. Improper crosswind compensation and a variable, gusty crosswind were contributing factors.NTSB BFO90FA079Accident · 1 fatalField investigationFinal reportHughes 269C · Jefferson, MDThe failure of the tail rotor drive transmission system due to a worn tail rotor splined drive sleeve, and inadequate maintenance and/or inspection by the operator. Contributing to the loss of control was the student pilot's failure to maintain adequate rotor…NTSB BFO90FA077Accident · 1 fatalField investigationFinal reportChristen Industries A-1 · Middle River, MDThe pilot delayed his recovery from an intentional spin manuever until there was insufficient altitude to recover.NTSB BFO90FA074Accident · 1 fatalField investigationFinal reportBeech C35 · Forest Hill, MDThe pilot's failure to maintain aircraft control during the turn from base to final approach. A factor was the pilot's abrupt aircraft handling during the turn.NTSB BFO90LA069Accident · No injuriesLimited investigationFinal reportCessna 170B · Frederick, MDFatigue failure of the left main gear wheel axle.NTSB BFO90FA067Accident · No injuriesField investigationFinal reportCessna 150K · Clinton, MDImproper planning/decision by the instructor pilot (CFI), which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB BFO90DIG02Accident · Minor injuriesFinal reportCessna 182J · Frederick, MDFailure of the pilot to assure that the magneto (ignition) switch was in the proper position. A factor related to the accident was: partial failure of the magneto switch, which allowed the key to be removed, though the switch was not in the 'off' position.NTSB BFO90FA064Accident · Serious injuriesField investigationFinal reportPiper PA-28-200 · Baltimore, MDThe pilot failed to maintain adequate airspeed which resulted in a stall. Contributing was the loss of power for undetermined reasons.NTSB BFO90LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Clinton, MDThe student pilot's failure to maintain directional control of the aircraft and his improper use of the throttle control. Contributing to the accident was the student's lack of total experience.NTSB BFO90LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chester, MDThe pilot's misidentification of a road for the runway. Factors were sunglare and the pilot's unfamiliarity with the airport, and inadequate visual lookout.NTSB BFO90LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Farmington, MDStudent pilot's misjudged approach to landing and the instructor's inadequate supervision.NTSB BFO90FA053Accident · 2 fatalField investigationFinal reportBeech 36 · Gaithersburg, MDFailure of the pilot to extend the landing gear, which resulted in a wheels up landing; his improper decision to attempt a go around (aborted landing) after the airplane contacted the runway; and his failure to attain or maintain adequate airspeed while…NTSB BFO90LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lusby, MDThe pilot misjudged the distance needed to touchdown and stop his aircraft before running off the end of the runway. The pilot failed to use all of the available runway during the landing sequence.NTSB BFO90LA047Accident · No injuriesLimited investigationFinal reportRobinson R-22M · Stevensville, MDThe pilot failed to maintain control while taxiing on turbulent water.NTSB BFO90LA042Accident · No injuriesLimited investigationFinal reportBell 47D · Baltimore, MDThe pilot applied excessive cyclic control, causing the main rotor to flex and severe the tail cone.NTSB BFO90LA044Accident · No injuriesLimited investigationFinal reportCessna 172A · Pocomoke, MDThe pilot's misjudgement of distance and speed during the approach to land, and his failure to attain the proper touchdowwn point during the landing. The ditch was a related factor.NTSB BFO90LA040Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Have De Grace, MDThe pilot failed to maintain directional control, and used excessive braking trying to regain control.NTSB BFO90LA038Accident · No injuriesLimited investigationFinal reportCessna 150G · Clinton, MDPilot factor in that he improperly used the engine controls.NTSB BFO90LA037Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Prnc Frederick, MDThe pilot's improper planning/decision by not shutting down the engine or assuring the helicopter was properly attended,when he deplaned.NTSB BFO90LA035Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Frederick, MDThe pilot failed to maintain directional control, and used excessive braking trying to regain control.NTSB BFO90LA027Accident · No injuriesLimited investigationFinal reportBeech H35 · College Park, MDThe pilot's inadequate compensation for wind conditions. The adverse wind was a related factor.NTSB BFO90LA022Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Gaithersburg, MDInadequate supervision by the instructor pilot (CFI), which resulted in failure to maintain airspeed and a subsequent stall. Factors related to the accident were: gusty/crosswind conditions, the student pilot's inadequate compensation for wind conditions and…NTSB BFO90FA017Accident · Serious injuriesField investigationFinal reportDouglas DC-10 · Baltimore, MDInjuries associated with the evacuation of the aircraft.