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 SEA88FA131Accident · 1 fatalField investigationFinal reportApplebay Zuni 2 · Wellington, NVThe plt (with only 13 hrs flt time in the hi performance sailplane) took off at 1330 PDT. Psn rprts with her gnd crew were normal until 1630, then another plt offered to relay messages. After ctcg her gnd crew, the otr plt tried calling her back at aprx 1645,…Jul 16, 1988 · N14XZ · DestroyedNTSB CHI88FA160Accident · 1 fatalField investigationFinal reportCessna 172N · Middletown, INAttempted operation of the accident airplane by the PIC when he was under the influence of alcohol.Jul 7, 1988 · N6187D · DestroyedNTSB CHI88FA153Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Hamm Lake, MNLoss of control in flight, either by the student or by the instructor, at an altitude insufficient to allow for a recovery, by the flight instructor, before the resulting out of control descent caused the accident airplane to strike the terrain.Jul 3, 1988 · N2485N · DestroyedNTSB ANC88LA152Accident · 1 fatalLimited investigationFinal reportChampion 7AC · Coldfoot, AKUndetermined.Jun 11, 1988 · N81725 · DestroyedNTSB ATL89FAMS2Accident · 1 fatalMissing aircraftFinal reportPiper PA-28-140 · MissingThe airplane and pilot reportedly departed moncks corner, SC sometime between 1900 and 2000 EDT on 4/17/88. The airplane was subsequently reported Missing, and search efforts were conducted between 4/20/88 and 4/29/88. Aircraft damage and injury index are…Apr 17, 1988 · N98070 · DestroyedNTSB CHI88FA080Accident · 1 fatalField investigationFinal reportCessna 310Q · Servia, INThe pilot induced overload to the airplane structure causing material failure of the airplane. Attempted flight into adverse weather, and spatial disorientation of the pilot, are contributing factors in this accident.Mar 24, 1988 · N7797Q · DestroyedNTSB ATL88IA117Incident · No injuriesIncident investigationFinal reportAero Commander 680E · New York, NYThe airplane had been given a daily insp on 03-10-88 with no structural damage noted. During the next daily inspection on 03-14-88, skin buckling was noted on both wings. Three different pilots had flown the airplane between inspections and all indicated that…Mar 14, 1988 · N50 · Minor damageNTSB MIA88LA104Accident · 2 fatalLimited investigationFinal reportBeech 65-88Undetermined.Feb 7, 1988 · N884G · DestroyedNTSB CHI88FAMS1Accident · 4 fatalMissing aircraftFinal reportCessna 172N · Warsaw, INAircraft departed during the hours of darkness and was declared missing after failing to arrive at its stated destination. The proposed route of flight crossed a large body water and a local lakeshore resident reported hearing an airplane strike the water. No…Jan 8, 1988 · N4878G · DestroyedNTSB CHI88DEX01Accident · 1 fatalFinal reportPiper PA-24-250 · Salem, INN6478P crashed during a forced landing near the Salem, IN, airport. The aircraft had experienced an engine failure due to failure of the number 5 connecting rod cap bolt. The aircraft struck a tree during the approach and crashed 100 yards north of the runway.Jan 5, 1988 · N6487P · DestroyedNTSB LAX88DUM02Accident · 1 fatalFinal reportBede BD-5 · Chula Vista, CADec 24, 1987 · N29DT · DestroyedNTSB MIA88LA073Accident · 1 fatalLimited investigationFinal reportCessna 152 · MissingAccording to the operator the acft departed san juan, PR on a cross country flight to la romana. The acft arrived there & dropped the student off & the plt departed at about 1400 ast on his return trip to san juan. The acft did not arrive at it's destination…Dec 21, 1987 · N757EQ · DestroyedNTSB DEN88FA036Accident · 1 fatalField investigationFinal reportCessna A152 · Benson, AZAbt 20 min after tkof, the acft crashed in VMC conds, aprx 26 mi along the route fm tucson to las cruces. Initial impactoccurred with the l wing hitting the top of a yucca plant as the acft was in a slgt nose down, l wing low attitude. Justbyd this point, the…Dec 8, 1987 · N234ZN · DestroyedNTSB BFO88FA003Accident · 1 fatalField investigationFinal reportCessna 172H · Indian Head, MDThe non-certificated plt took the acft without proper authority. A note was found in his automobile that showed he intended to commit suicide. A revolver was found at the crash scene with a spent cartridge under the hammer. Postmortem studies showed the pilot…Oct 16, 1987 · N9WB · DestroyedNTSB ANC87LA139Accident · No injuriesLimited investigationFinal reportCessna 185F · Wasilla, AKThe pilot stated that after rollout on the grass runway, he lost directional control causing the plane to ground loop. Exmination of the tailwheel revealed that the tire was flat prior to the landing.Sep 6, 1987 · N93018 · Substantial damageNTSB LAX87FAMS4Accident · 1 fatalMissing aircraftFinal reportCessna 172P · Missing Acft, CAThe pilot told family and friends that he was going to fly along the coast and return at night. He did not return. The civil air patrol searched for the aircraft and pilot for several days without success. The flight originated at van nuys airport, van nuys,…Aug 30, 1987 · N65797 · DestroyedNTSB LAX87LA334Accident · 1 fatalLimited investigationFinal reportCessna 206 · Williams, AZThe aircraft was reported stolen on July 26, 1987. It is believed that the aircraft departed the grand canyon airport in grand canyon, Arizona on July 26, 1987, at 0300 MST. A search of records or airports in the area revealed that the aircraft was refueled…Jul 26, 1987 · N4651Z · DestroyedNTSB CHI87DEC03Accident · Serious injuriesFinal reportNavion G · Erie, MIWith the landing gear extended, the aircraft impacted with trees in a near inverted attitude and was destroyed. The pilot, who was the sole occupant was seriously injured. There were no witnesses to the accident and the pilot could not remember the events…Jun 23, 1987 · N2386T · DestroyedNTSB ATL87FA173Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B · Coral Springs, FLThe pilot reported to ground personnel at fort lauderdale that he was experiencing an avionics problem and the passengerentry door was sprung the day before when it was slammed; however, the pilot elected to depart. The aircraft wreckage was located on June…Jun 18, 1987 · N184MA · DestroyedNTSB NYC87FA160Accident · 2 fatalField investigationFinal reportRobinson R22 Mariner · So. Windsor, CTA loss of control in flight for undetermined reasons.Jun 3, 1987 · N2287L · DestroyedNTSB MIA87IA166Incident · No injuriesIncident investigationFinal reportBoeing 747-245F · Caracas, VenezuelaFlight experienced leakage of a five gallon container of glutaraldehyde listed by the shipper as a class 8 corrosive on the aircrafts upper deck enroute miami, Florida to Caracas, venezuela. The chemical was later found not to be corrosive and the aircraft…May 29, 1987 · N813FT · Minor damageNTSB MIA87LA164Accident · 1 fatalLimited investigationFinal reportCessna 402C · Missing Acft, BahamasOn 5/27/87 at about 0915 EDT, the plt departed palm beach intl arpt (pbi) on a flt to marsh harbour, great abaco island, Bahamas. When the Acft did not arrive at the destination, a search was initiated. The Acft was not fnd & was presumed to have been…May 27, 1987 · N2652B · DestroyedNTSB SEA87FA098Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · North Las Vegas, NVA mechanic, who was not rated as a plt, took the acft without permission & elected to takeoff at ngt. A witness saw the acft dep at about 0250 PDT. Subsequently, it crashed aprx 3 mi ene of the arpt in an open undeveloped area. The time of the acdnt was not…May 20, 1987 · N22LV · DestroyedNTSB MIA87LA161Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Missing, FLThe acft failed to arrive at its destination on a flight from miami, FL to aruba, netherland antilles via andros is, great inagua & port au prince. According to a flt plan filed by the plt the acft carried enough fuel for 8 hours & 30 minutes of flt, along…May 14, 1987 · N640CC · DestroyedNTSB CHI87FA124Accident · 1 fatalField investigationFinal reportCessna 152 · Ina, ILBefore the flt, the plt stated his intentions were to practice ngt lndgs. He took off at 2010 CDT with an estd 1.5 hrs of fuel on board. When the acft did not return, a search was initiated. Subsequently, it was fnd by fishermen, submergedin a lake…May 6, 1987 · N25991 · DestroyedNTSB MKC87LA080Accident · No injuriesLimited investigationFinal reportFairchild SA-227 · Springfield, MOOn April 6, 1987 a crew operating a metro iii, commuter acft noticed damage on both eng nacelles during a preflt insp. The commuter operator chief pilot was notified and an on site insp was made. The crew originally rptng the damage claimed they were not at…Apr 7, 1987 · N26863 · Substantial damageNTSB ATL87IA083Incident · No injuriesIncident investigationFinal reportSaab-Fairchild SF340A · Covington, KYAfter a hydraulic sys malfunction, the capt returned to arpt to exchange acft. Company plt had completed day of flying and was asked to taxi acft to maint hangar. Departing capt was in process of manually pumping hyd sys to sufficient pressure to ensure…Mar 10, 1987 · N341CA · Minor damageNTSB LAX87DUG02Accident · 1 fatalFinal reportPrue Standard Unknown · Hemet, CADuring a local soaring flight, the acft was seen by a witness to be in a vertical dive and appeared to be intact when it impacted the terrain. Inspection of the aircraft revealed no control system malfunctions. The plts flt time was 38 hrs as of 2/5/85 the…Mar 8, 1987 · N9726Z · DestroyedNTSB MIA87LA097Accident · No injuriesLimited investigationFinal reportBeech B-65 · Key Largo, FLThe aircraft was found crashed in shallow water near Key Largo FL. Attempts to locate the pilot or current operator were fruitless. The circumstances surrounding the crash and the cause are unknown.Mar 3, 1987 · N822Q · DestroyedNTSB LAX87FAMS2Accident · 2 fatalMissing aircraftFinal reportPiper PA-44-180T · Missing Acft (Pacific Ocean)The instructor plt (CFI) & the single-eng, pvt plt (owner) were on a flt to conduct multi-eng training for the new owner. Drg the flt, the crew contacted los angeles TRACON & requested a VOR apch to the santa monica arpt & said they would not be able to maint…Feb 25, 1987 · N8307H · DestroyedNTSB CHI87FA083Accident · 4 fatalField investigationFinal reportCessna 172N · Fergus Falls, MNFollowing a 1.5 hour personal flight at night, the aircraft crashed into the side of a low hill near the destination airport. Although the pilot had a total of 6 hours of night time, most of his solo night time was during this last flight. Hazy VFR conditions…Feb 12, 1987 · N734MV · DestroyedNTSB MKC87LA046Accident · No injuriesLimited investigationFinal reportCessna 150M · Kansas City, MOThe student plt rptd colliding with a parked fuel truck during taxi on 1/24/87. Inspection of the acft revealed only minor leading edge skin damage to the rt wing. The acft was released for further trng flts. The acft operated for more than a wk with no one…Jan 24, 1987 · N671HA · Substantial damageNTSB SEA87FA062Accident · 2 fatalField investigationFinal reportCessna 150 · Ellensburg, WAThe two commercially certificated instrument rated flight instructors departed Ellensburg at approximately 1120 PST on a local flight. Both pilots had appointments at 1300 hours PST. VFR conditions prevailed in lower terrain near Ellensburg, however, a…Jan 8, 1987 · N704HM · DestroyedNTSB NYC87FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 310 · Hamburg, NYThe Cessna 310R departed the airport on a svfr departure. The pilot cancelled his clearance a few minutes later and reported in VFR conditions. The aircraft failed to arrive at its destination. Radar tracking showed the aircraft heading toward lake erie. The…Dec 31, 1986 · N5462J · DestroyedNTSB DEN87FA024Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Stugis, SDThe plt agreed to ferry the acft for another plt who was not IFR rated & who had been forced to land at kadoka on the previous evening due to low fuel & apchg darkness. IMC prevailed thru-out the area. The commercial/ifr rated plt did not obtain a wx briefing…Nov 29, 1986 · N2161B · DestroyedNTSB ATL87FA010Accident · 2 fatalField investigationFinal reportCessna 152 II · Pembroke, KYThe acft was observed shortly after departing the owner/operator's private landing strip. Witnesses rprtd hearing a sudden decrease in eng power, then a short time later, they heard the eng 'fire' or restart momentarily, but decrease in power again. The acft…Oct 22, 1986 · N5083L · DestroyedNTSB ANC86FA167Accident · 2 fatalField investigationFinal reportPiper PA-18 · Port Alsworth, AKUndetermined.Sep 13, 1986 · N9109D · DestroyedNTSB DEN86FAMS3Accident · 2 fatalMissing aircraftFinal reportMooney M20F · Cuba, NMThe acft departed a private airstrip in Cuba, NM, for the purpose of viewing real estate property before continuing to taos. State authorities were notified the following day when the plt failed to arrive at work. A search for the acft was conducted until…Sep 9, 1986 · N2688W · DestroyedNTSB ATL86FA235Accident · 2 fatalField investigationFinal reportPiper PA-18 · Wilton, MEWitnesses saw the acft go into a nose down attitude prior to crashing into a wooded area near the arpt. Rprtdly, the prop was turning, but no sound was heard from the eng. Subsequently, the acft impacted the gnd in a nose low, inverted attitude. No preimpact…Aug 30, 1986 · N4641H · DestroyedNTSB ATL86FLQ06Accident · 1 fatalFinal reportBernard Sonerai II · Trenton, KYWitnesses reported seeing the acft spin to ground impact with a section of the right wing hanging. Post accident exam revealed the outboard half (aprx 4 ft) of the right wing was bent aprx 120 degrees to the inside half of the right wing. Monnett experimental…Aug 5, 1986 · N325WB · DestroyedNTSB NYC86FHM04Accident · 1 fatalFinal reportWard Skybolt · Cranford, NJWitnesses heard the aircraft engine pop, sputter and then go silent. The aircraft was observed to continually lose altitude, then visual contact was lost due to the tree line. Post-accident wreckage examination disclosed no evidence of fuel on board the…Aug 4, 1986 · N2TW · DestroyedNTSB CHI86FA194Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Oshkosh, WIThe aircraft ran out of fuel after 3+41 hours of flight. The pilot stated that he was sure the tanks were full on takeoff. Flight planning and a documented conservative fuel burn rate indicated that the aircraft should have been able to remain airborne for at…Aug 2, 1986 · N5713P · Substantial damageNTSB LAX86FA307Accident · 1 fatalField investigationFinal reportCherry HP16 · Llano, CAThe glider pilot departed on a local flight and the wreckage of his glider was spotted a little over an hour later. There were no known witnesses to the accident which occurred in VFR daylight conditions.Jul 27, 1986 · N118PC · DestroyedNTSB SEA86FA145Accident · 2 fatalField investigationFinal reportGrumman AA-5A · Round Mountain, NVThe pilot and passenger departed on a local flight to spot potential fishing locations in mountainous terrain. High density altitude conditions existed at the time/place of the accident. Kinematics information from the accident site indicates that as the…Jun 11, 1986 · N9761U · DestroyedNTSB NYC86FA140Accident · 2 fatalField investigationFinal reportAeronca 7AC · Chaumont, NYThe pilot departed his private strip and crashed about 5 minutes later in a steep nose down attitude. Over 50 per cent of the fluid in the carburetor was a contaminant.Jun 5, 1986 · N82079 · DestroyedNTSB MIA86FA148Accident · Serious injuriesField investigationFinal reportCessna 150H · Vero Beach, FLThe CFI & student plt were on a training flt. Witnesses heard the eng sputter, then cut out completely. One witness said he thought the plt would attempt a landing to the south, lengthwise, into a pasture bordered on all sides by trees aprx 50 ft high. The…May 5, 1986 · N6989S · DestroyedNTSB MIA86LA109Accident · 6 fatalLimited investigationFinal reportPiper PA-31-350 · Atlantic Ocean (Atlantic Ocean)The acft failed to arrive at it's destination on a VFR flight from miami FL, to west end, Bahamas. The acft's last reported position was 10 miles west of west end. There was no further contact with the acft. U.S. Coast guard initiated search on March 26, 1986…Mar 26, 1986 · N3527E · DestroyedNTSB LAX86LAMS1Accident · 1 fatalFinal reportCessna U206C · Maunaloa, HIWhile on an inter-island cargo flight conducted under 14 CFR 135, the pilot reported to the honolulu ARTCC that the airplane was experiencing a loss of propeller RPM; he did not report that the engine was losing power. The airplane crashed into the pacific…Mar 21, 1986 · N144FP · DestroyedNTSB LAX86FVM03Accident · No injuriesFinal reportBeech 65-A80 · Cuyama, CAThe acft contacted two cows while operating along the side of a road in a remote area. Vehicle tracks were found near the wreckage, however, no persons were found at or near the wreckage. Trained drug sniffing dogs were used at the accident site and it is…Mar 21, 1986 · N29DS · Substantial damageNTSB ANC86FA032Accident · 1 fatalField investigationFinal reportCessna 206 · Anchorage, AKThe pilot was using the aircraft to commute on a weekly basis between his residence in Anchorage and to the king salmon area. The pilot received several preflight and inflight weather briefings. During the briefings the flight service station stated that VFR…Feb 24, 1986 · N8022Z · Destroyed