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 ANC94LA136Accident · No injuriesLimited investigationFinal reportCessna 140 · Willow, AKThe pilot's improper starting procedures. Factors in the accident were the unavailability of a parking brake and tiedowns to secure the airplane.Sep 13, 1994 · N76680 · Substantial damageNTSB LAX94LA347Accident · No injuriesLimited investigationFinal reportCessna 182P · Mesa, AZthe pilot's failure to properly secure the aircraft prior to a start attempt by handpropping.Sep 2, 1994 · N58645 · Substantial damageNTSB MIA94LA202Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12-D · Punta Gorda, FLThe failure of the pilot-in-command to tiedown the airplane prior to attempting an engine start by hand propping. Contributing to the accident was the pilot's complacency.Aug 30, 1994 · N39283 · Substantial damageNTSB MIA94LA190Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe pilot-in-command's decision to intentionally exit the airplane with the engine running, and failure to maintain a clearance from the propeller. The improper aircraft preflight was a factor.Aug 7, 1994 · N67334 · Minor damageNTSB NYC94LA144Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-8-311 · Washington, DCThe vehicle operator's improper handling of the baggage tractor resulting in loss of control of a second baggage tractor being pushed and its subsequent collision with the airplane.Aug 1, 1994 · N433AW · Substantial damageNTSB ANC94FA089Accident · No injuriesField investigationFinal reportAerospatiale AS-350 · Juneau, AKThe pilot's selection of unsuitable landing terrain. A factor was the crevasse in the ice.Jul 20, 1994 · N39GT · Substantial damageNTSB NYC94LA117Accident · Serious injuriesLimited investigationFinal reportWSK PZL Wilga 80 · Churchville, MDImproper starting procedure by the pilot.Jul 11, 1994 · N7080B · No damageNTSB ANC94LA064Accident · No injuriesLimited investigationFinal reportHiller FH1100 · Tyonek, AKThe pilot's selection of unsuitable terrain for landing which resulted in a dynamic rollover. A factor was the soft landing area selected.Jun 4, 1994 · N746FH · Substantial damageNTSB FTW94LA180Accident · 1 fatalLimited investigationFinal reportCessna 182A · Roland, ARBoth the pilot and passenger's failure to follow procedure/directives.May 25, 1994 · N3848D · Minor damageNTSB SEA94FA121Accident · 4 fatalField investigationFinal reportAero Commander 500A · Livermore, CAA fuel system leak, inadequate preflight by the pilot (PIC), and by the non-flying pilot/passenger intentionally allowing operation of the aircraft with a known deficiency (fuel leak). A factor related to the accident was: the lack of suitable terrain for a…May 20, 1994 · N601MK · DestroyedNTSB LAX94LA220Accident · Minor injuriesLimited investigationFinal reportRobinson R22-B · Stockton, CAA failure of the pilot-in-command of a landing helicopter to maintain sufficient clearance from a second helicopter.May 19, 1994 · N140PH · 2 aircraft · Substantial damageNTSB FTW94LA182Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Boerne, TXThe pilot-in-command's inadequate supervision of his deplaning passenger.May 19, 1994 · N6504M · No damageNTSB FTW94LA148Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Lancaster, TXThe pilot's failure to use tie downs and proper assistance during the hand propping engine start.May 8, 1994 · N111NZ · Substantial damageNTSB LAX94LA209Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Phoenix, AZthe pilot's failure to ensure that the magneto switch was in the off position prior to rotating the propeller by hand.May 1, 1994 · N1454S · Substantial damageNTSB SEA94LA105Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Auburn, WAClearance was not maintained by an other person. A factor to the accident was: procedures/directives were inadequate.Apr 20, 1994 · N159BC · No damageNTSB MIA94LA118Accident · No injuriesLimited investigationFinal reportCessna 310J · Ocala, FLFailure of the pilot to assure the generators were engaged before flight (failed to follow the checklist).Apr 10, 1994 · N310JF · Substantial damageNTSB MIA94LA096Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Wimauma, FLThe failure of the person removing the chock to maintain sufficient clearance from the propeller. A contributing factor was the total lack of experience by person on ground.Mar 18, 1994 · N71891 · No damageNTSB LAX94LA147Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Sacramento, CAthe child's disregard for prescribed safety procedures which was compounded by the diminishing lighting conditions existing at the time, and her lack of familiarity with an aviation environment.Mar 4, 1994 · N22682 · No damageNTSB NYC94LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Falls Of Rough, KYThe pilot's inadequate tiedown and starting procedure which resulted in a runaway aircraft, which subsequently collided with a building.Mar 3, 1994 · N4487J · Substantial damageNTSB NYC94LA050Accident · Serious injuriesLimited investigationFinal reportBell 47G-5 · Plymouth, MAThe pilot's failure to maintain adequate clearance of the fuel truck from the aircraft, which resulted in the main rotor striking the fuel hose and truck during refueling operation. A factor was the pilot's failure to follow company policy pertaining to the…Mar 1, 1994 · N7043J · Substantial damageNTSB LAX94LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Santa Rosa, CAA failure of the pilot-in-command to ensure that the powerplant controls were configured properly before moving the aircraft propeller. Inadequate planning/decision making was a factor in this accident.Feb 23, 1994 · N20BS · No damageNTSB BFO94LA041Accident · 1 fatalLimited investigationFinal reportCessna 150 · Lima, OHThe failure of the passenger to maintain clerance from the propeller.Feb 18, 1994 · N7843E · Minor damageNTSB ATL94LA042Accident · No injuriesLimited investigationFinal reportCessna 182D · Donalsonville, GAThe pilot's failure to clear the induction systems of excessive fuel.Jan 22, 1994 · N8980X · DestroyedNTSB BFO94LA033Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Georgetown, DEThe failure of ground personnel to maintain clearance from the engine propeller.Jan 21, 1994 · N95537 · No damageNTSB CHI94IA066Incident · No injuriesIncident investigationFinal reportBritish Aerospace ATP · South Bend, INan internal failure of the auxiliary power unit.Jan 19, 1994 · N857AW · No damageNTSB MIA94IA043Incident · No injuriesIncident investigationFinal reportBoeing 767-322 · Miami, FLEmergency procedure initiated by an unqualified person.Jan 1, 1994 · N648UA · No damageNTSB NYC94LA041Accident · No injuriesLimited investigationFinal reportCessna 172N · Bar Harbor, MEA disconnected fuel line with the carburetor not installed, and improper dispatch of the aircraft.Dec 17, 1993 · N5753E · Substantial damageNTSB LAX94LA050Accident · No injuriesLimited investigationFinal reportCessna 172RG · Santa Ana, CAwere the CFI's inadequate supervision of the flight and his delay in taking remedial action. The dual student's excessive taxi speed and the worn right brake lining were factors in this accident.Nov 18, 1993 · N9620B · 2 aircraft · Substantial damageNTSB MIA94LA019Accident · No injuriesLimited investigationFinal reportCessna 421 · Miami, FLFailure of the pilot-in-command to obtain the proper assistance after being notified of a fuel leak from the left wing fuel tanks after refueling.Nov 10, 1993 · N1600B · Substantial damageNTSB BFO94LA002Accident · 1 fatalLimited investigationFinal reportFairchild SA 227-AC · Newark, NJ1) The failure of the ramp agent to follow proper procedures during the servicing of the airplane, and 2) her lack of attention to the hazards surrounding her. Factors related to the accident are 1) the pressure placed on the ramp agent to rush the servicing…Nov 5, 1993 · N550TD · No damageNTSB MIA94LA009Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5B · Fort Myers, FLImproper decision by the other person (pilot's mother) to go to the airplane, while the pilot was making checks in preparation for flight, and her failure to identify the hazardous condition (turning propeller).Oct 17, 1993 · N28930 · Minor damageNTSB MIA94LA007Accident · 1 fatalLimited investigationFinal reportCessna 182-P · Orlando, FLThe pilot's improper procedures and his complacency during his attempts to start the engine.Oct 15, 1993 · N20718 · Minor damageNTSB FTW93GA269Accident · No injuriesFinal reportBell 206B · Wht Sands Mr, NMThe pilot's failure to land an adequate distance away from the unsecured parachute.Sep 29, 1993 · N39049 · Substantial damageNTSB FTW93LA266Accident · No injuriesLimited investigationFinal reportBeech A36 · Houston, TXThe fuel leak which resulted from the mechanic's improper installation of the fuel line. A factor was the lead mechanic's inadequate post run up inspection.Sep 27, 1993 · N80010 · DestroyedNTSB BFO93LA186Accident · 1 fatalLimited investigationFinal reportPiper PA-24-260 · Niagara Falls, NYThe pilot's failure to follow starting procedures and his inadequate preflight inspection by not removing the wheel chocks and the passenger not maintaining clearance from the propeller.Sep 26, 1993 · N8992P · No damageNTSB SEA93LA209Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA 315B · Avery, IDThe pilot's improper use of the cyclic control.Sep 24, 1993 · N351RM · Substantial damageNTSB ANC93IA183Incident · No injuriesIncident investigationFinal reportCessna 180C · Anchorage, AKA frayed fuel hose.Sep 22, 1993 · N9211T · Minor damageNTSB ANC93LA171Accident · 1 fatalLimited investigationFinal reportPiper PA-12 · Ptarmigan Pass, AKThe pilot inadvertently walked into a turning propeller. Factors in the accident were the soft runway which mired the airplane and the pilot's diverted attention during the attempt to free the airplane.Sep 6, 1993 · N3629M · No damageNTSB NYC93LA172Accident · 1 fatalLimited investigationFinal reportBellanca 7ECA · Ashland, NHThe pilot's improper decision to leave the airplane unattended with the engine operating.Aug 23, 1993 · N82819 · No damageNTSB FTW93LA209Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Longview, TXThe pilot's failure to follow procedures.Jul 8, 1993 · N3631L · Minor damageNTSB LAX93GA270Accident · Minor injuriesFinal reportBell 206L-3 · Agoura Hills, CAThe improper configuration of the aerial ignition device by the crew chief and an inadvertent activation of the unit by the pilot. The improper installation and configuration of the unit by maintenance personnel, inadequate crew coordination, and insufficient…Jun 30, 1993 · N911VC · DestroyedNTSB ANC93LA105Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Gambell, AKIntentional personal injury. Factors in the accident were: the person's psychological condition, and the lack of sufficient procedures/airport staff by the operator(s).Jun 29, 1993 · N4112D · No damageNTSB CHI93LA222Accident · No injuriesLimited investigationFinal reportCessna 172 · St. Cloud, MNthe pilot's improper starting procedures.Jun 25, 1993 · N1670Y · Substantial damageNTSB FTW93LA179Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAThe pilot's failure to have the airplane properly attended during start when people were available. A factor was the inadequate tie down rope.Jun 5, 1993 · N6693Q · Substantial damageNTSB DEN93FA066Accident · Minor injuriesField investigationFinal reportCessna 310J · Broomfield, COFriction of escaping oxygen under high pressure igniting a lubricant in the nosewheel well area, and improper aircraft servicing by maintenance personnel.Jun 5, 1993 · N3005L · DestroyedNTSB CHI93LA176Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Plainwell, MIThe pilot-in-command's initiating hand starting of the airplane unattended by a qualified person.May 16, 1993 · N8657B · Substantial damageNTSB CHI93LA327Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace ATP · Green Bay, WIthe passenger's loss of footing (miscellaneous).May 7, 1993 · N852AW · No damageNTSB FTW93LA147Accident · No injuriesLimited investigationFinal reportRaven S-55A · Bentonville, ARAircraft control was not maintained by the pilot. A factor was unfavorable windsMay 1, 1993 · N6465K · Substantial damageNTSB NYC93LA095Accident · No injuriesLimited investigationFinal reportMacphee RV6 · Farmingdale, NJThe pilot's improper starting procedure, which caused the airplane to nose down.Apr 30, 1993 · N726WM · Substantial damageNTSB CHI93FA129Accident · 1 fatalField investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILthe unqualified baggage handler's attempting to load an unfamiliar airplane and inadequate training by the airline which employed the baggage handler.Apr 5, 1993 · N422MQ · Minor damage