NTSB investigations, 2000, FL

21 cases where the phase of flight was Approach.

Cases per year

19622026
NTSB investigations, 2000, FL per year, 1962–2026: 1,192 cases
19621
196413
196516
196618
196716
196818
196925
197021
197120
197223
197321
197422
197518
197622
197725
197829
197934
198043
198126
198216
198326
198425
198520
198626
198731
198829
198925
199020
199125
199222
199319
199423
199518
199624
199718
199820
199917
200021
200115
200219
200310
200410
200517
200621
200723
200816
200910
201014
201114
201215
201314
201413
201521
20167
201711
201812
201913
202011
202114
202212
20238
202416
202513
20267

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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\") = 2000
    AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 500)
  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 ATL01LA010Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Everglades City, FLThe pilot's failure to maintain control of the aircraft during landing.Nov 15, 2000 · N2334J · Substantial damageNTSB MIA01LA023Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Daytona Beach, FLThe CFI's inadequate supervision of the dual student and the dual student's loss of directional control during landing.Nov 3, 2000 · N1519T · Substantial damageNTSB ATL01LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172-B · Palatka, FLThe CFI's inadequate preflight planning which resulted in fuel exhaustion and the subsequent loss of engine power.Oct 13, 2000 · N7894X · Substantial damageNTSB ATL00FA091Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Ft. Pierce, FLFailure of local controller to provide adequate spacing between two airplanes that resulted in a midair collision. Contributing Factors: the local controller declined receiving a formal brief before relieving the controller on duty. The controller who was…Sep 11, 2000 · N9208N · 2 aircraft · DestroyedNTSB ATL00LA084Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Vero Beach, FLThe pilot's inability to control the aircraft after landing due to a loss of engine power and landing gear failure for undetermined reasons. A factor in the severity of the accident was the impact with the airport marker lights.Aug 18, 2000 · N4380S · Substantial damageNTSB MIA00LA240Accident · Serious injuriesLimited investigationFinal reportLake LA-4 · Pensacola, FLThe pilot receiving instruction failure to achieve the proper touch down point during a water landing, and the CFI's improper supervision and failure to initiate a go-around in sufficient time to avoid and in-flight collision with trees, water, and subsequent…Aug 17, 2000 · N2015L · Substantial damageNTSB ATL00LA064Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · Palmetto, FLThe pilot's failure to maintain airspeed during final approach to landing, resulting in an inadvertent stall.Jun 10, 2000 · N83972 · Substantial damageNTSB ATL00LA058Accident · Minor injuriesLimited investigationFinal reportBell 407 · Lake Placid, FLThe pilot's failure to establish/maintain a safe rate of descent during approach to landing. Contributing factors were the pilot's incorrect altimeter (Kollsman) setting, smoke, and dark night conditions.Jun 5, 2000 · N234BH · Substantial damageNTSB MIA00FA163Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Titusville, FLThe failure of the PIC to maintain control of the aircraft while in the simulated engine inoperative configuration in the landing pattern during a checkout flight resulting in an uncontrolled descent and collision with trees. A factor in the accident is the…May 19, 2000 · N3492P · DestroyedNTSB ATL00FA041Accident · 1 fatalField investigationFinal reportBeech BE-58 · Palatka, FLThe pilot's physically impaired condition due to his high level of alcohol. Factors were the pilot's intentional VFR flight into IMC conditions and failure to perform a missed approach, which resulted in a collision with the ground.Apr 15, 2000 · N1072D · DestroyedNTSB ATL00LA040Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Leesburg, FLThe pilot's failure to maintain clearance from objects during the final approach. A factor was downdraft on final approach.Apr 8, 2000 · N45618 · Substantial damageNTSB MIA00FA129Accident · 3 fatalField investigationFinal reportLearjet 35A · Marianna, FLthe pilot's failure to maintain control of the airplane while on final approach resulting in the airplane striking trees. Factors in this accident were: improper planning of the approach, and not obtaining the proper alignment with the runway.Apr 5, 2000 · N86BE · DestroyedNTSB MIA00IA128Incident · No injuriesIncident investigationFinal reportDassault DA-20 · Opa Locka, FLThe failure of the PIC to execute the complete procedure for emergency extension of the landing gear and the subsequent landing with the left main landing gear not locked fully down, resulting in an excursion off the runway and collision with a runway…Apr 4, 2000 · N175GA · Minor damageNTSB MIA00LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgewater, FLThe partial loss of engine power due to undetermined reasons.Mar 26, 2000 · N757JE · Substantial damageNTSB MIA00FA107Accident · No injuriesField investigationFinal reportCessna 310D · Stuart, FLthe failure of both pilots to maintain an adequate visual lookout, resulting in both airplanes colliding in flight. Contributing to the accident were: 1) inadequate approach/departure control service by ATC approach/departure personnel, and the failure of the…Mar 14, 2000 · N6744T · 2 aircraft · Minor damageNTSB ATL00LA031Accident · 1 fatalLimited investigationFinal reportunknown unknown · Manatee, FLThe pilot's impairment due to the use of unapproved medication which led to loss of control in flight.Mar 3, 2000 · UNREG · DestroyedNTSB MIA00LA099Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Brooksville, FLTotal loss of engine power for undetermined reasons on appr oach for landing resulting in an in-flight collision with a dirt bank, separation of the main landing gear, and subsequent nose over. Contributing to the accident was carburetor icing conditions.Feb 28, 2000 · N717NC · Substantial damageNTSB ATL00LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Titusville, FLThe pilot's improper decision to attempt a flight on minimal fuel, which resulted in a total loss of engine power due to fuel exhaustion. A factor was the closed fuel pumps at the departure airport.Feb 28, 2000 · N441WA · Substantial damageNTSB MIA00LA093Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Miami, FLthe pilot planned the approach too low, which resulted in inadequate altitude to clear powerlines, and the subsequent in-flight collision with the ground.Feb 19, 2000 · N65819 · Substantial damageNTSB ATL00LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe pilot's inadequate pre-flight planning resulting in a total loss of engine power due to fuel exhaustion.Feb 19, 2000 · N68197 · Substantial damageNTSB ATL00FA024Accident · 2 fatalField investigationFinal reportMooney M20J · Odessa, FLThe pilot's failure to maintain a safe altitude and his failure to attain the proper touchdown point during landing. A factor was the utility pole.Feb 10, 2000 · N201RC · Substantial damage