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 20030912023709ICessna U206E · Lafayette, LA(-23) Pilot failed to extend the landing gear on landing and landed on floats.Incident 20030912023569IBoeing 737 · Cleveland, OH(-23) Passenger on swa flight 2306, [privacy data omitted] went to the rear of the aircraft and smoked a cigarette. This occurred while the aircraft was at the gate, having returned to the gate after a precautionary landing following a birdstrike on…Accident 20030912023509ACessna 182D · Rushville, IN(-23) On 09/12/2003 at approximately 1430 EST, jerry a. stevens an instrument rated Private pilot encountered wind gusts while on take off from runway 36 of his Private grass airstrip. This led to a hard landing and loss of directional control substantially…Accident 20030912023029ABell 47G3B1 · Diamond, OR(-23) While herding wild horses with his helicopter, pilot went into a hover at about 40 feet above the ground. All of a sudden the engine wound up to a high RPM and the main and tail rotors became unpowered. The pilot tried to auto rotate to a field but only…Accident 20030912022629AAirtrc AT502B · Farwell, TX(-23) On September 12, 2003, approximately 0900 central daylight time, an air tractor AT-502B, N61353, was destroyed when it impacted the ground following a loss of control. The aircraft was owned by tate spraying service, inc., of clovis, new Mexico. The…Incident 20030912022429IPiper PA28* · Homedale, ID(-23) During the approach to, and as the aircraft crossed the threshold to runway 31 at Homedale airport, Idaho, the pilot stated that he encountered a significant wind shear condition that he could not counteract with the addition of power or flight…Incident 20030912022209IPiper PA23250 · East Haddam, CT(-23) On September 13, 2003 while returning to home base from a CFR part 135 trip the pilot landed at Goodspeed Airport at 1955. The airplane hit a deer that had run onto the runway. The nose gear collapsed causing both the left and right propellers to hit…Incident 20030911031339ILittlestown, PA(-23) 1. (Name) [privacy data omitted] 2. (Experience) 200 jumps, uspa "c" license 3. (Club) the "sky divin place" 205 carlise street, hanover, PA 17331. 4. (Equipment) main=para-flit ZX-145, s/n TZX-04048, reserve=performance design-PD143R, s/n 143R6213,…Incident 20030911026299IAmtr ME108 · Alamogordo, NM(-23) On September 11, 2003 at 1200 MDT an ME-108, owned by American airpower heritage flying museum, p.o. box 62000 midland, Texas and operated by wanliss e. armstrong, [privacy data omitted] was landed with the gear partially extended following a loss of…Accident 20030911026089AAmtr KR2 · Clarinda, IA(-23) The pilot landed on a gravel road near Clarinda, Iowa, as a precaution due to thunderstorm and heavy rain activity in the area. After waiting for the thunderstorm activity to pass, he attempted to depart from the road. During the departure, he made…Incident 20030911025129ICessna 172S · Santa Maria, CA(-23) Student pilot lost directional control during touch and go.Incident 20030911024629IAmtr KR2 · Clarinda, IA(-23) The pilot encountered inclement weather while enroute from chillicothe, MO to red oak, IA. The weather closed in around the aircraft which was one of a flight of two. Both pilots elected to make a precautionary landing on a gravel road near Clarinda,…Incident 20030911023989IAmtr SKYARROW1450 · Chapel Hill, NC(-23) Reference attached sheets (record of telephone conversations dated 9-12-03 and 9-15-03, letter from dom, david humphries regarding findings at buy). Pilot indicated he did not know what caused the engine to quit during the phone interview dated 09-12-03…Accident 20030911023439AHughes 269C1 · Homestead, FL(-23) 09-11-03 - Arrived at Homestead general airport (X51) at 1710 hours on September 11, 2003, to investigate a crash involving a Schweizer rotorcraft, model 269C-1, N6147Q operated by helicenter international academy that crashed on runway 36N while…Incident 20030911022999ICessna 180 · Rexburg, ID(-23) Distraction of the taxiing pilot due to a cell phone call. Both aircraft involved were conventional geared aircraft which require some additional vigilance while maneuvering on the ground due to reduced forward visibility.Incident 20030911022719ICessna R182 · Miami, FL(-23) On September 11, 2003 adf airways corp. Cessna 182RG N736LF had a nose gear collapsed on a landing.Incident 20030911022599IPiper PA28140 · Pawtucket, RI(-23) Philip keohane departed from owd in N5944U and was described by owd twr chief as "foggy and disoriented", asked to depart west and flew 5 NM east then turned and climbed into the class b without a clearance. He arrived at sfz and made what was described…Accident 20030910037699AAmtr KITFOXSERIE5 · Kenai, AK(-23) Pilot experienced engine problems after take-off. Pilot decided to land back at airstrip, engine quit operating. Pilot became focused on restarting engine and forgot about altitude and approach to land. He landed long on strip causing aircraft to flip…Accident 20030910037039ACessna U206F · Ft Yukon, AK(-23) [privacy data omitted] on September 10, 2003 at approximately 1800 local time, a Cessna 206, N710MH, piloted by Mr. Renald joseph drouin crashed while attempting a take-off from a snow covered grass airstrip on the coleen river. The pilot stated as he…Incident 20030910029809IPiper PA34200 · Ann Arbor, MI(-23) On 9/10/2003, N439CT, a Piper seneca, PA34-200, was approaching Ann Arbor, MI (arb) to pick up a passenger for an angel flight. Approximately 9 miles NE of arb, with engine power set, the pilot heard a loud bang, and the left engine failed. He noticed…Incident 20030910029659IBeech B200 · Moline, IL(-23) The pilot-in-command had a multiengine rated second pilot aboard this airplane that did not, however, require a second pilot. Purdue university, owner of the airplane, used the airplane in orientation flights that allowed inexperienced pilots--but…Accident 20030910027319APiper J5A · Winter Haven, FL(-23) On September 10, 2003 at approximately 1400 local time, Mr. Bird water taxied the aircraft from brown's seaplane base into lake jesse in Winter Haven, Florida. After 15 minutes of practicing step taxis, he took off to the north. At approximately 300…Accident 20030910026609AGrob G102IIIB · Highland, IL(-23) Pilot departed on a pleasure flight at approximately 1600 hours. Experienced weak lift conditions and decided to return to the field. Encountered sink returning to the field. Elected to land off field rather than attempt to return to airport. Landed on…Incident 20030910024049IAirbus A300F4605R · Indianapolis, IN(-23) On 09/10/2003 fedex flight 3608 declared an emergency due to a flight control problem. The flaps had failed at 15 degrees. Maintenance personnel replaced both flap/slat control computers. A mechanical reliability report will be filed by the operator in…Incident 20030910023889IPiper PA32R300 · Madison, MS(-23) Pilot stated he moved the gear handle to the down position prior to landing, and did not get any indication that the gear was not down. The aircraft landed on the runway with all three gears stowed in the wheel wells. [privacy data omitted]Accident 20030910023529ACessna 172M · Ardmore, OK(-23) Pilot departed Ardmore, OK and flew to gainsville, TX. No landing was made. Pilot returned to Ardmore, OK. Pilot stated she took the left downwind for a full stop landing on runway 17. She turned onto the left base and encountered a downdraft or wind…Accident 20030910023519APiper PA22160 · Billings, MT(-23) Pilot states he encountered dust devils upon roll out which ground looped the aircraft.Accident 20030909036289AHiller UH12E · Kekaha, HI(-23) This was a part 137 aerial application operation on the island of kauai, vicinity of barking sands, pmfr. The PIC was not aware wires were in the vicinity of where he was operating and stated he did not see the wires until it impacted the front canopy…Incident 20030909035979IConaer LA4 · Boyne City, MI(-23) After performing several water landings in his aircraft, the pilot landed on the hard surface of runway 09 at the Boyne City, MI. Airport without extending the landing gear. Pilot stated that he placed the gear switch in what he though was the down…Accident 20030909031169ACessna 152 · Kissimmee, FL(-23) After takeoff, during climb at an altitude of 200 to 300 feet, the student pilot on his second solo flight reported that the engine began to sputter and lost significant RPM. The student pilot turned left 180 degrees back towards the airport for an…Accident 20030909027989ACessna T210L · Monterey, CA(-23) On September 09, 2003, at 15:22 PDT, a Cessna 210L airplane, N93860, impacted a tree while in a left gliding turn approximately 1000 feet short of runway 10R at Monterey Peninsula Airport, Monterey, California. The airline transport pilot and two…Accident 20030909025219ABell 206B · Kisatchie, LA(-23) The rotorcraft departed platform and climbed to 50 ft. AGL, then lost power and impacted ground approximately 1000 ft from departure point.Incident 20030909025199ICessna 560CESSNA · Easton, MD(-23) Aircraft landed at Easton (esn). On rollout, the nose gear collapsed, causing some damage to the aircraft in the nose gear area.Accident 20030909025019ACessna T210N · Pine River, MN(-23) On September 9, 2003, at 1415 CDT, a Cessna 210 owned and operated by richard adams experienced a loss of power and crashed in a field near Pine River, MN. This power loss required the airman to execute an emergency landing. While conducting a power off…Incident 20030909024809ICndair CL6002B19 · Atlanta, GA(-23) Air Wisconsin flight 2103, ksav to katl sept 9 2003, had a "smoke cargo" message display off and on three times while cruising at FL 200 (18 minutes from katl). The crew declared an emergency and initiated the emergency checklist, firing both fire…Accident 20030909024719ASnias AS350BA · Hilo, HI(-23) After cresting the northern rift zone of mauna loa volcano on the island of Hawaii, the pilot encountered low cloud condition on the side of the eastern slopes of mauna lao. The pilot initially attempted to parallel the cloud line northerly toward Hilo,…Incident 20030909024459IBombdr DHC8401 · Portland, OR(-23) Crew experienced #2 engine fadec caution during approach to land. Copilot was flying at the time. The captain initiated the check list for #2 engine fadec fail. This check list requires the shutdown of the engine. The #2 engine fadec caution check list…Accident 20030909023309ASwrngn S2RG6 · Cash, AR(-23) Air thrust, N3299X, attempted a take-off from burns farms, hwy 18, 2 miles north of Cash, Arkansas. The pilot failed to abort the take-off when it became apparent to him that the aircraft had not developed the proper ground speed needed for rotation.…Accident 20030909023129AMooney M20A · Rockford, OH(-23) The aircraft was observed by a ground witness circling above a Private Airport. While attempting to land, the aircraft struck utility wires and crashed. The aircraft was destroyed by a post crash fire. The pilot received serious injury.Incident 20030909021949IBoeing 7377H4 · Seattle, WA(-23) On September 9, 2003 at approximately 0555AM at the Seattle-Tacoma International Airport (sea), a southwest airline Boeing 737-700, N768SW was being towed from parking spot A2 to gate B-4 by two (2) southwest airlines ramp supervisors when the right…Accident 20030908026229AGulstm 680 · Porter, TX(-23) On 8 sept. 2003 at approximately 1930 local time a GA-680, s/n 680-443-114 registered as N233S, was landing at Williams Airport "9X1" Porter TX when the aircraft went off the runway and hit a runway light, collapsed the nose landing gear and came to a…Incident 20030908025339IPiper PA32R300 · Fort Worth, TX(-23) On 09/09/2003, at 12:45 local time a Piper PA-32R-300, N15BR, registered to by [privacy data omitted] landed gear up after numerous attempts by the pilot to lower the landing gear prior to landing. The aircraft was on a pleasure flight, VFR conditions…Incident 20030908024619IBeech A36 · Lexington, MO(-23) PIC stated that, shortly after takeoff on runway 04, the right front passenger door opened. He performed a teardrop turn in order to return for a landing on runway 22. Due to the loud wind noise and the distraction of an open door, he neglected to…Incident 20030908024599ICessna 172RG · St Paul, MN(-23) Upon entering the traffic pattern, pilot experienced difficulties extending the landing gear. After recycling gear and following the recommended checklist procedures, the aircraft over flew the tower to check the gear. The right gear failed to extend.…Incident 20030908023699INamer SNJ4 · Kent, OH(-23) N224X (SNJ-T-6) was parked in the run-up area of runway 19 at Kent State airport (1G3). Aircraft N119KS was holding short of rwy 19 for take-off, as N224X pulled out of the run-up area, left turn to the east, it struck N119KS with his right wing. N119KS…Accident 20030908023409APiper PA20 · Wausau, WI(-23) On sept. 8, 2003, at 10:00 cdst a Piper PA-20, N5595H ground looped on rollout after landing parallel to runway 12 at the Wausau downtown airport, Wausau, WI. The student and instructor reported no injuries. The flight was conducted under visual…Incident 20030908021839IAmtr LANCAIR4P · Omaha, NE(-23) Pilot stated he was distracted by the tcad (ryan 900B) issuing him "alert, alert, alert". While scanning for traffic, pilot forgot to lower landing gear.Incident 20030908021179ICndair CL6002B19 · Salt Lake City, UT(-23) Skywest flight 3886 was on approach to 34L at slc, hit a large bird, at approx. 2032 MDT 9/08/03. Minor damage to the right wing inboard flap.Incident 20030908021169ICndair CL6002B19 · Salt Lake City, UT(-23) Skywest flight 3716 was on approach to 34L at slc, hit a large bird, at approx. 2032MDT 9/08/03. Damage to the right wing leading edge.Accident 20030907035159APiper PA18150 · Tok, AK(-23) [privacy data omitted] landed on ridge top, front seat only occupied, runway rough, applied brakes, allowed tail to rise too high angle, aircraft nosed over onto its back.