OpenAirDocs.org

NTSB investigations

1,978 cases where the phase of flight was Unknown.

Cases, newest first

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 c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 990)
  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 LAX83LA016Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Sun City, CAThe 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…Oct 20, 1982 · N4729P · Substantial damageNTSB DEN83FA008Accident · 2 fatalField investigationFinal reportLuscombe T-8F · Choteau, MTThe 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…Oct 14, 1982 · N2231B · Substantial damageNTSB MIA83LA012Accident · 2 fatalLimited investigationFinal reportPiper PA-32-300 · Near St. CroixThe 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…Oct 13, 1982 · N77QT · DestroyedNTSB ATL83FKW01Accident · 2 fatalFinal reportCessna 172P · Gallatin, TNCessna 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.Oct 9, 1982 · N5313K · DestroyedNTSB MIA83LA009Accident · 2 fatalLimited investigationFinal reportBeech H35 · Missing Acft (Atlantic Ocean)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…Sep 28, 1982 · N5999 · Substantial damageNTSB LAX82DA359Accident · 1 fatalFinal reportPiper PA-18 · Casa Grande, AZStudent 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.Sep 27, 1982 · N1851A · DestroyedNTSB CHI82FA342Accident · 1 fatalField investigationFinal reportBeech H35 · Beaver Dam, WIAt 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,…Sep 16, 1982 · N4676D · DestroyedNTSB ANC82DAG59Accident · 3 fatalFinal reportCessna 180 · Missing Acft, AKAircraft 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.Sep 7, 1982 · N2194Z · DestroyedNTSB LAX82DA327Accident · Minor injuriesFinal reportCessna 172H · Daggett, CAThe 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.Sep 1, 1982 · N2584L · Substantial damageNTSB ATL83FA186Accident · 1 fatalField investigationFinal reportPiper PA-18 · Ft. Pickett, VAThe 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.…Aug 21, 1982 · N90910 · DestroyedNTSB DEN82DA168Accident · No injuriesFinal reportCessna 150 · Weldona, COThe 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.Aug 20, 1982 · N684CF · Substantial damageNTSB FTW82FPA16Accident · 2 fatalFinal reportBellanca 7ECA · Plano, TXDuring 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…Aug 19, 1982 · N10984 · DestroyedNTSB LAX82FUM11Accident · 2 fatalFinal reportCessna 172N · San Clemente, CAAircraft 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.Aug 18, 1982 · N739UY · DestroyedNTSB LAX82DA299Accident · No injuriesFinal reportLake LA-4 · Lake Tahoe, CAThis 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…Aug 14, 1982 · N1104L · DestroyedNTSB DEN82DA152Accident · No injuriesFinal reportCessna 172N · Lander, WYThe 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…Aug 3, 1982 · N6476G · Substantial damageNTSB LAX82FA261Accident · No injuriesField investigationFinal reportCessna 150M · Lake Isabella, CAAfter 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.…Jul 17, 1982 · N704GL · Substantial damageNTSB ATL82DA203Accident · No injuriesFinal reportAmerican AA-1 · Covington, TNPrior 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…Jul 17, 1982 · N5715L · Substantial damageNTSB NYC83FA083Accident · 1 fatalField investigationFinal reportGrumman AA-1 · Missing Acft, NYThe 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…Jul 12, 1982 · N5637L · DestroyedNTSB DEN82DA110Accident · No injuriesFinal reportPiper PA-32RT-300T · Durango, COThe 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…Jun 23, 1982 · N31912 · Substantial damageNTSB ANC82FAG32Accident · 1 fatalFinal reportPiper PA-18-150 · Chugiak, AKThe 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…Jun 13, 1982 · N2340S · Substantial damageNTSB LAX82FA218Accident · 4 fatalField investigationFinal reportCessna 150L · Corona, CABoth 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…Jun 12, 1982 · N18007 · 2 aircraft · DestroyedNTSB LAX82DAMS1Accident · 2 fatalFinal reportWing D-1 · Catalina Island, CAThe 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…Jun 11, 1982 · N8601M · DestroyedNTSB FTW82FPG14Accident · 2 fatalFinal reportAeronca 7AC · Lehi, ARThe 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…Jun 7, 1982 · N83654 · Substantial damageNTSB LAX82FVD17Accident · 1 fatalFinal reportSavage Skybolt · Livermore, CAAfter 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…Jun 5, 1982 · N1914S · DestroyedNTSB FTW82FRA21Accident · 1 fatalFinal reportPiper PA-32 · Houston, TXThe 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.Jun 5, 1982 · N36497 · Substantial damageNTSB FTW82FPD11Accident · 1 fatalFinal reportCessna 152 · Carswell, TXAn 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…May 1, 1982 · N4889H · Substantial damageNTSB FTW82DA163Accident · No injuriesFinal reportCessna TU-206A · Rachal, TXThe 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…May 1, 1982 · N4955F · Substantial damageNTSB LAX82FVD13Accident · 3 fatalFinal reportBeech A36TC · Hearst, CAAbout 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…Apr 22, 1982 · N667WT · DestroyedNTSB FTW82FA108Accident · 1 fatalField investigationFinal reportGulfstream American 690C · Hughes, ARThe 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…Mar 29, 1982 · N5957K · DestroyedNTSB ATL82FA066Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · Bradley, SCBefore 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…Feb 28, 1982 · N38540 · DestroyedNTSB DEN82DA036Accident · Minor injuriesFinal reportPiper PA-18 · Plentywood, MTOn 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…Feb 14, 1982 · N4380Z · Substantial damageNTSB MIA82FLD15Accident · Serious injuriesFinal reportPiper PA-31 · Ft. Pierce, FLThe 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…Feb 7, 1982 · N747CE · DestroyedNTSB FTW82FRD08Accident · 2 fatalFinal reportCessna 150G · Jeanerette, LAAccording 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.…Feb 2, 1982 · N3166J · DestroyedNTSB LAX82FA049Accident · 2 fatalField investigationFinal reportMooney M20C · Victorville, CAThe 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…Jan 23, 1982 · N7860V · 2 aircraft · DestroyedNTSB LAX82FUQ09Accident · 2 fatalFinal reportSons Mustang II · Lancaster, CAThe 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…Jan 22, 1982 · N13JL · DestroyedNTSB ANC82FAG14Accident · 3 fatalFinal reportCessna 180 · Skwenta, AKThe 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…Jan 2, 1982 · N7641A · DestroyedNTSB CHI82DAMS1Accident · 3 fatalClosedCessna 182A · Missing AircraftDec 4, 1981 · N5173D · DestroyedNTSB LAX82DUJ08Accident · No injuriesClosedPiper PA-28 · Mesa, CANov 15, 1981 · N8089R · DestroyedNTSB ATL82DKJ03Accident · No injuriesClosedCessna T210N · Bayou La Batre, ALNov 8, 1981 · N6335C · DestroyedNTSB NYC82FHJ03Accident · No injuriesClosedPiper PA-30 · East Moriches, NYNov 5, 1981 · N755RY · DestroyedNTSB MIA82DKA03Accident · No injuriesClosedAero Comdr 520 · Cabo Rojo, PROct 23, 1981 · N4162B · Substantial damageNTSB ANC82DA005Accident · 1 fatalClosedCessna 170B · Missing AircraftOct 22, 1981 · N4640C · DestroyedNTSB MIA82DLD03Accident · No injuriesClosedBeech D50 · Vero Beach, FLOct 19, 1981 · N8WQ · DestroyedNTSB MIA82FA003Accident · 3 fatalClosedCessna 172 · Ft.Lauderdale, FLOct 10, 1981 · N2260E · DestroyedNTSB ANC82FA002Accident · 2 fatalClosedPiper PA-12 · Valouga Lake, AKOct 9, 1981 · N3953M · Substantial damageNTSB ANC81DA113Accident · 4 fatalClosedCessna 180H · Missing AircraftSep 2, 1981 · N3498Y · DestroyedNTSB ANC81DA107Accident · 1 fatalClosedMooney 20 · Missing AircraftAug 28, 1981 · N9409V · DestroyedNTSB ANC81DA102Accident · 2 fatalClosedCessna 185 · Wales, AKAug 25, 1981 · N8626Q · DestroyedNTSB ANC81FA101Accident · 4 fatalClosedCessna 180H · Missing AircraftAug 17, 1981 · N3424Y · DestroyedNTSB MIA82FA025Accident · 2 fatalClosedPiper PA-23 · Bunnell, FLAug 8, 1981 · N14185 · Destroyed