# 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 5 of 5 · 212 cases ## Cases, newest first - [NTSB FTW83LA156](https://openairdocs.org/ntsb/FTW83LA156.md): Piper PA-22-150 · Ramon, NM · Accident · No injuries · Limited investigation · Final report · Mar 15, 1983 · N1841P · Substantial damage > The flt departed Oklahoma city, ok with en route stops planned at amarillo, TX tucumcari, NM. At tucumcari, the occupants found themselves 'staggering a little' & concluded this was from exposure to hi alt (en route 6500 ft, tucumcari, 4065 ft). After… - [NTSB LAX83LA046](https://openairdocs.org/ntsb/LAX83LA046.md): Beech G35 · Fair Oaks, CA · Accident · No injuries · Limited investigation · Final report · Dec 18, 1982 · N218B · Substantial damage > During takeoff, the engine lost power at about 50 ft AGL after the pilot had raised the gear. Reportedly, there was insufficient time to extend the gear, so a wheels-up landing was made on the remaining portion of the runway. An investigation revealed that a… - [NTSB SEA82DA164](https://openairdocs.org/ntsb/SEA82DA164.md): Hiller-Soloy UH-12E · Spirit Lake, WA · Accident · No injuries · Final report · Sep 15, 1982 · N513HA · Substantial damage > Pilot performed autorotation from 2000 feet to check RPM. At 200-300 feet when collective was added power loss occurred. Aircraft landed hard and severed tail boom. Logging support operations. - [NTSB DEN82IA192](https://openairdocs.org/ntsb/DEN82IA192.md): Fairchild/Swearingen SA226TC · Denver, CO · Incident · No injuries · Incident investigation · Final report · Sep 13, 1982 · N5471M · Minor damage > During takeoff on a maintenance ferry flight, with a mechanic flying from the right seat, the aircraft would not accelerate above V1 and would not rotate even with full aft yoke. The captain aborted the takeoff and the aircraft was stopped at the end of the… - [NTSB CHI82FA290](https://openairdocs.org/ntsb/CHI82FA290.md): Starduster II · Oshkosh, WI · Accident · 3 fatal · Field investigation · Final report · Aug 3, 1982 · N9JR · 2 aircraft · Destroyed > Both acft were operating in the fly-by (no radio) pattern during the annual eaa convention. According to participant records both plts had received fly-by pattern briefings. Both acft were observed to be in the southern most portion of the upwind leg of the… - [NTSB DEN82FTC07](https://openairdocs.org/ntsb/DEN82FTC07.md): Piper 18 · Labarge, WY · Accident · 2 fatal · Final report · Jul 21, 1982 · N83503 · Destroyed > The aircraft was on a power line patrol mission. The rear seat occupant was acting as an observer. He was also along to assist the company in route familiarization of the pilot, but was assigned no other official crewmember duties. The accident occurred while… - [NTSB CHI82FA236](https://openairdocs.org/ntsb/CHI82FA236.md): Cessna 152 · Morenci, MI · Accident · 2 fatal · Field investigation · Final report · Jul 5, 1982 · N4698L · Destroyed > The flt departed the toledo surburban arpt at 1800 for a local instructional flt. One witness described the acft as flying very erratically. It was dipping from side to side & gaining & losing altitude very rapidly. He next observed the plane climb straight… - [NTSB LAX82DA185](https://openairdocs.org/ntsb/LAX82DA185.md): Rockwell 112TC · Fort Apache, AZ · Accident · 2 fatal · Final report · May 20, 1982 · N4567W · Destroyed > The aircraft was observed to fly between two parked campers in a left wing low attitude before hitting a pine tree. The aircraft then went into an inverted position before contacting the ground about 300 yards from the campers. Investigation revealed that the… - [NTSB ANC82DA023](https://openairdocs.org/ntsb/ANC82DA023.md): Piper PA-18 · Near Gulkana, AK · Accident · No injuries · Final report · Mar 2, 1982 · N8293C · Substantial damage > The pilot stated that he arrived at crosswinds lake, made a low pass and attempted to contact the wheels on the snow to determine if a landing was possible. The wheels broke through the crust on the snow and the aircraft flipped over. - [NTSB MIA82DA056](https://openairdocs.org/ntsb/MIA82DA056.md): Cessna 210A · Florida City, FL · Accident · No injuries · Final report · Feb 22, 1982 · N7335E · Substantial damage > The aircraft was found inverted in 5 feet of water. Only one seat was installed and an auxiliary fuel pump was inside the aircraft. It appeared that the aircraft landed on the adjacent canal bank and then purposely run into the water. Police suspect a drug… - [NTSB LAX82FXQ04](https://openairdocs.org/ntsb/LAX82FXQ04.md): Bell 214B-1 · Quincy, CA · Accident · 1 fatal · Final report · Feb 14, 1982 · N2240H · Destroyed > The pilot was moving logs during an external load operation in a mountainous, burned out, wooded area. The elevation was about 4500 ft. logging crews observed the helicopter approach the "log landing area" while hauling a load of logs with a 160 ft cable.… - [NTSB LAX82FUJ24](https://openairdocs.org/ntsb/LAX82FUJ24.md): Cessna 182P · Sunflower, AZ · Accident · Minor injuries · Final report · Jan 17, 1982 · N7383S · Destroyed > The pilot reported that he had throttled back below cruise power to survey one of his business locations. Reportedly, he moved the throttle forward to climb, but was unable to get full power. He stated that he gradually lost power and airspeed, and… ## 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=5 --- 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.