FAA incident reports
234,323 FAA reports of aviation accidents and incidents, from the FAA’s Accident/Incident Data System (AIDS) through its Aviation Safety Information Portal. An incident falls short of an accident: a bird strike, say, or a gear-up landing without substantial damage. The NTSB investigates accidents separately, and its record of an accident is the fuller one.
Reports, newest first
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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.
Incident 20021102034669IBeech 1900D · Mccook, NE(-23) During a night, IFR runway 12 approach at mck, gl 5035'S left wing tip contacted the runway. A go-around was executed, unable to see the runway on the second approach the aircraft diverted to grand island, NE where the damage to the left wing tip was…Incident 20021102030939ICessna 152 · Opelika, AL(-23) On November 2, 2002, at 1300 CST, a CE-152, N5252B operated by Mr. Wint, made an emergency landing on highway 431 north of oppelika, Alabama. Visual meteorological conditions prevailed, and the pilot and one passenger received no injuries and there was…Incident 20021102030899ILear 35A · Rifle, CO(-23) Upon landing at Rifle, CO, on runway 26, the high pressure hyraulic line from the left engine failed, causing loss of brakes and complete hydraulic failure. The pilot states he turned on the standby hydraulic pump and deployed the emergency parachute.…Accident 20021102030709ABlanca 1730A · Pell City, AL(-23) On November 2, 2002, at 1640 CST, a bllanca BL-17-30A, N9558E registered to and operated by a private individual, crashed while attempting to land at st. Clair county airport, Pell City, Alabama. Visual meteorological conditions prevailed. The…Accident 20021102030459ABell 47G2 · Pollickpines, CA(-23) During take off helicopter struck bush and crashed.Accident 20021102030419ACessna T182T · Long Beach, CA(-23) On November 2, 2002, flight instructor, carol anastasia andrews, and her student, michael eric mcleod prepared for a flight lesson at Long Beach airport in Long Beach, California in Cessna T182, N184TA, owned and operated by Mr. Mcleod and his family.…Accident 20021101036079AGulstm 500B · Rayville, LA(-23) There were several witnesses that either heard the airplane or saw the airplane for a few seconds before it disappeared from their view. One witness, who is a private pilot, reported seeing the airplane at a low altitude (1,000 feet) doing power off…Incident 20021101035249ICessna 337G · Detroit, MI(-23) Mr. Pacioccao was in the left seat receiving a bi-annual flight check. Mr. Picioccoe was on his 4th touch-and-go when they landed with the gear up (Mr. Robert labuhn was the PIC). The aircraft slid approximately 500'. There were not injuries. This…Accident 20021101032939AAmtr Firestarii · Birchwood, AK(-23) On 11/01/2002 about 1300 ast, a wheel equipped kolb fire star, N8199, sustained substantial damage during takeoff at Birchwood Airport, Birchwood, AK. The amateur/homebuilt was being operated as a visual flight rules (VFR), local area, personal flight…Incident 20021101032379IPiper PA32300 · Wilmington, NC(-23) N9028K a PA-32-300 aircraft operated by a commercially rated pilot and co-owner of the aircraft along with 2 passengers was enroute from new bern, NC to st. augustine, FL, under title 14 CFR 91. At approximately 8 miles west of the Wilmington, NC…Incident 20021101031809IPiper PA28R200 · San Jose, CA(-23) Aircraft landed without having the landing gear extended. The gear handle was found in the up position. Gear horn was tested and worked properly.Incident 20021101031779IMooney M20E · Tucson, AZ(-23) After doing airwork for 1.5 hours, the flight instructor and student returned to the airport for touch and go's on runway 24L. Student was habitually coming in low carrying power. After the first touch and go, the aircraft was assigned right traffic rwy…Accident 20021101031219AGulstm 690B · San Antonio, TX(.19) On November 1, 2002, approximately 1550 central standard time, a rockwell 690B twin-engine airplane, N77UA, sustained substantial damage after the top portion of the airplane's rudder separated during cruise flight. The airplane was registered to and…Incident 20021101031059ICessna 340A · Eugene, OR(-23) N102TP C-340 was practicing t&go's @eug when he landed and blew both main tires, a/c blk rnwy from 1840ZTO 1912Z. A/c was not damaged except for the tires. A/c towed to FBO for insp and repair. PIC stated via ph call that a/c had recently had new brake…Incident 20021101031009IDoug DC932 · Pittsburgh, PA(-23) On 11/01/02, airtran flight 985 a DC-9-32, made an emergency landing on runway 32, at Pittsburgh international airport (pit), shortly after departure due to smoke in cabin as reported by flight attendant. The airplane landed without incident and…Incident 20021101030829IRobsin R22BETA · Lawrence, MA(-23) Instructor pilot was instructing student pilot to recover from a low rotor RPM condition while hovering at ten feet above the ground. Student pilot initiated an incorrect procedure which caused the rotor RPM to decay rapidly and a hard landing occurred.…Accident 20021101030259AHughes 269A · Fortgibson, OK(.19) On November 01, 2002, approximately 1150 central standard time, a Hughes 269A helicopter, N8885F, impacted the terrain following a loss of control during cruise flight near fort gibson, Oklahoma. The helicopter was owned and operated by tundra resources…Accident 20021101030249APiper PA24180 · Corona, CA(.19) On November 1, 2002, about 1740 pacific standard time, a Piper PA-24-180, N5129P, experienced the collapse and separation of one main landing gear assembly during rollout at the Corona Municipal Airport, Corona, California. Thereafter, the airplane…Incident 20021101029329IAirbus A320232 · New York, NY(-23) Jet blue flight 0003 (a/c N503JB) was unable to retract landing gear after departure from buf. Decision was made to land at jfk where a tower fly by revealed the nose wheels were turned 90 degrees to the flight path. Aircraft landed on runway 22R when…Accident 20021031037779AHughes OH6A · Marietta, PA(-23) On October 31, 2002, at 1721 hours local eastern daylight savings time, a Hughes helicopter HU-369-OH6A, N817SC, flew into the susquehanna river while flying at low levels over the river in east donegal township, PA. Visual meteorological conditions…Accident 20021031037319ABbavia 7AC · Warner Robins, GA(-23) While hand propping the Aeronca/7AC, s/n 7AC-2329 for a flight. Mr. Shema stated "the aircraft started and jump the chalk he had under the right tire." The circular tire marks left in the grass indicate the aircraft made numerous left hand circles in…Incident 20021031037269IBell 206L4 · New Orleans, LA(-23) The pilot in command reported that immediately after lift-off from the helipad the helicopter rolled to the left. He applied full right cyclic and rapidly lowered the collective to land as soon as possible. These actions resulted in a level, hard…Incident 20021031033459IPiper PA23160 · Houston, TX(-23) After completing a landing, a take-off was executed. At rotation speed, a deer struck the aircraft on the right main landing and gear doors. The take-off was aborted. No injuries and very minor damage to aircraft.Incident 20021031033359IBeech 95C55 · Bridgeport, CT(-23) This aircraft was performing touch and go on runway 06. After completing the touch down in a normal landing with flaps extended, Mr. Jared gowlis the certificated flight instructor instructed Mr. Sanchez his student to raise the flaps. Mr. Sanchez…Accident 20021031032759APiper PA28R200 · Mountain City, TN(.19) On October 31, 2002, at 0950 eastern standard time, a Piper PA-28R-200, N15704, registered to dorsch aviation, LLC, and operated by the private pilot, collided with trees and terrain while maneuvering in laurel bloomery, Tennessee. The personal flight…Accident 20021031032729ACessna 182S · Accident, MD(-23) Non-instrument rated pilot departed claremont county airport, Ohio on a cross country VFR trip to his home base at meridian CT. (Mmk) airport. The pilot was receiving flight following from clarksburg approach. As the aircraft approached the west…Accident 20021031032249ABeech F33A · Fernandina Beac, FL(-23) During test flight, after maintenance, for the replacement of both magnetos and a stand-by alternator, the engine lost power at approximately 2500 feet MSL. Pilot attempted to restore engine power, but was unsuccessful. Pilot then attempted to return to…Incident 20021031032179ICessna 172N · San Diego, CA(-23) On October 10, 2002, Mr. Gary tomes and Mr. Joseph leone were the flight crewmembers of an aircraft that ran out of fuel on an instrument instruction flight originating from Montgomery airport (myf) to oxnard airport (oxr) and return. Upon engine…Incident 20021031032159ICessna 172P · Ft Worth, TX(-23) The student pilot had just been endorsed for solo flight by his flight instructor and had made two normal landings. This incident occurred during the third landing at Alliance airport in fort Worth, Texas. The student pilot experienced a gust of wind…Incident 20021031032099IPiper PA31350 · Watkins, CO(-23) Aircraft was on ILS approach to front range airport. Pilot stated he broke out of overcast at approx. 300 feet at which time he disengaged autopilot and continued to fly manually to landing. Because of front windshield being almost totally obscured with…Incident 20021031031479IAmtr CH601HDS · Morrilton, AR(-23) On October 31, 2002 at approximately 11:00 hours, N64041, experimental ayers RV-6 was substantially damaged resulting from a ground incident. The pilot in command began a cross-country flight from west monroe, la enroute to clarksville, AR. In the…Accident 20021031031349ACessna 177RG · Marshall, AR(-23) On October 31, 2002, at 1110 central standard time, a Cessna 177RG, registration number N35866, serial number 177RG1065 while being operated by commercial pilot gene malcolm richardson, sustained substantial damage during an emergency landing in a field…Accident 20021031031159ACessna 172N · Porter, TX(.19) On October 31, 2002, at 1820 central standard time, a Cessna 172N single-engine airplane, N1317E, was substantially damaged when it impacted wires and terrain during a forced landing after takeoff from the Williams Airport, Porter, Texas. The airplane…Accident 20021031030309ACessna 172G · Ft Stockton, TX(-23) On October 31, 2002, at 2310 central daylight time, a Cessna 172G, N6072R was substantially damaged during a collision with terrain while executing a precautionary landing because of low fuel/fuel exhaustion 1 mile from fort Stockton, Texas municipal…Incident 20021031030029ISwrngn SA227AC · Casper, WY(-23) While in climb out from Casper, WY airport, the right engine oil pressure caution light came on. The flight crew checked the right oil pressure gauge and noticed it was also going down in pressure. The right engine was feathered and shut down. Flight…Incident 20021030036739ICessna 172P · Vero Beach, FL(-23) The student pilot on a cross country elected to land at Vero Beach airport. The winds were 12 to 14 knots from 220 degrees, the landing runway was 29. After landing the aircraft touched down and during roll out was allowed to rotate between the nose and…Incident 20021030036129IPiper PA28151 · Jacksonville, FL(-23) Brittany marlier was on first supervised solo. Mike bailey her instructor said on the 2nd landing the aircraft swerved to the left back to the right then back left, left the runway and slid sideways through the grass, and stopped between taxiway and the…Incident 20021030034589IBeech 1900D · Dallas-Ft Worth, TX(-23) On October 30, 2002, at 15:30 local time, aircraft N140ZV enroute from hro to dfw, upon landing crew reported that the right brake assembly had bad brake action. The captain said that the right brake was mushy, and that the brake pedal was depresses 3/4…Incident 20021030031439ICessna 152 · Houston, TX(-23) After bounced landing attempts on runway 35R, pilot went around for another landing attempt. On second landing attempt, aircraft settled onto nose strut since the nose tire and nose tire fork was now absent. Nose strut stub and propeller struck runway.…Incident 20021030030839IBeech 1900D · PA(-23) On September 30, 2002, at 20:15 local time, aircraft N231YV while en route from pit to lbr, nose landing gear annunciator did not illuminate after the crew lowered the gear handle. Crew checked the bulb in the annunciator which they said was "ok," then…Accident 20021030030519APiper PA31T · Hobbs, NM(-23) On October 30, 2002, at approximately 0729 MST, local time, the pilot of a Piper PA-31-T cheyenne aircraft, N3998Y, after departure and during climb-out in IMC conditions, lost control and impacted the ground at approximately 3 miles north of Hobbs lea…Incident 20021029035779IBeech 35C33 · Show Low, AZ(-23) Pilot stated that he thought he had put the landing gear down but could not swear to it but he does specifically remember that he did not verify the gear down with the floor indicator. He additionally stated that he did hear the gear warning horn just…Accident 20021029033339ACessna 180A · Larsonbay, AK(-23) (Pilot was out of town on 11/12/02 till 11/26/02). Pilot fly's for f & w, no prior accidents/incidents. Has cabin on a beach 6 miles south east of larsen bay. He said the approach he had to use comes over a high cliff and has two trees, 60' tall that…Accident 20021029033319AHughes 369D · Wahiawa, HI(-23) Aircraft was attempting to fly from a high degree of slope (right skid low). Dynamic rollover occurred. Additional strong winds were experienced from left front of aircraft.Accident 20021029030699ACessna A188B · La Grange, TX(-23) A CE-188 which was not equipped with an aviation radio, entered left traffic (published) for runway 24 at big spring, Texas. A radio equipped PA-22 entered right traffic for runway 24 at big spring. At approximately 200 to 300 feet above ground level…Accident 20021029030679APiper PA22 · Palmer, AK(-23) The airman indicated that during takeoff, he allowed the aircraft to become airborne with insufficient airspeed. The aircraft settled onto a gravel bar and collided with rocks. The impact collapsed the left main landing gear and then the right main…Accident 20021029030669ACessna 172S · St Paul, MN(-23) The investigation did not uncover any contributing factors associated with this accident. Student pilot received additional ground and flight instruction and was endorsed for solo flight.Accident 20021029030599APiper PA22 · La Grange, TX(-23) A CE-188 which was not equipped with an aviation radio, entered left traffic (published) for runway 24 at big spring, Texas. A radio equipped PA-22 entered right traffic for runway 24 at big spring. At approximately 200 to 300 feet above ground level…Accident 20021029030559ACessna T188C · Seminole, TX(-23) On October 29, 2002, at approximately 10:45 CST, local time, the pilot of a Cessna 188-T agricultural aircraft, N4779J, experienced loss of power. While enroute to the spraying area, N4779J made an emergency landing on a cotton field located 5 miles…Accident 20021029029959ACurtis C46DFLYTIGER · Fairbanks, AK(-23) Aircraft right main landing gear collapsed during rollout after landing. Aircraft had progressed approximately 2000 feet after touchdown and was preparing to exit the active runway when gear collapsed. [privacy data omitted] (.19) On October 29, 2002,…