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 20041127032419ICessna 172P · Boulder City, NV(-23) Per telephone interview with pilot on 1/06/05, pilot stated he flew solo for about one hour practicing takeoffs and landings. Winds were light at beginning of flight but became gusty during last approach and landing. Strong gust blew aircraft off runway…Accident 20041127030699AAmtr Kitfoxspeeds · Sterling, MA(-23) "I flew this morning after a normal preflight showed no abnormalities. Fuel was 3/8 full. Oil was ok. I flew locally for about 45 minutes and took my passenger home. I returned to the airport and did my walkaround. The fuel was slightly below 3/8 full.…Accident 20041127030469ARobsin R22BETA · Arlington, WA(-23) On November 27th @ approx. 9:30 am, N4029Q a Robinson R-22 helicopter with two people on board was flying nw of Arlington airport at an unknown altitude and for an unknown reason, broke up in-flight and scattered debris for approx. 3/4 of a mile and…Incident 20041127030109IBeech J35 · Houston, TX(-23) The pilot [privacy data omitted] stated that on nov. 27, 2004 he departed the kerrville airport enroute to the pearland regional airport. Upon entering a left downwind for runway 32L extended his landing gear @ 140 KIAS. He observed a gear down and…Incident 20041127029689IAmtr Aircamper · Apex, NC(-23) Aircraft lost power in cruise flight, engine was only producing 1300 RPM with a loss of 400 fpm. Pilot landed safely on hwy 64 near Apex, NC. Minor damage to aircraft, no injuries to pilot.Incident 20041127029399IPiper PA28161 · Factoryville, PA(-23) Student was practicing landings on runway 22 at Seamans airport (9N3), Factoryville, PA. Student was not lined up with the centerline and executed a go-around at a low altitude and hit a runway light, causing damage to the propeller. Student flew the…Incident 20041127028809IDoug DC951 · Kansas City, MO(-23) During takeoff, at 110-120 KTS, smoke entered flight deck. The takeoff was aborted and aircraft returned to the gate without incident. This incident [privacy data omitted] is closed.Accident 20041126034919APiper PA28180 · Appomattox, VA(-23) Airman states he was landing to northwest on a grass strip, as he had done many times before. Although the wind was light and variable, he felt the aircraft sink as if in a windshear. The airman failed to maintain airspeed on final approach. The…Incident 20041126034259IBoeing 7375H4 · Jackson, MS(-23) Passenger was smoking a cigarette in the forward lavatory. [privacy data omitted] Injury summary not known by ASI.Incident 20041126031529IPiper PA32R301T · Porterville, CA(-23) During a flight under visual flight rules from van nuys, CA to mammoth, CA, the pilot noted that the alternator was not charging. Initially, an annunciator light was blinking on and off followed by the load meter indicating battery discharge. The pilot…Incident 20041126030189IBolkms BK117B2 · Sioux City, IA(-23) EMS helicopter operated by air methods had flown from mercy hospital in Sioux City, Iowa, to pierson, Iowa, with the pilot and two medical attendants to pick up a patient. After arriving in pierson, it was decided that the patient would be transported…Incident 20041126029729IDoug DC3 · Honolulu, HI(-23) Right engine was shut down due to low oil pressure. The flight crew declared an emergency and landed without any further problems. Finding: oil pressure relief valve had a piece of debris in an oil passage. The debris has been identified as a snap ring…Accident 20041125035109APiper PA28181 · York, PA(-23) The pilot aborted take-off on runway 17 at the York Airport (thv), in thomasville, Pennsylvania. The pilot [privacy data omitted] over ran the runway and hit a fence past the end of the runway.Accident 20041125033799ACessna 411 · Corona, CA(-23) On November 25, 2004, a Cessna 411, operated by a private pilot crashed shortly after takeoff approximately one mile from the departure end of runway 25 at the Corona airport. The pilot and one passenger were fatally injured. The accident was witnessed…Incident 20041125031749ICessna 152 · Ann Arbor, MI(-23) Student pilot lost control during landing. Aircraft touched down hard on nosegear, "porpoised", landed hard and smashed nosegear and propeller.Accident 20041125031369AAmtr Longez · Huntsville, TX(-23) The pilot [privacy data omitted] was enroute from lufkin (lfk) to college station (cll) descending from 5500 feet to 4500 feet when the engine in his long-ez, N234BW quit. The pilot [privacy data omitted] executed an off-airport landing approximately 20…Accident 20041125029759ACessna 195 · Kilmichael, MS(-23) Aircraft was flying low towards private residence. Aircraft struck power tension wires, and crashed into back of residence. Both pilot and sole passenger received fatal injuries.Accident 20041124035489ACessna 172E · Rupert, WV(-23) Just prior to the accident the OAT was indicated in the aircraft as 35 degrees farenheit. The aircraft altitude was reported to be 4500 feet. A light mist was encountered by the pilot approximately 10 to 20 minutes north of kroa. This mist was reported…Accident 20041124035479ACessna 310R · Waterford, VA(-23) On November 24, 2004, at 1209 eastern standard time, a Cessna 310R, N310DM, was substantially damaged after impacting terrain in paeonian springs, Virginia, during an approach to the leesburg executive airport (jyo), leesburg, Virginia. Instrument…Accident 20041124034269APiper PA22160 · Prescott, AZ(-23) Conversation with the pilot [privacy data omitted] revealed he had 3.5 hrs in this type of aircraft. Attempted take-off, became airborne, and decided he was not satisfied with the aircraft performance. Decided to land on remaining runway. Departed…Accident 20041124032899AAmtr TAILWINDW8 · Davey, NE(-23) N191AS, an [privacy data omitted] tailwind W-8, lost RPM and oil pressure during cruise flight. The pilot had departed crete municipal airport for a local flight when the aircraft lost RPM and oil pressure. He landed in a field, and the main landing…Incident 20041124032879IBeech B300 · St Louis, MO(-23) Pilot stated that they were on a stabilized approach with low visibility, approx. 1.5 miles in blowing snow with rain mixed in, approx. 3/8 inch of ice on aircraft with gusty winds from 320 deg at 17 knots gusting to 21. She reported seeing the approach…Incident 20041124032659IBeech 76 · Kissimmee, FL(-23) During takeoff roll nose gear collapsed, pilot reported that the aircraft was approximately 30KTS, engines were shut down immediately. Damage to aircraft minor.Incident 20041124030119IPiper PA22150 · Liberty, MO(-23) The pilot departed runway 36 in a light gusty crosswind from the northwest at about 10 knots. He said he did not position the ailerons properly for the wind and the wind got under the left wing. The airplane went off the right edge of the runway tilting…Incident 20041123034609ICleveland, OH(-23) Passenger [privacy data omitted] smoked cigarette in aircraft lavatory while in flight while "no smoking" sign illuminated and after "no smoking" briefing. Flight attendant found the cigarette butt still burning in the trash. ^^injury summary not known…Incident 20041123034209IDhav DH82C · Hawthorne, CA(-23) During the landing phase of flight at Hawthorne airport (hhr), the pilot experienced a gust of wind during the landing flare. As a result, the aircraft landed hard on its main wheels and nosed over onto the propeller. The left wheel and tire separated…Accident 20041123032939ACessna 150H · Columbia, IL(-23) The mishap flight departed memphis, TN enroute to the spirit of st. louis airport, (ksus), chesterfield, MO on an IFR flight plan. Prior to departing memphis the mishap pilot asked the line service person to put 10 gallons of fuel in his aircraft, 5…Incident 20041123032689IMooney M20G · Lakeland, FL(-23) N6702N was on final approach and tower requested him to do a 360 turn for spacing on other traffic, and pilot forgot to lower the landing gear and landed gear up with minor damage to the aircraft.Incident 20041123032609IBoeing 717200 · Honolulu, HI(-23) Hawaiian airlines flight 592, a Boeing 717 aircraft, was cleared by ATC to enter the inter-island ramp on taxiway lima. Upon leaving taxiway alpha, lima and golf are in a non-movement area for ATC. The normal entrance to the inter-island ramp is taxiway…Incident 20041123031569IEMB EMB145 · Cleveland, OH(-23) Passenger refused to comply with crewmember instructors to stow bag prior to taxi, both from flight attendant and pilot. Passenger made sarcastic reference to bomb. Crewmembers not comfortable allowing him to remain on aircraft and passenger was removed…Incident 20041123030459IPiper PA28161 · Bedford, MA(-23) The pilot [privacy data omitted] reported a normal landing at approximately 70 knots on runway 29. Weather was clear, calm, and dry. The pilot [privacy data omitted] reported that with initial brake application after landing, a loud noise was heard and…Accident 20041122034939AGulstm G1159A · Houston, TX(-23) Aircraft crashed 3 miles short of Houston Hobby airport during a positioning flight. Weather at the time of the accident was 1/8 mile visibility with 100 foot broken clouds.Accident 20041122034349ATcraft BC12D · Cocoa Beach, FL(-23) Witnesses at a school and a city facility adjacent to the accident site reported that the airplane initially flew over the area at low altitude and low speed then left the area to the north for a few minutes. One of the witnesses, a teacher, reported…Incident 20041122034109IPiper PA28140 · Tyler, TX(-23) Private pilot was caught on top of an overcast cloud layer. With direction and help from ATC, N7201J was vectored to VMC weather until PIC was able to descend in an opening in the overcast. PIC was able to descend to a VFR landing at Tyler, TX (tyr).Incident 20041122033479ICndair CL6002B19 · Allentown, PA(-23) Incident [privacy data omitted] was reported by air traffic because of a loss of separation between ASH2618 and AAL366. The required separation was lost when the flight crew of ASH2618 responded to a GPWS warning of "gear horn, terrain terrain, sink…Incident 20041122031049IAmtr Kitfoxiii · Pine Island, FL(-23) On November 22, 2004 (item 3) at 1030 EST (item 9), a l.h. randall, Kitfox iii, N934LR (item 13), registered to [privacy data omitted], collided with a mangrove at Pine Island, Florida, while on a pleasure flight. Visual meteorological conditions…Incident 20041122030179IBeech E55 · Minden, NV(-23) The cabin door popped open during climb-out, at approximately 300 feet AGL, after which, the aircraft experienced elevator flutter and a dramatic rolling tendency. During landing, the right wingtip scraped the ground and right propeller tips struck a…Incident 20041122029919IConaer LA4200 · Deland, FL(-23) On November 22, 2004, at approximately 1800 hours, at the Deland municipal airport, located in Deland, FL, Mr. William andrew gibson, the pilot, landed aircraft N8542Z, a lake model, LA-4-200, (amphibious) with it's landing gear retracted. Mr. Gibson…Accident 20041122029559AHughes 269C · Rialto, CA(-23) During take-off the pilot encountered a loss of RPM when transitioning from a hover to forward flight causing a forced landing onto a steep hillside. Upon ground contact, the helicopter rolled downhill two complete rolls, stopping on its left side…Accident 20041121034989ACessna 172R · Martinsburg, WV(-23) Pilot was conducting touch and go landings on runway 26. Aircraft was landed hard on the nose gear. The nose gear collapsed and the airplane skidded off the runway onto the grass. The pilot was the only person on board. There were no injuries.Accident 20041121034089AEnstrm F28A · Smyrna, TN(-23) Pilot stated he lost power on landing resulting in a hard landing in soft dirt breaking the left skid and rolling the aircraft on its left side. Examination of the helicopter and engine by the factory representative, two helicopter mechanics, and two…Incident 20041121032459IPiper PA28181 · Corsica, SD(-23) On Sunday, November 21, 2004 a Piper archer pa 28-181 owned by [privacy data omitted] lost power during cruise flight from yankton to pierre, SD. VFR conditions prevailed and no flight plan was filed. The aircraft right wing received minor damage when…Accident 20041121032199ACessna 172S · Anderson, IN(-23) On November 21, 2004, at approximately 2025Z, the pilot [privacy data omitted] was the sole occupant and manipulator of the controls of N967SA, a 2002 Cessna 172S, during a solo cross-country flight originating from south bend, IN (sbn), and ending at…Accident 20041121032159AAmtr Sonex · Oconomowoc, WI(-23) On November 21, 2004, at 1435 CST, an amateur built Sonex aircraft, volkswagen powered, N478SX registered to, built by and piloted by[privacy data omitted]experienced an engine roughness and then failure while cruising at 3000 feet. The subsequent…Incident 20041121031919IDoug DC982 · Denver, CO(-23) On November 21, 2004, at 1038 mountain standard time, a mcdonnel Douglas DC-9-82, N234AA, operated as American airlines flight 1115, sustained minor damage when during landing at Denver International Airport (den), Denver, Colorado, the airplane struck…Accident 20041121031209ACessna 172B · Zephyrhills, FL(-23) PIC flew N7493X from lal into zph to obtain fuel (at a lower price). After fueling for the return flight to lal, he stated that the aircraft's battery was too weak to start the engine, so he decided to hand crank it without anyone in the cockpit. The…Accident 20041121029869AAmtr RAF2000GTX · Chatham, MA(-23) Date: November 21, 2004 Chatham Municipal Airport (cqx) [privacy data omitted] N9327B [privacy data omitted] [privacy data omitted] N9327B, RAF-2000-GTX, experimental gyrocopter, was flying VFR on a local flight doing touch and go landings at Chatham…Accident 20041121029469AAircre AIRCREATION5 · Emmett, ID(-23) The wreckage was discovered in the foothills on a ridgetop. The evidence at the scene showed nose down vertical impact with the ground. The uncertificated airman was killed on impact. A friend of the airman stated he had witnessed the deceased…Accident 20041121029459AAmtr Skyraider · Port Royal, VA(-23) On November 21, 2004, at 13:26 local time, an unregistered an uncertificated home built aircraft crashed at an ultralight vehicle flight park in rappahannock academy in caroline county Virginia. The sky raider took off and was flying at 100' to 150'…Incident 20041120033719IBeech C24R · San Diego, CA(-23) On November 20, 2004, at approximately 1604 PST, N6713D, a Beechcraft model BE-24 experienced a collapsed nose gear during landing at Montgomery airfield, San Diego, CA. The aircraft was being operated by a private pilot under federal aviation…