NTSB investigations
1,332 cases where the sequence of events included Collision during takeoff/land.
Cases, newest first
Query with SQL
duckdb -csv -c "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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '490' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '490' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN22LA098Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Youngstown, OHA loss of engine power for reasons that could not be determined based on available information, which resulted in a forced landing.NTSB CEN22LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Minocqua, WIThe pilot’s loss of control during landing when the airplane encountered ice and snow on the runway.NTSB ERA22LA081Accident · Serious injuriesClass 4 · LimitedFinal reportGlobe GC-1B · Bennettsville, SCThe pilot’s inadequate preflight planning, resulting in a takeoff attempt from a grass parking area instead of the runway and subsequent impact with a pole.NTSB WPR22LA036Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Mackay, IDThe pilot’s failure to maintain directional control during the landing roll, which resulted in the airplane veering into a ditch and nosing over.NTSB WPR22LA037Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Stanley, IDThe pilot's failure to attain sufficient airspeed for the airplane to climb with a tailwind.NTSB CEN22LA025Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Cresson, TXThe student pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with trees.NTSB ERA22LA037Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Waverly, TNThe pilot’s improper pre-flight fuel planning, which resulted in a total loss of engine power to both engines due to fuel exhaustion.NTSB ERA22LA030Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Atlanta, GAThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion and a collision with runway approach lighting equipment.NTSB ERA22LA025Accident · Serious injuriesClass 4 · LimitedFinal reportPipistrel Apis-Bee · Columbia, SCThe pilot’s failure to maintain control of the glider during the landing approach, which resulted in an aerodynamic stall and subsequent impact with the runway.NTSB WPR22LA006Accident · No injuriesClass 4 · LimitedFinal reportBevilacqua Jeffrey L Dragonfly Mkiih · Camarillo, CAThe pilot’s failure to maintain airplane control during takeoffNTSB CEN22LA009Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Gonzales, LAThe student pilot’s failure to compensate for an unanticipated right yaw, which resulted in a loss of tail rotor effectiveness and helicopter control.NTSB ANC21LA098Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Willow, AKThe pilot’s failure to maintain clearance to terrain following a go-around.NTSB WPR21LA355Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Tucumcari, NMThe pilot’s improper landing flare which resulted in a hard and bounced landing.NTSB WPR21LA348Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Grass Valley, CAThe pilot’s failure to attain a proper touchdown point on the runway while landing in gusting wind conditions, which resulted in a runway overrun. Contributing to the accident was the pilot’s distraction due to an electrical issue.NTSB CEN21LA448Accident · No injuriesClass 4 · LimitedFinal reportCessna 305A · Topeka, KSThe loss of control and ground loop due to the mechanical malfunction of the tailwheel lock.NTSB CEN21LA446Accident · Serious injuriesClass 4 · LimitedFinal reportCole Paul B Challenger I · Higginsville, MOThe non-certificated pilot's exceedance of the airplane's critical angle of attack during a low-level turn, which resulted in an aerodynamic stall.NTSB ERA21LA366Accident · No injuriesClass 4 · LimitedFinal reportSproul Keith A 83K-16 · Ryegate, VTThe pilot's failure to secure himself to the balloon seat which resulted in a loss of control of the balloon.NTSB WPR21LA358Accident · No injuriesClass 3 · LimitedFinal reportBeech 35-B33 · Baker, NVA total loss of engine power during the initial climb due to the failure of the No. 5 connecting rod bearing.NTSB CEN21LA420Accident · Minor injuriesClass 3 · LimitedFinal reportQuad City Ultralight Challenger II · Rogers City, MIThe separation of the right wing’s forward lift strut from the fuselage due to a missing nylon-insert lock nut. Contributing to the accident was the noncertificated pilot’s decision to operate the airplane even though a condition inspection had not been…NTSB ANC21LA087Accident · Serious injuriesClass 4 · LimitedFinal reportAeronca 15AC · North Pole, AKThe pilot’s failure to ensure adequate obstacle clearance while maneuvering, which resulted in a collision with a tree and a loss of control.NTSB ERA21FA354Accident · Serious injuriesClass 3 · FieldFinal reportCessna 402C · Provincetown, MAThe pilot’s delayed decision to perform an aborted landing late in the landing roll with insufficient runway remaining. Contributing to the accident was the pilot’s failure to execute a go-around once the approach became unstabilized, per the operator’s…NTSB ANC21LA083Accident · Minor injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Delta Junction, AKThe pilot’s inability to maintain lateral control during the takeoff, which resulted in dynamic rollover. Contributing to the accident was the pilot’s decision to utilize an unsuitable landing area for flight operations.NTSB ANC21LA085Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Tyonek, AKThe pilot’s selection of inappropriate terrain and decision to land with a tailwind, which resulted in a loss of directional control, an attempted go-around, and subsequent impact with terrain.NTSB ERA21LA381Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Fort Lauderdale, FLThe flight instructor’s loss of airplane control during an attempted go around maneuver, which resulted in an aerodynamic stall, and subsequent impact with the runway.NTSB ERA21FA346Accident · 4 fatalClass 2 · FieldFinal reportCessna 560 · Farmington, CTThe pilot-in-command’s failure to release the parking brake before attempting to initiate the takeoff, which produced an unexpected retarding force and airplane-nose-down pitching moment that prevented the airplane from becoming airborne within the takeoff…NTSB WPR21LA343Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-24-400 · Fullerton, CAThe pilot’s failure to monitor the environment and maintain a proper glidepath on approach which, resulted in a collision with the airport perimeter fence.NTSB WPR21LA341Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Camp Verde, AZThe pilot's inadequate preflight performance calculations which resulted in an aborted takeoff and collision with trees.NTSB WPR21LA319Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Panguitch, UTThe airplane’s inability to maintain altitude during the initial climb due to a degradation in the airplane’s performance due to high-density altitude conditions. Contributing to the accident was the pilot’s failure to conduct preflight performance planning…NTSB WPR21LA307Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170A · Metaline Falls, WAThe pilot’s failure to attain sufficient altitude during the initial climb to clear trees due to an encounter with windshear.NTSB CEN21LA362Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Topeka, KSThe pilot’s decision to continue low-level aerial application flight maneuvers after the low fuel warning light illuminated, which resulted in a partial loss of engine power due to fuel exhaustion.NTSB CEN21LA359Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Gosport, INA total loss of engine power during cruise flight due to the failure of a cylinder exhaust valve stem, which led to a forced landing during which the airplane impacted terrain.NTSB WPR21LA306Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C-85 · Woodburn, ORThe pilot’s failure to maintain clearance during takeoff from a person on the ground who sustained a serious injury as a result of the collision.NTSB ANC21LA070Accident · No injuriesClass 4 · LimitedFinal reportAlaskan Air Adventures SQ2 · Talkeetna, AKThe pilot’s inadvertent movement of the fuel selector valve to a position between the tanks, which resulted in fuel starvation and a subsequent loss of engine power.NTSB WPR21LA312Accident · Minor injuriesClass 4 · LimitedFinal reportLake LA-4 · Lake Isabell, CAThe pilot’s failure to establish a positive climb rate after takeoff, which resulted in an impact with an object.NTSB CEN21LA353Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Jeffersonville, INA loss of directional control due to failure of the landing gear attachment hardware for reasons that could not be determined based on the available information.NTSB ERA21LA313Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Waxhaw, NCThe pilot’s failure to abort the takeoff in sufficient time to stop the airplane on the runway remaining. Contributing to the accident was the lack of airplane takeoff performance due to the pilot’s failure to assure that the carburetor heat control was in…NTSB CEN21LA351Accident · Serious injuriesClass 3 · LimitedFinal reportCozy Mark IV · Rushville, NEA total loss of engine power due to an obstruction of airflow to the engine as a result of the landing brake being deployed in flight.NTSB GAA21WA198Accident · No injuriesClass 5 · ForeignCessna 182 · Tannheim, GermanyNTSB WPR21LA297Accident · No injuriesClass 4 · LimitedFinal reportKevin P Stolhammer KR 1 · Electric City, WAThe pilot's failure to maintain directional control during the landing roll.NTSB CEN21LA333Accident · No injuriesClass 4 · LimitedFinal reportBoeing E75 · Baraboo, WIThe pilot’s failure to maintain clearance from the fence while on final approach.NTSB GAA21WA184Accident · No injuriesClass 5 · ForeignCessna 172 · Almoguera, SpainNTSB WPR21LA295Accident · No injuriesClass 4 · LimitedFinal reportCessna 172I · Renton, WAThe boat operator’s failure to remain a safe distance from the floatplane during the takeoff run, which resulted in a collision.NTSB CEN21LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Brenham, TXThe pilot’s failure to maintain control of the airplane during takeoff from a rough field.NTSB WPR21FA272Accident · 4 fatalClass 3 · FieldFinal reportMooney M20J · Dinsmore, CAThe airplane’s degraded engine performance due to wear to the intake cam lobes, which diminished the airplane’s takeoff and climb performance, resulting in a subsequent collision with trees.NTSB CEN21LA322Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Edcouch, TXThe pilot’s inadequate compensation for a gusting wind during takeoff.NTSB WPR21LA287Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36TC · Chandler, AZThe pilot’s delayed decision to abort the takeoff due to insufficient airspeed.NTSB ERA21LA283Accident · 1 fatalClass 3 · LimitedFinal reportBailey N Moyes Dragonfly · Charlestown, NHThe passenger’s decision to continue an unstable approach while at low altitude and in proximity to a known obstacle, which resulted in a collision with power lines.NTSB ERA21LA280Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Bishopville, SCThe flight instructor’s inadequate supervision of the student during a go-around, which resulted in a loss of lift and a subsequent collision with the VASI lights.NTSB ANC21LA058Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-210C · Anchorage, AKThe pilot’s impact with a log while dragging an off-airport landing site.NTSB ANC21LA053Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Kenney Lake, AKThe pilot’s failure to maintain adequate clearance from a tree during takeoff, which resulted in a loss of directional control and impact with terrain.