NTSB investigations, 2004, 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, 2004, 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\") = 2004
    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 NYC04CA175Accident · No injuriesData collectionFinal reportCessna 182R · Mitchellville, MDThe private pilot's inadequate flare, and the CFI's delayed remedial action, which resulted in an inadvertent stall/mush and hard landing. A factor related to the accident was the night conditions.Jul 22, 2004 · N9476X · Substantial damageNTSB NYC04CA164Accident · No injuriesData collectionFinal reportCessna 172S · Stevensville, MDThe pilot's improper flare during touch down, which resulted in a hard landing.Jun 30, 2004 · N421RW · Substantial damageNTSB IAD04FA021Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Ferndale, MDThe pilot's failure to maintain airspeed during a sharp turn, which resulted in an inadvertent stall and subsequent impact with terrain. Factors included the pilot's failure to fly to the intended point of landing, and his abrupt course reversal back towards…May 14, 2004 · N755AF · DestroyedNTSB IAD04LA020Accident · No injuriesLimited investigationFinal reportTaylorcraft BC · Cumberland, MDThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall into transmission lines.May 8, 2004 · N26644 · Substantial damageNTSB NYC04LA082Accident · Minor injuriesLimited investigationFinal reportSocata TB-20 · Frederick, MDTotal loss of engine power for undetermined reasons.Mar 7, 2004 · N163GT · Substantial damageNTSB NYC04CA084Accident · No injuriesData collectionFinal reportCessna 172S · Stevensville, MDThe student pilot's failure to maintain aircraft control while landing. A factor was the student pilot's lack of experience.Mar 7, 2004 · N317ME · Substantial damageNTSB NYC04CA073Accident · No injuriesData collectionFinal reportCessna 172N · Easton, MDThe student pilot's improper flare, which resulted in a hard landing.Feb 12, 2004 · N734AT · Substantial damageNTSB NYC04CA064Accident · No injuriesData collectionFinal reportCessna 172M · Cumberland, MDThe pilot's inadequate compensation for the crosswind while landing. A factor was the crosswind.Feb 7, 2004 · N61648 · Substantial damageNTSB IAD04CA009Accident · No injuriesData collectionFinal reportCessna 172R · Fredrick, MDThe student pilot's failure to maintain directional control during the landing. A factor was the snow bank.Feb 5, 2004 · N5165M · Substantial damageNTSB NYC04LA061Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · College Park, MDThe loss of hydraulic fluid due to chaffing of a brake line by a strut fairing rivet, resulting in the failure of the braking system.Jan 22, 2004 · N344CD · Substantial damageNTSB IAD04LA007Accident · No injuriesLimited investigationFinal reportPiper PA-25-180 · Baltimore, MDA loss of engine power for undetermined reasons. Factors included a low ambient temperature and a lack of suitable terrain for the forced landing.Jan 10, 2004 · N242JG · Substantial damage