OpenAirDocs.org

NTSB investigations

14,038 cases where the phase of flight was Takeoff.

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 = 300)
  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 ATL96LA107Accident · Serious injuriesLimited investigationFinal reportGrumman G-164 · Scotia, SCa loss of engine power for undetermined reasons. A factor was the unsuitable terrain for a forced landing.Jul 14, 1996 · N5370 · Substantial damageNTSB NYC96LA149Accident · No injuriesLimited investigationFinal reportCessna 172P · Fairfield, NJthe pilot's improper aborted takeoff by extending full flaps which resulted in a porpoise. Subsequently, the airplane veered off the runway and the nose gear collapsed.Jul 13, 1996 · N98730 · Substantial damageNTSB IAD96LA112Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Salisbury, MDthe student pilot's failure to maintain directional control during the takeoff roll.Jul 11, 1996 · N91493 · Substantial damageNTSB ATL96FA101Accident · Serious injuriesField investigationFinal reportBoeing 737-200 · Nashville, TNthe captain's improper rejected takeoff, in that the takeoff was rejected after V1, and the flight attendants' improper use of the evacuation procedure, in that an evacuation was independently initiated without the captain's approval, and without assessing…Jul 8, 1996 · N53SW · Minor damageNTSB DCA96MA068Accident · 2 fatalClass 1 · MajorFinal reportMcDonnell Douglas MD-88 · Pensacola, FLthe fracture of the left engine's front compressor fan hub, which resulted from the failure of Delta Air Lines' fluorescent penetrant inspection process to detect a detectable fatigue crack initiating from an area of altered microstructure that was created…Jul 6, 1996 · N927DA · Substantial damageNTSB FTW96LA300Accident · No injuriesLimited investigationFinal reportCessna 172P · Owasso, OKInadequate maintenance by maintenance personnel resulting in inoperative brake system during an aborted takeoff. A factor was the downhill runway condition.Jul 4, 1996 · N62511 · Substantial damageNTSB FTW96LA298Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Ardmore, OKThe pilot's inadvertent premature retraction of the landing gear during takeoff roll. A factor was inadequate supervision by the safety pilot/flight instructor.Jul 3, 1996 · N2992F · Substantial damageNTSB ANC96LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cantwell, AKThe pilot's inadequate compensation for the crosswind conditions. A factor in the accident was the crosswind.Jul 3, 1996 · N57617 · Substantial damageNTSB LAX96LA257Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Redlands, CAthe CFI's delayed remedial action by not preventing the airplane's departure from the runway, and his failure to maintain airspeed sufficient to avoid stalling during an attempted low altitude climbing turn.Jul 2, 1996 · N2931V · DestroyedNTSB CHI96LA225Accident · Serious injuriesLimited investigationFinal reportSisk BD-5 · Lake Geneva, WIfailure of the pilot to abort the takeoff, while there was sufficient runway remaining. The high temperature and calm wind were related factors.Jul 1, 1996 · N51SK · DestroyedNTSB ATL96LA099Accident · No injuriesLimited investigationFinal reportCessna 188 · Pelham, GAfailure of the pilot to maintain directional control on the takeoff roll, which resulted in the airplane veering off the runway and colliding with a cotton picker (vehicle).Jul 1, 1996 · N9088R · Substantial damageNTSB IAD96LA102Accident · Serious injuriesLimited investigationFinal reportBeech 65 · Campbellsville, KYthe pilot's inadequate preflight preparation, his failure to remove the control lock, and his failure to abort the takeoff.Jun 30, 1996 · N3870C · DestroyedNTSB SEA96LA138Accident · No injuriesLimited investigationFinal reportCessna A188B · Opheim, MTthe pilot's failure to follow the proper short field takeoff procedure as specified in the Airplane Flight Manual, his improper use of wing flaps during the takeoff, and his failure to abort the takeoff (while there was sufficient runway remainin). A factor…Jun 29, 1996 · N731ED · Substantial damageNTSB NYC96LA136Accident · No injuriesLimited investigationFinal reportCessna 172N · Newry, PAfailure of the pilot to identify the inoperative airspeed indication and abort the takeoff, while there was sufficient runway remaining; excessive speed during the approach/landing; and the pilot's failure to perform a go-around after not attaining a proper…Jun 28, 1996 · N4776E · Substantial damageNTSB MIA96LA167Accident · Minor injuriesLimited investigationFinal reportBeech B55B · Clinton, NCa loss of right engine power for undetermined reasons, resulting in the pilot loosing control of the airplane and impact with tress.Jun 27, 1996 · N112G · DestroyedNTSB FTW96LA275Accident · No injuriesLimited investigationFinal reportRockwell S2R · Las Animas, COinadequate preflight planning/preparation by the pilot. Factors relating to the accident were: the unfavorable wind condition for takeoff, and the terrain condition beyond the end of the runway.Jun 24, 1996 · N4907X · Substantial damageNTSB FTW96LA273Accident · No injuriesLimited investigationFinal reportWilliams Velocity 173RG · Longmont, COthe pilot's improper planning/decision. Factors relating to the accident were: the high density altitude, and the pilot's inadequate weather evaluation.Jun 24, 1996 · N525V · Substantial damageNTSB SEA96LA135Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Vancouver, WAfailure of the pilot to maintain directional control of the airplane during take-off, which resulted in an inadvertent ground swerve and subsequent dragging of the right wing. The pilot's lack of experience in the make/model of aircraft was a related factor.Jun 23, 1996 · N81966 · Substantial damageNTSB NYC96LA129Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Block Island, RIthe pilot's inadequate preflight, by failing to remove the control lock and checking the flight controls before takeoff, and his failure to abort the takeoff in a timely manner, which resulted in an overrun, an encounter with brush, and a subsequent nose over…Jun 23, 1996 · N1665Y · Substantial damageNTSB SEA96LA132Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Hazleton, IDpartial loss of engine power for undetermined reason(s). Factors relating to the accident were: high density altitude; the pilot's delay in dumping the entire chemical load, when he first perceived a power loss; and rough/uneven terrain in the emergency…Jun 20, 1996 · N9970P · Substantial damageNTSB CHI96TA260Accident · No injuriesFinal reportSchweizer SGS 2-33AK · Mattoon, ILthe pilot's failure to maintain directional control of the glider. Factors were the runway sign and the failure of the pilot to maintain a visual lookout.Jun 19, 1996 · N65809 · Substantial damageNTSB FTW96LA260Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 · Prescott, ARThe loss of engine power due to improper fuel. Factors were the pilot's inadequate preflight and lack of suitable terrain for the forced landing.Jun 17, 1996 · N6210Z · Substantial damageNTSB ANC96LA089Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nikiski, AKThe pilot's premature lift-off during the takeoff roll. The pilot's selection of unsuitable terrain for takeoff was a factor in the accident.Jun 16, 1996 · N8796D · Substantial damageNTSB FTW96LA251Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Cash, ARThe partial loss of engine power due to fuel contamination. A factor was the lack of suitable terrain available for the forced landing.Jun 15, 1996 · N1004W · Substantial damageNTSB SEA96LA115Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Tooele, UTfailure of the flight instructor (CFI) to ensure that adequate airspeed was maintained during initial climb after lift-off, which resulted in an inadvertent stall/mush. High density altitude was a related factor.Jun 7, 1996 · N9594V · Substantial damageNTSB LAX96FA228Accident · No injuriesField investigationFinal reportBritish Aerospace BA-3100/3201 · San Luis Obispo, CAThe flight crew's loss of directional control resulting from an attempted takeoff with the left propeller on the start lock. Factors in the accident were: the lack of cockpit caution/warning system/lights available to verify that the propellers are out of the…Jun 6, 1996 · N926AE · Substantial damageNTSB CHI96LA190Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Oskaloosa, KSfailure of the pilot to maintain proper alignment with the roadway during the takeoff roll. A factor relating to the accident was: the selection of an unsuitable area for takeoff.Jun 4, 1996 · N9408R · DestroyedNTSB ANC96LA082Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Akiachak, AKThe pilot's inadequate compensation for the variable crosswind conditions. Factors associated with the accident were the variable crosswinds and the short runway.Jun 4, 1996 · N91052 · Substantial damageNTSB CHI96LA196Accident · No injuriesLimited investigationFinal reportCessna 140 · Potter, NEa fatigue fracture of the landing gear axle.Jun 2, 1996 · N3609V · Substantial damageNTSB SEA96LA108Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Rimrock, WAthe pilot's delay in aborting the takeoff, and his excessive use of brakes while decelerating the airplane during the aborted takeoff. Factors relating to the accident were: the pilot's loading the airplane above its maximum gross weight, high density…Jun 1, 1996 · N2965N · Substantial damageNTSB LAX96LA212Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-20 · Sparks, NVthe pilot's inadequate compensation for wind conditions during the takeoff roll, and his failure to maintain control of the glider. The gusty wind condition was a related factor.May 28, 1996 · N204Q · Substantial damageNTSB ANC96LA080Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kivalina, AKThe pilot's selection of an unsuitable takeoff area.May 24, 1996 · N83616 · Substantial damageNTSB CHI96LA168Accident · No injuriesLimited investigationFinal reportCessna 188 · Roseau, MNthe pilot failed to maintain directional control during takeoff. The crosswind was a factor.May 21, 1996 · N2062J · Substantial damageNTSB CHI96LA167Accident · No injuriesLimited investigationFinal reportAir Tractor AT401 · Letcher, SDthe pilot's inadequate evaluation of the severe weather condition. A factor was the weather conditions.May 20, 1996 · N1019X · Substantial damageNTSB LAX96LA203Accident · No injuriesLimited investigationFinal reportCessna 152 · Van Nuys, CAthe student pilot's failure to maintain directional control of the aircraft during an aborted takeoff.May 19, 1996 · N49438 · Substantial damageNTSB LAX96LA196Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Williams, CAThe pilot's failure to maintain directional control during a rejected takeoff, and the catastrophic failure of the engine's turbine section due to an improper overhaul procedure. A factor in the accident was the close proximity of the drainage ditch to the…May 11, 1996 · N447AT · Substantial damageNTSB FTW96LA205Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Iowa, LAthe pilot's selection of an unsuitable area for takeoff. The high vegetation (tall grass) was a related factor.May 10, 1996 · N6832K · Substantial damageNTSB CHI96LA151Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Big Lake, MNthe pilot's inadequate preflight of the helicopter by not having removed a tiedown strap before attempting takeoff.May 4, 1996 · N177HA · Substantial damageNTSB FTW96LA201Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-233A · Odessa, TXthe pilot's failure to obtain the required airspeed resulting in a hard landing. A factor was the lack of thermal lift.May 3, 1996 · N7773S · No damageNTSB FTW96TA195Accident · No injuriesFinal reportRockwell NA-265-80 · Albuquerque, NMoverdeflection of the left outboard main landing gear tire, probably due to underinflation and inadequate inspection, which resulted in fatigue failure of the left outboard tire and subsequent failure of the left inboard tire.May 2, 1996 · N773W · Substantial damageNTSB CHI96LA148Accident · No injuriesLimited investigationFinal reportFairchild M-62C · Garden City, KSfailure of the left main landing gear strut due to corrosoion.May 2, 1996 · N67481 · Substantial damageNTSB ANC96LA064Accident · No injuriesLimited investigationFinal reportAviat A-1 · Togiak, AKThe pilot's failure to remove frost from the surface of the wings and his delay in aborting the takeoff. Factors in the accident were the presence of frost on the wings and a deteriorated climb performance.May 2, 1996 · N93HU · Substantial damageNTSB ANC96IA065Incident · No injuriesIncident investigationFinal reportVeazie Super Acro Zenith CH · Fairbanks, AKthe pilot's improper understanding of his amended clearance, and the local controller's failure to assure that the pilot understood that he was cleared only to land. Factors in the incident were: the airport design that places two airplanes in close proximity…May 2, 1996 · N200BV · No damageNTSB ATL96LA083Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Cochran, GAfailure of the flight instructor (CFI) to maintain directional control of the airplane during takeoff, when the airplane encountered an uneven area on the airstrip and becoming airborne prematurely; and his failure to maintain clearance (or altitude) from…May 1, 1996 · N1209C · Substantial damageNTSB MIA96FA130Accident · 1 fatalField investigationFinal reportHelio H-295 · Gaffney, SCfailure of the pilot to remove the control lock during the preflight, and his failure to check the flight controls before taking off.Apr 26, 1996 · N700HC · DestroyedNTSB FTW96LA192Accident · No injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKthe student's inadvertent dynamic rollover, and inadequate supervision by the flight instructor.Apr 26, 1996 · N5226 · Substantial damageNTSB FTW96LA180Accident · Minor injuriesLimited investigationFinal reportWhistle Questair Venture M20 · Watkins, COthe pilot's failure to compensate for prevailing wind conditions and to maintain directional control. Factors were the gusting and quartering tailwind conditions.Apr 23, 1996 · N68U · Substantial damageNTSB MIA96LA126Accident · No injuriesLimited investigationFinal reportLuttrell-Lacky Breezy · Hendersonville, NCinadequate preflight planning/preparation by the pilot, by not adequately surveying the area to be used for takeoff, which resulted in a collision with a fence.Apr 21, 1996 · N78LL · Substantial damageNTSB ANC96LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Wasilla, AKthe pilot's delay in aborting the takeoff.Apr 21, 1996 · N8873J · Substantial damageNTSB LAX96LA174Accident · No injuriesLimited investigationFinal reportHelio H-295 · Grand Canyon, AZthe partial failure of the landing gear brake system resulting from loss of the clips retaining the right-hand brake disk. The resulting loss of braking authority impaired the pilot's ability to maintain directional control in a left quartering tailwind and…Apr 19, 1996 · N6470V · Substantial damage