NTSB investigations
4,605 cases where the first occurrence was “In flight collision with object”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220) 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 SEA92FA049Accident · 2 fatalField investigationFinal reportCessna 150M · Pullman, WAPoor inflight planning/decision. Factors to the accident were bright night conditions and clearance not maintained.NTSB FTW92FA067Accident · 2 fatalField investigationFinal reportCessna 150M · Covington, OKThe pilot failed to maintain proper object clearance. A factor was his decision to perform the low pass.NTSB CHI92LA086Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Sandstone, MNThe collision with the deer, the damage to the gascolator which resulted from the collision and the pilot's decision to abort the landing after the collision.NTSB FTW92FA064Accident · 2 fatalField investigationFinal reportCessna 182 · Bartlesville, OKThe pilot's failure to maintain terrain clearance. A factor was the dark night.NTSB FTW92FA061Accident · 1 fatalField investigationFinal reportBellanca 17-30 · Oklahoma City, OKThe second pilot's (left seat) failure to attain a positive rate-of-climb during an instrument takeoff, and inadequate supervision by the pilot-in-command. Factors were: the weather, and the copilot's lack of instrument flight time and training.NTSB SEA92IA040Incident · Minor injuriesIncident investigationFinal reportPiper PA-28R-200 · Anacortes, WAA bird impacting the aircraft.NTSB LAX92LA095Accident · No injuriesLimited investigationFinal reportCessna 150J · Pinyon, CAThe flight instructor's inadequate in-flight planning to enter a mountainous area at a low altitude, and his improper handling of the airplane. Factors which contributed to the accident related to the instructor's lowering of the wing flaps during a time when…NTSB CHI93LA381Accident · No injuriesLimited investigationFinal reportCessna 172 · Union Center, SDImproper planning/decision by the pilot, and his failure to abort the takeoff, while there was sufficient runway remaining. Factors related to the accident were: the soft runway condition & fence at the end of the runway.NTSB LAX92FA088Accident · 5 fatalField investigationFinal reportBell 206BIII · Crockett, CAThe pilot's failure to maintain vigilant watch for obstructions while intentionally cruising slowly at a low altitude. A factor was the power line was supported by distant towers, and the line was not conspicuous.NTSB MIA92LA057Accident · 1 fatalLimited investigationFinal reportWalter R. Penney VARI-EZE · Lamar, MSThe pilot in commands departure into and continued flight in instrument meteorological conditions while operating under visual flight rules resulting in an inflight collision with trees and then the ground.NTSB LAX92FA082Accident · 4 fatalField investigationFinal reportCessna 421C · Mammoth Lakes, CAThe failure of the pilot to plan and conduct his departure flight to avoid high mountainous terrain, during which the pilot became lost/disoriented. Contributing to the accident was self induced pressure to depart before the arrival of a snow storm.NTSB CHI92FA062Accident · 2 fatalField investigationFinal reportCessna 172M · Sanford, MIThe pilot-in-command's failure to maintain a visual lookout to avoid a wire strike. Factors were the pilot-in-command's intentional low level flight, his failure to maintain proper altitude, and the transmission wires.NTSB NYC92FA050Accident · 3 fatalField investigationFinal reportBeech A36 · Wilmington, OHThe failure of the pilots to maintain adequate terrain clearance. Factors which contributed to the accident were: the night conditions, reduced visibility due to fog, and the likelihood that the pilots diverted their attention to the operation of the loran…NTSB FTW92LA047Accident · No injuriesLimited investigationFinal reportCessna 182D · Carlisle, ARThe parachute jumper's reserve parachute inadvertently opening, for undetermined reasons, resulting in the jumper impacting the right horizontal stabilizer.NTSB NYC92LA043Accident · No injuriesLimited investigationFinal reportCessna 177B · Dalmatia, PAThe pilot's failure to maintain proper altitude and object clearance which resulted in a collision with power lines.NTSB FTW92LA038Accident · No injuriesLimited investigationFinal reportCessna 172B · Tulsa, OKClearance was not maintained and the airplane struck a wire. A factor was the aircraft had been stolen by two unknown individuals.NTSB FTW92LA033Accident · No injuriesLimited investigationFinal reportBoeing 737-200 · Lubbock, TXThe in flight collision with geese. A factor was the dark night.NTSB LAX92LA049Accident · No injuriesLimited investigationFinal reportPiper PA28R-201 · Gila Bend, AZThe animal on the runway. Contributing to this accident was separation of the right main landing gear due to overload and the dark night.NTSB CHI92FA032Accident · 3 fatalField investigationFinal reportBeech B100 · Romeo, MIThe pilot in command's improper inflight decision and the minimum descent altitude disregarded during an instrument approach.NTSB FTW92FA024Accident · 1 fatalField investigationFinal reportBeech V35TC · Jasper, TXThe pilot's failure to continue a normal climb after takeoff due to spatial disorientation. A factor was the dark night condition.NTSB MIA92LA028Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Groveland, FLPoor in-flight planning/decision by the pilot-in-command resulting in the off airport landing. Contributing to the accident was his lack of total experience.NTSB CHI92LA026Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Charles City, IAProper glide path not maintained. Factors in the accident are the premature landing gear extension and inadequate airspeed by the pilot in command.NTSB CHI92LA025Accident · No injuriesLimited investigationFinal reportCessna 182A · Bowling Green, MOInadvertent deployment of the sky diver's parachute.NTSB ATL92FA020Accident · 1 fatalField investigationFinal reportPiper PA-24 · Engelhard, NCThe spatial disorientation experienced by the pilot, and his inadvertent descent into the terrain. A factor was the dark, night lighting condition at the time of the accident.NTSB MIA92LA022Accident · No injuriesLimited investigationFinal reportCessna 150 · Coleman, FLFailure of the unqualified pilot to maintain the proper glidepath while on final approach. Also, failure to perform the correct remedial action resulting in the collision with a power line.NTSB NYC92LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R · Caldwell, NJThe pilot allowed the airplane to get too low on final approach during a night visual landing. Factors in the accident were: the pilot improperly planned the approach, dark night and a lack of flight experience in night operations.NTSB NYC92LA023Accident · No injuriesLimited investigationFinal reportBeech B23 · Bombay, NYFailure of the pilot to use all the available take off area.NTSB NYC92LA020Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Groton, CTThe pilot's failure to maintain the minimum descent altitude during the approach. A factor was pilot fatigue.NTSB LAX92LA029Accident · 3 fatalLimited investigationFinal reportBell 206B · Vallejo, CAThe pilot's intentional flight into known adverse weather, continued flight into instrument meteorological conditions, and improper altitude. Contributing to the accident was low ceilings, poor visibility, and restricted visual lookout.NTSB NYC92DHA01Accident · 1 fatalFinal reportJesse Knight Long EZ · Milford, PAThe pilot's inadequate visual lookout.NTSB LAX92LA021Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Fremont, CAThe pilot's inadequate altitude on final approach.NTSB FTW92LA012Accident · No injuriesLimited investigationFinal reportNorth American Navion · Denison, TXThe exceeding of the airplane's takeoff performance capability by the pilot's inadequate preflight preparation..NTSB NYC92LA010Accident · 1 fatalLimited investigationFinal reportBalloon Works Firefly 7 · Webster, NHFailure of the ground crewman (from another Balloon) to recognize the hazardous condition that existed, when the Balloon came in contact with a high voltage power line during a precautionary landing. Factors related to the accident were: the lack of suitable…NTSB CHI92FA013Accident · 2 fatalField investigationFinal reportPiper PA28-140 · Lafayette, INFailure of the pilot to compensate for wind conditions during initial climb. Factors associated with the accident are crosswind conditions and a dark night light condition.NTSB ATL92LA012Accident · Serious injuriesLimited investigationFinal reportDon Jackman Pitts S-1S · Franklinville, NCThe failure of the pilot to maintain proper clearance from the power line.NTSB SEA92FA013Accident · 3 fatalField investigationFinal reportCessna 172N · Columbus, MTThe pilot in command's operation at too low an altitude over the river and his failure to maintain adequate clearance from the power lines. Factors contributing to the accident were the wires crossing the river and the pilot in command's poor judgement in…NTSB SEA92LA010Accident · No injuriesLimited investigationFinal reportCessna 172C · Colville, WAThe pilot's delayed go-around. Factors contributing to the accident was the pilot's misjudgement of distance and speed during the approach.NTSB NYC92LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Lincoln, METhe pilot's failure to see and avoid the transmission lines. A factor was the sunglare.NTSB SEA92FA002Accident · 4 fatalField investigationFinal reportCessna 172G · Miltonfreewater, ORInadequate in-flight planning. Factors to the accident were: mountainous terrain, clearance not maintained, lack of total flight experience, and lack of familiarity with geographical area.NTSB MIA92LA003Accident · Minor injuriesLimited investigationFinal reportBell 47D-1 · Clewiston, FLThe pilot in command's failure to maintain adequate clearance while maneuvering resulting in an in flight collision with a guy wire.NTSB SEA91FA255Accident · 3 fatalField investigationFinal reportLake LA-250 · Sisters, ORImproper planning/decision by the pilot(s), and failure to attain sufficient altitude to remain clear of obstructions. Factors related to the accident were: the pilot(s) failure to use all available runway, high density altitude, rising terrain and trees…NTSB NYC91LA251Accident · Minor injuriesLimited investigationFinal reportCessna C-152 II · Blue Bell, PAThe pilot failed to maintain directional control of the airplane, resulting in the airplane drifting to the left of the runway and impacting with a windsock pole. Contributing factors in the accident were the pilot's inadequate compensation for a crosswind…NTSB ATL91LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Newberry, SCThe pilot's failure to maintain visual lookout and clearance while maneuvering at a low altitude.NTSB SEA91LA254Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Kaycee, WYInadequate clearance with the vehicle and the pilot's failure to obtain proper assistance for the takeoff. Factors contributing to the accident were 1) the pilot's inadequate preflight planning, 2) the vehicle, and 3) high density altitude conditions.NTSB FTW91LA166Accident · Minor injuriesLimited investigationFinal reportBell 47G-5A · Pearsall, TXThe pilot's failure to maintain adequate visual lookout for obstacles during operations from a remote site.NTSB NYC91LA244Accident · Serious injuriesLimited investigationFinal reportCessna 170B · E. Stroudsbury, PAImproper takeoff planning by the pilot which resulted in the airplane striking trees during initial climb. A factor related to the accident was the failure of the pilot to make his departure turn in a timely manner.NTSB SEA91LA242Accident · Serious injuriesLimited investigationFinal reportAeronca 7DC · Yellow Pine, IDImproper inflight planning/decision by the pilot, which resulted in inadvertent flight into a box canyon and subsequent collision with trees, when there was insufficient space to reverse course and the aircraft would not outclimb rising terrain. The terrain…NTSB DEN91FA132Accident · 2 fatalField investigationFinal reportCessna 172N · Tererro, NMA failure of the pilot to maintain adequate obstacle clearance in mountainous terrain. Factors were: lack of familiarity with the aircraft, and insufficient standards by the operator.NTSB CHI91FA294Accident · 3 fatalField investigationFinal reportBell-K Copter 47D1 · Laurie, MOPoor judgement of the pilot, due to impairment from consumption of alcoholic beverage before flight, his intentional buzzing, and his inadequate visual lookout (failure to see-and-avoid power lines).NTSB BFO91LA083Accident · No injuriesLimited investigationFinal reportCessna 152U · Burnt Chimney, VAImproper planning/decision by the pilot. The uphill runway and obstructions (trees) near the departure end of the runway were related factors.