# NTSB investigations: Other

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 3 of 5 · 212 cases

## Cases, newest first

- [NTSB MIA06LA073](https://openairdocs.org/ntsb/MIA06LA073.md): Piper PA-28-180 · Bunnell, FL · Accident · No injuries · Limited investigation · Final report · Mar 29, 2006 · N2182T · Substantial damage
  > The failure of the pilot to perform a preflight inspection of the airplane resulting in departure with an inadequate oil supply, subsequent engine failure due to oil starvation, and damage to the airplane during a forced landing. Contributing to the accident…
- [NTSB CHI05LA186](https://openairdocs.org/ntsb/CHI05LA186.md): Bell 206L-1 · West Plains, MO · Accident · No injuries · Limited investigation · Final report · Jul 13, 2005 · N2756A · Substantial damage
  > A loss of engine power for undetermined reasons during the intentional autorotation. The pilot's misjudgment of the touchdown flare leading to a hard landing was an additional cause. A contributing factor was the intentional autorotation.
- [NTSB DFW05LA047](https://openairdocs.org/ntsb/DFW05LA047.md): Bombardier CL-600-2C10 · Austin, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 29, 2004 · N506MJ · No damage
  > The failure of an air conditioning pack, which resulted in a haze filling the cabin. A contributing factor was the failure of the passenger to follow evacuation instructions.
- [NTSB MIA05CA032](https://openairdocs.org/ntsb/MIA05CA032.md): Cessna 172B · Zephyrhills, FL · Accident · Serious injuries · Data collection · Final report · Nov 21, 2004 · N7493X · Substantial damage
  > The pilot's failure to set the parking brake and his improper starting procedure which resulted in an unattended aircraft running away after hand starting the engine and the airplane colliding with parked airplanes, incurring substantial damage.
- [NTSB NYC04LA217](https://openairdocs.org/ntsb/NYC04LA217.md): Firefly Galaxy 9 · Lewisburg, WV · Accident · 1 fatal · Limited investigation · Final report · Sep 25, 2004 · N2200Z · Minor damage
  > The pilot's improper decision to attempt to board the balloon while it was ascending.
- [NTSB CHI04FA223](https://openairdocs.org/ntsb/CHI04FA223.md): Cessna 172L · Webster, WI · Accident · 1 fatal · Field investigation · Final report · Aug 12, 2004 · N3599F · Destroyed
  > The high velocity impact with terrain for undetermined reasons.
- [NTSB ATL04IA098](https://openairdocs.org/ntsb/ATL04IA098.md): Cessna 208B · Tunica, MS · Incident · No injuries · Incident investigation · Final report · Apr 27, 2004 · N738FX · Minor damage
  > The pilot's improper use of the emergency power lever which resulted in excessive operating temperatures. A factor was the improper adjustment of the emergency power lever dead band.
- [NTSB SEA03LA180](https://openairdocs.org/ntsb/SEA03LA180.md): Lancair LC41 · Bend, OR · Accident · No injuries · Limited investigation · Final report · Aug 27, 2003 · N166PD · Destroyed
  > The inadequate design of the drogue chute mechanical jettison system, which resulted in its failure to separate from the aircraft during in-flight spin recovery tests, and the incorrectly wired drogue chute cable cutter activation unit, which resulted in the…
- [NTSB MIA03LA055](https://openairdocs.org/ntsb/MIA03LA055.md): Aerospatiale ATR72-212 · San Juan, PR · Accident · Serious injuries · Limited investigation · Final report · Feb 8, 2003 · N448AM · No damage
  > The aft passenger stair handrail collapsing due to undetermined reasons.
- [NTSB ATL03IA006](https://openairdocs.org/ntsb/ATL03IA006.md): American Blimp A-60 · Valdosta, GA · Incident · No injuries · Incident investigation · Final report · Oct 21, 2002 · N660VL · Minor damage
  > Loss of airship control during tie down, due to gusty wind conditions.
- [NTSB ATL02LA125](https://openairdocs.org/ntsb/ATL02LA125.md): Rotorway Exec 162F · Concord, NC · Accident · No injuries · Limited investigation · Final report · Jun 17, 2002 · N588JR · Substantial damage
  > The pilot's improper use of cyclic while attempting a hover resulting in dynamic rollover.
- [NTSB CHI02FA093](https://openairdocs.org/ntsb/CHI02FA093.md): Cessna 208B · Alma, WI · Accident · 1 fatal · Field investigation · Final report · Mar 15, 2002 · N228PA · Substantial damage
  > The pilot not removing the ice contamination from the airplane prior to departure and the pilot intentionally flying into known severe icing conditions, resulting in the aircraft not being able to maintain altitude/clearance from the terrain. Factors to the…
- [NTSB SEA02FA035](https://openairdocs.org/ntsb/SEA02FA035.md): Robinson R-22 Beta · Silver City, MT · Accident · Serious injuries · Field investigation · Final report · Jan 31, 2002 · N7507G · Substantial damage
  > Both the pilot/owner and the FAA inspector pilots' failure to maintain adequate rotor RPM during a practice auto rotation landing which resulted in a hard landing. A contributing factor was the pilot/owner's application of excessive anti-torque pedal during…
- [NTSB ANC01LA109](https://openairdocs.org/ntsb/ANC01LA109.md): Sikorsky S61A · Wrangell, AK · Accident · No injuries · Limited investigation · Final report · Aug 11, 2001 · N5193Y · Substantial damage
  > The separation of a steel long line cable that failed and rebounded from a load of logs into the helicopter's main and tail rotors.
- [NTSB CHI01LA239](https://openairdocs.org/ntsb/CHI01LA239.md): Anderson Revelation · Wautoma, WI · Accident · Minor injuries · Limited investigation · Final report · Jul 21, 2001 · N6116S · Substantial damage
  > The pilot's failure to maintain airspeed, resulting in a stall. An inadequate pitch setting of the propeller is a contributing factor.
- [NTSB CHI01LA222](https://openairdocs.org/ntsb/CHI01LA222.md): Druine Turbulent D-31 · Lebanon, IN · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 2001 · N4697T · Substantial damage
  > The pilot not maintaining aircraft control while maneuvering during initial climb. Factors to the accident were the improperly serviced propeller that resulted in a pitch setting that was insufficient for normal flight.
- [NTSB CHI01LA103](https://openairdocs.org/ntsb/CHI01LA103.md): Piper PA-28-140 · Port Huron, MI · Accident · No injuries · Limited investigation · Final report · Mar 16, 2001 · N6532W · Substantial damage
  > The pilot not maintaing a proper glide path during the simulated forced landing. Factors were flight instructor's inadequate supervision and the wind gusts.
- [NTSB SEA01LA046](https://openairdocs.org/ntsb/SEA01LA046.md): Western International UH-1H · Darby, MT · Accident · 1 fatal · Limited investigation · Final report · Feb 7, 2001 · N205GL · Substantial damage
  > Inflight loss of a tail rotor pitch change link-to-blade grip attach bolt, resulting partial loss of tail rotor control, and subsequent entanglement of the helicopter's external load cable with a tree during emergency descent. Factors included the pilot's…
- [NTSB ANC00LA134](https://openairdocs.org/ntsb/ANC00LA134.md): Piper PA-18-105 · Slana, AK · Accident · No injuries · Limited investigation · Final report · Sep 29, 2000 · N5489H · Substantial damage
  > The pilot's inadvertent touch down. A factor associated with the accident was deep snow on the airstrip.
- [NTSB SEA00TA149](https://openairdocs.org/ntsb/SEA00TA149.md): Short SD3-30 200 · Elk City, ID · Accident · No injuries · Final report · Jul 31, 2000 · N179Z · Substantial damage
  > Entanglement of air-dropped cargo parachute with the aircraft's horizontal stabilizer, resulting in damage to the horizontal stabilizer.
- [NTSB MIA00LA010](https://openairdocs.org/ntsb/MIA00LA010.md): Cessna 150M · Bunnell, FL · Accident · No injuries · Limited investigation · Final report · Oct 18, 1999 · N3240V · Substantial damage
  > The erosion and separation of the aft end plate P/N 0450338-18 of the right muffler resulting in exhaust gas contact to electrical wires in the engine compartment. Also, unsuitable terrain encountered by the pilot during the forced landing. A finding in the…
- [NTSB MIA99LA185](https://openairdocs.org/ntsb/MIA99LA185.md): Beech E-35 · Yankeetown, FL · Accident · No injuries · Limited investigation · Final report · Jun 5, 1999 · N3508B · Substantial damage
  > The failure of maintenance personnel to balance check the ruddervators after painting the airplane and unclear information contained in the compliance section of AD 94-20-04 resulting in the failure of maintenance personnel to balance check the out-of-balance…
- [NTSB DCA99IA058](https://openairdocs.org/ntsb/DCA99IA058.md): Airbus Industrie 300-600 · Miami, FL · Incident · No injuries · Incident investigation · Final report · May 11, 1999 · N7082A · No damage
  > Uncommanded rudder movement caused by a contaminant in the engagement valve solenoid that prevented disengagement of the autopilot yaw actuator and cross-connected wiring of the autopilot yaw actuator's main valve solenoids by the operator. Factors…
- [NTSB IAD98FA086](https://openairdocs.org/ntsb/IAD98FA086.md): Consolidated-Vultee BT-13A · Stevensville, MD · Accident · 2 fatal · Field investigation · Final report · Aug 2, 1998 · N550C · Destroyed
  > The pilot-in-command's failure to maintain aircraft control while buzzing a building.
- [NTSB FTW98LA353](https://openairdocs.org/ntsb/FTW98LA353.md): de Havilland DH-8-202 · Telluride, CO · Accident · No injuries · Limited investigation · Final report · Jul 27, 1998 · N449YV · Substantial damage
  > The inadequate chocks and inadequate chocking procedures by the operator. Factors were the unavailability of the parking brake and sloping terrain.
- [NTSB MIA98FA196](https://openairdocs.org/ntsb/MIA98FA196.md): Cessna 150E · Panama City Bch, FL · Accident · 1 fatal · Field investigation · Final report · Jul 15, 1998 · N3549J · Substantial damage
  > The failure of the pilot to maintain airspeed (Vs) and the inadvertent stall by the pilot. Contributing to the accident was the intentional operation of the airplane by the pilot in an over gross weight condition resulting in a higher stall speed, and failure…
- [NTSB SEA98LA085](https://openairdocs.org/ntsb/SEA98LA085.md): Piper PA-30 · Everett, WA · Accident · 1 fatal · Limited investigation · Final report · Jun 4, 1998 · N98NT · Minor damage
  > The pilot-in-command's exiting the aircraft with both engines running to remove a wheel chock. A factor was the inadequate preflight of the aircraft (not removing the chock) prior to engine start.
- [NTSB MIA98FA039](https://openairdocs.org/ntsb/MIA98FA039.md): Christen Industries A-1 · Lansing, NC · Accident · 1 fatal · Field investigation · Final report · Dec 2, 1997 · N9613P · Destroyed
  > the pilot's failure to maintain clearance from a wire.
- [NTSB ATL97LA137](https://openairdocs.org/ntsb/ATL97LA137.md): John W. Culp KR-2 · Greenwood, SC · Accident · 1 fatal · Limited investigation · Final report · Sep 21, 1997 · N9097E · Destroyed
  > The collision with the ground for undetermined reasons.
- [NTSB MIA97FA142](https://openairdocs.org/ntsb/MIA97FA142.md): Boeing Stearman N2S-4 · Apex, NC · Accident · 2 fatal · Field investigation · Final report · Apr 20, 1997 · N61S · Substantial damage
  > The pilot-in-command's ostentatious display by performing an aerobatic maneuver with inadequate altitude.
- [NTSB LAX97LA061](https://openairdocs.org/ntsb/LAX97LA061.md): McDonnell Douglas MD-600N · Flagstaff, AZ · Accident · No injuries · Limited investigation · Final report · Nov 21, 1996 · N630N · Substantial damage
  > The pilot's inattention to the altitude and inadvertent late entry into an autorotation maneuver below the established minimum test altitude with a helicopter operating at maximum gross weight in a high density altitude environment that led to a subsequent…
- [NTSB CHI96FA211](https://openairdocs.org/ntsb/CHI96FA211.md): McDonnell Douglas F/A-18C · Bethalto, IL · Accident · 1 fatal · Field investigation · Final report · Jun 19, 1996 · N16518 · Destroyed
  > the pilot's failure to follow the preflight crew briefing and attain a proper altitude during an aerobatic maneuver. Factors in the accident were: the pilot's previous experience of flying similar airshow routines in a different airplane with substantially…
- [NTSB MIA96LA175](https://openairdocs.org/ntsb/MIA96LA175.md): Piper PA-60-601P · Atlantic Ocean (Atlantic Ocean) · Accident · 1 fatal · Limited investigation · Final report · Feb 17, 1996 · N956AF · Destroyed
  > pilot incapacitation.
- [NTSB ANC96LA004](https://openairdocs.org/ntsb/ANC96LA004.md): Piper PA-18 · Tyonek, AK · Accident · No injuries · Limited investigation · Final report · Oct 7, 1995 · N4463Z · Substantial damage
  > Improper planning/decision by the pilot concerning his method of testing the landing area. His selection of an unsuitable area was a related factor.
- [NTSB CHI95LA325](https://openairdocs.org/ntsb/CHI95LA325.md): Bede BD12 · Chesterfield, MO · Accident · No injuries · Limited investigation · Final report · Sep 14, 1995 · N112BD · Substantial damage
  > The airplane's inadequate handling characteristics which resulted in the inability to control pitch attitude during landing.
- [NTSB FTW95LA167](https://openairdocs.org/ntsb/FTW95LA167.md): Boeing 757-223 · San Antonio, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 11, 1995 · N683A · No damage
  > The pilot-in-command's failure to set the parking brake.
- [NTSB CHI94LA016](https://openairdocs.org/ntsb/CHI94LA016.md): Cessna 150J · Grosse Ile, MI · Accident · No injuries · Limited investigation · Final report · Oct 3, 1993 · N5522G · Substantial damage
  > The pilot misjudged altitude/clearance during the banner pickup, which resulted in the tow rope snagging the landing gear, and failed to maintain adequate airspeed, while landing with the banner attached, which resulted in a failure (or inability) to attain a…
- [NTSB SEA93LA169](https://openairdocs.org/ntsb/SEA93LA169.md): Hadaller Murphy Renegade · Guernsey, WY · Accident · No injuries · Limited investigation · Final report · Aug 1, 1993 · N95HH · Substantial damage
  > Improper planning/decision by the pilot. Factors related to the accident were: rising/mountainous terrain, high density altitude, the lack of climb performance information available to the pilot, and rough/uneven terrain in the emergency landing area.
- [NTSB ATL93MA055](https://openairdocs.org/ntsb/ATL93MA055.md): Lockheed L382E-44K-20 · Marietta, GA · Accident · 7 fatal · Major investigation · Final report · Feb 3, 1993 · N130X · Destroyed
  > Disengagement of the rudder fly-by-wire flight control system resulting in a total loss of rudder control capability while conducting ground minimum control speed tests. The disengagement was a result of the inadequate design of the rudder's integrated…
- [NTSB CHI93FA029](https://openairdocs.org/ntsb/CHI93FA029.md): Cessna 150L · Elwood, IL · Accident · 2 fatal · Field investigation · Final report · Nov 13, 1992 · N11199 · Destroyed
  > The pilot-in-command's failure to maintain a proper adequate altitude to avoid obstructions. Factors contributing to the accident was the pilot's impairment of efficiency and judgement due to alcohol, and the dark night condition.
- [NTSB NYC93LA008](https://openairdocs.org/ntsb/NYC93LA008.md): Cessna 152 II · Milford, NH · Accident · No injuries · Limited investigation · Final report · Oct 5, 1992 · N301DW · Substantial damage
  > The instructor pilots improper in-flight planning, and his failure to maintain a proper glide path to the forced landing area. A factor in this accident was the instructor's decision to shut down the engine during a 'simulated' engine failure.
- [NTSB NYC92LA162](https://openairdocs.org/ntsb/NYC92LA162.md): Piper PA-18A-150 · Ocean City, NJ · Accident · No injuries · Limited investigation · Final report · Aug 12, 1992 · N9374D · Substantial damage
  > The airplane nosing over on landing roll due to inadequate airplane handling characteristics while landing with the banner attached. Factors related to the accident were the use of rope instead of steel cable, the main landing gear mounted tow hitch, and the…
- [NTSB LAX92GA347](https://openairdocs.org/ntsb/LAX92GA347.md): Hughes 369D · Maxwell, CA · Accident · 1 fatal · Final report · Aug 12, 1992 · N58425 · Destroyed
  > The failure of the pilot to maintain an adequate visual outlook, and failure of the company to provide adequate training. Contributing to the accident was: inadequate company supervision during the operation, and inadequate surveillance by the FAA which…
- [NTSB MIA92LA113](https://openairdocs.org/ntsb/MIA92LA113.md): Piper PA-18-150 · St. Augustine, FL · Accident · 1 fatal · Limited investigation · Final report · Apr 22, 1992 · N13910 · Destroyed
  > The pilot-in-command's failure to maintain airspeed while buzzing which resulted in the aircraft stalling and entering a spin.
- [NTSB SEA92LA074](https://openairdocs.org/ntsb/SEA92LA074.md): Moore Sonerai 1 · Harrisburg, OR · Accident · 1 fatal · Limited investigation · Final report · Apr 11, 1992 · N27127 · Destroyed
  > The pilot's failure to maintain an altitude sufficient to avoid colliding with terrain while performing acrobatic maneuvers as a result of his alcoholic impairment of efficiency and judgement. Factors contributing to the accident were: the pilots disregard of…
- [NTSB ATL92LA067](https://openairdocs.org/ntsb/ATL92LA067.md): Cessna 182 · Barnwell, SC · Accident · 1 fatal · Limited investigation · Final report · Mar 22, 1992 · N5441B · Minor damage
  > The pilot's failure to maintain a safe altitude above the ground while making a low pass at night.
- [NTSB DEN91DTE02](https://openairdocs.org/ntsb/DEN91DTE02.md): Cresawn Pitts S1-C · Calhan, CO · Accident · 1 fatal · Final report · Sep 3, 1991 · N939PC · Substantial damage
  > The pilot's failure to attain adequate aircraft control to avoid terrain collision.
- [NTSB CHI91DCD02](https://openairdocs.org/ntsb/CHI91DCD02.md): Canadian Car & Foundry Harvard Mark IV · Ida Grove, IA · Accident · 1 fatal · Final report · Aug 11, 1991 · N15795 · Destroyed
  > The pilot's failure to maintain airspeed.
- [NTSB DEN91FA110](https://openairdocs.org/ntsb/DEN91FA110.md): Cessna 177 · Hygiene, CO · Accident · 1 fatal · Field investigation · Final report · Aug 6, 1991 · N3185T · Destroyed
  > Suicide. A factor related to the accident was: the pilot's other psychological condition.
- [NTSB BFO91FA060](https://openairdocs.org/ntsb/BFO91FA060.md): Piper J5 · Berlin, MD · Accident · 1 fatal · Field investigation · Final report · Jun 29, 1991 · N763WM · Destroyed
  > The pilot's failure to maintain adeqate airspeed which caused the airplane to stall.

Next page: https://openairdocs.org/ntsb-phases/800/cases.md?page=4

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 800)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/800/cases?page=3

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.