NTSB investigations, 2006, 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\") = 2006
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") = 2006 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 NYC07CA053Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Cumberland, MDThe pilot's misjudgment of the airplane's distance/altitude during the landing approach.NTSB NYC07FA042Accident · 2 fatalField investigationFinal reportCessna 210K · Edgewater, MDThe pilot's failure to maintain the proper altitude/clearance will on approach, which resulted in an in-flight collision with trees. Contributing to the accident was the night-light conditions, an obstruction light that was not illuminated, and trees that had…NTSB NYC07FA029Accident · Serious injuriesField investigationFinal reportRobinson R44 II · Baltimore, MDThe pilot's failure to maintain control while landing to a trailer, which resulted in a collision with terrain. A factor in the accident was the narrow trailer.NTSB NYC07LA022Accident · 1 fatalLimited investigationFinal reportMonard RAF 2000 GTX · Ridgely, MDThe pilot's failure to maintain rotor rpm while maneuvering, which resulted in a loss of rotor blade rigidity.NTSB NYC07LA021Accident · No injuriesLimited investigationFinal reportCessna 150F · McHenry, MDThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion and a loss of engine power during takeoff-initial climb.NTSB NYC07FA009Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Odenton, MDThe pilot's failure to maintain adequate clearance from terrain during the approach. Contributing was the pilot's self-induced pressure to land the airplane after being informed by air traffic control that he was not operating in compliance with the ADIZ…NTSB NYC07LA006Accident · No injuriesLimited investigationFinal reportBeech BE-200 · Leonardtown, MDThe airplane manufacturer's inadequate landing gear downlock plate maintenance orientation information, and the disengaged main landing gear.NTSB NYC07CA004Accident · No injuriesData collectionFinal reportBeech BE-58 · Annapolis, MDThe pilot's improper in-flight decision to attempt to land on the wet runway, which resulted in an overrun. Factors in the accident were rain, and the gusty wind conditions.NTSB NYC06CA232Accident · No injuriesData collectionFinal reportCessna 172S · Cambridge, MDThe pilot's failure to maintain directional control while landing.NTSB NYC06CA221Accident · No injuriesData collectionFinal reportCessna 172P · Baltimore, MDThe pilot's improper flare, which resulted in a hard landing.NTSB NYC06CA213Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Frederick, MDThe flight instructor's delayed remedial action during a hovering autorotation, which resulted in a hard landing and inadvertent dynamic rollover.NTSB NYC06CA199Accident · No injuriesData collectionFinal reportStampe SV-4C · Taneytown, MDThe collapse of the right main landing gear for an undetermined reason.NTSB NYC06LA178Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Frederick, MDA failure of the masterod, due to a hydraulic lock on a previous flight, which resulted in a total loss of engine power.NTSB CHI06FA186Accident · 1 fatalField investigationFinal reportCirrus Design SR-22 · Edgewater, MDThe pilot' failure to maintain sufficient airspeed which resulted in a stall. A factor was the pilots failure to properly set the flaps for the go-around.NTSB NYC06LA160Accident · 1 fatalLimited investigationFinal reportAerial Productions Intl. Acrojet Special · Ocean City, MDThe pilot's failure to maintain adequate airspeed which resulted in a stall mush and subsequent impact with trees. A factor in the accident was windshear, and the high weight of the airplane.NTSB NYC06LA134Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Hagerstown, MDThe pilot's failure to maintain directional control during takeoff.NTSB NYC06CA088Accident · No injuriesData collectionFinal reportCessna 172-P · Cambridge, MDThe student pilot's improper recovery from a bounced landing.NTSB NYC06FA071Accident · 2 fatalField investigationFinal reportCessna 172R · Mitchellville, MDThe pilot's improper inflight planning/decision to attempt a landing in weather conditions below landing minimums, and his failure to maintain airspeed while maneuvering. Factors in the accident were the fog and snow.NTSB NYC06LA055Accident · Serious injuriesLimited investigationFinal reportRenquist Starduster SA300 · Churchville, MDThe pilot's failure to maintain adequate airspeed during takeoff, which resulted in an inadvertent stall.