OpenAirDocs.org

NTSB investigations

2,085 cases where the phase of flight was Standing.

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 = 150)
  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 LAX87DUJ05Accident · No injuriesFinal reportHiller UH-12E · Tolleson, AZThe plt stated that he landed the acft on a platform on top of a chemical tank truck. The truck was parked on a slight slope with its left side six inches lower than the right. The plt reduced power to idle and the loader began to load the helicopter with…May 19, 1987 · N4034T · DestroyedNTSB ATL87LA143Accident · 1 fatalLimited investigationFinal reportBeech B100 · Birmingham, ALThe lineman walked into the prop arc of the operating rt engine and was fatally injured after disconnecting a ground power unit (gpu) cable from the rt engine nacelle. The lineman initially approached the nacelle from the rear, but walked forward into the…May 19, 1987 · N753D · Minor damageNTSB NYC87LA151Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Jeanette, PAThe plt put small chocks under the wheels, then began to hand prop the eng with no one at the controls. The eng started, & before the plt could reach the cockpit, the acft made svrl 360 deg turns & subsequently rolled into trees.May 17, 1987 · N3886E · Substantial damageNTSB SEA87LA090Accident · Minor injuriesLimited investigationFinal reportRutan VARI-EZE · Renton, WAWhile being hand propped the aircraft began to move. The pilot then attempted to climb inside the aircraft but the canopy had closed. The pilot held onto the aircraft and was dragged across the end of the runway. The aircraft struck a parked, unoccupied…May 8, 1987 · N29Z · Substantial damageNTSB FTW87FA116Accident · No injuriesField investigationFinal reportBeech V35-B · Terrell, TXWhile attempting to start the aircraft the starter solenoid wiring caught fire. The heat from the fire caused an overstressed brake line to fall, allowing brake fluid to drain onto the lip of the nose gear door. The fire then burned through the floor of the…May 8, 1987 · N1861W · DestroyedNTSB NYC87LA168Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Sanford, METhe acft was being hand propped from behind the prop on the rgt side when the eng started. The plane jumped the chock, knocked the plt to the ground, turned to the rgt & collided with a parked acft in the tie-down area. The acft was not tied down & only the…Apr 22, 1987 · N58032 · Substantial damageNTSB LAX87LA185Accident · Minor injuriesLimited investigationFinal reportCessna P210N II · Tucson, AZA C-172 collided with a C-210N while txg. The C-172 was txg along a 75 ft wide parallel twy after landing. The C-210N was txg from a ramp area to his dep rwy. The C-210N route intersected the C-172 route at the parallel twy where the collision occurred. Plts…Apr 20, 1987 · N6509P · 2 aircraft · Minor damageNTSB LAX87LA171Accident · No injuriesLimited investigationFinal reportMooney M20J · Fullerton, CAWhile holding short of the runway behind a Cessna 182R, the pilot of a Mooney M20J, reached over to tighten his four year old sons seatbelt. The pilots foot came off the toe brake and the aircraft rolled forward and collided with the Cessna.Apr 4, 1987 · N5690N · 2 aircraft · Minor damageNTSB CHI87IA110Incident · 1 fatalIncident investigationFinal reportCessna 172L · Plainfield, ILThe pilot decided the weather was not good enough to fly, but he would run the engine and turn the tires. He was discovered in the plane by other pilots and later pronounced dead, from carbon monoxide asphyxiation. The muffler had a 12 inch crack which a…Mar 29, 1987 · N4211Q · No damageNTSB ANC87LA042Accident · No injuriesLimited investigationFinal reportCessna 185F · Anchorage, AKThe pilot was unable to start his airplane due to a weak battery and elected to start the unsecured acft's engine by hand-propping. The engine started and the airplane accelerated away from its tie-down area and into a building before the pilot could reenter…Mar 1, 1987 · N2449J · Substantial damageNTSB NYC87LA090Accident · No injuriesLimited investigationFinal reportCessna 150C · Manville, NJAfter making a rest stop, the plt attempted to restart the eng, using a normal start procedure, but the starter would not engage. He tried to turn off the ignition switch, but said that 'possibly due to the fact that I was wearing heavy gloves, I failed to…Feb 17, 1987 · N63218 · Substantial damageNTSB CHI87FA081Accident · Serious injuriesField investigationFinal reportBoeing 747-122 · Detroit, MIDrg flt, united flt 108 recd info of a bomb threat. Due to a short time limit, specified in the threat, the flt divertedto Detroit & the slides were used to evacuate the acft; 8 of 10 slides deployed nmly & were used. The slide at door 4R didn't inflate &…Feb 12, 1987 · N4718U · No damageNTSB LAX87LA111Accident · Serious injuriesLimited investigationFinal reportCessna T210L · El Cajon, CAThe plt indicated that he and his wife were planning to fly together, but at the last minute his wife changed her mind. She exited the acft and departed the area to the rear of the plane. The plt was taxiing from his parking spot when his wife suddenly…Feb 8, 1987 · N5275V · No damageNTSB CHI87DEE04Accident · 1 fatalFinal reportCessna 172 · Plainfield, ILWhile taxiing for takeoff, the aircraft became stuck in a snowbank. The pilot and passenger got out of the aircraft to free it. The passenger walked into the propeller of the running engine and received fatal injuries.Feb 2, 1987 · N2968U · No damageNTSB CHI87DER02Accident · Serious injuriesFinal reportCessna 150M · Lakeville, MNThe student & instructor (CFI) were preflighting the acft to fly on a cold morning. To facilitate better eng starting, the CFI elected to turn the prop while the student 'pushed the primer in.' He told the student to check that the mag & master sws were off &…Jan 31, 1987 · N714QW · Minor damageNTSB CHI87DEP01Accident · Minor injuriesFinal reportChampion 7ECA · La Crosse, WIAfter the third try at an engine start the eng started and ran at full throttle. The plt could not reduce RPM. To avoid striking two parked acft the plt struck a hangar. Post accident investigation revealed that the throttle cable was not operating properly.…Jan 18, 1987 · N9999Y · Substantial damageNTSB MIA87LA063Accident · Serious injuriesLimited investigationFinal reportFokker F28 MK4000 · West Palm Bch, FLDuring passenger boarding at tallahassee it was discovered that the left handrail on the airstair was collapsed. The failure was at the soldered joint at the handrail locking mechanism. The station manager used metal glue for a temporary repair of the joint.…Dec 30, 1986 · N510 · Minor damageNTSB NYC87LA041Accident · No injuriesLimited investigationFinal reportCessna 441 · Erie, PAReason for the Cessna to veer in a semi-circle and collide with another aircraft is undetermined. Examination of the start lock assemblies could not be completed due to the extensive impact and fire damage. The acft was being prepared for a flt. During a…Nov 30, 1986 · N117EA · Substantial damageNTSB SEA87LA030Accident · 1 fatalLimited investigationFinal reportCessna 180J · Juneau, AKThe passenger deplaned while the plt shut down the aircrafts engine. Although the plt noticed that the passenger was near the wing strut and attempted to yell at him, the passenger inadvertently walked into the wind milling propeller which struck him in the…Nov 24, 1986 · N9907N · No damageNTSB BFO87LA011Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Baltimore, MDThe acft traveled out of control after the plt hand-prop started the engine. The acft collided with a parked fuel trucks. There was no fire. The sole occupant in the acft was a non-pilot passenger.Nov 22, 1986 · N2733Q · Substantial damageNTSB CHI87LA033Accident · Serious injuriesLimited investigationFinal reportCessna 182F · Sandwich, ILThe pilot was attempting to hand prop the aircraft due to a low battery. The engine started and the plane began moving. The aircraft struck the pilot and then traveled into a hangar door.Nov 15, 1986 · N3289U · Minor damageNTSB NYC87LA032Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Philadelphia, PADuring hand propping, the aircraft began to move and rolled across a field crashing through a fence when fire erupted destroying the aircraft. The plt stated that after setting brakes to full pressure he atmptd to had prop acft. The eng started and while the…Nov 14, 1986 · N82089 · DestroyedNTSB LAX87LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · San Jose, CAThe acft went through a fence and collided with trees after a 'hand-propped' start. The student plt had exhausted the acft battery power during previous starting attempts. He then tied the acft down at both wings and the tail. He primed the eng with the…Nov 12, 1986 · N5153W · Substantial damageNTSB FTW87LA015Accident · Serious injuriesLimited investigationFinal reportHouk Pitts S1-S · La Porte, TXA mechanic was attempting to pull the prop through one revolution prior to starting the engine on a pitts S1-S. Due to a bad p-lead on the magneto's the engine fired, causing the prop to strike the right leg of the mechanic. The mechanics leg was amputated…Nov 9, 1986 · N35DH · No damageNTSB SEA87LA024Accident · No injuriesLimited investigationFinal reportCessna 182B · Bellingham, WADrg an attempted start, the eng backfired & an induction fire started. However, the plt did not continue cranking the eng. Strong surface winds inhibited the effectiveness of the acft's portable fire extinguisher. The plt then attempted to use an extinguisher…Nov 8, 1986 · N2654G · Substantial damageNTSB LAX87DUG01Accident · No injuriesFinal reportAero Commander 520 · Lucerne Valley, CADuring a pleasure flt, the plt reported that the right engine caught on fire. The plt made a landing on dry lake bed and disembarked from the plane examination of the wreckage revealed that the path of the landing roll showed no signs of melted metal or…Nov 2, 1986 · N70FM · DestroyedNTSB LAX87DJA01Accident · No injuriesFinal reportMurrayair MA-1 · Hilo, HIAfter returning from a spraying flt, the acft was refueled. After refueling, the plt used fuel to wash oil from the side of the acft & the wing step. When the eng was restarted about 2 min later, fuel fumes ignited & fire spread to the fuel truck. Both the…Oct 28, 1986 · N306MA · DestroyedNTSB CHI87LA007Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Lake Village, INThe plt stated that the acft would not start so he applied the acft hand brake and proceeded to hand prop the acft with no one aboard. While hand propping the acft, the engine fired and the hand brake did not hold. As the plt walked around the right wing, the…Oct 21, 1986 · N6997Q · Substantial damageNTSB LAX87LA020Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Pacoima, CAThe plt refueled the acft, but was unable to restart the eng by using the battery. He hand propped the eng which started immediately. The acft began to move unattended & the plt clung to the left wing strut, but relinquished his grip after the acft moved aprx…Oct 18, 1986 · N18737 · Substantial damageNTSB NYC87LA010Accident · Serious injuriesLimited investigationFinal reportLockheed L188A · Boston, MADuring engine start number 4 engine was started. The signal was given to the ground crewman to disconnect the air start unit. The engineer thought he heard 'start number 3'. Engine number 4 was shifted up, it stabilized, and engine number 3 was started. After…Oct 9, 1986 · N342HA · No damageNTSB SEA87IA003Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Seattle, WADuring attempt to apply ground power to acft, internal feeder cables shorted and melted down. Investigation revealed poor workmanship by contracted maintenance personnel in modification installation.Oct 5, 1986 · N1843U · Minor damageNTSB MKC86LA199Accident · No injuriesLimited investigationFinal reportBell 206A · Texarkana, ARThe pilot stated that the left front passenger raised the collective pitch control by mistake while trying to open the cabin door. According to the pilot, the rotor system was between 65-70 n 1 , and the throttle at flight idle. When the helicopter achieved…Sep 26, 1986 · N206DW · Substantial damageNTSB LAX86LA355Accident · No injuriesLimited investigationFinal reportAero Commander 112A · El Monte, CAThe pilot stated that the engine would not start so he secured the left wing and hand propped the engine. When the engine started, the aircraft began moving in a circular path to the left and collided with a parked aircraft.Sep 17, 1986 · N1455J · Substantial damageNTSB MKC86LA169Accident · No injuriesLimited investigationFinal reportDavid Gordon Whitman Tailwind · Valley Center, KSThe acft rolled forward unrestrained after the PIC had started the eng. The acft was not moored before the PIC attempted the hand start. The acft rolled a short distance where it impacted the edge of a building and sustained substantial damage. Multiple…Aug 11, 1986 · N3064 · Substantial damageNTSB DCA86IA037Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Chicago, ILA charter flt arrived & deplaned without incident & with no indication of smoke, fumes or heat. Company maint psnl had placed damaged passenger seatbacks (incorporating solid-state chemical oxygen generators) in the fwd cargo compartment with seat covers &…Aug 10, 1986 · N184AT · DestroyedNTSB MIA86LA219Accident · No injuriesLimited investigationFinal reportCessna 172M · Fort Myers, FLThe plt stated that his non-rated wife was onboard the acft while he was pulling the propeller through, priming the engine. While doing so, the engine started due to the mag switch being left on. The acft then taxied uncontrolled, colliding with a parked…Jul 26, 1986 · N13351 · Substantial damageNTSB SEA86LA176Accident · 1 fatalLimited investigationFinal reportBell 47G-3B1 · Burbank, WAThe helicopter had landed for reloading and was stationary with rotors idling. A ground loader person approached the helicopter over a small sandy knoll and was struck by the main rotor, sustaining fatal injury.Jul 23, 1986 · N1197W · Minor damageNTSB ATL86IA190Incident · Minor injuriesIncident investigationFinal reportSwearingen SA-26AT · Waycross, GAThe pax had received instructions by the plt on how to open the cabin door. The acft was shut down on the ramp and the pax attempted to open the cabin door. The latch was turned; the door began to fall open and the pax caught the door step channel at a hinge…Jul 4, 1986 · N20EF · No damageNTSB ATL86FEI07Accident · 1 fatalFinal reportBell 47G2 · Lisbon, OHThe aerial application helicopter was being serviced by a chemical truck that was parked adjacent to the acft. The acft engine was at high idle with the main rotor turning at 250 RPM. The ground crewman jumped off the side of the chemical truck into the main…Jun 26, 1986 · N984B · Minor damageNTSB ATL86LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · Pelion, SCThe private plt and student plt returned to the acft after pausing from landing practice for a soft drink. An engine start was attempted and a back fire occurred that started and induction fire. The intensity of the fire grew and the occupant exited the acft…Jun 14, 1986 · N30265 · DestroyedNTSB MIA86LA176Accident · No injuriesLimited investigationFinal reportCessna 411 · Tallahassee, FLThe plt observed a fuel spill on the ground as a result of refueling overflow. He attempted to start the engines & an explosion & fire resulted.Jun 11, 1986 · N4959T · Substantial damageNTSB LAX86LA227Accident · Minor injuriesLimited investigationFinal reportBellanca 7ACA · Lompoc, CAThe bellance champion went out of control an collided with two other parked acft after a hand propped start. The plt indicated that the acft was tied down with two chains attached to each of the wings at one end and to a cable that stretched across the ramp…May 21, 1986 · N9158L · Substantial damageNTSB DEN86LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTAcft carburetor had been removed for maintenance and sign posted in acft to this effect. Student plt called to schedule acft and was put in another acft. Scheduler said plt was told acft was out of service but plt claimed he did not hear this. Plt met flt…May 11, 1986 · N53345 · DestroyedNTSB FTW86IA078Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Dallas/Ftw Apt, TXThe crew stated that during an attempted start the no. 1 eng failed to gain ignition during the prescribed 25 sec limit and that they aborted the start. Shortly thereafter, grnd pers reported that the eng had developed a tail pipe fire. Following emerg…May 7, 1986 · N109AA · No damageNTSB MIA86LA147Accident · No injuriesLimited investigationFinal reportHughes 269C · Jacksonville, FLThe plt stated that as he was landing on a dolly, the helicopter experienced ground resonance & began to shake violently. It then rolled over on its side, causing the main rotor blades to strike the tail boom & the ground.May 4, 1986 · N8993F · Substantial damageNTSB FTW86FA066Accident · 2 fatalField investigationFinal reportGrumman G164A · Hankamer, TXTwo Grumman ag cats operated by the same air service collided in mid air. The accident occurred as one was departing and the other was returning to a temporary air strip adjacent to the fields they were fertilizing. Witnesses indicated that both pilot…Apr 15, 1986 · N8751H · 2 aircraft · DestroyedNTSB CHI86LA109Accident · No injuriesLimited investigationFinal reportCessna 152 · Wonder Lake, ILThe starter would not engage, so the plt tied down the tail & hand propped the acft to start the eng, but did not use chocks. After the eng started, the acft rolled forward, slipped loose from the rear tie-down & ran into a pile of i-beams. A post acdnt exam…Mar 21, 1986 · N49421 · Substantial damageNTSB FTW86LRA10Accident · Serious injuriesFinal reportCessna 150L · Houston, TXThe acft failed to start so the CFI got out to turn the prop. The mag switch was left on and the eng fired as the CFI moved the prop blade. The CFI was struck by the blade and serously injured.Mar 1, 1986 · N19271 · No damageNTSB CHI86LA093Accident · No injuriesLimited investigationFinal reportBeech C23 · Elkhart, INThe plt was unable to start the acft eng and got out to pull the prop through by hand. The magneto switch had been left in the both position and the eng started as the passenger primed the eng while the plt pulled the prop through. The plt was unable to stop…Feb 27, 1986 · N5150M · DestroyedNTSB MIA86IA072Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · New York, NYWhile on walk around inspection the flight crew noticed a burned through area on the number one engine outboard cowling. The engine was removed from service and disassembled and examined. The fan duct and the engine combustion outer liner were also burned…Feb 5, 1986 · N812EA · Minor damage