NTSB investigations, 2002, AL

7 cases where the first occurrence was “Loss of control - in flight”.

Cases per year

19822026
NTSB investigations, 2002, AL per year, 1982–2026: 110 cases
19822
19833
19847
19853
19864
19873
19884
19895
19906
19916
19929
19936
19943
19955
19964
19973
19983
19992
20003
20013
20027
20034
20045
20053
20063
20074

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\") = 2002
    AND c.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250)
  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 ATL03FA008Accident · 1 fatalField investigationFinal reportCessna 208B · Spanish Fort, ALthe pilot's spatial disorientation, which resulted in loss of airplane control. Contributing to the accident was the night instrument meteorological conditions with variable cloud layers.Oct 24, 2002 · N76U · DestroyedNTSB MIA03LA002Accident · 2 fatalLimited investigationFinal reportGolden RV6A · Tuskegee, ALthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, and subsequent impact with the terrain.Oct 6, 2002 · N609CG · DestroyedNTSB ATL02FA143Accident · 2 fatalField investigationFinal reportCessna 150G · Duncanville, ALThe pilot's failure to maintain airspeed , which resulted in an inadvertent stall, and subsequent collision with the ground. A contributing factor was low level flight.Jul 17, 2002 · N3400J · DestroyedNTSB ATL02LA115Accident · Serious injuriesLimited investigationFinal reportFrank Fitzgerald Team Z Max · Huntsville, ALThe pilot's failure to maintain airspeed during a take off climb resulting in a loss of control (inadvertent stall) and the subsequent in-flight collision with terrain. A factor was the lack of total experience in type of aircraft.May 31, 2002 · N1995Z · Substantial damageNTSB ATL02LA093Accident · No injuriesLimited investigationFinal reportCessna 150B · Enterprise, ALThe pilot's failure to maintain airspeed during an attempted go-around that resulted in an inadvertent stall and the subsequent collision with the ground.Apr 26, 2002 · N1299Y · Substantial damageNTSB MIA02LA071Accident · No injuriesLimited investigationFinal reportBeech C-24R · Bayou La Batre, ALThe pilot's failure to maintain aircraft directional control while executing a go-around, resulting in an inflight collision with trees.Mar 24, 2002 · N18891 · Substantial damageNTSB ATL02LA061Accident · 1 fatalLimited investigationFinal reportMoore Sammie M-Breezy · Pell City, ALThe pilot's failure to maintain flying speed, followed by an inadvertent stall spin, and subsequent collision with terrain.Mar 8, 2002 · N9167C · Destroyed