OpenAirDocs.org

NTSB investigations

2,084 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 ANC89LA109Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Kenai, AKFailure of the pilot to obtain proper assistance in starting the engine and/or his inadequate supervision. The passenger's lack of familiarity with the aircraft resulted in her improper use of the throttle which contributed to the accident.Jun 29, 1989 · N5302W · Substantial damageNTSB ATL89LA172Accident · Serious injuriesLimited investigationFinal reportBoeing 737-291 · Atlanta, GAFailure of the ground employee to follow normal safety procedures. His lack of familiarity with the operation was a related factor.Jun 26, 1989 · N7375F · No damageNTSB SEA89LA109Accident · No injuriesLimited investigationFinal reportCessna 177B · Minden, NVThe inadequate maintenance which caused a crack in the fuel pressure line leading into the carburetor.Jun 11, 1989 · N34211 · DestroyedNTSB SEA89LA102Accident · No injuriesLimited investigationFinal reportBeech 19A · Cashmere, WAThe pilot used poor starting procedures. The airplane was inadequately secured resulting in a collision with an object when the airplane broke free of the tiedown ropes.Jun 3, 1989 · N6061N · Substantial damageNTSB MIA89LA163Accident · No injuriesLimited investigationFinal reportCessna 150L · Jacksonville, FLThe pilot's failure to have someone operate the airplane's brakes and engine controls during hand propping the engine.May 30, 1989 · N17018 · Substantial damageNTSB MIA89LA162Accident · No injuriesLimited investigationFinal reportCessna A152 · Lake Wales, FLImproper planning/decision by the pilot by not properly securing the aircraft or obtaining proper assistance.May 29, 1989 · N4896A · Substantial damageNTSB CHI89LA075Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Watertown, WIThe pilot's improper use of brakes and throttle. A contributing factor was the parked aircraft which was nearby.Apr 24, 1989 · N39868 · Substantial damageNTSB FTW89LA086Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Lampasas, TXThe pilot's failure to follow proper procedures and directives for the attempted operation. A factor was the undetermined status of the magnetos.Apr 6, 1989 · N17513 · Substantial damageNTSB NYC89LA112Accident · No injuriesLimited investigationFinal reportChampion 8KCAB · Manchester, NHThe loss of control and collision with a parked aircraft due to the inadvertent application of the throttle that took place as the pilot was fastening the over the shoulder safety harness while warming the engine in preparation for departure.Apr 3, 1989 · N2520Z · Substantial damageNTSB LAX89LA144Accident · Serious injuriesLimited investigationFinal reportBoeing 767-201 · Los Angeles, CAThe first officer did not properly evacuate the airplane.Apr 3, 1989 · N645US · No damageNTSB FTW89LA077Accident · No injuriesLimited investigationFinal reportGulfstream 680FLP · Lohn, TXArson undertaken to conceal illegal activity.Apr 1, 1989 · N721F · DestroyedNTSB LAX89LA127Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Malibu, CAThe failure of the passenger to follow briefed procedures and the failure of ground personnel to provide adequate assistance.Mar 18, 1989 · N8784F · No damageNTSB DCA89MA035Accident · 2 fatalClass 1 · MajorFinal reportMcDonnell Douglas DC-9-33F · Saginaw, TXThe loss of control of the airplane for undetermined reasons following the inflight opening of the improperly latched cargo door. Contributing to the accident were: inadequate procedures used by evergreen airlines and approved by the FAA for preflight…Mar 18, 1989 · N931F · DestroyedNTSB DCA89MA034Accident · No injuriesMajor investigationFinal reportBoeing 737-300 · Oakland, CAIgnition of puddled fuel from a blocked combustor drain line, and a slow start during which fuel was misted and blown out the tail pipe. An existing tailwind at the gate allowed the fuel to wet the tail surfaces and be ignited during the APU start. The…Mar 17, 1989 · N12318 · Substantial damageNTSB MKC89LA075Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wynne, ARAn engine fire during engine start for undetermined reasons.Mar 10, 1989 · N6602Q · DestroyedNTSB BFO89LA018Accident · Serious injuriesLimited investigationFinal reportCessna 172I · Fort Washington, MDThe passenger failed to maintain adequate clearance from the propeller as she attempted to board the aircraft. Both the pilot failure to supervise the boarding of the passenger and the night light conditions are contributing factors to the accident.Feb 26, 1989 · N8359L · No damageNTSB NYC89LA081Accident · No injuriesLimited investigationFinal reportCessna 402B · Hyannis, MAInadequate preflight planning and preparation by the pilot which resulted in improper weight and balance (aft CG). The aft CG also contributed to the uncommanded altitude deviation after takeoff.Feb 4, 1989 · N49PB · Substantial damageNTSB MIA89LA073Accident · No injuriesLimited investigationFinal reportBeech A36 · Daytona Beach, FLFailure of the driver of the automobile to maintain an adequate visual lookout and to yield the right of way to the aircraft.Jan 27, 1989 · N2860W · Substantial damageNTSB SEA89LA038Accident · No injuriesLimited investigationFinal reportCessna 180A · Arlington, WAThe pilot attempted to hand-prop the engine without properly securing it.Jan 19, 1989 · N9104R · Substantial damageNTSB ANC89IA032Incident · No injuriesIncident investigationFinal reportBoeing 727-222 · Anchorage, AKImproper placement of the 727 on the ramp and the failure of the 747 crew to maintain separation.Jan 9, 1989 · N7298U · 2 aircraft · Minor damageNTSB DEN89LA059Accident · No injuriesLimited investigationFinal reportBell 206B III · Park City, UTThe selection of an unsuitable landing site by the pilot, resulting in tail rotor contact with the terrain and shearing of the tail rotor driveshaft.Jan 8, 1989 · N16733 · Substantial damageNTSB ATL89IA057Incident · No injuriesIncident investigationFinal reportLockheed L-1011 · Atlanta, GA1St officer was observed to be sick & was replaced on the flt prior to departing the originating city. Subsequently, he was confronted by an intervention group regarding his condition and requested medical assistance under the company employee assistance…Dec 19, 1988 · UNK · No damageNTSB MIA89LA051Accident · No injuriesLimited investigationFinal reportCessna 172G · Venice, FLThe pilot experienced difficulty when he attempted to start the eng with a less than fully-charged battery. The former navy plt exited the acft, leaving his nonplt pax aboard, and the mag switch 'on'. He attempted to slowly pull the prop thru compression…Dec 16, 1988 · N4419L · Substantial damageNTSB BFO89LA010Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Dublin, WVThe pilot was attempting to hand prop his acft without any assistance. He stated he chocked both the front and back of the right main gear. After several unsuccessful attempts the engine finally started. The acft ran at what the pilot described as sounding…Nov 15, 1988 · N88054 · Substantial damageNTSB DEN89LA032Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12D · Carrizozo, NMThe private plt said his Taylorcraft was secured to the ramp by 3 chains. He tried to hand start the engine, with no one at the controls, and the throttle full open. The engine started, the acft broke the right wing tie down ring, and straightened an 's' hook…Nov 13, 1988 · N43603 · Substantial damageNTSB ATL89LA032Accident · Minor injuriesLimited investigationFinal reportBeech 35-A33 · Marietta, GADuring preflt 'run-up' at the end of the active rwy, the right brake failed and the airplane pivoted left while the engine was at a high power setting. The plt rpted that things happened so fast that he may have added power while attempting to reduce power.…Nov 13, 1988 · N431T · Substantial damageNTSB MIA89IA031Incident · No injuriesIncident investigationFinal reportCessna 210L · Stuart, FLWhile hand-propping the engine with a passenger in the right front seat, the eng started. The acft travelled uncontrolled into a parked unoccupied acft. Both acft sustained substantial damage. The plt on the ground & the passenger in the acft were not…Nov 12, 1988 · N2267S · Minor damageNTSB MIA89LA019Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · San Juan, PRThe pilot noted an explosion in the right wing during engine start. He stated that the aircraft had been 'topped off' prior to the flight. Residue of fuel was found in the wing outside the fuel cells after the explosion.Oct 29, 1988 · N5237Y · Substantial damageNTSB ANC89LA014Accident · No injuriesLimited investigationFinal reportCessna TU206A · Soldotna, AKThe ATP certificated pilot and his two passengers were returning from a hunting trip when the turbocharged Cessna 206 caught fire soon after landing. The pilot stated that the engine quit during the landing roll and an attempt at restarting the engine as the…Oct 26, 1988 · N4850F · DestroyedNTSB NYC89LA008Accident · Serious injuriesLimited investigationFinal reportAmerican AA-5B · Wrightstown, NJThe plt said that the battery ran low while he was attempting to start his acft. He said he hand-propped the eng for several minutes and when he became fatigued, the passenger, who is also a pilot, began to hand prop the eng. When the passenger turned the…Oct 9, 1988 · N666GA · No damageNTSB DEN88LA183Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Hoven, SDThe private plt and his wife were going to make a local flight in their airplane at 0215. The plt said he hand- propped the acft and moved to enter the cabin as the engine started. The acft began to move, and his wife pulled the parking brake lock, which…Aug 14, 1988 · N5301Z · Substantial damageNTSB NYC88LA212Accident · 1 fatalLimited investigationFinal reportCessna 152 · Swanton, VTThe plt took the passenger (his wife) on a short flt, which was her 1st flt. She was described as apprehensive. Before going back to the parking area after landing, the plt taxied to the terminal bldg for his wife to deplane. He stopped the acft with the left…Aug 10, 1988 · N757LD · Minor damageNTSB NYC88LA208Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Auburn-Lewiston, METhe student pilot of an Ercoupe 415C hand-propped the aircraft with no one at the controls and the tail not tied down. The engine started and the Ercoupe struck a parked, unoccupied, tied down Cessna 170.Aug 3, 1988 · N169WS · Substantial damageNTSB SEA88LA194Accident · No injuriesLimited investigationFinal reportAeronca 65-LB · Ephrata, WAThe pilot set the parking brake, then hand-propped the aircraft. He did not tie the aircraft down nor was it chocked. Also, he momentarily left the aircraft unattended; at that time, it began moving & subsequently collided with a parked aircraft.Jul 22, 1988 · N33713 · Substantial damageNTSB SEA88LA127Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Haines, AKThe pilot purchased the helicopter with an undocumented modification designed to restrain the collective. Reportedly, hereceived no guidance regarding the use of the collective hold-down device. According to the aircraft manufacturer there existed no Enstrom…Jul 13, 1988 · N8620C · Substantial damageNTSB NYC88IA186Incident · No injuriesIncident investigationFinal reportMBB BK-117 · Manhattan, NYFailure of the main rotor blade appears to be the result of a static downward bending overstress, caused by another helicopter hovering over or very close to the main rotor blade as it was in a static/stopped position.Jul 12, 1988 · N135CP · Minor damageNTSB MKC88LA116Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cotton Plant, ARThe pilot did not adequately secure the aircraft prior to hand-propping the engine. The engine started and resulted in the aircraft taxiing without a pilot at the controls. The pilot-less aircraft impacted a utility pole causing substantial damage.Jun 22, 1988 · N8644H · Substantial damageNTSB ANC88LA150Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Mekoryuk, AKThe pilot-in-command was herding reindeer for a native corporation and he and his passenger had to relieve themselves so they landed on the tundra and left the helicopter's engine and rotors operating. As they were exiting the helicopter, it shifted on the…Jun 17, 1988 · N9076D · Substantial damageNTSB DEN88LA127Accident · No injuriesLimited investigationFinal reportCessna 182K · Cotton City, NMThe pilot reported that he was attempting to start the Cessna 182 for a cross country, solo, personal transportation flight. During the starting procedures, the engine backfired and the pilot smelled and saw smoke coming from the engine cowling area. The…Jun 14, 1988 · N2829R · DestroyedNTSB FTW88LA117Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Cleveland, TXThis acft was damaged when it collided with a ditch and flipped over. The acft's battery was dead and the plt hand propped the eng without the benefit of chocks or an experienced individual in the cockpit. The eng started and as the plt was attempting to…Jun 8, 1988 · N7317T · Substantial damageNTSB DEN88LA116Accident · Serious injuriesLimited investigationFinal reportCessna TR-182RG · Englewood, COThe CFI, a private rated dual student, and one passenger were preparing to depart on a training flight. The CFI attempted to hand prop the airplane when the battery was found to be inoperative. During the attempt, the CFI was struck in the back of the head.Jun 1, 1988 · N999HP · No damageNTSB MIA88LA165Accident · No injuriesLimited investigationFinal reportRockwell 500-S · Jacksonville, FLThe plt stated that he had just brought the acft to a stop & had shut down both engs. At that time, the lt. gear collapsed. Maintenance crew found that one of the actuating cyls was out of adjustment & the bungee cords were weak. The gear assy itself appeared…May 8, 1988 · N57222 · Substantial damageNTSB BFO88LA044Accident · No injuriesLimited investigationFinal reportCessna 150J · Winchester, VAThe T-6 struck the C-150 from behind while both were taxiing for takeoff. The C-150 was stopped at the time. There was an annual fly-in being held at the arpt with about 300 acft in attendance. Ground personnel were directing ground traffic. The T-6 plt said…May 1, 1988 · N905PS · 2 aircraft · Substantial damageNTSB NYC88LA130Accident · No injuriesLimited investigationFinal reportBeech 35 · New Haven, CTDuring engine start the throttle jammed in the full forward position and could not be pulled back to the idle position to retard the power. The aircraft started rolling and collided with an unoccupied parked aircraft. Examination of the throttle control…Apr 25, 1988 · N4528V · Substantial damageNTSB MIA88LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hialeah, FLEngine stalled during landing roll. During attempts to restart engine pilot flooded it. The engine backfired and the excess fuel in the carburetor caught fire. The pilot did not motor the engine in time to draw the flames into the engine and the fire spread…Apr 25, 1988 · N47966 · DestroyedNTSB ANC88LA046Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Near Central, AKThe pilot-in-command landed at the 'hot' refueling site and was attempting to exit the helicopter for a crew change. The hot refueling landing pad consisted of a black membrane with bundles of laths placed perpendicular to the helicopter's skids to prevent…Apr 18, 1988 · N65185 · Substantial damageNTSB ATL88IA139Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Atlanta, GAThe left MLG outer cylinder main trunnion fractured and separated while the airplane was sitting at the gate, shortly before the planned departure. Subsequent metallurgical exam of the part revealed that it was improperly overhauled, which significantly…Apr 12, 1988 · N889Z · Minor damageNTSB MIA88FA138Accident · Serious injuriesField investigationFinal reportBoeing 727-224 · Sarasota, FLThe captain of the Boeing 727 aircraft was aware that a refueler was utilizing known quantity refueling procedures due to an inoperative fuel guage. He allowed the flight engineer to activate the b hydraulic system and the ground interconnect switch, without…Apr 3, 1988 · N88703 · No damageNTSB MIA88FA132Accident · No injuriesField investigationFinal reportSwearingen SA-227-TT · Miami, FLThe plt stated that during his attempt to taxi around N30042, he thought he had enough clearance to get by, but misjudged the distance & the rudder of the merlin acft was struck by the DC6B'S left wing tip.Mar 29, 1988 · N30042 · 2 aircraft · Substantial damageNTSB CHI88LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Muncie, INWhen the pilot found that the battery would not start the aircraft, he elected to hand start it. His wife, a non-pilot passenger, was in the aircraft when it started. She attempted to close the throttle, however opened it and the aircraft began to move…Mar 27, 1988 · N7725D · Substantial damage