NTSB investigations, 2015, 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
Latest 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\") = 2015
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") = 2015 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 GAA16CA092Accident · No injuriesData collectionFinal reportPiper PA 46 · Stevensville, MDThe pilots failure to maintain glide path, descent rate and landing flare, in off shore wind conditions, resulting in a hard landing short of the runway.NTSB GAA16CA088Accident · No injuriesData collectionFinal reportDay William L Minicoupe · Middle River, MDThe pilot's incorrect installation of the rudder horn and failure to properly inspect the installation, which led to a loss of directional control during takeoff.NTSB GAA16CA077Accident · No injuriesData collectionFinal reportPiper PA 28 · California, MDThe student pilot's descent below the prescribed final approach path at night, and flight instructor's failure to correct the student pilot's descent, which resulted in a collision with trees and impact with the ground.NTSB GAA16CA072Accident · No injuriesData collectionFinal reportSkaggs Ronnie Lynn Rans S6S · Oldtown, MDThe pilot's failure to visually inspect the fuel level during the preflight inspection, which resulted in fuel starvation and a subsequent off-field landing and impacted terrain.NTSB GAA16CA064Accident · No injuriesData collectionFinal reportCessna 172 · Gaithersburg, MDThe student pilot's improper flare during landing, which resulted in a bounced landing, and a runway excursion.NTSB ERA16LA046Accident · No injuriesLimited investigationFinal reportMooney M20 · Fort Meade, MDA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB GAA16CA059Accident · No injuriesData collectionFinal reportCessna 172R · Westminster, MDThe student pilot's failure to maintain pitch control during the landing, which resulted in a hard landing.NTSB ERA15LA368Accident · No injuriesLimited investigationFinal reportCessna 150M · Mount Airy, MDThe in-flight fatigue failure of the No. 4 cylinder barrel, which resulted in a total loss of engine power.NTSB ERA15LA292Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1125 Westwind Astra · Baltimore, MDThe flight crew's failure to visually ensure that the cabin door locking pin was in place before takeoff.NTSB GAA15CA155Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Salisbury, MDThe student pilot's loss of directional control during the landing roll, resulting in a runway excursion and collision with terrain.NTSB GAA15CA142Accident · No injuriesData collectionFinal reportCessna 182P · Westminster, MDThe flight instructor's delayed remedial action during the landing flare, which resulted in a hard landing and porpoise.NTSB ERA15LA228Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Churchville, MDThe pilot's improper reduction of the fuel mixture while the airplane was descending on the final leg of the traffic pattern, which resulted in a total loss of engine power and subsequent aerodynamic stall.NTSB ERA15CA222Accident · No injuriesData collectionFinal reportCessna 172P · Mitchellville, MDThe pilot’s improper landing flare, which resulted in a bounced landing and damage to the airplane.NTSB GAA15CA030Accident · No injuriesData collectionFinal reportCessna R172E · Fort Meade, MDThe flight instructor's decision to land the airplane without sufficient runway to stop, resulting in a runway excursion and substantial damage to the right wing of the airplane.NTSB ERA15LA179Accident · No injuriesLimited investigationFinal reportBell 206B · Taylors Island, MDA partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB GAA15CA014Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Cambridge, MDThe pilot's failure to maintain directional control during takeoff.NTSB GAA15CA031Accident · Minor injuriesData collectionFinal reportCessna 140 · Easton, MDThe pilot's failure to maintain directional control during the landing roll.NTSB ERA15CA157Accident · No injuriesData collectionFinal reportMooney M20K · Laurel, MDThe pilot's improper decision to attempt a nighttime landing at an unsuitable airport, which resulted in a collision with the precision approach path indicator.NTSB ERA15LA135Accident · No injuriesLimited investigationFinal reportCessna 208 · Baltimore, MDThe ground service vehicle operator's failure to yield right of way to the airplane due to distraction, which necessitated the pilot's use of reverse thrust and braking to avoid a collision and resulted in the airplane's empennage striking the ground.NTSB ERA15LA123Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Fort Meade, MDThe mechanic’s failure to detect the incorrect dry valve tappet clearances while troubleshooting ongoing engine issues, which resulted in partial loss of engine power during takeoff. Contributing to the partial loss of engine power was the mechanic's failure…