# NTSB investigations: Unknown

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 28 of 40 · 1,978 cases

## Cases, newest first

- [NTSB LAX83LA016](https://openairdocs.org/ntsb/LAX83LA016.md): Piper PA-23-250 · Sun City, CA · Accident · No injuries · Limited investigation · Final report · Oct 20, 1982 · N4729P · Substantial damage
  > The pilot made a wheels up landing on hawn avenue in Sun City, CA and abandoned the aircraft. During the landing, both wing tips struck sign posts and were damaged. No fuel was found in the aircraft after it had crashed, but about 650 lbs of illegal drugs…
- [NTSB DEN83FA008](https://openairdocs.org/ntsb/DEN83FA008.md): Luscombe T-8F · Choteau, MT · Accident · 2 fatal · Field investigation · Final report · Oct 14, 1982 · N2231B · Substantial damage
  > The PIC was a designated pilot examiner. The purpose of the flt was to give the PIC opportunity to fly the acft from the rear seat as he was planning to give flt instruction in the acft in the near future. As FAR as could be determined, the PIC had never…
- [NTSB MIA83LA012](https://openairdocs.org/ntsb/MIA83LA012.md): Piper PA-32-300 · Near St. Croix · Accident · 2 fatal · Limited investigation · Final report · Oct 13, 1982 · N77QT · Destroyed
  > The non-instrument rated pilot departed st Croix, VI at about 2000 local time on a VFR flight to san juan, PR. The weather was VFR, but it was a dark night. The aircraft failed to arrive at its destination and a search was initiated. About 10 miles northwest…
- [NTSB ATL83FKW01](https://openairdocs.org/ntsb/ATL83FKW01.md): Cessna 172P · Gallatin, TN · Accident · 2 fatal · Final report · Oct 9, 1982 · N5313K · Destroyed
  > Cessna 172P, N5313K crashed into a densely wooded area during the initial portion of cross-country flight. The pilot and his wife were killed but an infant son survived. Weather was not a factor.
- [NTSB MIA83LA009](https://openairdocs.org/ntsb/MIA83LA009.md): Beech H35 · Missing Acft (Atlantic Ocean) · Accident · 2 fatal · Limited investigation · Final report · Sep 28, 1982 · N5999 · Substantial damage
  > Aircraft Missing on a flight from marsh harbour Bahamas to ft. pierce FL. Thunderstorms were along the proposed route. Last recorded position on radar data log was at 27-06-13 north and 79-27-58 west. No radio communications were reported with flight after…
- [NTSB LAX82DA359](https://openairdocs.org/ntsb/LAX82DA359.md): Piper PA-18 · Casa Grande, AZ · Accident · 1 fatal · Final report · Sep 27, 1982 · N1851A · Destroyed
  > Student pilot with no night flying experience flew into wires at night on a personal flight with a passenger. VFR conditions existed and no flight plan was filed.
- [NTSB CHI82FA342](https://openairdocs.org/ntsb/CHI82FA342.md): Beech H35 · Beaver Dam, WI · Accident · 1 fatal · Field investigation · Final report · Sep 16, 1982 · N4676D · Destroyed
  > At about 1530 CDT, the aircraft departed madison, WI on a flight to the dodge county airport at juneau, WI. According to a fixed base operator at juneau, the pilot had made arrangements to fly the aircraft there on that date for an annual inspection. At 1544,…
- [NTSB ANC82DAG59](https://openairdocs.org/ntsb/ANC82DAG59.md): Cessna 180 · Missing Acft, AK · Accident · 3 fatal · Final report · Sep 7, 1982 · N2194Z · Destroyed
  > Aircraft disappeared on this flight of 9/7/82. No flight plan was filed but it is believed pilot was on round robin from lake hood to two lakes and return.
- [NTSB LAX82DA327](https://openairdocs.org/ntsb/LAX82DA327.md): Cessna 172H · Daggett, CA · Accident · Minor injuries · Final report · Sep 1, 1982 · N2584L · Substantial damage
  > The acft flew into rising terrain at night. The plt was issued a student pilot certificate 3 yrs before the accident. The acft was registered to the plt's father. No further information was made available.
- [NTSB ATL83FA186](https://openairdocs.org/ntsb/ATL83FA186.md): Piper PA-18 · Ft. Pickett, VA · Accident · 1 fatal · Field investigation · Final report · Aug 21, 1982 · N90910 · Destroyed
  > The acft collided with the ground at ft Pickett shortly after a similiar acft was seen trying to approach blackstone army airfield. This acft made a go-around and disappeared to the south. The wrecked acft was found 3.5 miles south of the arpt 8 months later.…
- [NTSB DEN82DA168](https://openairdocs.org/ntsb/DEN82DA168.md): Cessna 150 · Weldona, CO · Accident · No injuries · Final report · Aug 20, 1982 · N684CF · Substantial damage
  > The plt stated to a FAA inspector that prior to takeoff the fuel gauges indicated approximately 1/4 full in each tank. The inspector indicated the fuel supply was exhausted. Numerous attempts to obtain an accident report from the plt were unsuccessful.
- [NTSB FTW82FPA16](https://openairdocs.org/ntsb/FTW82FPA16.md): Bellanca 7ECA · Plano, TX · Accident · 2 fatal · Final report · Aug 19, 1982 · N10984 · Destroyed
  > During the 1818 departure from addison the plt advised addison tower that he was going to airpark-dallas for touch & go landings. The acft was observed to make at least one touch & go. At 1902 a witness called and reported hearing a noise, seeing a cloud of…
- [NTSB LAX82FUM11](https://openairdocs.org/ntsb/LAX82FUM11.md): Cessna 172N · San Clemente, CA · Accident · 2 fatal · Final report · Aug 18, 1982 · N739UY · Destroyed
  > Aircraft declared missing by wife of passenger. Parts of the aircraft were found by boater and beach walkers from 8/18 to 8/25. Injury index presumed.
- [NTSB LAX82DA299](https://openairdocs.org/ntsb/LAX82DA299.md): Lake LA-4 · Lake Tahoe, CA · Accident · No injuries · Final report · Aug 14, 1982 · N1104L · Destroyed
  > This was to have been the fourth sight-seeing flight of the day. As the amphibian was taxied for takeoff, the pilot noticed water flowing into the aircraft. The bilge pump was unable to quell the flow. The pilot and passengers, four children, abandoned the…
- [NTSB DEN82DA152](https://openairdocs.org/ntsb/DEN82DA152.md): Cessna 172N · Lander, WY · Accident · No injuries · Final report · Aug 3, 1982 · N6476G · Substantial damage
  > The pilot reported that the aircraft suddenly veered to the right after he had slowed to about 30 to 35 KTS. An examination revealed that the nose gear fork had failed in two places. The breaks were just below the strut attachment point and directly accross…
- [NTSB LAX82FA261](https://openairdocs.org/ntsb/LAX82FA261.md): Cessna 150M · Lake Isabella, CA · Accident · No injuries · Field investigation · Final report · Jul 17, 1982 · N704GL · Substantial damage
  > After takeoff, the acft was flown aprx 5 mi south of the arpt & was at about 1000 ft above a lake when the eng began vibrating violently & losing power. The plt turned toward the shore & tried various mixture settings in an attempt to correct the problem.…
- [NTSB ATL82DA203](https://openairdocs.org/ntsb/ATL82DA203.md): American AA-1 · Covington, TN · Accident · No injuries · Final report · Jul 17, 1982 · N5715L · Substantial damage
  > Prior to landing, the pilot checked his brakes to insure their integrity and noted that the left brake did not hold pressure. He elected to land on runway 01 since the hangar and ramp areas were located at the north end of the field and he didn't want to taxi…
- [NTSB NYC83FA083](https://openairdocs.org/ntsb/NYC83FA083.md): Grumman AA-1 · Missing Acft, NY · Accident · 1 fatal · Field investigation · Final report · Jul 12, 1982 · N5637L · Destroyed
  > The non-instrument rated pilot called ground control and requested a VFR departure. He was advised that the field was IFR and an IFR clearance was needed. The pilot filed an IFR flight plan and about 15 min later called for his clearance. He had trouble…
- [NTSB DEN82DA110](https://openairdocs.org/ntsb/DEN82DA110.md): Piper PA-32RT-300T · Durango, CO · Accident · No injuries · Final report · Jun 23, 1982 · N31912 · Substantial damage
  > The pilot reported that after taking off, dense white smoke began to fill the cockpit and seemed to come from under the instrument panel. He stated that the instruments were in the normal operating range, but the smoke became so dense that the visibility in…
- [NTSB ANC82FAG32](https://openairdocs.org/ntsb/ANC82FAG32.md): Piper PA-18-150 · Chugiak, AK · Accident · 1 fatal · Final report · Jun 13, 1982 · N2340S · Substantial damage
  > The student plt contacted his flight instructor by phone on the day of the accident & informed him that he was going to use his own acft for a fishing trip. He also stated that a commercially rated plt would be going along & would be flyingthe acft. The…
- [NTSB LAX82FA218](https://openairdocs.org/ntsb/LAX82FA218.md): Cessna 150L · Corona, CA · Accident · 4 fatal · Field investigation · Final report · Jun 12, 1982 · N18007 · 2 aircraft · Destroyed
  > Both aircraft (a Cessna 150L, N18007 and a Cessna 140, N90006) had taken off from the Corona municipal airport, sometime around noon on 6/12/82. The Cessna 150 pilot and passenger were on a flight to porterville, CA, while the Cessna 140 pilot and passenger…
- [NTSB LAX82DAMS1](https://openairdocs.org/ntsb/LAX82DAMS1.md): Wing D-1 · Catalina Island, CA · Accident · 2 fatal · Final report · Jun 11, 1982 · N8601M · Destroyed
  > The flt departed torrance at 1259 PDT & VFR conditions existed at the time. When the flt did not return a search was initiated. The search was terminated after 4 days. Friends & relatives speculated this may have been a dual instruction flt in preparation for…
- [NTSB FTW82FPG14](https://openairdocs.org/ntsb/FTW82FPG14.md): Aeronca 7AC · Lehi, AR · Accident · 2 fatal · Final report · Jun 7, 1982 · N83654 · Substantial damage
  > The acft was believed to have departed the west memphis arpt at approximately 1900. The acft was found at approximately 2000 in an open field 2 mi sw of the arpt. The acft had collided with the ground very hard in a nose down condition. Neither occupant…
- [NTSB LAX82FVD17](https://openairdocs.org/ntsb/LAX82FVD17.md): Savage Skybolt · Livermore, CA · Accident · 1 fatal · Final report · Jun 5, 1982 · N1914S · Destroyed
  > After the eng quit witnesses observed the acft nose over to about a 30-45 deg nose down attitude. No usable fuel was found in the acft. The acft has a section of clear plastic tubing on the outside of the fuel tank that is used as the fuel gauge. It would be…
- [NTSB FTW82FRA21](https://openairdocs.org/ntsb/FTW82FRA21.md): Piper PA-32 · Houston, TX · Accident · 1 fatal · Final report · Jun 5, 1982 · N36497 · Substantial damage
  > The acft was found in a rice field on 6/5/82. Narcotics were found in the acft along with a large quantity of money on the pilot's body. The acft had N38312 painted on the side. The acft was stolen in atlanta, ga in October of 1981.
- [NTSB FTW82FPD11](https://openairdocs.org/ntsb/FTW82FPD11.md): Cessna 152 · Carswell, TX · Accident · 1 fatal · Final report · May 1, 1982 · N4889H · Substantial damage
  > An instructor pilot and a passenger (a student pilot) departed north richland hills, TX at about 1700 hrs. The instructor flew to a recreational area and landed in an open nearby field. He gave airplane rides to various persons for about 1 1/2 hrs then parked…
- [NTSB FTW82DA163](https://openairdocs.org/ntsb/FTW82DA163.md): Cessna TU-206A · Rachal, TX · Accident · No injuries · Final report · May 1, 1982 · N4955F · Substantial damage
  > The aircraft wreckage was found by a rancher on may 1, 1982. The date of accident and circumstances could not be determined. The accident reporting forms sent to the registered owner were returned undelivered. Dea found 340 lb. Of marijuana on board the…
- [NTSB LAX82FVD13](https://openairdocs.org/ntsb/LAX82FVD13.md): Beech A36TC · Hearst, CA · Accident · 3 fatal · Final report · Apr 22, 1982 · N667WT · Destroyed
  > About 26 minutes after takeoff, the aircraft crashed in mountainous terrain at night. The crash site was located about eight miles east of the departure airport and was at an elevation of about 2000 ft MSL. During impact it struck trees and a 20 degree slope…
- [NTSB FTW82FA108](https://openairdocs.org/ntsb/FTW82FA108.md): Gulfstream American 690C · Hughes, AR · Accident · 1 fatal · Field investigation · Final report · Mar 29, 1982 · N5957K · Destroyed
  > The acft had been on sales demonstration flts and was on a delivery flt from memphis, TN to dallas, TX. The plane was observed departing at 1550 CDT in a max performance climb. Radar info from mode c of the transponder returns indicated that the acft climbed…
- [NTSB ATL82FA066](https://openairdocs.org/ntsb/ATL82FA066.md): Piper PA-32-260 · Bradley, SC · Accident · 4 fatal · Field investigation · Final report · Feb 28, 1982 · N38540 · Destroyed
  > Before takeoff, the pilot telephoned his brother in north carolina and asked about the weather. He was told that there was an overcast. The pilot replied that he would "come on and skirt the mountains." No flight plan was filed and there was no FAA record of…
- [NTSB DEN82DA036](https://openairdocs.org/ntsb/DEN82DA036.md): Piper PA-18 · Plentywood, MT · Accident · Minor injuries · Final report · Feb 14, 1982 · N4380Z · Substantial damage
  > On 2/16/82, the county sheriff received information that the pilot had wrecked his aircraft on 2/13/82. He went to the scene and observed the aircraft in an inverted position on snow covered terrain. On 2/20/82, he received information that the pilot had…
- [NTSB MIA82FLD15](https://openairdocs.org/ntsb/MIA82FLD15.md): Piper PA-31 · Ft. Pierce, FL · Accident · Serious injuries · Final report · Feb 7, 1982 · N747CE · Destroyed
  > The aircraft crashed at night near a private strip in marginal weather conditions. The gear was found in the up position, the right engine was broken off, the nose section was crushed back to the windshield, and both propellers were bent and twisted. About…
- [NTSB FTW82FRD08](https://openairdocs.org/ntsb/FTW82FRD08.md): Cessna 150G · Jeanerette, LA · Accident · 2 fatal · Final report · Feb 2, 1982 · N3166J · Destroyed
  > According to a friend of the deceased pilot and his female companion the three of them had been at a nightclub until 0215 CST. The friend then followed them to the airport, since he lived adjacent to the airport. After arriving he heard an aircraft takoeff.…
- [NTSB LAX82FA049](https://openairdocs.org/ntsb/LAX82FA049.md): Mooney M20C · Victorville, CA · Accident · 2 fatal · Field investigation · Final report · Jan 23, 1982 · N7860V · 2 aircraft · Destroyed
  > The pilot had planned to fly to the big bear airport, but changed his destination to apple valley, California. While on an easterly heading at about 6800 ft MSL, a collision occurred with another aircraft, a Mooney M20C, N7860V. The Piper pilot believed that…
- [NTSB LAX82FUQ09](https://openairdocs.org/ntsb/LAX82FUQ09.md): Sons Mustang II · Lancaster, CA · Accident · 2 fatal · Final report · Jan 22, 1982 · N13JL · Destroyed
  > The purpose of the flight was to demonstrate the aircraft to a prospective buyer. About 20 to 30 minutes after takeoff, witnesses observed the aircraft in a circling descent. At 500 to 700 ft AGL, the descent angle suddenly increased to nearly vertical and…
- [NTSB ANC82FAG14](https://openairdocs.org/ntsb/ANC82FAG14.md): Cessna 180 · Skwenta, AK · Accident · 3 fatal · Final report · Jan 2, 1982 · N7641A · Destroyed
  > The aircraft departed finger lake at approximately 1000 ast for a short ice fishing trip to fish lakes. The aircraft never returned and a search was started. The wreckage was located near the kahiltna river about 5 miles from the intended destination on…
- [NTSB CHI82DAMS1](https://openairdocs.org/ntsb/CHI82DAMS1.md): Cessna 182A · Missing Aircraft · Accident · 3 fatal · Closed · Dec 4, 1981 · N5173D · Destroyed
- [NTSB LAX82DUJ08](https://openairdocs.org/ntsb/LAX82DUJ08.md): Piper PA-28 · Mesa, CA · Accident · No injuries · Closed · Nov 15, 1981 · N8089R · Destroyed
- [NTSB ATL82DKJ03](https://openairdocs.org/ntsb/ATL82DKJ03.md): Cessna T210N · Bayou La Batre, AL · Accident · No injuries · Closed · Nov 8, 1981 · N6335C · Destroyed
- [NTSB NYC82FHJ03](https://openairdocs.org/ntsb/NYC82FHJ03.md): Piper PA-30 · East Moriches, NY · Accident · No injuries · Closed · Nov 5, 1981 · N755RY · Destroyed
- [NTSB MIA82DKA03](https://openairdocs.org/ntsb/MIA82DKA03.md): Aero Comdr 520 · Cabo Rojo, PR · Accident · No injuries · Closed · Oct 23, 1981 · N4162B · Substantial damage
- [NTSB ANC82DA005](https://openairdocs.org/ntsb/ANC82DA005.md): Cessna 170B · Missing Aircraft · Accident · 1 fatal · Closed · Oct 22, 1981 · N4640C · Destroyed
- [NTSB MIA82DLD03](https://openairdocs.org/ntsb/MIA82DLD03.md): Beech D50 · Vero Beach, FL · Accident · No injuries · Closed · Oct 19, 1981 · N8WQ · Destroyed
- [NTSB MIA82FA003](https://openairdocs.org/ntsb/MIA82FA003.md): Cessna 172 · Ft.Lauderdale, FL · Accident · 3 fatal · Closed · Oct 10, 1981 · N2260E · Destroyed
- [NTSB ANC82FA002](https://openairdocs.org/ntsb/ANC82FA002.md): Piper PA-12 · Valouga Lake, AK · Accident · 2 fatal · Closed · Oct 9, 1981 · N3953M · Substantial damage
- [NTSB ANC81DA113](https://openairdocs.org/ntsb/ANC81DA113.md): Cessna 180H · Missing Aircraft · Accident · 4 fatal · Closed · Sep 2, 1981 · N3498Y · Destroyed
- [NTSB ANC81DA107](https://openairdocs.org/ntsb/ANC81DA107.md): Mooney 20 · Missing Aircraft · Accident · 1 fatal · Closed · Aug 28, 1981 · N9409V · Destroyed
- [NTSB ANC81DA102](https://openairdocs.org/ntsb/ANC81DA102.md): Cessna 185 · Wales, AK · Accident · 2 fatal · Closed · Aug 25, 1981 · N8626Q · Destroyed
- [NTSB ANC81FA101](https://openairdocs.org/ntsb/ANC81FA101.md): Cessna 180H · Missing Aircraft · Accident · 4 fatal · Closed · Aug 17, 1981 · N3424Y · Destroyed
- [NTSB MIA82FA025](https://openairdocs.org/ntsb/MIA82FA025.md): Piper PA-23 · Bunnell, FL · Accident · 2 fatal · Closed · Aug 8, 1981 · N14185 · Destroyed

Next page: https://openairdocs.org/ntsb-phases/990/cases.md?page=29

## 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 = 990)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

---
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.
