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 20060706014419IBeech C24R · Sioux City, IA(-23) Aircraft porpoised on landing causing the nose gear to collapse. [privacy data omitted]Incident 20060706013349IDoug DC931 · Kansas City, MO(-23) On July 6, 2006 northwest airlines flight 1752, a DC-9-31, lost the number two engine upper side cowling on climb out from Kansas City International Airport (mci). A witness reported "seeing something falling off a silver airplane" at approx 10:00 am.…Accident 20060706013329AAmtr RV6 · Groveland, CA(-23) On 7/6/2006, at approximately 1930 PDT, RV-6 aircraft, N157ST, crashed during an attempted go-around from an aborted landing on runway 09, Pine Mountain Lake Airport (E45), Groveland, CA. The pilot-in-command, [privacy data omitted] private pilot…Incident 20060706013219ICessna 210M · Orlando, FL(-23) During a landing on runway 7 at Orlando Executive Airport (orl) the pilot stated he forgot to lower the landing gear. Pilot stated he was doing full stop taxi backs and was on his second landing when he landed gear up.Accident 20060706013049ACessna T210G · Pontiac, IL(-23) The aircraft was on a 14 CFR part 91 VFR flight from savannah, ga (sav) to freeport, IL (fep) when the pilot decided to land at Pontiac, IL (pnt) for fuel. The pilot stated that he was in a left hand descending turn over pnt out of his cruise altitude…Accident 20060706012959APiper PA28235 · Stevens Village, AK(-23) Aircraft was missing on flight from manley hot springs to five mile strip near pump station 6 aleyeska pipeline. N9026W wreckage was found;aircraft impacted ground on downslope of mountain, pilot did not survive. In flight break up has yet to be…Accident 20060706012619APiper PA18A150 · Skwentna, AK(-23) According to the pilot, he was attempting to land on a sandbar. The aircraft hit an unknown object which caused the pilot to lose control. The aircraft nosed over and went backwards into the river.Accident 20060706012529ACessna 305A · Saratoga, WY(-23) Pilot lost control of aircraft on take-off roll. Aircraft veered to the right, was over corrected to the left and would not come back to the right to the center of the runway. Aircraft went off the left side of the runway and the landing gear collapsed…Accident 20060705029939ACessna 210K · Novato, CA(-23) On July 5, 2006, acft N12PF departed san carlos airport (sql) headed for Gnoss Field Airport (dvo). During landing attempt at (dvo), acft main gear collapsed and acft veered off the runway and came to rest in a ditch causing substantial damage to acft.…Incident 20060705028019IPiper PA28RT201 · Fort Atkinson, WI(-23) The aircraft landed with the gear up. The pilot failed to extend the landing gear in a timely manner.Accident 20060705022289APiper PA28R200 · Block Island, RI(-23) Aircraft departed Block Island airport (bid) at approximately 1200 hrs local from runway 28. Two passengers on board. Heavy rain at the time. Aircraft impacted the ground approximately 1/2 mile from the airport. Three fatalities.Incident 20060705016669ICessna 182K · Plainwell, MI(-23) Pilot touched down with approximately 800FT remaining on runway 27 (2650FT total) at Plainwell municipal 61D. Insufficient runway remaining to safely stop aircraft, resulted in aircraft rolling off end. Minor damage to aircraft only.Accident 20060705016409ACessna 340A · San Antonio, TX(-23) On July 5, 2006, Cessna 340, N2745F was flown from west houston airport to San Antonio International Airport. On final approach to runway 12R, the pilot in command, lowered the landing gear, and observed three green gear down lights. Upon landing the…Incident 20060705013789ICessna T310Q · Juneau, AK(-23) The aircraft was performing aerial mapping at 24,000 ft near Juneau when approximately 5 inches of a propeller tip separated from the right engine. The aircraft returned to Juneau with the engine shut-down, prop feathered and landed uneventfully.…Incident 20060705012429ICessna 172RG · Tulsa, OK(-23) During downwind portion of landing pattern, pilot (acting as CFI) pulled the gear motor cb with knowledge of student. Then, CFI instructed student to perform a power-off 180 degree approach and landing maneuver. During turn to final, student put the…Incident 20060705012359ILear 25D · Omaha, NE(-23) N520SR departed Eppley Airfield at Omaha, NE. On a local flight. The pilot was unable to retract the gear the aircraft returned to the airport and landed safely. Maintenance discovered that the left main landing gear was out of rig.Incident 20060704023179IPiper J3C65 · Jackson, MI(-23) Engine hesitated and quit on short final. Aircraft landed on small hill 10 feet short of runway in corn field.Accident 20060704023029ABell 47G2 · Petersburg, WV(-23) Pilot was taking off from field with 2 passengers, giving sightseeing rides. There was a tailwind. There was a loss of rotor RPM after takeoff and the pilot was not going to be able to stay in the air. Pilot picked a spot to do a run on landing and was…Incident 20060704018609IDoug DC983 · Fresno, CA(-23) During the takeoff phase at lift-off, the right engine (#2) experienced severe compressor stalls that required immediate shutdown of the engine. This takeoff was a maximum gross weight takeoff requiring maximum power settings. The aircraft returned to…Incident 20060704016319IAerovd L29 · Riverside, CA(-23) The forward canopy departed from the aircraft in flight. While climbing, @ 5500 feet, the pilot in command (PIC) noticed the cockpit pressurization caution light illuminated. The PIC checked the canopy seal and discovered the forward left locking…Incident 20060704015299IArostr RX8 · Woodridge, IL(-23) During landing, basket touched down then gust of wind took basket up again, then dragged basket/balloon approximately 90 feet. Pilot deflated envelope which fell over light pole.Incident 20060704013699ICessna T210J · Tacoma, WA(-23) Aircraft was departing runway 17 at tiw and aborted takeoff. Went off the end of the runway approximately 50 feet without any incident. Upon taxi back to the runway the nose wheel went into a shallow ditch causing a propeller strike.Incident 20060704013679ICessna 310I · Ankeny, IA(-23) Pilot was landing on runway 36 at the Ankeny Regional Airport. He selected the gear handle down, but inadvertently placed the handle in the center neutral position instead of in the down position. He stated that he did not confirm the gear was down with…Incident 20060704013299IBbavia 7KCAB · Shallowater, TX(-23) On July 4, 2006, at approximately 1350 CDT, the pilot and single occupant of N8651V, a Bellanca model BL-7-kcab, landed long and ground looped at the end of runway 13 at Biggin Hill airstrip (TA67) located five miles west of Shallowater, Texas. The…Accident 20060704012479AFlaglo Hightow · Jackson, WY(-23) Pilot operated the aircraft in an unairworthy condition. A flag (approximately 2.5 feet by 3.0 feet) was attached to a strut on each wing. The aircraft could not get out of ground effect, the aircraft settled back onto the runway and went through a…Incident 20060703022369ICessna 172S · Albany, NY(-23) Upon landing airplane pulled left, as airplane slowed left pulling increased. Pilot was able to reach taxiway, but did not completely clear runway. Upon examination, pilot determined that left main tire was flat. Airplane was towed clear of runway &…Accident 20060703016949AAmtr DREAMMACH503 · Monticello, KY(-23) The pilot [privacy data omitted] did not hold any FAA certificates. The pilot [privacy data omitted] did not receive any formal flight training for power parachutes. The pilot [privacy data omitted] did not receive a 2-place exemption putting the…Accident 20060703013659ACessna 195 · Great Falls, MT(-23) On July 3, 2006, the pilot [privacy data omitted] holder of airline transport pilot certificate [privacy data omitted] ground looped a Cessna CE-195, N6857D at approximately 1010 local time during the takeoff run in Great Falls, Montana. Neither the…Accident 20060703013639APiper PA28181 · Dorris, CA(-23) During landing on rwy 23, pilot encountered a gust of wind and tried to abort by applying full power and positioned flaps in second detent. Aircraft was unable to produce lift and went off end of runway. Left wing had substantial damage and was leaking…Accident 20060703013479ABeech A36TC · Montrose, CO(-23) The aircraft departed rifle, CO. With both fuel tanks half full. After flying approximately 1.5 hours, a full stop landing was made at Montrose, CO. On runway 31. The aircraft then departed and remained in the pattern. While turning from downwind to…Incident 20060703013129ILear 35LEAR · Ontario, CA(-23) While flying at 23000 ft the pilot experienced pitch control problems. He activated emergency pitch control and returned safely to cno.Incident 20060703012329ICessna 172L · Port Royal, SC(-23) On July 3, 2006 at approximately 1825 hours, on the state Port authority rail yard, in Port Royal, SC, a Cessna 172, N3974Q, landed on an abandoned railroad track. The off airport landing, as reported by the pilot, occurred because, he ran out of fuel.…Accident 20060703011909APiper PA28161 · Jefferson City, MO(-23) The student pilot, occupying the left seat, was practicing takeoffs and landings at Jefferson City Memorial Airport (jef), in Jefferson City, Missouri, under the supervision of a certificated flight instructor in the right seat. On the second landing,…Accident 20060702031129ARyan Navion · Sturgis, KY(-23) Navion aircraft, N91686 while cruising at approximately 2000 ft. with pilot and one passenger on board aircraft had a total engine power failure north of Sturgis, KY airport (twt). Pilot attempted an off airport landing in field 1 to 2 miles north of…Incident 20060702025299ICessna 172RG · Philadelphia, PA(-23) On July 02, 2006 at approximately 2320 the pilot in command taxied about 200 yards from his parking spot when without indication the nose went down. He called the tower and stated that he thought he taxied into a ditch. He secured the aircraft and…Incident 20060702023279ICessna 177RG · Dover/Cheswold, DE(-23) Pilot reported nose landing gear failed to extend. Pilot elected to land gear up. No injuries to pilot or passengers.Incident 20060702021959IDhav DHC8311 · Roanoke, VA(-23) The crew observed that the nose gear would not lock in the up retracted position after takeoff. The crew returned to runway 33 without further incident. Maintenance personnel determined that the nose gear drag link actuator was defective. The actuator…Accident 20060702017099AAmtr Acrosportii · Hertford, NC(-23) The instructor [privacy data omitted] was giving duel instruction to the pilot [privacy data omitted] who was occupying the rear seat of the tandem seat aircraft (the rear seat is occupied for solo flight). On short approach the aircraft struck a power…Incident 20060702013289ICessna 172K · Odessa, MO(-23) The pilot was on a visual flight rules (VFR) flight from jonesboro, Arkansas, to east Kansas city airport (3GV) in grain valley, Missouri, in N84819, a CE-172-K. The engine failed prior to reaching grain valley and he landed in a vacant field…Accident 20060702012939ANancng CJ6 · Brewster, WA(-23) During cruise flight, pilot heard/felt a couple of bangs, engine RPM increased to 4000 and quit. Pilot elected to attempt landing at Anderson field (S97), Brewster, WA. A/c did not clear the last row of trees in orchard, about 350 feet west of S97…Incident 20060702012389IPiper PA46310P · Anderson, SC(-23) On July 2, 2006 at approximately 0014 local, on landing at the Anderson County Airport, (kand) Anderson, SC, N550MG, a PA-46, Piper malibu, struck and killed a deer. The pilot and passenger were the only occupants of the aircraft. No injuries were…Accident 20060702012179AAmtr LIBERTYXL2 · Mansfield, MA(-23) Pilot was practicing soft field take off and landings on Mansfield airport's grass runway 22. The first take off and landing was uneventful. The second take off and approach to landing was uneventful. The aircraft bounced on the second landing. The…Accident 20060702012129ACessna TU206G · Stanley, ID(-23) The pilot and sole occupant of the aircraft initiated a take off on runway 17 at the Stanley, Idaho airstrip. The winds were out of the south as reported by the pilot and eye witnesses. As the pilot applied power the witnesses saw the dust from the prop…Accident 20060702011849ACessna 180K · Anchorage, AK(-23) The aircraft ground looped after landing on lake Hood strip runway 31. According to the pilot, on roll out he was slightly off center and tried to correct using right rudder but his foot was too high on the pedal which caused right braking action and…Accident 20060702011819ACessna 180K · Owasso, OK(-23) On July 2, 2006, about 0925 central daylight time, a single-engine Cessna 180K tailwheel-equipped airplane, N1SE, was substantially damaged when it impacted terrain following a collision with static transmission lines while on takeoff from a residential…Accident 20060701031239ABbavia 7GCBA · Toms River, NJ(-23) Aircraft lost engine power, pilot atttempted to apply more power/throttle, engine failed to respond. Pilot elected to make an emergency landing on west bound NJ route 37, a main highway in Toms River NJ. Upon touching down, the aircraft bounced 3 times,…Incident 20060701028679ICessna T210N · Danville, IL(-23) [privacy data omitted] at Danville, IL, pilot in command landed gear up then stated to UNICOM that he had engine trouble and would require a tug and towbar. Then after a pause he exclaimed that he had landed gear up. This incident is closed with this…Incident 20060701021979IPiper PA18A · Toms River, NJ(-23) While conducting a banner towing operation aircraft lost engine power after a loud pop. Oil streamed over wind screen, pilot released banner over an open area, but was unable to maintain altitude or airspeed and was not within gliding distance of an…Incident 20060701017499IBoeing 717200 · Atlanta, GA(-23) Airtran (trs) flight 263 from tpa-fnt diverted into Atlanta (atl) due to an incapacitated first officer. While in cruise first officer complained she had a stomach ache and needed to use the lavatory. The lead flight attendant informed the captain a…Incident 20060701017369ICessna 172N · Pembroke Pines, FL(-23) On 07/01/06 on about 1415 N483G on a VFR flight from (tpf) peter oknight airport to (hwo) hollywood north perry airport the pilot stated that the engine lost power then failed and he made an emergency landing on hwy 27 with no damage.