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 CHI91LA114Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Burlington, IADelayed initiation of remedial action by the flight instructor. Factors related to the accident are gusty crosswinds, inadequate compensation for wind conditions and not maintaining airspeed by the student pilot, and complacency by the instructor.NTSB FTW91LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tulsa, OKThe pilot's failure to maintain airspeed and altitude on final approach.NTSB NYC91FA080Accident · Serious injuriesField investigationFinal reportBeech F-33A · West Brookfield, MAThe decision of the pilot to fly the airplane in conditions that prevented him from seeing and avoiding higher terrain. Factors related to the accident were the pilot's decision to not follow the instrument approach into palmer, and the reduced visibility due…NTSB LAX91FA116Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Monterey Park, CASuicide.NTSB BFO91LA025Accident · 1 fatalLimited investigationFinal reportCessna 182C · Bonnyman, KYThe pilot's failure to maintain adequate obstacle clearance. Contributing was inadequate altitude.NTSB DEN91LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Timberon, NMThe pilot's inadequate preflight planning and selection of the wrong runway. Related factors were: the rising terrain, trees, and the pilot's lack of experience.NTSB LAX91LA100Accident · Minor injuriesLimited investigationFinal reportMaule M-6-235 · Mobile, AZThe pilots' failure to establish a sufficient climb rate to avoid striking a fence.NTSB FTW91DPA01Accident · Serious injuriesFinal reportDonald E. Samuels Q2 · Gilmer, TXThe pilot's failure to attain proper climb performance.NTSB DEN91FA039Accident · 2 fatalField investigationFinal reportPiper PA-24-400 · Snowmass, COThe pilot's failure to maintain a proper altitude in mountainous terrain.NTSB ATL91FA051Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Liberty, NCFailure of the pilot to maintain a positive rate-of-climb after lift-off. Factors related to the accident were: darkness, low ceiling, fog, and the pilot's limited experience in a Piper PA-23.NTSB LAX91LA088Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Merced, CAA disoriented and intoxicated automobile driver entering the runway in front of the departing aircraft.NTSB ATL91FA047Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Cordele, GAFailure of the pilot to attain proper runway alignment and to maintain proper altitude. Related factors were: darkness and the pilot becoming lost/disoriented.NTSB ANC91FA023Accident · No injuriesField investigationFinal reportChampion 7EC · Eagle River, AKThe pilot-in-command's failure to maintain clearance from the terrain.NTSB CHI91LA074Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Cabool, MOFailure of the pilot to maintain proper runway alignment during a go-around. Factors related to the accident were: darkness and the pilot's lack of understanding of the landing gear electrical system.NTSB ATL91FA040Accident · 4 fatalField investigationFinal reportRockwell 114 · Bessemer, ALFailure of the pilot to follow instrument flight rules (IFR) and maintain the minimum descent altitude (mda) during the VOR approach. Factors related to the accident were: darkness and the adverse weather conditions.NTSB LAX91LA068Accident · No injuriesLimited investigationFinal reportCessna 172N · Ukiah, CAThe failure of the pilot to maintain an adequate clearance from ground obstructions. A factor in the accident was: failure of the pilot to maintain an altitude sufficient to clear all obstructions along his route of flight.NTSB CHI91LA052Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Ignace, MIThe deer crossing the runway which the pilot was unable to avoid.NTSB SEA91LA033Accident · 1 fatalLimited investigationFinal reportErco 415-C · Ola, IDThe pilot's failure to maintain sufficient altitude for terrain clearance. Also causal was the pilot's impairment due to alcohol. Contributing factors were the night light condition and the hilly terrain.NTSB ATL91LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Hickory, NCThe pilots's inadequate visual lookout during flight. A factor in the accident was the pilot's failure to maintain a safe altitude.NTSB FTW91LA021Accident · Serious injuriesLimited investigationFinal reportCessna 150E · Amarillo, TXAn underpowered takeoff attempt due to incorrectly set magnetos. Contributing was the transmission lines.NTSB BFO91LA016Accident · 1 fatalLimited investigationFinal reportCessna 172P · Axton, VAThe pilot's failure to maintain adequate clearance with an obstacle. Contributing was an unmarked powerline and the pilot's lack of familiarity with the geographical area.NTSB MIA91FA035Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Bunnell, FLFailure of the pilot to maintain altitude, while maneuvering at night over an unlighted area, which resulted in a collision with trees. Factors related to the accident were: darkness and possible spatial disorientation of the pilot due to lack of visual ques.NTSB SEA91LA023Accident · No injuriesLimited investigationFinal reportHughes 369D · Mulina, ORIn-flight collision with a rebounding long-line, which caused main-rotor RPM decay and tail-boom separation, compromising the pilot's ability to successfully accomplish an attempted autorotation.NTSB MIA91LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa Locka, FLThe pilot's failure to maintain a positive rate of climb while maneuvering to avoid a flock of birds, resulting in an in flight collision with trees. Factor(s) included: attention diverted.NTSB CHI91LA030Accident · No injuriesLimited investigationFinal reportCessna 177 · Mount Ayr, IAProper touch-down point not attained and go-around delayed by the PIC. Contributing factors were a downwind, crosswind, weather evaluation misjudged, wrong runway selected and lack of total experience by the PIC.NTSB LAX91LA041Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Young, AZThe pilot selected the wrong runway and attempted to land with a tailwind.NTSB CHI91FA031Accident · 4 fatalField investigationFinal reportPiper PA-32-RT300 · Gaylord, MIThe pilot's failure to maintain adequate terrain clearance. Factors which contributed to the accident were: the dark night, adverse weather conditions, and the pilot's overconfidence in continuing VFR flight into these conditions.NTSB SEA91LA017Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Boise, IDThe pilot's delaying remedial action after a poor landing approach.NTSB MIA91LA026Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fort Pierce, FLImproper preflight decision of the instructor pilot to allow the student to takeoff from the soft grass runway and his failure to abort the takeoff.NTSB SEA91LA013Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B Lama · Trout Lake, WAThe pilot's failure to maintain clearance from an obstacle.NTSB ANC91LA011Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Thorne Bay, AKThe pilot's delay in aborting the takeoff.NTSB NYC91LA024Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Buckland, MAThe pilot's failure to execute an aerobatic maneuver at an altitude sufficient to clear the stand of trees.NTSB MIA91LA021Accident · No injuriesLimited investigationFinal reportCessna 170 · Patillas, PRThe accident was failure of the non certificated pilot to lower the flaps to the correct position for takeoff and failure to abort the takeoff due to insufficient acceleration.NTSB CHI91DEP01Accident · No injuriesFinal reportDean Bartel Avid Flyer Stol · New London, WIThe pilot's failure to obtain a proper touchdown point and his delay in initiating a go-around.NTSB ATL91IA014Incident · No injuriesIncident investigationFinal reportBell 412 · Knoxville, TNThe pilot's failure to see and avoid the wires prior to the collision. Factors in the incident were the failure of the ground personnel to adequately inspect the landing zone, the presence of high intensity lights at the lz, and the dark lighting conditions.NTSB NYC91LA022Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Sherburne, NYThe pilot failed to maintain adequate altitude to outclimb surrounding terrain.NTSB NYC91LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Columbia, PAThe failure of the pilot to maintain a proper altitude on final approach and compensate for the headwind. A factor to the accident was the failure of the pilot to recognize his low altitude and execute a go-around.NTSB CHI91LA020Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180D · Crivitz, WIImproper planning/decision by the pilot, and his failure to abort the takeoff (while there was sufficient runway remaining).NTSB DEN91FA012Accident · 2 fatalField investigationFinal reportCessna T210M · Carbondale, COFailure of the pilot to see-and-avoid the power line.NTSB LAX91FA012Accident · 1 fatalField investigationFinal reportCessna 172M · Goleta, CAThe pilot's failure to maintain proper glidepath while on final approach. A contributing factor was sunglare.NTSB LAX91LA011Accident · No injuriesLimited investigationFinal reportBeech C35 · Independence, CAThe pilot's failure to attain an altitude adequate to avoid colliding with ojbects during takeoff.NTSB NYC91FA005Accident · 4 fatalField investigationFinal reportBeech V35B · Ottawa, OHFailure of the pilot to follow the proper instrument procedure and maintain the minimum descent altitude (mda) during an approach to the airport at night in instrument meteorological conditions.NTSB DEN91LA003Accident · 2 fatalLimited investigationFinal reportRaven S-55A · Bernalillo, NMThe pilot to maintain adequate visual lookout, resulting in an inflight collision with power lines.NTSB FTW91DPG01Accident · Minor injuriesFinal reportCessna A-188 · Manila, ARThe pilot's failure to maintain proper clearance from power lines and the inadvertent stall.NTSB FTW91GA001Accident · No injuriesFinal reportMcdonnell Douglas 369E · Anadarko, OKFailure of the pilot to maintain proper visual lookout prior to and during departure.NTSB FTW90DQG05Accident · No injuriesFinal reportCessna T188C · Nazareth, TXThe pilot's failure to maintain obstacle clearance.NTSB CHI90LA277Accident · 1 fatalLimited investigationFinal reportNavion L-17A · Fort Wayne, INPoor judgement of the pilot due to impairment from consumption of alcohol and use of a drug, and his failure to maintain proper altitude/clearance above wooded terrain. Darkness was a related factor.NTSB CHI90LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Amana, IAProper touchdown point not attained and go-around delayed by the pilot in command. Contributing factors were ATC communications inadequate and wet, grass runway with a tailwind environment plus a fence.NTSB LAX90FA332Accident · 4 fatalField investigationFinal reportCessna 500 · San Luis Obispo, CAThe pilot's improper IFR (instrument) procedure, and his failure to maintain the minimum descent altitude (mda) for the approach. The adverse weather was a related factor.NTSB CHI90LA270Accident · Serious injuriesLimited investigationFinal reportBeech F-33A · Osage Beach, MOThe pilot's failure to establish a proper glide path, resulting in contact with trees short of the intended runway.