NTSB investigations, 2005, 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

19622026
NTSB investigations, 2005, MD per year, 1962–2026: 1,679 cases
19622
19631
196476
196581
196668
196772
196852
196969
197056
197139
197236
197335
197435
197532
197640
197741
197831
197929
198025
198122
198229
198334
198428
198530
198626
198732
198825
198933
199029
199121
199225
199316
199418
199524
199627
199725
199820
199924
200018
200119
200212
200312
200411
200511
200619
200713
200820
200913
201021
201123
201210
201315
201413
201520
201610
201714
201812
201917
202012
202110
202217
20238
20247
20255
20269

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\") = 2005
    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.

NTSB NYC06CA063Accident · Serious injuriesData collectionFinal reportGulfstream Aerospace G-200 · Baltimore, MDThe passenger's improper decision to get up from her seat while the airplane was taxiing. A factor was the inadvertent excessive application of the emergency brake.Dec 30, 2005 · N885RR · No damageNTSB NYC05CA146Accident · No injuriesData collectionFinal reportCessna 172P · Mitchellville, MDThe pilot's failure to maintain directional control during landing.Sep 23, 2005 · N99137 · Substantial damageNTSB NYC05CA132Accident · No injuriesData collectionFinal reportCessna R172E · Patuxent River, MDThe pilot's improper recovery from a bounced landing, resulting in a hard landing.Aug 10, 2005 · N7880N · Substantial damageNTSB NYC05CA124Accident · No injuriesData collectionFinal reportWaco AQC-6 · Leonardtown, MDThe pilot's inadequate compensation for wind and his failure to maintain aircraft control while landing, which resulted in a nose over. A factor in this accident was the crosswind condition.Jul 24, 2005 · N16227 · Substantial damageNTSB NYC05LA121Accident · 1 fatalLimited investigationFinal reportRatliff Hummel Bird · Pittsville, MDA loss of control for undetermined reasons, which resulted in an uncontrolled descent into terrain.Jul 19, 2005 · N707TR · Substantial damageNTSB IAD05LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Denton, MDA loss of engine power for undetermined reasons.Jul 18, 2005 · N4797L · Substantial damageNTSB NYC05CA076Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Indian Head, MDThe pilot's failure to maintain adequate altitude/clearance while on final approach, which resulted in an in-flight collision with trees. A factor in this accident was the gusty wind conditions.Apr 27, 2005 · N8730E · Substantial damageNTSB IAD05LA055Accident · Serious injuriesLimited investigationFinal reportCessna 337G · Oakland, MDThe pilot's delay in aborting the landing, which resulted in an inadvertent stall/mush into the trees. A factor in the accident was the tailwind.Apr 14, 2005 · N53548 · DestroyedNTSB NYC05CA062Accident · No injuriesData collectionFinal reportCessna 150L · Mitchellville, MDThe pilot's inadequate compensation for wind conditions. A factor was the gusty wind conditions.Mar 19, 2005 · N11965 · Substantial damageNTSB IAD05LA043Accident · No injuriesLimited investigationFinal reportCessna 172N · Frederick, MDThe inadequate visual lookout of the pilots in each airplane, which resulted in a ground collision.Mar 10, 2005 · N711DA · 2 aircraft · Substantial damageNTSB NYC05MA039Accident · 2 fatalMajor investigationFinal reportEurocopter Deutschland EC 135 P2 · Oxon Hill, MDThe pilot's failure to identify and arrest the helicopter's descent, which resulted in controlled flight into terrain. Contributing to the accident were the dark night conditions, limited outside visual references, and the lack of an operable radar altimeter…Jan 11, 2005 · N136LN · Destroyed