NTSB investigations, 2023, AL

5 cases where the sequence of events included Off-field or emergency landing.

Cases per year

20082026
NTSB investigations, 2023, AL per year, 2008–2026: 60 cases
20081
20092
20115
20124
20134
20145
20153
20162
20178
20185
20191
20202
20212
20225
20235
20242
20252
20262

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\") = 2023
    AND c.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 ERA24FA050Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Attalla, ALThe undetected wear of both pawl retaining rivets of the left magneto impulse coupling and fatigue failure of one pawl retaining rivet, which led to cascading fractures of the second pawl retaining rivet, left gear retainer assembly, and gear teeth of…Nov 27, 2023 · N4187Q · DestroyedNTSB ERA23LA288Accident · No injuriesClass 4 · LimitedFinal reportSteen Skybolt · Aliceville, ALA partial loss of engine power for reasons that could not be determined as the wreckage was not recovered and could not be examined.Jul 4, 2023 · N32WM · Substantial damageNTSB ERA23LA286Accident · No injuriesClass 3 · LimitedFinal reportGrumman American Avn. AA5A · Redstone Arsenal, ALThe separation of the clamp assembly securing the throttle control cable outer housing, which resulted in the pilot’s inability to control the throttle.Jul 4, 2023 · N26387 · Substantial damageNTSB ERA23LA232Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Selma, ALThe pilot’s improper preflight inspection, during which the left wing fuel sump drain was moved to and left in the open and locked position, allowing for fuel to drain during the flight and resulting in a total loss of engine power due to fuel starvation.…May 12, 2023 · N1347T · Substantial damageNTSB ERA23LA183Accident · No injuriesClass 4 · LimitedFinal reportPeterson Mark G Peterson A600 · Foley, ALThe loss of engine power during the initial climb due to the disconnection of the turbocharger air intake hose and clamp, and the pilot’s inadequate servicing and preflight inspection of the turbocharger air intake clamp.Apr 6, 2023 · N272AM · Destroyed