NTSB investigations, 1982, DC
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
| 1964 | 5 |
|---|---|
| 1965 | 3 |
| 1966 | 5 |
| 1967 | 6 |
| 1968 | 3 |
| 1969 | 6 |
| 1970 | 10 |
| 1971 | 7 |
| 1972 | 7 |
| 1973 | 3 |
| 1974 | 4 |
| 1975 | 3 |
| 1976 | 3 |
| 1977 | 2 |
| 1978 | 4 |
| 1979 | 5 |
| 1980 | 3 |
| 1981 | 3 |
| 1982 | 5 |
| 1983 | 1 |
| 1984 | 4 |
| 1985 | 3 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 3 |
| 1989 | 1 |
| 1990 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2017 | 1 |
| 2025 | 2 |
| 2026 | 1 |
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\") = 1982
AND c.\"eventStateOrRegion\" = 'DC' 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") = 1982 AND c."eventStateOrRegion" = 'DC' 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 ATL83IA085Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Washington, DCThe acft was observed by witnesses to descend below its normal descent path and to horizontially stray off course to thepoint that office bldg occupants and persons on the ground were concerned by the appearance and noise of the acft duringa vor/dme approach…NTSB ATL83IA053Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Washington, DCThe pilot reported that he had 3 green lights after extending the landing gear. During landing roll, the left main ldg gr collapsed for an undetermined reason. The landing gear handle was found in the down position.NTSB DCA82IA031Incident · Serious injuriesIncident investigationFinal reportBoeing 727 · Washington, DCThe announcement of the possibility of turbulence during the descent and approach was made. During the lulls in the turbulence the cabin attendants were attending their duties and were hurt when intermittent jolts of rough air were encountered while two of…NTSB ATL82IA038Incident · No injuriesIncident investigationFinal reportde Havilland DHC-6-300 · Washington, DCAircraft was being ferried to Washington, DC following rework in toronto, Canada. During letdown in IFR conditions and moderate icing, pilot noticed a glow on the right wing. As he leaned over to check it, the right engine fire warning light and fire bell…NTSB DCA82AA011Accident · 78 fatalFinal reportBoeing 737-222 · Washington, DCThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-82/08. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Sched…