NTSB investigations, 1999, MD
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 1999
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") = 1999 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 NYC00LA045Accident · Minor injuriesLimited investigationFinal reportCessna TR 182 · Clarksville, MDDeer that entered the runway environment while the pilot was executing a takeoff.NTSB NYC00LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Annapolis, MDThe pilot's failure to adequately adjust engine power to compensate for the winds on final approach.NTSB NYC00LA034Accident · Serious injuriesLimited investigationFinal reportBates Kitfox · Westminster, MDThe pilot's failure to maintain aircraft control while maneuvering.NTSB NYC00LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Rising Sun, MDThe PIC CFI's improper planning/decision to perform a downwind takeoff. A factor in this accident was the tail wind condition.NTSB NYC00LA009Accident · Minor injuriesLimited investigationFinal reportGrumman G164 · Burkittsville, MDThe vehicle drivers inadequate lookout.NTSB NYC00LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Berlin, MDThe failure of the number 3-cylinder exhaust valve stem due to fatigue cracking.NTSB IAD99FA070Accident · Serious injuriesField investigationFinal reportCessna 310Q · Salisbury, MDThe improper installation of the #2 cylinder that resulted in a fractured crankshaft and a total loss of engine power. Factors in the accident were the premature deployment of the landing gear and flaps by the pilot.NTSB IAD99FA069Accident · Serious injuriesField investigationFinal reportCessna 150M · Ellicott City, MDthe flight instructor's failure to follow the balked landing procedure in the owner's manual by retracting the flaps from 40 degrees to zero degrees.NTSB IAD99LA068Accident · No injuriesLimited investigationFinal reportCessna 172P · Friendly, MDThe pilot's misjudgment of speed during the landing approach. The inoperative airspeed indicator was a contributing factor.NTSB NYC99LA232Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT17 · Westminister, MDThe pilot's failure to maintain control of the airplane while taxiing.NTSB NYC99LA192Accident · No injuriesLimited investigationFinal reportBeech A36 · Westminster, MDThe pilot-in-command's failure to maintain aircraft control while landing.NTSB NYC99LA191Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Frederick, MDThe pilot's failure to maintain directional control. Contributing factors were gusty wind conditions and the sign.NTSB IAD99FA051Accident · No injuriesField investigationFinal reportCessna 172P · Gaithersburg, MDwas the pilot's failure to obtain the proper rotation speed and his subsequent loss of directional control. A factor in the accident was the improper setting of the elevator trim.NTSB NYC99FA161Accident · 1 fatalField investigationFinal reportPiper J3C-85 · Dawson, MDThe pilot's improper decision to turn toward rising terrain with inadequate terrain clearance. Factors were the density altitude, downdraft, and the pilot's decision to operate at a weight in excess of the maximum allowable gross weight.NTSB NYC99FA160Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Dawson, MDwas the pilot's improper decision to turn toward rising terrain with inadequate terrain clearance. Factors were the density altitude, and unfavorable winds.NTSB NYC99LA153Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Rising Sun, MDThe failure of the connecting rod end bolts, due to an overtemperature condition.NTSB IAD99LA049Accident · No injuriesLimited investigationFinal reportKucki Pitts S-1S · Mitchellville, MDwas the loss of braking action on the left side due to a broken brake caliper.NTSB NYC99LA134Accident · 1 fatalLimited investigationFinal reportSaliba Long EZ · Friendly, MDThe separation of the airplane canopy for undetermined reasons, the diminished controllability of the airplane, and the pilot's failure to maintain airspeed resulting in a stall/mush into trees short of the runway.NTSB IAD99LA047Accident · Serious injuriesLimited investigationFinal reportNanchang CJ-6A · Ocean City, MDWas the pilot leaving the magneto switch in the on position while hand rotating the propeller.NTSB NYC99LA120Accident · No injuriesLimited investigationFinal reportCessna 172N · Churchville, MDThe pilot's failure to maintain directional control during the takeoff roll. Factors were the pilot's lack of recent experience, and the crosswind.NTSB IAD99LA042Accident · No injuriesLimited investigationFinal reportCessna 182K · Baltimore, MDwas the pilot's improper remedial action when he improperly used the elevator during the landing flare.NTSB NYC99LA101Accident · Serious injuriesLimited investigationFinal reportBeech BE-C23 · Annappolis, MDThe pilot's failure to perform a go-around and he landed long resulting in an overrun. A factor in the accident was the night light conditions.NTSB NYC99FA096Accident · 1 fatalField investigationFinal reportSellors Searey · Selby Beach, MDThe pilot's failure to maintain aircraft control during the landing sequence, which resulted in the airplane contacting the water in a nose low attitude.NTSB NYC99LA084Accident · No injuriesLimited investigationFinal reportCessna 150 · Leonardtown, MDThe pilot's failure to maintain control of the airplane during a crosswind landing.