NTSB investigations, 2007, MD

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, 2007, 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\") = 2007
    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 OPS08IA002Incident · No injuriesIncident investigationFinal reportBombardier CRJ1 · Baltimore, MDThe probable cause of this incident is local controller's failure of maintaining awareness of the situation and failing to provide the appropriate separation between the two aircraft operating on intersecting runways. Providing separation between aircraft is…Dec 3, 2007 · N781CA · 2 aircraft · No damageNTSB NYC08LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Gaithersburg, MDThe student pilot's failure to maintain aircraft control during an attempted touch-and-go. Contributing to the accident was the instructor's delay in taking remedial action, and the presence of trees in proximity to the side of the runway.Dec 1, 2007 · N259ER · Substantial damageNTSB ATL07CA107Accident · Serious injuriesData collectionFinal reportMcNicholas S-12 · Cambridge, MDThe non certificated pilot's failure to remove the control lock prior to taxi and takeoff.Aug 25, 2007 · N8157Q · Substantial damageNTSB DEN08LA024Accident · No injuriesLimited investigationFinal reportIniziative Industriali Italian Sky Aero 600 Sport · Stevensville, MDThe pilot's premature flare that resulted in a hard landing, fracturing the left main landing gear strut that subsequently collapsed. A contributing factor was the flight instructor's inadequate supervision of the pilot.Aug 24, 2007 · N435SA · Substantial damageNTSB ATL07LA111Accident · 1 fatalLimited investigationFinal reportPiper PA-22-160 · Leonardtown, MDThe pilot's inadequate performance planning and failure to abort the takeoff.Aug 9, 2007 · N2731P · DestroyedNTSB MIA07CA115Accident · No injuriesData collectionFinal reportMooney M20R · Mitchellville, MDThe pilot's failure to attain the proper touchdown point for landing and his failure to initiate a go-around when he realized the airplane would touchdown past the intended point.Jul 1, 2007 · N321MD · Substantial damageNTSB ATL07CA096Accident · Minor injuriesData collectionFinal reportBurk RV-6A · Laurel, MDThe pilot's improper landing flare resulting in an inadvertent stall and hard landing, which resulted in the airplane sliding off the runway and nosing over.Jun 23, 2007 · N526W · Substantial damageNTSB NYC07FA109Accident · Serious injuriesField investigationFinal reportPiper PA38-112 · Odenton, MDThe pilot's mismanagement of the airplane's fuel supply, which resulted in fuel starvation and a total loss of engine power.May 4, 2007 · N2600N · Substantial damageNTSB DEN07CA091Accident · No injuriesData collectionFinal reportPiper PA-28-201T · Westminster, MDThe pilot's failure to maintain directional control.Apr 29, 2007 · N28989 · Substantial damageNTSB ATL07CA082Accident · Minor injuriesData collectionFinal reportFlight Design Ctsw · Fort Meade, MDThe student pilot's inadequate compensation for the gusty wind conditions during the landing flare, resulting in a loss of control, and an in-flight collision with terrain. A factor associated with the accident was the wind gusts.Apr 29, 2007 · N22QT · DestroyedNTSB NYC07LA105Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · La Plata, MDAn in-flight encounter with turbulence and the flight crew's failure to advise the cabin crew about potential forecast turbulence, as reported by the flight attendant.Apr 25, 2007 · N648SW · No damageNTSB NYC07FA091Accident · 3 fatalField investigationFinal reportPiper PA-30 · Trappe, MDThe pilot's improper decision to fly into an area of thunderstorms, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was the thunderstorm.Apr 4, 2007 · N555EM · DestroyedNTSB NYC07FA083Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · Jacksonville, MDThe pilot's failure to maintain control of the airplane which was a result of spatial disorientation after takeoff into instrument conditions with an operationally degraded electronic primary flight display. Contributing to the accident were the pilot’s…Mar 24, 2007 · N324ST · Destroyed