NTSB investigations, 2000, FL

25 cases where the phase of flight was Enroute.

Cases per year

19622026
NTSB investigations, 2000, FL per year, 1962–2026: 2,183 cases
19621
19632
196426
196530
196635
196737
196845
196933
197053
197142
197243
197361
197438
197550
197639
197751
197855
197954
198058
198155
198254
198352
198459
198558
198664
198746
198841
198937
199037
199138
199237
199335
199440
199543
199638
199735
199831
199942
200025
200125
200231
200333
200431
200535
200622
200739
200819
200929
201018
201113
201222
201317
201413
201513
201620
201718
201822
201914
202012
202123
202216
202315
202424
202520
202619

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 = 400)
  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 ATL01LA016Accident · No injuriesLimited investigationFinal reportCessna 182A · Plant City, FLThe loss of engine power due to fuel starvation resulting from the separation of the mixture control cable from the carburetor. Factors were cows, rough and uneven terrain.Dec 12, 2000 · N6300B · Substantial damageNTSB MIA01LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Wewahitchka, FLa loss of engine power due to the number 5 cylinder connecting rod separating at the rod cap, resulting in a forced landing and subsequent impact with rough uneven terrain.Nov 21, 2000 · N9658C · Substantial damageNTSB MIA01FA029Accident · 1 fatalField investigationFinal reportAirbus Industrie A300B4-605R · Miami, FLThe failure of the flight crew to perform the cabin pressurization manual control abnormal checklist after experiencing a pressurization system malfunction and switching to manual pressurization control, and the failure of the flight crew to perform the…Nov 20, 2000 · N14056 · Minor damageNTSB MIA01FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Zolfo Springs, FLThe loss of engine power for undetermined reasons, which resulted in the pilot executing a forced landing to an open field, and the aircraft subsequently impacting a tree during the landing rollout.Oct 31, 2000 · N8603E · Substantial damageNTSB MIA01LA017Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Daytona Beach, FLan inadvertent inflight collision with a bird during cruise flight that resulted in substantial damage to the airplane.Oct 21, 2000 · N928ER · Substantial damageNTSB ATL00LA094Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Homosassa, FLThe pilot's inadvertent flight into instrument meteorological conditions and subsequently exhausting his fuel supply. Factors were his failure to obtain a weather briefing, the weather conditions which included clouds and obscuration, the residence and the…Sep 30, 2000 · N2234K · Substantial damageNTSB MIA00LA271Accident · Serious injuriesLimited investigationFinal reportBoeing 777-223 · Miami, FLan in-flight encounter with turbulence.Sep 26, 2000 · N789AN · No damageNTSB ATL00LA088Accident · No injuriesLimited investigationFinal reportCessna 188 · Tampa, FLThe failure of the number six-piston connecting rod that resulted in the total loss of engine power.Sep 10, 2000 · N9977G · Substantial damageNTSB MIA00LA251Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Daytona Bch Sh, FLa loss of engine power due to undetermined reasons, that resulted in the aircraft being ditched.Aug 26, 2000 · N5117K · Substantial damageNTSB MIA00LA242Accident · No injuriesLimited investigationFinal reportRyan ST3KR · St. Lucie, FLThe pilot's improper judgment to conduct a precautionary landing when he first experienced a partial loss of engine power, and his subsequent failure to maintain a visual lookout during a forced landing resulting in an in-flight collision with a tree.…Aug 19, 2000 · N54403 · Substantial damageNTSB MIA00TA200Accident · No injuriesFinal reportHughes 369D · Destin, FLimproper maintenance inspection of the tail rotor by maintenance personnel and improper preflight inspection of the tail rotor by the pilot, which resulted in worn elastomeric bearings being continued in service, resulting in failure of the tail rotor…Jul 2, 2000 · N88MP · Substantial damageNTSB MIA00LA195Accident · No injuriesLimited investigationFinal reportCessna 402C · Naples, FLan inflight collision with a bird during descent that resulted in substantial damage to the airplane's vertical stabilizer spar.Jun 30, 2000 · N7037E · Substantial damageNTSB ATL00LA073Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Key West, FLA landing gear collapse resulting from the pilot's unsuccessful attempt to complete the manual gear extension due to physical strength overload. A factor was the complete electrical system failure during cruise flight.Jun 24, 2000 · N8629Y · Substantial damageNTSB MIA00FA190Accident · 4 fatalField investigationFinal reportLearjet 55 · Boca Raton, FLThe failure of the pilot's of both airplanes to maintain a visual lookout (while climbing and maneuvering) resulting in an in-flight collision and subsequent collision with residences and terrain.Jun 23, 2000 · N220JC · 2 aircraft · DestroyedNTSB MIA00LA173Accident · No injuriesLimited investigationFinal reportRawdon T1 · North Miami Bch, FLThe failure of the pilot to change the fuel selector position after experiencing surging of the engine. Contributing to the accident was the partial loss of engine power due to fuel starvation and the incorrect reading of the left fuel gauge.May 27, 2000 · N2706D · Substantial damageNTSB MIA00IA164Incident · No injuriesIncident investigationFinal reportBeech 1900C · Fort Lauderdale, FLThe failure of the first officer to comply with procedures and directives for his failure to assure that the forward airstair door was closed and locked. A contributing factor in the incident was the inoperative annunciation system of the forward airstair…May 19, 2000 · N154GA · Minor damageNTSB MIA00LA158Accident · No injuriesLimited investigationFinal reportPiper J-3 · Boca Raton, FLa loss of engine power due to undetermined reasons that resulted in a forced landing and substantial damage to the aircraft.May 14, 2000 · N70546 · Substantial damageNTSB MIA00LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Fernandina Bch, FLThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed resulting in an inadvertent stall., in-flight collision with terrain, and subsequent nose over.May 12, 2000 · N760WB · Substantial damageNTSB ATL00FA048Accident · 3 fatalField investigationFinal reportEurocopter BK117-A3 · St. Petersburg, FLThe pilot's failure to maintain clearance that resulted in the in-flight collision with a tower.Apr 25, 2000 · N428MB · DestroyedNTSB MIA00LA111Accident · Minor injuriesLimited investigationFinal reportHiller UH-12B · Sanford, FLThe pilot's improper collective and cyclic control usage during an emergency descent, following the onset of a 1 to 1 vibration for undetermined reasons, resulting in the helicopter landing hard and rolling over.Mar 17, 2000 · N5304V · Substantial damageNTSB ATL00LA033Accident · Serious injuriesLimited investigationFinal reportAero Comp COMP-AIR-6 · Indiantown, FLThe maintenance personnel inadequate inspection of the fuel system that resulted in loss of engine power due to fuel filter contamination.Mar 5, 2000 · N61520 · Substantial damageNTSB ATL00LA030Accident · Minor injuriesLimited investigationFinal reportBurak Stanley A XF4 · Brooksville, FLThe owner/builder's failure to build the airplane within the design stress limits of the drive shaft assembly, that resulted in the failure of the Flex Coupling Retention Bolts.Feb 29, 2000 · N9VY · Substantial damageNTSB MIA00LA094Accident · No injuriesLimited investigationFinal reportNorth American NA-64 · Clearwater, FLA total loss of engine power due to fuel starvation for und etermined reasons. This resulted in a forced landing to none suitable terrain, and a subsequent in-flight collision with trees and terrain.Feb 24, 2000 · N64WP · Substantial damageNTSB MIA00LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Kissimmee, FLThe failure of the pilot to obtain winds aloft for the planned cross country flight with a preflight weather briefing and inadequate fuel consumption calculations performed by the pilot resulting in the total loss of engine power due to fuel exhaustion.Jan 29, 2000 · N94999 · Substantial damageNTSB MIA00LA063Accident · No injuriesLimited investigationFinal reportCessna 550 · Homestead, FLAn inadvertent in-flight collision with a bird in cruise flight resulting in substantial damage to the airplane.Jan 1, 2000 · N752CC · Substantial damage